private void btnDelete_Click(object sender, EventArgs e) { try { EmpSalary oEmpSalary = new EmpSalary(); if (lsvEmpSalary.SelectedItems != null && lsvEmpSalary.SelectedItems.Count > 0) { oEmpSalary = (EmpSalary)lsvEmpSalary.SelectedItems[0].Tag; if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DEWSRMEntities db = new DEWSRMEntities()) { db.EmpSalaries.Attach(oEmpSalary); db.EmpSalaries.Remove(oEmpSalary); db.SaveChanges(); } RefreshList(); } } } catch (Exception Ex) { MessageBox.Show("Cannot delete item due to " + Ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { using (DEWSRMEntities db = new DEWSRMEntities()) { int[] selRows = ((GridView)grdModels.MainView).GetSelectedRows(); DataRowView oModelID = (DataRowView)(((GridView)grdModels.MainView).GetRow(selRows[0])); int nModelID = Convert.ToInt32(oModelID["ModelID"]); Model oModel = db.Models.FirstOrDefault(p => p.ModelID == nModelID); if (nModelID > 0) { if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.Models.Attach(oModel); db.Models.Remove(oModel); //Save to database db.SaveChanges(); RefreshList(); } } } } catch (Exception Ex) { MessageBox.Show("Cannot delete item due to " + Ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { using (DEWSRMEntities db = new DEWSRMEntities()) { int[] selRows = ((GridView)grdCategorys.MainView).GetSelectedRows(); DataRowView oCategoryD = (DataRowView)(((GridView)grdCategorys.MainView).GetRow(selRows[0])); int nCategoryID = Convert.ToInt32(oCategoryD["CategoryID"]); Category oCategory = db.Categorys.FirstOrDefault(p => p.CategoryID == nCategoryID); if (oCategory == null) { MessageBox.Show("select an item to delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.Categorys.Attach(oCategory); db.Categorys.Remove(oCategory); db.SaveChanges(); MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshList(); } ; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { bool isNew = false; if (!IsValid()) { return; } using (DEWSRMEntities db = new DEWSRMEntities()) { if (_Expenditure.ExpenditureID <= 0) { RefreshObject(); _Expenditure.ExpenditureID = db.Expenditures.Count() > 0? db.Expenditures.Max(obj => obj.ExpenditureID) + 1:1; db.Expenditures.Add(_Expenditure); isNew = true; } else { _Expenditure = db.Expenditures.FirstOrDefault(obj => obj.ExpenditureID == _Expenditure.ExpenditureID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!isNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Expenditure = new Expenditure(); RefreshValue(); txtVoucherNo.Text = GenerateVoucher(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnDelete_Click(object sender, EventArgs e) { try { User oUser = new User(); if (lsvUsers.SelectedItems != null && lsvUsers.SelectedItems.Count > 0) { oUser = (User)lsvUsers.SelectedItems[0].Tag; if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DEWSRMEntities db = new DEWSRMEntities()) { db.Users.Attach(oUser); db.Users.Remove(oUser); db.SaveChanges(); RefreshList(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { int[] selRows = ((GridView)grdCompany.MainView).GetSelectedRows(); Supplier oSupplier = (Supplier)(((GridView)grdCompany.MainView).GetRow(selRows[0])); if (oSupplier == null) { MessageBox.Show("select an item to edit", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.Suppliers.Attach(oSupplier); db.Suppliers.Remove(oSupplier); //Save to database db.SaveChanges(); MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshList(); } } catch (Exception Ex) { MessageBox.Show("Cannot delete item due to " + Ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { int[] selRows = ((GridView)grdExpenditures.MainView).GetSelectedRows(); DataRowView oExpenditureID = (DataRowView)(((GridView)grdExpenditures.MainView).GetRow(selRows[0])); int nExpenditureID = Convert.ToInt32(oExpenditureID["ID"]); Expenditure oExpenditure = db.Expenditures.FirstOrDefault(p => p.ExpenditureID == nExpenditureID); if (oExpenditure == null) { MessageBox.Show("select an item to delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.Expenditures.Attach(oExpenditure); db.Expenditures.Remove(oExpenditure); db.SaveChanges(); MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshList(); } } catch (Exception Ex) { MessageBox.Show("Cannot delete item due to " + Ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { if (!IsValid()) { return; } using (DEWSRMEntities db = new DEWSRMEntities()) { if (_Designation.DesignationID <= 0) { RefreshObject(); _Designation.DesignationID = db.Designations.Count() > 0 ? db.Designations.Max(obj => obj.DesignationID) + 1 : 1; db.Designations.Add(_Designation); } else { _Designation = db.Designations.FirstOrDefault(obj => obj.DesignationID == _Designation.DesignationID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Do you want to create another Designation?", "Create Designation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Designation = new Designation(); RefreshValue(); txtCode.Text = GenerateDegCode(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } bool IsNew = false; using (DEWSRMEntities db = new DEWSRMEntities()) { List <MenuPermission> oNewMenuPermissions = new List <MenuPermission>(); int id = db.MenuPermissions.Count() > 0 ? db.MenuPermissions.Max(obj => obj.MenuPermissionID) + 1 : 1; RefreshObject(oNewMenuPermissions, id); db.MenuPermissions.AddRange(oNewMenuPermissions); foreach (MenuPermission item in _oMenuPermissions) { db.MenuPermissions.Attach(item); } db.MenuPermissions.RemoveRange(_oMenuPermissions); db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!IsNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _MenuPermission = new MenuPermission(); RefreshValue(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { try { bool IsNew = false; if (!IsValid()) { return; } if (_CardTypeSetup.CardTypeSetupID <= 0) { RefreshObject(); _CardTypeSetup.CardTypeSetupID = db.CardTypeSetups.Count() > 0 ? db.CardTypeSetups.Max(obj => obj.CardTypeSetupID) + 1 : 1; db.CardTypeSetups.Add(_CardTypeSetup); IsNew = true; } else { _CardTypeSetup = db.CardTypeSetups.FirstOrDefault(obj => obj.CardTypeSetupID == _CardTypeSetup.CardTypeSetupID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!IsNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _CardTypeSetup = new CardTypeSetup(); RefreshValue(); } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { using (DEWSRMEntities db = new DEWSRMEntities()) { if (_EmpSalary.EmpSalaryID <= 0) { RefreshObject(); _EmpSalary.EmpSalaryID = db.EmpSalaries.Count() > 0 ? db.EmpSalaries.Max(obj => obj.EmpSalaryID) + 1 : 1; db.EmpSalaries.Add(_EmpSalary); } else { _EmpSalary = db.EmpSalaries.FirstOrDefault(obj => obj.EmpSalaryID == _EmpSalary.EmpSalaryID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Do you want to paid another employee salary?", "Salary Paid.", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _EmpSalary = new EmpSalary(); RefreshValue(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnSave_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { using (DEWSRMEntities db = new DEWSRMEntities()) { if (_SystemInformation.SystemInfoID <= 0) { RefreshObject(); _SystemInformation.SystemInfoID = db.SystemInformations.Count() > 0 ? db.SystemInformations.Max(obj => obj.SystemInfoID) + 1 : 1; db.SystemInformations.Add(_SystemInformation); } else { _SystemInformation = db.SystemInformations.FirstOrDefault(obj => obj.SystemInfoID == _SystemInformation.SystemInfoID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); //if (MessageBox.Show("Do you want to create another Customer?", "Create Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) //{ // if (ItemChanged != null) // { // ItemChanged(); // } // this.Close(); //} //else //{ // if (ItemChanged != null) // { // ItemChanged(); // } // _SystemInformation = new INVENTORY.DA.SystemInformation(); // RefreshValue(); //} } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } bool IsNew = false; List <UserRole> oNewUserRoles = new List <UserRole>(); int id = db.UserRoles.Count() > 0 ? db.UserRoles.Max(obj => obj.UserRoleID) + 1 : 1; RefreshObject(oNewUserRoles, id); db.UserRoles.AddRange(oNewUserRoles); foreach (UserRole item in _oUserRoles) { db.UserRoles.Attach(item); } db.UserRoles.RemoveRange(_oUserRoles); db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!IsNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _UserRole = new UserRole(); RefreshValue(); } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { using (DEWSRMEntities db = new DEWSRMEntities()) { if (_Employee.EmployeeID <= 0) { RefreshObject(); _Employee.EmployeeID = db.Employees.Count() > 0 ? db.Employees.Max(obj => obj.EmployeeID) + 1 : 1; db.Employees.Add(_Employee); } else { _Employee = db.Employees.FirstOrDefault(obj => obj.EmployeeID == _Employee.EmployeeID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Do you want to create another Employee?", "Create Employee", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Employee = new Employee(); RefreshValue(); txtEmpCode.Text = GenerateEmpCode(); } } } } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private async void btnSave_Click(object sender, EventArgs e) { if (!IsValid()) { return; } if (MessageBox.Show("Do you want to send SMS?", "Send SMS", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { IQueryable <Customer> CustomerList = null; if (chkSendToAllCustomer.Checked) { CustomerList = db.Customers; } else if (ctlCustomer._IDList != null) { CustomerList = db.Customers.Where(i => ctlCustomer.IDList.Contains(i.CustomerID)); } else { CustomerList = db.Customers.Where(i => i.CustomerType == (int)cboCustomerType.SelectedValue); } List <SMSRequest> smsList = new List <SMSRequest>(); SMSRequest sms = null; foreach (var item in CustomerList) { sms = new SMSRequest(); sms.CustomerID = item.CustomerID; sms.MobileNo = item.ContactNo; sms.SMS = txtSMS.Text; sms.SMSType = EnumSMSType.Offer; smsList.Add(sms); } var response = await Task.Run(() => SMSHTTPService.SendSMSAsync(EnumtestbdType.NumberSms, smsList, Global.SystemInfo)); if (response.Count > 0) { db.SMSStatuses.AddRange(response); db.SaveChanges(); MessageBox.Show("Successfully sent SMS: " + response.Where(i => i.SendingStatus == (int)EnumSMSSendStatus.Success).Count() + " ,Failed: " + response.Where(i => i.SendingStatus == (int)EnumSMSSendStatus.Fail).Count(), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.InnerException.Message, "Failed to send", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public void ReturnBankDepositTransaction(int BankTranID) { if (BankTranID != 0) { using (var dbC = new DEWSRMEntities()) { var BankTrans = dbC.BankTransactions.FirstOrDefault(i => i.BankTranID == BankTranID); if (BankTrans != null) { var bank = dbC.Banks.FirstOrDefault(i => i.BankID == BankTrans.BankID); bank.TotalAmount -= BankTrans.Amount; dbC.BankTransactions.Remove(BankTrans); dbC.SaveChanges(); } } } }
private void btnStockEdit_Click(object sender, EventArgs e) { try { if (StockID > 0) { if (numCurrPrice.Value > 0) { oSTUpdate.PMPrice = numChangePrice.Value; db.SaveChanges(); RefreshStock(); MessageBox.Show("Successfully Price Update."); } } else { MessageBox.Show("Please select stock entry for update Purchase Rate.", "Stock Update"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } bool IsNew = false; using (DEWSRMEntities db = new DEWSRMEntities()) { if (_Product.ProductID <= 0) { _Product.ProductID = db.Products.Count() > 0 ? db.Products.Max(obj => obj.ProductID) + 1 : 1; RefreshObject(); if (txtName.Text.Length > 0) { Product oProductInfo = null; oProductInfo = (Product)db.Products.FirstOrDefault(o => o.ProductName.Trim().ToUpper() == txtName.Text.Trim().ToUpper() && (o.CompanyID == _Product.CompanyID) && (o.CategoryID == _Product.CategoryID) && (o.ModelID == _Product.ModelID) && (o.UnitType == _Product.UnitType)); if (oProductInfo != null) { MessageBox.Show("This product already exists", "Duplicate Product", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); return; } } db.Products.Add(_Product); IsNew = true; } else { _Product = db.Products.FirstOrDefault(obj => obj.ProductID == _Product.ProductID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (ItemChanged != null) { ItemChanged(); } if (!IsNew) { this.Close(); } else { _Product = new Product(); //RefreshValue(); txtCode.Text = GenerateProductCode(); //pbxEmpPic.Image = null; txtName.Text = ""; numMinQTY.Value = 0; numBQty.Value = 0; RefreshControl(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { try { bool isNew = false; if (!IsValid()) { return; } using (DEWSRMEntities db = new DEWSRMEntities()) { if (_ShareInvestmentHead.SIHID <= 0) { #region Validation Check if (txtName.Text.Length > 0) { ShareInvestmentHead oShareInvestmentHead = (ShareInvestmentHead)(db.ShareInvestmentHeads.FirstOrDefault(o => o.Name.Trim().ToUpper() == txtName.Text.Trim().ToUpper())); if (oShareInvestmentHead != null) { MessageBox.Show("Investment name already Exists.", "Duplicate Invest Item.", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); return; } } #endregion RefreshObject(); _ShareInvestmentHead.SIHID = db.ShareInvestmentHeads.Count() > 0 ? db.ShareInvestmentHeads.Max(obj => obj.SIHID) + 1 : 1; db.ShareInvestmentHeads.Add(_ShareInvestmentHead); isNew = true; } else { _ShareInvestmentHead = db.ShareInvestmentHeads.FirstOrDefault(obj => obj.SIHID == _ShareInvestmentHead.SIHID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!isNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _ShareInvestmentHead = new ShareInvestmentHead(); RefreshValue(); txtCode.Text = GenerateInvestCode(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnDelete_Click(object sender, EventArgs e) { try { using (DEWSRMEntities db = new DEWSRMEntities()) { int[] selRows = ((GridView)grdBanks.MainView).GetSelectedRows(); DataRowView oBankD = (DataRowView)(((GridView)grdBanks.MainView).GetRow(selRows[0])); int nBankID = Convert.ToInt32(oBankD["BankID"]); Bank oBank = db.Banks.FirstOrDefault(p => p.BankID == nBankID); if (oBank == null) { MessageBox.Show("select an item to delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { db.Banks.Attach(oBank); db.Banks.Remove(oBank); db.SaveChanges(); MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshList(); } ; } } catch (Exception ex) { MessageBox.Show(ex.Message); } //try //{ // Category oCategory = new Category(); // if (lsvCategory.SelectedItems != null && lsvCategory.SelectedItems.Count > 0) // { // oCategory = (Category)lsvCategory.SelectedItems[0].Tag; // if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo, // MessageBoxIcon.Question) == DialogResult.Yes) // { // using (DEWSRMEntities db = new DEWSRMEntities()) // { // db.Categorys.Attach(oCategory); // db.Categorys.Remove(oCategory); // //Save to database // db.SaveChanges(); // } // RefreshList(); // } // } //} //catch (Exception Ex) //{ // MessageBox.Show("Cannot delete item due to " + Ex.Message); //} }
private void btnSave_Click(object sender, EventArgs e) { try { #region Save Return if (_Return.ReturnID <= 0) { RefreshObject(); #region Return Orders _Return.ReturnID = db.Returns.Count() > 0 ? db.Returns.Max(obj => obj.ReturnID) + 1 : 1; _Return.CreatedBy = Global.CurrentUser.UserID; _Return.CreatedDate = DateTime.Now; int detailid = db.ReturnDetails.Count() > 0 ? db.ReturnDetails.Max(obj => obj.ReturnDetailsID) + 1 : 1; var ProductList = db.Products.ToList(); foreach (ReturnDetail item in _ReturnDetails) { item.ReturnDetailsID = detailid; item.ReturnID = _Return.ReturnID; db.ReturnDetails.Add(item); detailid++; } db.Returns.Add(_Return); #endregion #region Stock Updates foreach (ReturnDetail item in _ReturnDetails) { _TranStock = null; _TranStockDetail = null; _TranStockDetail = db.StockDetails.FirstOrDefault(o => o.SDetailID == item.SDetailID); _TranStock = db.Stocks.FirstOrDefault(o => o.ProductID == item.ProductID && o.ColorID == _TranStockDetail.ColorID); var oProduct = ProductList.FirstOrDefault(i => i.ProductID == item.ProductID); if (oProduct.ProductType == (int)EnumProductType.NoBarCode) { _TranStockDetail.Quantity -= (decimal)item.Quantity; if (_TranStockDetail.Quantity == 0) { _TranStockDetail.Status = (int)EnumStockDetailStatus.Sold; } } else { _TranStockDetail.Status = (int)EnumStockDetailStatus.Sold; } _TranStock.Quantity = _TranStock.Quantity - (decimal)item.Quantity; _TranStock.EntryDate = DateTime.Today; #endregion #region Update Supplier Due Amount _oSupplier = (Supplier)(db.Suppliers.FirstOrDefault(o => o.SupplierID == _Return.SupplierID)); _oSupplier.TotalDue = numPrevDue.Value - numTotalDueAmt.Value; #endregion //_oCustomer = (Customer)(db.Customers.FirstOrDefault(o => o.CustomerID == _Return.CustomerID)); //_oCustomer.TotalDue = numPrevDue.Value - (numTotalDueAmt.Value); } } else //Update { int detailid = db.ReturnDetails.Count() > 0 ? db.ReturnDetails.Max(obj => obj.ReturnDetailsID) + 1 : 1; RefreshObject(); _Return.ModifiedBy = (int)Global.CurrentUser.UserID; _Return.ModifiedDate = (DateTime)DateTime.Today; if (_RemoveReturnDetail != null) { foreach (ReturnDetail item in _RemoveReturnDetail) { //_TranStock = db.Stocks.FirstOrDefault(o => o.ProductID == item.ProductID && o.GodownID == item.GodownID); _TranStockDetail = db.StockDetails.FirstOrDefault(o => o.ProductID == item.ProductID && o.SDetailID == item.SDetailID); _TranStock = db.Stocks.FirstOrDefault(o => o.ProductID == item.ProductID && o.ColorID == _TranStockDetail.ColorID); _TranStock.Quantity = _TranStock.Quantity + (decimal)item.Quantity; _TranStock.EntryDate = DateTime.Today; _TranStockDetail.Quantity = _TranStockDetail.Quantity + item.Quantity; #region Update Supplier Due Amount _oSupplier = (Supplier)(db.Suppliers.FirstOrDefault(o => o.SupplierID == _Return.SupplierID)); _oSupplier.TotalDue = numPrevDue.Value + _currentCredit - numTotalDueAmt.Value; #endregion //_oCustomer = (Customer)(db.Customers.FirstOrDefault(o => o.CustomerID == _Return.CustomerID)); //_oCustomer.TotalDue = numPrevDue.Value + _currentCredit - numTotalDueAmt.Value; db.SaveChanges(); db.ReturnDetails.Remove(item); } } foreach (ReturnDetail item in _ReturnDetails) { if (item.ReturnDetailsID <= 0) { item.ReturnDetailsID = detailid; item.ReturnID = _Return.ReturnID; db.ReturnDetails.Add(item); detailid++; } } } RefreshObject(); db.SaveChanges(); MessageBox.Show("Returned successfully.", "Return Information", MessageBoxButtons.OK, MessageBoxIcon.Information); #endregion GenerateReturnInvoice(_Return); ItemChanged(); numPrevDue.Value = 0; numTotalDueAmt.Value = 0; _Return = new Return(); _ReturnDetails = new List <ReturnDetail>(); RefreshValue(); RefreshControl(); RefreshGrid(); } catch (Exception EX) { MessageBox.Show(EX.Message); } //RefreshStock(); //RefreshCustomerDue(); //RefreshSupplierDue(); }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } bool isNew = false; using (DEWSRMEntities db = new DEWSRMEntities()) { if (_Godown.GodownID <= 0) { #region Validaton Check if (txtName.Text.Length > 0) { Godown oGodown = (Godown)(db.Godowns.FirstOrDefault(o => o.GodownName.Trim().ToUpper() == txtName.Text.Trim().ToUpper())); if (oGodown != null) { MessageBox.Show("This Godown already exists.", "Duplicate Godown.", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); return; } } #endregion RefreshObject(); _Godown.GodownID = db.Godowns.Count() > 0 ? db.Godowns.Max(obj => obj.GodownID) + 1 : 1; db.Godowns.Add(_Godown); isNew = true; } else { _Godown = db.Godowns.FirstOrDefault(obj => obj.GodownID == _Godown.GodownID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!isNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Godown = new Godown(); RefreshValue(); txtCode.Text = GenerateCode(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnReturn_Click(object sender, EventArgs e) { try { int[] selRows = ((GridView)grdOrders.MainView).GetSelectedRows(); DataRowView oOrderID = (DataRowView)((GridView)grdOrders.MainView).GetRow(selRows[0]); DataRowView InvoiceDate = (DataRowView)(((GridView)grdOrders.MainView).GetRow(selRows[0])); int nOrdersID = Convert.ToInt32(oOrderID["OrderID"]); DateTime dInvoiceDate = Convert.ToDateTime(InvoiceDate["OrderDate"]); List <Stock> oStockList = db.Stocks.ToList(); List <StockDetail> oStockDList = db.StockDetails.ToList(); if (nOrdersID <= 0) { MessageBox.Show("Select an item to cancel order.", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (Global.CurrentUser.ISEditable == 1) { if (dInvoiceDate < DateTime.Today) { MessageBox.Show("This order can't be return, Please contact BD Team", "Unauthorized Access", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } if (MessageBox.Show("Do you want to return this order sure?", "Return Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (nOrdersID > 0) { _Order = db.SOrders.FirstOrDefault(s => s.SOrderID == nOrdersID); if (_Order.Status == (int)EnumSalesType.Return) { MessageBox.Show("This item already return please select correct item.", "Return Item", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } #region Update SOrder Data _Order.Status = (int)EnumSalesType.Return; #endregion #region Stock Data Stock oStock = null; StockDetail oStockDetail = null; Product oProduct = null; foreach (SOrderDetail sODetail in _Order.SOrderDetails) { oProduct = db.Products.FirstOrDefault(i => i.ProductID == sODetail.ProductID); oStockDetail = oStockDList.FirstOrDefault(sd => sd.SDetailID == sODetail.StockDetailID); if (oStockDetail != null) { oStock = oStockList.FirstOrDefault(o => o.ProductID == sODetail.ProductID && o.StockID == oStockDetail.StockID); } oStock.Quantity = oStock.Quantity + sODetail.Quantity; oStockDetail.Status = (int)EnumStockDetailStatus.Stock; if (oProduct.ProductType == (int)EnumProductType.NoBarCode) { oStockDetail.Quantity += sODetail.Quantity; } } #endregion #region Update Customer Due Amount Customer oCustomer = db.Customers.FirstOrDefault(c => c.CustomerID == _Order.CustomerID); if (oCustomer != null) { oCustomer.TotalDue = (decimal)(oCustomer.TotalDue - _Order.PaymentDue); } #endregion #region Bank Transactions and Bank Update if (_Order.BankTranID != 0) { FCreditSales bankdepo = new FCreditSales(); bankdepo.ReturnBankDepositTransaction(_Order.BankTranID); } #endregion db.SaveChanges(); MessageBox.Show("Order return successfully.", "Return Information", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshList(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } bool IsNew = false; using (DEWSRMEntities db = new DEWSRMEntities()) { if (_Company.CompanyID <= 0) { if (txtName.Text.Length > 0) { Company oCompany = (Company)(db.Companies.FirstOrDefault(o => o.Description.Trim().ToUpper() == txtName.Text.Trim().ToUpper())); if (oCompany != null) { MessageBox.Show("This Company already exists.", "Duplicate Company.", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); return; } } RefreshObject(); _Company.CompanyID = db.Companies.Count() > 0 ? db.Companies.Max(obj => obj.CompanyID) + 1 : 1; db.Companies.Add(_Company); IsNew = true; } else { _Company = db.Companies.FirstOrDefault(obj => obj.CompanyID == _Company.CompanyID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!IsNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Company = new Company(); RefreshValue(); txtCode.Text = GenerateCode(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { try { if (!IsValid()) { return; } bool IsNew = false; using (DEWSRMEntities db = new DEWSRMEntities()) { //if (_Bank.BankID <= 0) //{ // if (txtName.Text.Length > 0) // { // Bank oBank = null; // oBank = (Bank)db.Banks.FirstOrDefault(o => o.BankName.Trim().ToUpper() == txtName.Text.Trim().ToUpper()); // if (oBank != null) // { // MessageBox.Show("This Bank already Exists.", "Duplicate Category", MessageBoxButtons.OK, MessageBoxIcon.Error); // txtName.Focus(); // return; // } // } //} if (_Bank.BankID <= 0) { RefreshObject(); _Bank.BankID = db.Banks.Count() > 0 ? db.Banks.Max(obj => obj.BankID) + 1 : 1; db.Banks.Add(_Bank); IsNew = true; } else { _Bank = db.Banks.FirstOrDefault(obj => obj.BankID == _Bank.BankID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!IsNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _Bank = new Bank(); RefreshValue(); txtCode.Text = GenerateCategoryCode(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSave_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { bool isNew = false; #region Stock if (_stock != null) { _stock.Quantity = _stock.Quantity - numQTY.Value; } if (_StockDetail != null) { _StockDetail.Status = (int)EnumStockDetailStatus.Damage; } //if (_oProduct.IsBarCode == 3) //{ // if (numStock.Value == 0) // { // _StockDetail.Status = (int)EnumStockDetailStatus.Sold; // } //} //else //{ // _StockDetail.Status = (int)EnumStockDetailStatus.Sold; //} #endregion if (_DamageProduct.DamageProID <= 0) { RefreshObject(); _DamageProduct.CreatedBy = Global.CurrentUser.UserID; _DamageProduct.CreateDate = DateTime.Now; _DamageProduct.SDetailID = _StockDetail.SDetailID; //_DamageProduct.DamageProID = db.DamageProducts.Count() > 0 ? db.DamageProducts.Max(obj => obj.DamageProID) + 1 : 1; db.DamageProducts.Add(_DamageProduct); isNew = true; } else { _DamageProduct = db.DamageProducts.FirstOrDefault(obj => obj.DamageProID == _DamageProduct.DamageProID); RefreshObject(); _DamageProduct.SDetailID = ctlProduct.SelectedID; _DamageProduct.ModifiedDate = (DateTime)DateTime.Today; _DamageProduct.ModifiedBy = (int)Global.CurrentUser.UserID; } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!isNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _DamageProduct = new DamageProduct(); RefreshValue(); } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnSave_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { if (_CashCollection.CashCollectionID <= 0) { RefreshObject(); _CashCollection.CashCollectionID = db.CashCollections.Count() > 0 ? db.CashCollections.Max(obj => obj.CashCollectionID) + 1 : 1; db.CashCollections.Add(_CashCollection); if (_oCustomer != null) { _oCustomer.TotalDue -= (decimal)_CashCollection.Amount + (decimal)_CashCollection.AdjustAmt; } } else { _CashCollection = db.CashCollections.FirstOrDefault(obj => obj.CashCollectionID == _CashCollection.CashCollectionID); RefreshObject(); if (_oCustomer != null) { _oCustomer.TotalDue = _oCustomer.TotalDue + PrvCashCollAmt; _oCustomer.TotalDue -= ((decimal)_CashCollection.Amount + _CashCollection.AdjustAmt); } } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Do you want to create another Collection?", "Create Collection", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { if (_oCustomer != null) { MoneyReceipt(_CashCollection); } if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (_oCustomer != null) { MoneyReceipt(_CashCollection); } if (ItemChanged != null) { ItemChanged(); } _CashCollection = new CashCollection(); RefreshValue(); txtReceiptNo.Text = GenerateReceipt(); } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnSave_Click(object sender, EventArgs e) { try { bool IsNew = false; if (!IsValid()) { return; } if (_BankTransaction.BankTranID <= 0) { RefreshObject(); if (_BankTransaction.TransactionType == 1) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; Previous = Previous + (double)_BankTransaction.Amount; oBank.TotalAmount = (decimal)Previous; } else if (_BankTransaction.TransactionType == 2) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; if (Previous < (double)_BankTransaction.Amount) { MessageBox.Show("Amount is not availabe", "Bank Amount", MessageBoxButtons.OK, MessageBoxIcon.Information); numRPAmount.Focus(); return; } Previous = Previous - (double)_BankTransaction.Amount; oBank.TotalAmount = (decimal)Previous; } else if (_BankTransaction.TransactionType == 3) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; Previous = Previous + (double)_BankTransaction.Amount; oBank.TotalAmount = (decimal)Previous; Previous = (double)_Customer.TotalDue; Previous = Previous - (double)_BankTransaction.Amount; _Customer.TotalDue = (decimal)Previous; } else if (_BankTransaction.TransactionType == 4) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; if (Previous < (double)_BankTransaction.Amount) { MessageBox.Show("Amount is not availabe", "Bank Amount", MessageBoxButtons.OK, MessageBoxIcon.Information); numRPAmount.Focus(); return; } Previous = Previous - (double)_BankTransaction.Amount; oBank.TotalAmount = (decimal)Previous; Previous = (double)_Supplier.TotalDue; Previous = Previous - (double)_BankTransaction.Amount; _Supplier.TotalDue = (decimal)Previous; } else if (_BankTransaction.TransactionType == 5) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; Previous = Previous - (double)_BankTransaction.Amount; if (Previous < (double)_BankTransaction.Amount) { MessageBox.Show("Amount is not availabe", "Bank Amount", MessageBoxButtons.OK, MessageBoxIcon.Information); numRPAmount.Focus(); return; } if (ctlBank.SelectedID == ctlAnotherBank.SelectedID) { MessageBox.Show("Fund Transfer to same bank is not possible", "Fund Transfer", MessageBoxButtons.OK, MessageBoxIcon.Information); ctlAnotherBank.Focus(); return; } oBank.TotalAmount = (decimal)Previous; Previous = (double)_AnotherBank.TotalAmount; Previous = Previous + (double)_BankTransaction.Amount; _AnotherBank.TotalAmount = (decimal)Previous; } _BankTransaction.BankTranID = db.BankTransactions.Count() > 0 ? db.BankTransactions.Max(obj => obj.BankTranID) + 1 : 1; db.BankTransactions.Add(_BankTransaction); IsNew = true; } else { if (_BankTransaction.TransactionType == 1) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; double changeAmt = (double)numRPAmount.Value - (double)numEditAmt.Value; Previous = Previous + changeAmt - (double)numEditAmt.Value; oBank.TotalAmount = (decimal)Previous; } else if (_BankTransaction.TransactionType == 2) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; if (Previous < (double)_BankTransaction.Amount) { MessageBox.Show("Amount is not availabe", "Bank Amount", MessageBoxButtons.OK, MessageBoxIcon.Information); numRPAmount.Focus(); return; } double changeAmt = (double)numRPAmount.Value - (double)numEditAmt.Value; Previous = Previous - changeAmt - (double)numEditAmt.Value; oBank.TotalAmount = (decimal)Previous; } else if (_BankTransaction.TransactionType == 3) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; Previous = Previous + (double)_BankTransaction.Amount; oBank.TotalAmount = (decimal)Previous; Previous = (double)_Customer.TotalDue; double changeAmt = (double)numRPAmount.Value - (double)numEditAmt.Value; Previous = Previous - changeAmt - (double)numEditAmt.Value; _Customer.TotalDue = (decimal)Previous; } else if (_BankTransaction.TransactionType == 4) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; Previous = Previous - (double)_BankTransaction.Amount; oBank.TotalAmount = (decimal)Previous; Previous = (double)_Supplier.TotalDue; double changeAmt = (double)numRPAmount.Value - (double)numEditAmt.Value; Previous = Previous - changeAmt - (double)numEditAmt.Value; _Supplier.TotalDue = (decimal)Previous; } else if (_BankTransaction.TransactionType == 5) { Bank oBank = db.Banks.FirstOrDefault(o => o.BankID == _BankTransaction.BankID); double Previous = (double)oBank.TotalAmount; Previous = Previous - (double)_BankTransaction.Amount; if (Previous < (double)_BankTransaction.Amount) { MessageBox.Show("Amount is not availabe", "Bank Amount", MessageBoxButtons.OK, MessageBoxIcon.Information); numRPAmount.Focus(); return; } if (ctlBank.SelectedID == ctlAnotherBank.SelectedID) { MessageBox.Show("Fund Transfer to same bank is not possible", "Fund Transfer", MessageBoxButtons.OK, MessageBoxIcon.Information); ctlAnotherBank.Focus(); return; } oBank.TotalAmount = (decimal)Previous; Previous = (double)_AnotherBank.TotalAmount; double changeAmt = (double)numRPAmount.Value - (double)numEditAmt.Value; Previous = Previous + changeAmt; _AnotherBank.TotalAmount = (decimal)Previous; } _BankTransaction = db.BankTransactions.FirstOrDefault(obj => obj.BankTranID == _BankTransaction.BankTranID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (!IsNew) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _BankTransaction = new BankTransaction(); RefreshValue(); } //} } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnCreate_Click(object sender, EventArgs e) { if (MessageBox.Show("Do you want to save the information?", "Save Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { if (!IsValid()) { return; } using (DEWSRMEntities db = new DEWSRMEntities()) { if (_User.UserID <= 0) { if (txtUserName.Text.Length > 0) { User oUser = (User)(db.Users.FirstOrDefault(o => o.UserName.Trim().ToUpper() == txtUserName.Text.Trim().ToUpper())); if (oUser != null) { MessageBox.Show("This User already exists.", "Duplicate User.", MessageBoxButtons.OK, MessageBoxIcon.Error); txtUserName.Focus(); return; } } RefreshObject(); _User.UserID = db.Users.Count() > 0 ? db.Users.Max(obj => obj.UserID) + 1 : 1; db.Users.Add(_User); } else { _User = db.Users.FirstOrDefault(obj => obj.UserID == _User.UserID); RefreshObject(); } db.SaveChanges(); MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information); if (MessageBox.Show("Do you want to create another User?", "Create User", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { if (ItemChanged != null) { ItemChanged(); } this.Close(); } else { if (ItemChanged != null) { ItemChanged(); } _User = new User(); RefreshValue(); } } } catch (Exception ex) { if (ex.InnerException == null) { MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void btnDelete_Click(object sender, EventArgs e) { try { CreditSale oCreditSale = new CreditSale(); _oFCreditSale = new FCreditSale(); List <Stock> oStockList = db.Stocks.ToList(); List <StockDetail> oStockDList = db.StockDetails.ToList(); int[] selRows = ((GridView)grdCreditSalesCustomers.MainView).GetSelectedRows(); DataRowView oCreditSalesCustomerD = (DataRowView)(((GridView)grdCreditSalesCustomers.MainView).GetRow(selRows[0])); int nCreditSalesCustomerID = Convert.ToInt32(oCreditSalesCustomerD["CreditSalesID"]); Product oProduct = null; Stock oStock = null; StockDetail oStockDetail = null; if (nCreditSalesCustomerID > 0) { oCreditSale = db.CreditSales.FirstOrDefault(p => p.CreditSalesID == nCreditSalesCustomerID); if (oCreditSale != null) { if (MessageBox.Show("Do you want to return the selected item?", "Return Item", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { List <CreditSaleProduct> CSP = db.CreditSaleProducts.Where(cp => cp.CreditSalesID == oCreditSale.CreditSalesID).ToList(); foreach (CreditSaleProduct item in CSP) { oProduct = db.Products.FirstOrDefault(i => i.ProductID == item.ProductID); oStockDetail = oStockDList.FirstOrDefault(sd => sd.SDetailID == item.StockDetailID); if (oStockDetail != null) { oStock = oStockList.FirstOrDefault(o => o.ProductID == item.ProductID && o.StockID == oStockDetail.StockID); } oStock.Quantity = (decimal)(oStock.Quantity + item.Quantity); oStockDetail.Status = (int)EnumStockDetailStatus.Stock; if (oProduct.ProductType == (int)EnumProductType.NoBarCode) { oStockDetail.Quantity += (decimal)item.Quantity; } //Stock oStock = db.Stocks.FirstOrDefault(o => o.ProductID == item.ProductID && o.ColorID == item.ColorInfoID); } List <CreditSalesDetail> CSD = db.CreditSalesDetails.Where(o => o.CreditSalesID == oCreditSale.CreditSalesID).ToList(); foreach (CreditSalesDetail oCSD in CSD) { db.CreditSalesDetails.Attach(oCSD); db.CreditSalesDetails.Remove(oCSD); } foreach (CreditSaleProduct oCSP in CSP) { db.CreditSaleProducts.Attach(oCSP); db.CreditSaleProducts.Remove(oCSP); } #region Customer Due Amount Update Customer oCustomer = db.Customers.FirstOrDefault(c => c.CustomerID == oCreditSale.CustomerID); if (oCustomer != null) { oCustomer.CreditDue = (decimal)(oCustomer.CreditDue - oCreditSale.Remaining); } #endregion db.CreditSales.Attach(oCreditSale); db.CreditSales.Remove(oCreditSale); if (oCreditSale.BankTranID != 0) { ReturnBankDepositTransaction(oCreditSale.BankTranID); } db.SaveChanges(); RefreshList(); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }