private void CategoryDGV_DoubleClick(object sender, EventArgs e)
{
category.c_id = Convert.ToInt32(CategoryDGV.CurrentRow.Cells[0].Value);
categoryunit.c_id = Convert.ToInt32(CategoryDGV.CurrentRow.Cells[0].Value);
using (StoreEFDBEntities storeEFDBEntities = new StoreEFDBEntities())
{
category = storeEFDBEntities.Categories.Where(x => x.c_id == category.c_id).FirstOrDefault();
categoryunit = storeEFDBEntities.Category_Unit.Where(x => x.c_id == categoryunit.c_id).FirstOrDefault();
textBox5.Text = Convert.ToString(category.c_id);
textBox6.Text = category.c_name;
//if(categoryunit.unit_id !=)
//{
textBox8.Text = Convert.ToString(categoryunit.unit_id);
//}
//else
//{
// textBox8.Text = "";
// textBox7.Text = "";
//}
textBox7.Text = categoryunit.unit;
storeEFDBEntities.SaveChanges();
}
}
void CustomerGridViewer()
{
CustomerDGV.AutoGenerateColumns = false;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
CustomerDGV.DataSource = db.Customers.ToList <Customer>();
}
}
void SupplierGridViewer()
{
SupplierDGV.AutoGenerateColumns = false;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
SupplierDGV.DataSource = db.Suppliers.ToList <Supplier>();
}
}
void StoresDataGridView()
{
StoreDGV.AutoGenerateColumns = false;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
StoreDGV.DataSource = db.Stores.ToList <Store>();
}
}
void UnitCategoryDataGridView()
{
UnitCategoryDGV.AutoGenerateColumns = false;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
UnitCategoryDGV.DataSource = db.Category_Unit.ToList <Category_Unit>();
}
}
void SupplyPermissionGridViewer()
{
SupplyPermissionDGV.AutoGenerateColumns = false;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
SupplyPermissionDGV.DataSource = db.SupplyPermissions.ToList <SupplyPermission>();
}
}
private void CustomerDGV_DoubleClick(object sender, EventArgs e)
{
customer.cust_id = Convert.ToInt32(CustomerDGV.CurrentRow.Cells[0].Value);
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
customer = db.Customers.Where(x => x.cust_id == customer.cust_id).FirstOrDefault();
textBox22.Text = customer.cust_id.ToString();
textBox21.Text = customer.cust_name;
textBox20.Text = customer.cust_phone;
textBox19.Text = customer.cust_fax;
textBox18.Text = customer.cust_mobile;
textBox17.Text = customer.cust_mail;
textBox16.Text = customer.cust_website;
db.SaveChanges();
}
}
private void button2_Click(object sender, EventArgs e) //update btn
{
store.s_id = Convert.ToInt32(textBox1.Text);
store.s_name = textBox2.Text;
store.s_address = textBox3.Text;
store.s_manager = textBox4.Text;
using (StoreEFDBEntities storeEFDBEntities = new StoreEFDBEntities())
{
storeEFDBEntities.Entry(store).State = EntityState.Modified;
storeEFDBEntities.SaveChanges();
}
Clear();
StoresDataGridView();
MessageBox.Show("Store updated successfully!");
}
private void SupplierDGV_DoubleClick(object sender, EventArgs e)
{
supplier.supp_id = Convert.ToInt32(SupplierDGV.CurrentRow.Cells[0].Value);
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
supplier = db.Suppliers.Where(x => x.supp_id == supplier.supp_id).FirstOrDefault();
textBox9.Text = supplier.supp_id.ToString();
textBox10.Text = supplier.supp_name;
textBox11.Text = supplier.supp_phone;
textBox12.Text = supplier.supp_fax;
textBox13.Text = supplier.supp_mobile;
textBox14.Text = supplier.supp_mail;
textBox15.Text = supplier.supp_website;
db.SaveChanges();
}
}
private void StoreDGV_DoubleClick(object sender, EventArgs e) //selection from gridview
{
if (StoreDGV.CurrentRow.Index != -1)
{
store.s_id = Convert.ToInt32(StoreDGV.CurrentRow.Cells[0].Value);
using (StoreEFDBEntities storeEFDBEntities = new StoreEFDBEntities())
{
store = storeEFDBEntities.Stores.Where(x => x.s_id == store.s_id).FirstOrDefault();
textBox1.Text = store.s_id.ToString();
textBox2.Text = store.s_name;
textBox3.Text = store.s_address;
textBox4.Text = store.s_manager;
storeEFDBEntities.SaveChanges();
}
}
}
private void button11_Click(object sender, EventArgs e) //customer update
{
customer.cust_id = Convert.ToInt32(textBox22.Text);
customer.cust_name = textBox21.Text;
customer.cust_phone = textBox20.Text;
customer.cust_fax = textBox19.Text;
customer.cust_mobile = textBox18.Text;
customer.cust_mail = textBox17.Text;
customer.cust_website = textBox16.Text;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
SupplierGridViewer();
MessageBox.Show("Customer updated successfully!");
}
private void button12_Click(object sender, EventArgs e) //customer insert btn
{
customer.cust_id = Convert.ToInt32(textBox22.Text);
customer.cust_name = textBox21.Text;
customer.cust_phone = textBox20.Text;
customer.cust_fax = textBox19.Text;
customer.cust_mobile = textBox18.Text;
customer.cust_mail = textBox17.Text;
customer.cust_website = textBox16.Text;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
}
Clear();
CustomerGridViewer();
MessageBox.Show("Customer added successfully!");
}
private void button7_Click(object sender, EventArgs e) //Supplier insert
{
supplier.supp_id = Convert.ToInt32(textBox9.Text);
supplier.supp_name = textBox10.Text;
supplier.supp_phone = textBox11.Text;
supplier.supp_fax = textBox12.Text;
supplier.supp_mobile = textBox13.Text;
supplier.supp_mail = textBox14.Text;
supplier.supp_website = textBox15.Text;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Suppliers.Add(supplier);
db.SaveChanges();
}
Clear();
SupplierGridViewer();
MessageBox.Show("Supplier added successfully!");
}
private void button5_Click(object sender, EventArgs e) //update btn
{
category.c_id = Convert.ToInt32(textBox5.Text);
category.c_name = textBox6.Text;
//categoryunit.unit_id = Convert.ToInt32(textBox8.Text);
categoryunit.unit = textBox7.Text;
//categoryunit.c_id = Convert.ToInt32(textBox5.Text);
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Entry(category).State = EntityState.Modified;
db.Entry(categoryunit).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
CategoryDataGridView();
UnitCategoryDataGridView();
MessageBox.Show("Category updated successfully!");
}
private void button8_Click(object sender, EventArgs e) //supplier update btn
{
supplier.supp_id = Convert.ToInt32(textBox9.Text);
supplier.supp_name = textBox10.Text;
supplier.supp_phone = textBox11.Text;
supplier.supp_fax = textBox12.Text;
supplier.supp_mobile = textBox13.Text;
supplier.supp_mail = textBox14.Text;
supplier.supp_website = textBox15.Text;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Entry(supplier).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
SupplierGridViewer();
MessageBox.Show("Supplier updated successfully!");
}
private void button1_Click(object sender, EventArgs e) // save in store
{
//string storeid = store.s_id.ToString();
//storeid = textBox1.Text;
store.s_id = Convert.ToInt32(textBox1.Text);
store.s_name = textBox2.Text;
store.s_address = textBox3.Text;
store.s_manager = textBox4.Text;
using (StoreEFDBEntities storeEFDBEntities = new StoreEFDBEntities())
{
//if (store.s_id == 0)//insert
storeEFDBEntities.Stores.Add(store);
//else //update
// storeEFDBEntities.Entry(store).State = EntityState.Modified;
storeEFDBEntities.SaveChanges();
}
Clear();
StoresDataGridView();
MessageBox.Show("Store added successfully!");
}
private void SupplyPermissionDGV_DoubleClick(object sender, EventArgs e)
{
supplypermission.sp_id = Convert.ToInt32(SupplyPermissionDGV.CurrentRow.Cells[0].Value);
//supplypermission.c_id = Convert.ToInt32(SupplyPermissionDGV.CurrentRow.Cells[4].Value);
//supplypermission.s_id = Convert.ToInt32(SupplyPermissionDGV.CurrentRow.Cells[0].Value);
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
supplypermission = db.SupplyPermissions.Where(x => x.sp_id == supplypermission.sp_id).FirstOrDefault();
textBox23.Text = supplypermission.sp_id.ToString();
textBox24.Text = supplypermission.sp_date.ToString();
textBox30.Text = supplypermission.s_id.ToString();
textBox25.Text = supplypermission.s_name;
textBox31.Text = supplypermission.c_id.ToString();
textBox26.Text = supplypermission.c_quantity.ToString();
textBox32.Text = supplypermission.supp_id.ToString();
textBox27.Text = supplypermission.supp_name;
textBox28.Text = supplypermission.prod_date.ToString();
textBox29.Text = supplypermission.exp_date.ToString();
db.SaveChanges();
}
}
private void button4_Click(object sender, EventArgs e) //categ insert
{
category.c_id = categoryunit.c_id = Convert.ToInt32(textBox5.Text);
category.c_name = textBox6.Text;
categoryunit.unit_id = Convert.ToInt32(textBox8.Text);
categoryunit.unit = textBox7.Text;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
//if (store.s_id == 0)//insert
db.Categories.Add(category);
db.Category_Unit.Add(categoryunit);
//else //update
// storeEFDBEntities.Entry(store).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
CategoryDataGridView();
UnitCategoryDataGridView();
MessageBox.Show("Category added successfully!");
}
private void button13_Click(object sender, EventArgs e) //insert supply permission
{
supplypermission.sp_id = Convert.ToInt32(textBox23.Text);
supplypermission.sp_date = Convert.ToDateTime(textBox24.Text);
supplypermission.s_name = textBox25.Text;
supplypermission.c_quantity = Convert.ToInt32(textBox26.Text);
supplypermission.supp_name = textBox27.Text;
supplypermission.prod_date = Convert.ToDateTime(textBox28.Text);
supplypermission.exp_date = Convert.ToDateTime(textBox29.Text);
supplypermission.s_id = Convert.ToInt32(textBox30.Text);
supplypermission.c_id = Convert.ToInt32(textBox31.Text);
supplypermission.supp_id = Convert.ToInt32(textBox32.Text);
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.SupplyPermissions.Add(supplypermission);
db.SaveChanges();
}
Clear();
SupplyPermissionGridViewer();
MessageBox.Show("Supply permission added successfully!");
}
