static public void Add(DrawEntry drawEntry) { using (conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand insertCommand = new SqlCommand("INSERT INTO DrawEntry (Email,ProductSerialNumber) VALUES (@email, @productsn)", conn); insertCommand.Parameters.Add(new SqlParameter("@email", drawEntry.Email)); insertCommand.Parameters.Add(new SqlParameter("@productsn", drawEntry.ProductSerialNumber)); insertCommand.ExecuteNonQuery(); } }
static public IEnumerable <DrawEntry> GetEntryList() { List <DrawEntry> drawEntries = new List <DrawEntry>(); using (conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand command = new SqlCommand("SELECT * FROM DrawEntry", conn); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { DrawEntry drawEntry = new DrawEntry(reader.GetString(1), reader.GetString(2)); drawEntries.Add(drawEntry); } } } return(drawEntries); }
public void Add(DrawSubmition drawSubmition) { if (drawSubmition.Age >= 18) { if (SerialNumberExists(drawSubmition.ProductSerialNumber)) { int entriesCount = 0; foreach (DrawEntry drawentry in drawEntriesList) { if (drawentry.Email == drawSubmition.Email && drawentry.ProductSerialNumber == drawSubmition.ProductSerialNumber) { entriesCount++; } } if (entriesCount < 2) { DrawEntry drawEntry = new DrawEntry(drawSubmition.Email, drawSubmition.ProductSerialNumber); drawEntriesList.Add(drawEntry); DatabaseAccess.Add(drawEntry); } } } }