Revision: 66411
                            
                                                            
                                    
                                        
Updated Code
                                    
                                    
                                                    
                        at May 1, 2014 04:13 by JordanRowles
                            
                            Updated Code
public class DictionaryToDB {
    public Dictionary<string, dynamic> MyDictionary = new Dictionary<string, dynamic>{ };
    public void AddToDictionary(string key, dynamic value) {
        if (
            (key == "hs_tag" || key == "host_pc" && value.Length <= 10) ||
            (key == "mac" && value.Length <= 17 || key == "ip" && value.Length <= 25 || key == "wireless_mac" && value.Length <= 20) ||
            (key == "disks" || key == "cpu" || key == "memory" || key == "graphics" && value.Length <= 25) ||
            (key == "name" || key == "manufacturer" || key == "model" || key == "serial_no" || key == "oem_os_key" || key == "allocated_to" || key == "bios" && value.Length <= 50) ||
            (key == "comment" && value.Length <= 255)) {
            MyDictionary.Add(key, value);
            MessageBox.Show("It worked!", "Success!");
        }
        else {
            MessageBox.Show("It Failed!", ":(");
        }
    }
}
                                
                            Revision: 66410
                            
                                                            
                                    
                                        
Initial Code
                                    
                                    
                                                            
                                    
                                        
Initial URL
                                    
                                    
                                
                                                            
                                    
                                        
Initial Description
                                    
                                    
                                                            
                                    
                                        
Initial Title
                                    
                                    
                                                            
                                    
                                        
Initial Tags
                                    
                                    
                                
                                                            
                                    
                                        
Initial Language
                                    
                                    
                                                    
                        at May 1, 2014 03:50 by JordanRowles
                            
                            Initial Code
public class DictionaryToDB {
    public Dictionary<string, dynamic> MyDictionary = new Dictionary<string, dynamic>{ };
    public void AddToDictionary(string key, dynamic value) {
        if (
            (key == "hs_tag" || key == "host_pc" && value.Length <= 10) ||
            (key == "mac" && value.Length <= 17 || key == "ip" && value.Length <= 25 || key == "wireless_mac" && value.Length <= 20) ||
            (key == "disks" || key == "cpu" || key == "memory" || key == "graphics" && value.Length <= 25) ||
(key == "name" || key == "manufacturer" || key == "model" || key == "serial_no" || key == "oem_os_key" || key == "allocated_to" || key == "bios" && value.Length <= 50) ||
            (key == "comment" && value.Length <= 255)) {
            MyDictionary.Add(key, value);
            MessageBox.Show("It worked!", "Success!");
        }
        else {
            MessageBox.Show("It Failed!", ":(");
        }
    }
}
                                Initial URL
Initial Description
Logic to make sure that the input through window controls (text boxes, drop down selections ...) were the correct length for the database table. 
I.e.
If the user entered 'abcdefghijk' into the 'HS Asset Tag' (hs_tag) text box, it will reject it because the table column hs_tag is set to VARCHAR(10) - a string with a length of ten.
======================================================
LINE   |   EXPLAINATION
---------------------------------------------------------------------------------------------------
  01          Creates a public class (container object) called DictionaryToDB.
                This is because it is taking the contents of a dictionary (key-value
                pair) and putting it into a database table.
---------------------------------------------------------------------------------------------------
  02         Create the dictionary object (another container type). 'string' means
                that the key in the dictionary must be a string (a sentence or word
                encapsulated by " "). 'dynamic' means that the datatypes can be
               different, you can have integers, strings, lists and objects in the
               same dictionary. This is useful because database table rows have a
              specific datatype attributed to them.
---------------------------------------------------------------------------------------------------
  04       I create a method/function that's public and doesn't return a value
              (void) called AddToDictionary, because it will perform the logic and
             add the keys and values (which we get from the windows form). It
             takes two arguments. Which is called whenever we want to use that
             method on some data. It becomes an object (method) inside another
             object (Class) - encapsulation.
            Used like:
                                      AddToDictionary("hs_tag", "02535")
---------------------------------------------------------------------------------------------------
05-13 
            05 - It starts as an if statement, it does something if the condition given
                    is either true or false. For example:
                              if (MyName == "Jordan") {
      06-10 - This is the basic layout of what you are seeing
                      == is equal to      || is 'or'      && is 'and'     <= is less than or equal to
                    if (
                              (columns with 10 or less characters)  or
                              (columns with mixed length) or
                              (columns with 25 or less characters) or
                              (columns with 50 or less characters) or
                              (columns with 255 or less characters)
                              = The users input   then
                                    Add the key and value to the dictionary
That's the basics of it. Still needs a little more work and need to add the other columns, with different datatypes like DATETIME and INT.
                                Initial Title
Logic used in internal Licensing program
Initial Tags
Initial Language
C#