private static void AddCustomer(object[] clientData)
{
using (var context = new CustomerOrdersEntities())
{
string firstName = (string)clientData[0];
string lastName = (string)clientData[1];
DateTime birthDate = Convert.ToDateTime(clientData[2]);
//check for the same customers
var isSameCustomerInDataBase = context.Customer
.Any(x => x.FirstName == firstName && x.LastName == lastName &&
x.BirthDate == birthDate);
if (!isSameCustomerInDataBase)
{
context.Customer.Add(new Customer()
{
FirstName = (string)clientData[0],
LastName = (string)clientData[1],
BirthDate = Convert.ToDateTime(clientData[2])
});
context.SaveChanges();
}
}
}
private static void AddOrders(object[] clientData, DataGridView productParameters)
{
int customerID = GetCustomerID(clientData);
using (var context = new CustomerOrdersEntities())
{
foreach (DataGridViewRow item in productParameters.Rows)
{
object Cell1 = item.Cells[0].Value;
object Cell2 = item.Cells[1].Value;
object Cell3 = item.Cells[2].Value;
string productName = (string)Cell1;
int quantity = Convert.ToInt32(Cell2);
float price = Convert.ToSingle(Cell3);
//Check for same Orders if there arent, add new order to database
var areThereSameOrders = context.Orders
.Any(x => x.ProductName == productName &&
x.Quantity == quantity &&
x.Price == price
);
if (!areThereSameOrders)
{
context.Orders.Add(new Orders()
{
ProductName = Cell1.ToString(),
Quantity = Convert.ToInt32(Cell2),
Price = Convert.ToSingle(Cell3),
ClientID = customerID
});
}
}
context.SaveChanges();
}
}