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;
}
}