private void btn_delete_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txt_orderid.Text);
ords = db.Orders.First(p => p.OrderId == id);
db.Orders.Remove(ords);
db.SaveChanges();
MessageBox.Show("Order Deleted");
}
private void btn_delete_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txt_custid.Text);
custss = db.Customers.First(p => p.CustId == id);
db.Customers.Remove(custss);
db.SaveChanges();
MessageBox.Show("Customer Deleted");
}
private void btn_delete_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txt_empid.Text);
emps = db.Employee.First(p => p.EmpId == id);
db.Employee.Remove(emps);
db.SaveChanges();
MessageBox.Show("Employee Deleted");
}
private void btn_add_Click(object sender, EventArgs e)
{
try
{
using (BookSellingContext db = new BookSellingContext())
{
Employee emp = new Employee();
emp.FirstName = txt_empname.Text.Trim();
emp.LastName = txt_empsurname.Text.Trim();
emp.Email = txt_empemail.Text.Trim();
emp.Password = txt_empass.Text.Trim();
db.Employee.Add(emp);
db.SaveChanges();
MessageBox.Show("Employee Added");
txt_empid.Text = " ";
txt_empname.Text = " ";
txt_empsurname.Text = " ";
txt_empemail.Text = " ";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_add_Click(object sender, EventArgs e)
{
try
{
using (BookSellingContext db = new BookSellingContext())
{
Orders ordss = new Orders();
ordss.CustId = Convert.ToInt32(txt_custid.Text);
ordss.InvoiceCreationDate = dt_inv.Value;
ordss.DeliveryDueDate = dt_delivery.Value;
ordss.PaymentDueDate = dt_payment.Value;
db.Orders.Add(ordss);
db.SaveChanges();
MessageBox.Show("Order Added");
txt_custid.Text = " ";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btn_add_Click(object sender, EventArgs e)
{
try
{
using (BookSellingContext db = new BookSellingContext())
{
Customers custs = new Customers();
custs.FirstName = txt_custname.Text.Trim();
custs.LastName = txt_surname.Text.Trim();
custs.Email = txt_custemail.Text.Trim();
db.Customers.Add(custs);
db.SaveChanges();
MessageBox.Show("Customer Added");
txt_custname.Text = " ";
txt_surname.Text = " ";
txt_custemail.Text = " ";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}