private void btnUpdateEmp_Click(object sender, EventArgs e) { name = tbName.Text.ToString(); rank = tbRank.Text.ToString(); phone = tbPhone.Text.ToString(); email = tbMail.Text.ToString(); address = tbAddress.Text.ToString(); nid = tbNid.Text.ToString(); sal = Convert.ToDecimal(tbSal.Text.ToString()); gender = cbGender.SelectedItem.ToString(); if (!name.Equals("") && !rank.Equals("") && !phone.Equals("") && !email.Equals("") && !address.Equals("") && !nid.Equals("") && !gender.Equals("") && sal > 0) { emp.emp_address = address; emp.emp_email = email; emp.emp_gender = gender; emp.emp_name = name; emp.emp_nid = nid; emp.emp_phone = phone; emp.emp_sal = sal; emp.emp_rank = rank; idc.SubmitChanges(); MessageBox.Show("Successfully updated an employee."); } else { lblError.Text = "Please select a row to delete."; } }
private void btnEditProduct_Click(object sender, EventArgs e) { name = txtName.Text.ToString(); brand = cbBrand.SelectedItem.ToString(); cat = cbCat.SelectedItem.ToString(); price = Convert.ToDecimal(txtProductPrice.Text.ToString()); warranty = Convert.ToInt32(txtProductWarrenty.Text.ToString()); quantity = Convert.ToInt32(txtProductQuantity.Text.ToString()); if (!name.Equals("") && !brand.Equals("") && !cat.Equals("") && !price.Equals("") && !quantity.Equals("") && !warranty.Equals("")) { pr.pro_brand = brand; pr.Pro_cat = cat; pr.pro_price = price; pr.pro_quantity = quantity; pr.pro_title = name; pr.pro_warranty = warranty; idc.SubmitChanges(); MessageBox.Show("Successfully Added an product."); } else { lblError.Text = "Please fill all the fields."; } }
private void btnAddCat_Click(object sender, EventArgs e) { name = tbCat.Text.ToString(); category c = new category(); c.cat_title = name; if (!name.Equals("")) { idc.categories.InsertOnSubmit(c); idc.SubmitChanges(); MessageBox.Show("Successfully Added a category."); } else { lblError.Text = "Please fill all the fields."; } }
private void btnAddBrand_Click(object sender, EventArgs e) { name = tbBrands.Text.ToString(); brand b = new brand(); b.brand_title = name; if (!name.Equals("")) { idc.brands.InsertOnSubmit(b); idc.SubmitChanges(); MessageBox.Show("Successfully Added a brand."); } else { lblError.Text = "Please fill all the fields."; } }
private void btnDelEmp_Click(object sender, EventArgs e) { if (gvEmp.SelectedCells[0].Value != null) { int id = Convert.ToInt32(gvEmp.SelectedCells[0].Value.ToString()); employee emp = idc.employees.SingleOrDefault(x => x.emp_id == id); idc.employees.DeleteOnSubmit(emp); idc.SubmitChanges(); MessageBox.Show("Successfully deleted an employee."); } else { lblErrorEmp.Text = "Please select a row to delete."; } }
private void btnAddEmp_Click(object sender, EventArgs e) { name = tbEmpName.Text.ToString(); rank = tbEmpRank.Text.ToString(); phone = tbEmpPhone.Text.ToString(); email = tbEmpMail.Text.ToString(); address = tbEmpAddress.Text.ToString(); nid = tbEmpNID.Text.ToString(); sal = Convert.ToDecimal(tbEmpSal.Text.ToString()); gender = cbGender.SelectedItem.ToString(); join = dtpJoin.Value.ToString("yyyy-MM-dd"); DOB = dtpDOB.Value.ToString("yyyy-MM-dd"); employee emp = new employee(); emp.emp_address = address; emp.emp_dob = Convert.ToDateTime(DOB); emp.emp_email = email; emp.emp_gender = gender; emp.emp_join_date = Convert.ToDateTime(join); emp.emp_name = name; emp.emp_nid = nid; emp.emp_phone = phone; emp.emp_sal = sal; emp.emp_rank = rank; if (!name.Equals("") && !rank.Equals("") && !phone.Equals("") && !email.Equals("") && !address.Equals("") && !nid.Equals("") && !gender.Equals("") && sal > 0) { idc.employees.InsertOnSubmit(emp); idc.SubmitChanges(); MessageBox.Show("Successfully Added an employee."); } else { lblError.Text = "Please fill all the fields."; } }