private void button1_Click(object sender, EventArgs e)
{
int prodid = int.Parse(textBox1.Text);
string itemame = textBox2.Text, categories = comboBox1.Text;
DateTime expirydate = DateTime.Parse(dateTimePicker1.Text);
int price = int.Parse(txtPrice.Text);
var st = new ProductInfo_Tab
{
ProductID = prodid,
itemName = itemame,
Price = price,
Categories = categories,
insertDate = DateTime.Now,
ExpiryDate = expirydate,
};
db.ProductInfo_Tab.Add(st);
db.SaveChanges();
MessageBox.Show("Succesfully Inserted");
loadData();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure to delete ?", "Delete record", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (var supermarket = new SuperEntities())
{
var customer_id = txtCustomerID.Text;
var fullname = txtFullName.Text;
var email = txtEmail.Text;
var address = txtAddress.Text;
var st = (from s in supermarket.Customers where s.CustomerID == customer_id select s).First();
supermarket.Customers.Remove(st);
supermarket.SaveChanges();
MessageBox.Show("Successfully deleted.");
LoadData();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
// Update
var customer_id = txtCustomerID.Text;
var fullname = txtFullName.Text;
var email = txtEmail.Text;
var address = txtAddress.Text;
using (var supermarket = new SuperEntities())
{
var st = (from s in supermarket.Customers where s.CustomerID == customer_id select s).First();
st.CustomerID = customer_id;
st.FullName = fullname;
st.Email = email;
st.Address = address;
supermarket.SaveChanges();
MessageBox.Show("Successfully Updated.");
LoadData();
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
//panel1.Enabled = true;
//txtCustomerID.Focus();
//Customer c = new Customer();
//supermarket.Customers.Add(c);
//customerBindingSource.MoveLast();
using (var supermarket = new SuperEntities())
{
var customer_id = txtCustomerID.Text;
var fullname = txtFullName.Text;
var email = txtEmail.Text;
var address = txtAddress.Text;
var st = new SupermarketFIX.Customer
{
CustomerID = customer_id,
FullName = fullname,
Email = email,
Address = address
};
supermarket.Customers.Add(st);
supermarket.SaveChanges();
MessageBox.Show("Succesfully Inserted");
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var transno = lblTransno.Text;
var customerid = gridCustomer.CurrentRow.Cells[0];
using (var context = new SuperEntities())
{
foreach (DataGridViewRow row in gridOrder.Rows)
{
if (row.IsNewRow)
{
continue;
}
var product_id = row.Cells[0].Value.ToString();
var item_name = row.Cells[1].Value.ToString();
var price = row.Cells[2].Value.ToString();
var quantity = row.Cells[3].Value.ToString();
var price_total = row.Cells[4].Value.ToString();
var order = new Order();
order.TransNo = transno;
order.ProductId = int.Parse(product_id);
order.Price = int.Parse(price);
order.Qty = int.Parse(quantity);
order.Total = int.Parse(price_total);
order.SDate = DateTime.Now;
context.Orders.Add(order);
context.SaveChanges();
}
}
gridOrder.Rows.Clear();
gridOrder.Refresh();
GetTransNo();
}
