public bool AddItem(string Abrev) { if (ColorExist(Abrev)) { return false; } else { Colors s = new Colors(Abrev); sList.Add(s); return true; } }
public static Colors PopulateColorsFromSqlDataReader(SqlDataReader dr) { Colors colors = new Colors(); colors.Id = Convert.ToInt32(dr["Id"]); colors.ColorName = Convert.ToString(dr["ColorName"]); colors.ColorNumber = Convert.ToString(dr["ColorNumber"]); colors.ColorManufacturer = Convert.ToString(dr["ColorManufacturer"]); colors.Abrev = Convert.ToString(dr["Abrev"]); colors.PoundsInStock = Convert.ToString(dr["PoundsInStock"]); colors.DesiredPounds = Convert.ToString(dr["DesiredPounds"]); return colors; }
public void AddColors(Colors Color) { // Initialize SPROC SqlConnection conn = new SqlConnection(ConnectionString); SqlCommand cmd = new SqlCommand("SPColorInsert", conn); cmd.CommandType = CommandType.StoredProcedure; // Add Parameters cmd.Parameters.AddWithValue("@ColorName", Color.ColorName); cmd.Parameters.AddWithValue("@ColorNumber", Color.ColorNumber); cmd.Parameters.AddWithValue("@ColorManufacturer", Color.ColorManufacturer); cmd.Parameters.AddWithValue("@Abrev", Color.Abrev); cmd.Parameters.AddWithValue("@PoundsInStock", Color.PoundsInStock); cmd.Parameters.AddWithValue("@DesiredPounds", Color.DesiredPounds); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); reload(); }
private void Object2Form(Colors s) { int Index = comboBox1.FindString(s.Abrev); comboBox1.SelectedIndex = Index; textBox1.Text = s.ColorName; textBox2.Text = s.ColorNumber; textBox3.Text = s.ColorManufacturer; textBox4.Text = s.PoundsInStock; textBox5.Text = s.DesiredPounds; }
private Colors Form2Object() { Colors tship = new Colors(0, comboBox1.Text, textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text); return tship; }
public Colors SearchColor(string Abrev) { foreach (Colors Color in sList) { if (Color.Abrev == Abrev) { return (Color); } } Colors s = new Colors(Abrev); return (s); }