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);
}
}
}
}
