private void btnUpdate_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { ad_CompanyProfile.AddressLine1 = txtboxAddressLine1.Text.Trim(); ad_CompanyProfile.AddressLine2 = txtboxAddressLine2.Text.Trim(); ad_CompanyProfile.BIN = txtboxBIN.Text.Trim(); ad_CompanyProfile.TIN = txtboxBIN.Text.Trim(); ad_CompanyProfile.CompanyName = txtboxCompanyName.Text.Trim(); ad_CompanyProfile.ContactPersion = txtboxContactPersion.Text.Trim(); ad_CompanyProfile.IncorporationNumber = txtboxIncorporationNumber.Text.Trim(); ad_CompanyProfile.Phone = txtboxPhone.Text.Trim(); ad_CompanyProfile.Remarks = txtboxRemarks.Text.Trim(); ad_CompanyProfile.BusinessNatureId = (int)cmbBusinessNatureId.SelectedValue; ad_CompanyProfile.BusinessTypeId = (int)cmbBusinessTypeId.SelectedValue; ad_CompanyProfile.ModificationDate = DateTime.Now; ad_CompanyProfile.ModifierId = 1; if (ad_CompanyProfile.Id > 0) { db.Entry(ad_CompanyProfile).State = EntityState.Modified; db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Updated Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { ad_MeasurementUnit.Description = txtboxDescription.Text.Trim(); ad_MeasurementUnit.CreationDate = DateTime.Now; ad_MeasurementUnit.CreatorId = 1; ad_MeasurementUnit.ModificationDate = DateTime.Now; ad_MeasurementUnit.ModifierId = 1; if (rdoIsActiveYes.Checked == true) { ad_MeasurementUnit.IsActive = true; } else { ad_MeasurementUnit.IsActive = false; } if (ad_MeasurementUnit.Id == 0) { db.AD_MeasurementUnit.Add(ad_MeasurementUnit); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnUpdate_Click(object sender, EventArgs e) { btnSave.Enabled = true; using (security_modulesEntities db = new security_modulesEntities()) { ad_BusinessType.BusinessType = txtboxBusinessType.Text.Trim(); ad_BusinessType.ModificationDate = DateTime.Now; ad_BusinessType.ModifierId = 1; if (rdoIsActiveYes.Checked == true) { ad_BusinessType.IsActive = true; } else { ad_BusinessType.IsActive = false; } if (ad_BusinessType.Id > 0) { db.Entry(ad_BusinessType).State = EntityState.Modified; db.SaveChanges(); } } LoadDate(); MessageBox.Show("Data Updated Successfuly"); Clear(); }
private void btnSavePrice_Click(object sender, EventArgs e) { try { foreach (var item in AD_ProductPricing) { try { AD_ProductPricing ad_ProductPricing = new AD_ProductPricing(); using (security_modulesEntities db = new security_modulesEntities()) { ad_ProductPricing.ProductId = item.ProductId; ad_ProductPricing.PricingType = item.PricingType; if (ad_ProductPricing.Id == 0) { db.AD_ProductPricing.Add(ad_ProductPricing); db.SaveChanges(); } } } catch (Exception ex) { throw ex; } } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } catch (Exception ex) { throw ex; } }
private void btnUpdate_Click(object sender, EventArgs e) { btnSave.Enabled = true; try { using (security_modulesEntities db = new security_modulesEntities()) { ad_PaymentMethod.PaymentType = txtboxPaymentType.Text.Trim(); ad_PaymentMethod.MethodTypeId = (int)cmbMethodType.SelectedValue; ad_PaymentMethod.ModificationDate = DateTime.Now; ad_PaymentMethod.ModifierId = 1; if (rdoIsActiveYes.Checked == true) { ad_PaymentMethod.IsActive = true; } else { ad_PaymentMethod.IsActive = false; } if (ad_PaymentMethod.Id > 0) { db.Entry(ad_PaymentMethod).State = EntityState.Modified; db.SaveChanges(); } } LoadDate(); MessageBox.Show("Data Updated Successfuly"); Clear(); } catch (Exception ex) { throw ex; } }
private void btnSaveCodeIntegration_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { aD_ProductCodeIntegration.ProductId = (int)cmbProductCode.SelectedValue; aD_ProductCodeIntegration.HSCode = txtboxHScode.Text.Trim(); aD_ProductCodeIntegration.ProductCode = txtboxHScode.Text.Trim(); aD_ProductCodeIntegration.AccountsCode = txtboxAccountCode.Text.Trim(); aD_ProductCodeIntegration.Barcode = Encoding.UTF8.GetBytes(txtboxBarCode.Text.Trim()); if (aD_ProductCodeIntegration.Id == 0) { db.AD_ProductCodeIntegration.Add(aD_ProductCodeIntegration); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { ad_ProductGroup.ProductGroup = txtboxProductGroup.Text.Trim(); ad_ProductGroup.ValuationTypeId = (int)cmbValuationType.SelectedValue; ad_ProductGroup.CreationDate = DateTime.Now; ad_ProductGroup.CreatorId = 1; ad_ProductGroup.ModificationDate = DateTime.Now; ad_ProductGroup.ModifierId = 1; if (rdoIsActiveYes.Checked == true) { ad_ProductGroup.IsActive = true; } else { ad_ProductGroup.IsActive = false; } if (ad_ProductGroup.Id == 0) { db.AD_ProductGroup.Add(ad_ProductGroup); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { aD_Product.Description = txtboxDescription.Text.Trim(); aD_Product.ProductGroup = (int)cmbGroup.SelectedValue; aD_Product.ProductType = (int)cmbProductType.SelectedValue; aD_Product.MeasurementUnit = (int)cmbUnit.SelectedValue; aD_Product.ExpieryDate = dateTimePicker.Value.Date; aD_Product.Rate = Convert.ToDecimal(txtboxRate.Text.Trim()); aD_Product.ROL = Convert.ToDecimal(txtboxROI.Text.Trim()); aD_Product.SD = Convert.ToDecimal(txtboxSD.Text.Trim()); aD_Product.VAT = Convert.ToDecimal(txtboxVAT.Text.Trim()); aD_Product.CreationDate = DateTime.Now; aD_Product.CreatorId = 1; aD_Product.ModificationDate = DateTime.Now; aD_Product.ModifierId = 1; if (aD_Product.Id == 0) { db.AD_Product.Add(aD_Product); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnUpdate_Click(object sender, EventArgs e) { btnSave.Enabled = true; try { using (security_modulesEntities db = new security_modulesEntities()) { aD_OpeningBalanceCompany.OpeningBalance = txtboxOpeningBalance.Text.Trim(); aD_OpeningBalanceCompany.PaymentMethordId = (int)cmbPaymentMethord.SelectedValue; aD_OpeningBalanceCompany.OpeningDate = dateTimePicker.Value; if (aD_OpeningBalanceCompany.Id > 0) { db.Entry(aD_OpeningBalanceCompany).State = EntityState.Modified; db.SaveChanges(); } } LoadDate(); MessageBox.Show("Data Updated Successfuly"); Clear(); } catch (Exception ex) { throw ex; } }
private void btnUpdate_Click(object sender, EventArgs e) { btnSave.Enabled = true; try { using (security_modulesEntities db = new security_modulesEntities()) { ad_Bank.AccountNumber = txtboxAccountNumber.Text.Trim(); ad_Bank.BankName = txtboxBankName.Text.Trim(); ad_Bank.ModificationDate = DateTime.Now; ad_Bank.ModifierId = 1; if (rdoIsActiveYes.Checked == true) { ad_Bank.IsActive = true; } else { ad_Bank.IsActive = false; } if (ad_Bank.Id > 0) { db.Entry(ad_Bank).State = EntityState.Modified; db.SaveChanges(); } } LoadDate(); MessageBox.Show("Data Updated Successfuly"); Clear(); } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { ad_HSCode.AIT = Convert.ToDecimal(txtboxAIT.Text.Trim()); ad_HSCode.AT = Convert.ToDecimal(txtboxAT.Text.Trim()); ad_HSCode.CD = Convert.ToDecimal(txtboxCD.Text.Trim()); ad_HSCode.Description = txtboxDescription.Text.Trim(); ad_HSCode.HSCode = txtboxHSCode.Text.Trim(); ad_HSCode.RD = Convert.ToDecimal(txtboxRD.Text.Trim()); ad_HSCode.SD = Convert.ToDecimal(txtboxSD.Text.Trim()); ad_HSCode.TTL = Convert.ToDecimal(txtboxTTL.Text.Trim()); ad_HSCode.VAT = Convert.ToDecimal(txtboxVAT.Text.Trim()); if (ad_HSCode.Id == 0) { db.AD_HSCode.Add(ad_HSCode); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnUpdate_Click(object sender, EventArgs e) { btnSave.Enabled = true; try { using (security_modulesEntities db = new security_modulesEntities()) { ad_HSCode.AIT = Convert.ToDecimal(txtboxAIT.Text.Trim()); ad_HSCode.AT = Convert.ToDecimal(txtboxAT.Text.Trim()); ad_HSCode.CD = Convert.ToDecimal(txtboxCD.Text.Trim()); ad_HSCode.Description = txtboxDescription.Text.Trim(); ad_HSCode.HSCode = txtboxHSCode.Text.Trim(); ad_HSCode.RD = Convert.ToDecimal(txtboxRD.Text.Trim()); ad_HSCode.SD = Convert.ToDecimal(txtboxSD.Text.Trim()); ad_HSCode.TTL = Convert.ToDecimal(txtboxTTL.Text.Trim()); ad_HSCode.VAT = Convert.ToDecimal(txtboxVAT.Text.Trim()); if (ad_HSCode.Id > 0) { db.Entry(ad_HSCode).State = EntityState.Modified; db.SaveChanges(); } } LoadDate(); MessageBox.Show("Data Updated Successfuly"); Clear(); } catch (Exception ex) { throw ex; } }
private void Delete() { if (MessageBox.Show("Are You Sure to Delete this Record ?", "Business Nature", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (security_modulesEntities db = new security_modulesEntities()) { var entry = db.Entry(ad_BusinessNature); if (entry.State == EntityState.Detached) { db.AD_BusinessNature.Attach(ad_BusinessNature); } db.AD_BusinessNature.Remove(ad_BusinessNature); db.SaveChanges(); LoadDate(); MessageBox.Show("Deleted Successfully"); } } }
private void btnSave_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { ad_Supplier.SupplierName = txtboxSupplierName.Text.Trim(); ad_Supplier.Email = txtboxEmail.Text.Trim(); ad_Supplier.BIN = txtboxBIN.Text.Trim(); ad_Supplier.TIN = txtboxTIN.Text.Trim(); ad_Supplier.NID = txtboxNID.Text.Trim(); ad_Supplier.AddressLine1 = txtboxAddressLine1.Text.Trim(); ad_Supplier.AddressLine2 = txtboxAddressLine2.Text.Trim(); ad_Supplier.PhoneNo1 = txtboxPhoneNumber1.Text.Trim(); ad_Supplier.PhoneNo2 = txtboxPhoneNumber2.Text.Trim(); ad_Supplier.Remarks = txtboxRemarks.Text.Trim(); ad_Supplier.CreationDate = DateTime.Now; ad_Supplier.CreatorId = 1; ad_Supplier.ModificationDate = DateTime.Now; ad_Supplier.ModifierId = 1; if (rdoIsActiveYes.Checked == true) { ad_Supplier.VATAppliable = true; } else { ad_Supplier.VATAppliable = false; } if (ad_Supplier.Id == 0) { db.AD_Supplier.Add(ad_Supplier); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { ad_SalesOutlet.OutletName = txtboxOutletName.Text.Trim(); ad_SalesOutlet.AddressLine1 = txtboxAddressLine1.Text.Trim(); ad_SalesOutlet.AddressLine2 = txtboxAddressLine2.Text.Trim(); ad_SalesOutlet.PhoneNumber1 = txtboxPhoneNumber1.Text.Trim(); ad_SalesOutlet.PhoneNumber2 = txtboxPhoneNumber2.Text.Trim(); ad_SalesOutlet.CreationDate = DateTime.Now; ad_SalesOutlet.CreatorId = 1; ad_SalesOutlet.ModificationDate = DateTime.Now; ad_SalesOutlet.ModifierId = 1; if (rdoIsActiveYes.Checked == true) { ad_SalesOutlet.IsActive = true; } else { ad_SalesOutlet.IsActive = false; } if (ad_SalesOutlet.Id == 0) { db.AD_SalesOutlet.Add(ad_SalesOutlet); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { // var rer = Convert.ToInt32(cmbBusinessNatureId.Text.Substring(cmbBusinessNatureId.Text.IndexOf("(")+1, 1).Trim()); try { using (security_modulesEntities db = new security_modulesEntities()) { ad_CompanyProfile.AddressLine1 = txtboxAddressLine1.Text.Trim(); ad_CompanyProfile.AddressLine2 = txtboxAddressLine2.Text.Trim(); ad_CompanyProfile.BIN = txtboxBIN.Text.Trim(); ad_CompanyProfile.TIN = txtboxBIN.Text.Trim(); ad_CompanyProfile.CompanyName = txtboxCompanyName.Text.Trim(); ad_CompanyProfile.ContactPersion = txtboxContactPersion.Text.Trim(); ad_CompanyProfile.IncorporationNumber = txtboxIncorporationNumber.Text.Trim(); ad_CompanyProfile.Phone = txtboxPhone.Text.Trim(); ad_CompanyProfile.Remarks = txtboxRemarks.Text.Trim(); ad_CompanyProfile.BusinessNatureId = (int)cmbBusinessNatureId.SelectedValue; ad_CompanyProfile.BusinessTypeId = (int)cmbBusinessTypeId.SelectedValue; ad_CompanyProfile.CreationDate = DateTime.Now; ad_CompanyProfile.CreatorId = 1; ad_CompanyProfile.ModificationDate = DateTime.Now; ad_CompanyProfile.ModifierId = 1; if (ad_CompanyProfile.Id == 0) { db.AD_CompanyProfile.Add(ad_CompanyProfile); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }
private void btnSave_Click(object sender, EventArgs e) { try { using (security_modulesEntities db = new security_modulesEntities()) { aD_OpeningBalanceCompany.OpeningBalance = txtboxOpeningBalance.Text.Trim(); aD_OpeningBalanceCompany.PaymentMethordId = (int)cmbPaymentMethord.SelectedValue; aD_OpeningBalanceCompany.OpeningDate = dateTimePicker.Value; if (aD_OpeningBalanceCompany.Id == 0) { db.AD_OpeningBalanceCompany.Add(aD_OpeningBalanceCompany); db.SaveChanges(); } LoadDate(); MessageBox.Show("Data Save Successfuly"); Clear(); } } catch (Exception ex) { throw ex; } }