private void OpenCustomerLedgerddUpdateForm(bool isEdit) { try { frmCustomerLedgerMasterAddUpdate form = new frmCustomerLedgerMasterAddUpdate(isEdit); form.IsInChildMode = true; ExtensionMethods.AddChildFormToPanel(this, form, ExtensionMethods.MainPanel); form.WindowState = FormWindowState.Maximized; if (isEdit && dgvCustomerLedger.SelectedRows[0] != null) { CustomerLedgerMaster existingItem = (CustomerLedgerMaster)dgvCustomerLedger.SelectedRows[0].DataBoundItem; form.frmCustomerLedgerMasterAddUpdate_Fill_UsingExistingItem(existingItem); form.LoadCustomerCompanyDiscountGrid(); } form.FormClosed += Form_FormClosed; form.Show(); if (!isEdit) { CustomerLedgerMaster nextCust = new CustomerLedgerMaster() { CustomerLedgerName = txtSearch.Text }; form.ConfigureCustomerLedger(nextCust); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDelete_Click(object sender, EventArgs e) { try { DialogResult result = MessageBox.Show(Constants.Messages.DeletePrompt, Constants.Messages.Confirmation, MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { if (dgvCustomerLedger.SelectedRows.Count == 0) { MessageBox.Show("Please select atleast one row to delete"); } if (dgvCustomerLedger.SelectedRows[0] != null) { CustomerLedgerMaster existingItem = (CustomerLedgerMaster)dgvCustomerLedger.SelectedRows[0].DataBoundItem; deleteCustomerLedger(existingItem); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnEdit_Click(object sender, EventArgs e) { try { if (dgvCustomerLedger.SelectedRows.Count == 0) { MessageBox.Show("Please select atleast one row to edit"); } if (dgvCustomerLedger.SelectedRows[0] != null) { frmCustomerLedgerMasterAddUpdate form = new frmCustomerLedgerMasterAddUpdate(true); form.IsInChildMode = true; ExtensionMethods.AddChildFormToPanel(this, form, ExtensionMethods.MainPanel); form.WindowState = FormWindowState.Maximized; CustomerLedgerMaster existingItem = (CustomerLedgerMaster)dgvCustomerLedger.SelectedRows[0].DataBoundItem; form.frmCustomerLedgerMasterAddUpdate_Fill_UsingExistingItem(existingItem); form.LoadCustomerCompanyDiscountGrid(); form.FormClosed += Form_FormClosed; form.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { //Add if (keyData == (Keys.F9)) { OpenCustomerLedgerddUpdateForm(false); return(true); } else if (keyData == Keys.F3) { if (dgvCustomerLedger.SelectedRows.Count == 0) { MessageBox.Show("Please select atleast one row to edit"); } OpenCustomerLedgerddUpdateForm(true); return(true); } else if (keyData == Keys.Delete) { DialogResult result = MessageBox.Show(Constants.Messages.DeletePrompt, Constants.Messages.Confirmation, MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { if (dgvCustomerLedger.SelectedRows.Count == 0) { MessageBox.Show("Please select atleast one row to delete"); } CustomerLedgerMaster existingItem = (CustomerLedgerMaster)dgvCustomerLedger.SelectedRows[0].DataBoundItem; deleteCustomerLedger(existingItem); } return(true); } else if (keyData == Keys.Down) { dgvCustomerLedger.Focus(); } else if (keyData == Keys.Enter && IsInChildMode && dgvCustomerLedger.SelectedRows.Count > 0) { this.Close(); } else if (keyData == Keys.Escape) { if (IsInChildMode) { if (DialogResult.Yes == MessageBox.Show(Constants.Messages.ClosePrompt, Constants.Messages.Confirmation, MessageBoxButtons.YesNo, MessageBoxIcon.Warning)) { this.Close(); } } else { this.Close(); } } return(base.ProcessCmdKey(ref msg, keyData)); }
private void deleteCustomerLedger(CustomerLedgerMaster customerLedger) { if (customerLedger != null) { applicationFacade.DeleteCustomerLedger(customerLedger.CustomerLedgerId); LoadDataGrid(); } }
public int UpdateCustomerLedger(CustomerLedgerMaster p) { try { return(new CustomerLedgerMasterBiz(this.LoggedInUser).UpdateCustomerLedger(p)); } catch (Exception) { throw; } }
private void frmCustomerLedgerMaster_FormClosing(object sender, FormClosingEventArgs e) { try { if (dgvCustomerLedger.CurrentRow != null) { this.LastSelectedCustomerLedger = dgvCustomerLedger.CurrentRow.DataBoundItem as CustomerLedgerMaster; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void dgvCustomerLedger_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { frmCustomerLedgerMasterAddUpdate form = new frmCustomerLedgerMasterAddUpdate(true); form.IsInChildMode = true; ExtensionMethods.AddChildFormToPanel(this, form, ExtensionMethods.MainPanel); CustomerLedgerMaster existingItem = (CustomerLedgerMaster)dgvCustomerLedger.CurrentRow.DataBoundItem; form.frmCustomerLedgerMasterAddUpdate_Fill_UsingExistingItem(existingItem); form.LoadCustomerCompanyDiscountGrid(); form.FormClosed += Form_FormClosed; form.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void FormCustomerLedgerMaster_FormClosed(object sender, FormClosedEventArgs e) { try { ExtensionMethods.RemoveChildFormToPanel(this, (Control)sender, ExtensionMethods.MainPanel); CustomerLedgerMaster selectedCustomer = (sender as frmCustomerLedgerMaster).LastSelectedCustomerLedger; if (selectedCustomer != null) { ReceiptPaymentItem receiptPaymentForSelectedCust = new ReceiptPaymentItem() { VoucherTypeCode = Constants.VoucherTypeCode.RECEIPTFROMCUSTOMER, VoucherDate = ExtensionMethods.ConvertToSystemDateFormat(dtReceiptPayment.Text), LedgerType = Constants.LedgerType.CustomerLedger, LedgerTypeCode = selectedCustomer.CustomerLedgerCode, LedgerTypeName = selectedCustomer.CustomerLedgerName, PaymentMode = Constants.PaymentMode.CASH, BankAccountLedgerTypeCode = Convert.ToString(txtTransactAccount.Tag), BankAccountLedgerTypeName = Convert.ToString(txtTransactAccount.Text), ChequeDate = DateTime.Now }; TransactionEntity transactionEntity = new TransactionEntity() { EntityType = Constants.LedgerType.CustomerLedger, EntityCode = selectedCustomer.CustomerLedgerCode }; UpdateReceiptPaymentRow(receiptPaymentForSelectedCust); LoadGridBillOutstanding(transactionEntity); dgvReceiptFromCustomer.Focus(); dgvReceiptFromCustomer.CurrentCell = dgvReceiptFromCustomer.Rows[dgvReceiptFromCustomer.SelectedCells[0].RowIndex].Cells["ChequeNumber"]; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//ADD/UPDATE/DELETE Functionality private void btnAddNew_Click(object sender, EventArgs e) { try { frmCustomerLedgerMasterAddUpdate form = new frmCustomerLedgerMasterAddUpdate(false); form.IsInChildMode = true; ExtensionMethods.AddChildFormToPanel(this, form, ExtensionMethods.MainPanel); form.WindowState = FormWindowState.Maximized; form.FormClosed += Form_FormClosed; form.Show(); CustomerLedgerMaster nextCust = new CustomerLedgerMaster() { CustomerLedgerName = txtSearch.Text }; form.ConfigureCustomerLedger(nextCust); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void StartMigration() { CompanyMaster companyMaster = new CompanyMaster(); ItemMaster itemMaster = new ItemMaster(); PersonRouteMaster personRouteMaster = new PersonRouteMaster(); PersonalLedgerMaster personalLedgerMaster = new PersonalLedgerMaster(); AccountLedgerMaster accountLedgerMaster = new AccountLedgerMaster(); SupplierLedgerMaster supplierLedgerMaster = new SupplierLedgerMaster(); CustomerLedgerMaster customerLedgerMaster = new CustomerLedgerMaster(); BillOutstanding billOutstanding = new BillOutstanding(); FIFO fifo = new FIFO(); int result; grdDataMigration.Rows.Add("Company Master", "Processing", 0); result = 0; result = companyMaster.InsertCompanyMasterData(); grdDataMigration.Rows[0].Cells[1].Value = "Completed"; grdDataMigration.Rows[0].Cells[2].Value = result; grdDataMigration.Rows.Add("A.S.M.", "Processing", 0); result = 0; result = personRouteMaster.InsertASMData(); grdDataMigration.Rows[1].Cells[1].Value = "Completed"; grdDataMigration.Rows[1].Cells[2].Value = result; grdDataMigration.Rows.Add("R.S.M.", "Processing", 0); result = 0; result = personRouteMaster.InsertRSMData(); grdDataMigration.Rows[2].Cells[1].Value = "Completed"; grdDataMigration.Rows[2].Cells[2].Value = result; grdDataMigration.Rows.Add("Z.S.M.", "Processing", 0); result = 0; result = personRouteMaster.InsertZSMData(); grdDataMigration.Rows[3].Cells[1].Value = "Completed"; grdDataMigration.Rows[3].Cells[2].Value = result; grdDataMigration.Rows.Add("Sales Man", "Processing", 0); result = 0; result = personRouteMaster.InsertSalesManData(); grdDataMigration.Rows[4].Cells[1].Value = "Completed"; grdDataMigration.Rows[4].Cells[2].Value = result; grdDataMigration.Rows.Add("Area", "Processing", 0); result = 0; result = personRouteMaster.InsertAreaData(); grdDataMigration.Rows[5].Cells[1].Value = "Completed"; grdDataMigration.Rows[5].Cells[2].Value = result; grdDataMigration.Rows.Add("Route", "Processing", 0); result = 0; result = personRouteMaster.InsertRouteData(); grdDataMigration.Rows[6].Cells[1].Value = "Completed"; grdDataMigration.Rows[6].Cells[2].Value = result; grdDataMigration.Rows.Add("Personal Details", "Processing", 0); result = 0; result = personalLedgerMaster.InsertPersonalLedgerMasterData(); grdDataMigration.Rows[7].Cells[1].Value = "Completed"; grdDataMigration.Rows[7].Cells[2].Value = result; grdDataMigration.Rows.Add("Control Codes", "Processing", 0); result = 0; result = accountLedgerMaster.InsertControlCodesData(); grdDataMigration.Rows[8].Cells[1].Value = "Completed"; grdDataMigration.Rows[8].Cells[2].Value = result; grdDataMigration.Rows.Add("Income Ledger", "Processing", 0); result = 0; result = accountLedgerMaster.InsertIncomeLedgerData(); grdDataMigration.Rows[9].Cells[1].Value = "Completed"; grdDataMigration.Rows[9].Cells[2].Value = result; grdDataMigration.Rows.Add("Expenditure Ledger", "Processing", 0); result = 0; result = accountLedgerMaster.InsertExpenditureLedgerData(); grdDataMigration.Rows[10].Cells[1].Value = "Completed"; grdDataMigration.Rows[10].Cells[2].Value = result; grdDataMigration.Rows.Add("Transaction Books", "Processing", 0); result = 0; result = accountLedgerMaster.InsertTransactionLedgerData(); grdDataMigration.Rows[11].Cells[1].Value = "Completed"; grdDataMigration.Rows[11].Cells[2].Value = result; grdDataMigration.Rows.Add("General Ledger", "Processing", 0); result = 0; result = accountLedgerMaster.InsertGeneralLedgerData(); grdDataMigration.Rows[12].Cells[1].Value = "Completed"; grdDataMigration.Rows[12].Cells[2].Value = result; grdDataMigration.Rows.Add("Purchase Ledger", "Processing", 0); result = 0; result = accountLedgerMaster.InsertPurchaseLedgerData(); grdDataMigration.Rows[13].Cells[1].Value = "Completed"; grdDataMigration.Rows[13].Cells[2].Value = result; grdDataMigration.Rows.Add("Sale Ledger", "Processing", 0); result = 0; result = accountLedgerMaster.InsertSaleLedgerData(); grdDataMigration.Rows[14].Cells[1].Value = "Completed"; grdDataMigration.Rows[14].Cells[2].Value = result; grdDataMigration.Rows.Add("Item Master", "Processing", 0); result = 0; result = itemMaster.InsertItemMasterData(); grdDataMigration.Rows[15].Cells[1].Value = "Completed"; grdDataMigration.Rows[15].Cells[2].Value = result; grdDataMigration.Rows.Add("FIFO", "Processing", 0); result = 0; result = fifo.InsertFIFOData(); grdDataMigration.Rows[16].Cells[1].Value = "Completed"; grdDataMigration.Rows[16].Cells[2].Value = result; grdDataMigration.Rows.Add("Supplier Ledger", "Processing", 0); result = 0; result = supplierLedgerMaster.InsertSupplierLedgerMasterData(); grdDataMigration.Rows[17].Cells[1].Value = "Completed"; grdDataMigration.Rows[17].Cells[2].Value = result; grdDataMigration.Rows.Add("Customer Ledger", "Processing", 0); result = 0; result = customerLedgerMaster.InsertCustomerLedgerMasterData(); //confirm mapping columns for columns having comments in CustomerLedgerMaster grdDataMigration.Rows[18].Cells[1].Value = "Completed"; grdDataMigration.Rows[18].Cells[2].Value = result; //For below method check comments in CustomerLedgerMaster grdDataMigration.Rows.Add("Customer Company Discount", "Processing", 0); result = 0; result = customerLedgerMaster.InsertCustomerCompanyReferenceData(); grdDataMigration.Rows[19].Cells[1].Value = "Completed"; grdDataMigration.Rows[19].Cells[2].Value = result; //For below method check comments in CustomerLedgerMaster grdDataMigration.Rows.Add("Supplier Company Discount", "Processing", 0); result = 0; result = supplierLedgerMaster.InsertSupplierCompanyReferenceData(); grdDataMigration.Rows[20].Cells[1].Value = "Completed"; grdDataMigration.Rows[20].Cells[2].Value = result; grdDataMigration.Rows.Add("Bill Oustanding", "Processing", 0); result = 0; result = billOutstanding.InsertBillOutstandingData(); grdDataMigration.Rows[21].Cells[1].Value = "Completed"; grdDataMigration.Rows[21].Cells[2].Value = result; MessageBox.Show("Process Completed"); }
public JsonResult SaveCustomer(CustomerVM A) { bool status = false; string mes = ""; int maxCus; maxCus = (from x in db.Customers where x.WarehouseID == A.WarehouseID select x).Max(p => p.CustomerID) + 1; //var c = db.Customers.Where(t => t.CustomerID == A.CustomerID).FirstOrDefault(); int v = maxCus; if (ModelState.IsValid) { try { using (PEPSIEntities dc = new PEPSIEntities()) { Customer c = new Customer(); { c.CustomerID = maxCus; c.CustomerName = A.CustomerName; c.ProprietorsName = A.ProprietorsName; //c.CustomerShortName = A.ProprietorsName; c.ContactPersonsName = A.ProprietorsName; c.WarehouseID = A.WarehouseID; c.CustomerTypeID = A.CustomerTypeID; c.CustomerAddress1 = A.CustomerAddress1; c.CustomerAddress2 = A.CustomerAddress1; c.CustomerPhone = A.CustomerPhone; c.CustomerMobilePhone = A.CustomerPhone; c.CustomerExecutiveID = A.CustomerExecutiveID; c.SalesPersonID = A.SalesPersonID; c.RegionID = A.RegionID; c.ClusterName = A.ClusterName; c.ProductRateID = A.ProductRateID; c.CustomerStartingDate = DateTime.Today; c.VATRegistrationNumber = A.VATRegistrationNumber; c.ActiveStatus = "A"; c.CreateBy = User.Identity.Name; c.CreateDate = System.DateTime.Now; } dc.Customers.Add(c); CustomerLedgerMaster cl = new CustomerLedgerMaster(); { cl.CustomerID = maxCus; cl.CurrentBalance = 0; cl.BankGuranteeAmt = 0; cl.BlockedAmt = 0; cl.BookedAmt = 0; cl.CheckingFlag = "Y"; cl.CreditAmt = 0; cl.OpeningBalance = 0; cl.PaymentAmt = 0; cl.ReplacementPayable = 0; cl.ReturnAmt = 0; cl.TotalSequrityAmt = 0; cl.CustomerStatus = "A"; cl.SequrityReceive = 0; cl.SequrityRefund = 0; cl.TotalSequrityAmt = 0; cl.LoadUnloadCharge = 0; cl.OutstandingAmt = 0; cl.InvoiceAmt = 0; cl.CreateBy = User.Identity.Name; cl.WarehouseID = A.WarehouseID; cl.CreateDate = System.DateTime.Now; } dc.CustomerLedgerMasters.Add(cl); TransportFareSetup tf = new TransportFareSetup(); tf.CustomerID = maxCus; tf.CustomerName = A.CustomerName; tf.WarehouseID = A.WarehouseID; tf.Address = A.CustomerAddress1; tf.IsActive = 1; tf.Rate1 = 3000; tf.Rate2 = 4000; tf.Rate3 = 6000; tf.Date = DateTime.Today; dc.TransportFareSetups.Add(tf); // Save All Data dc.SaveChanges(); status = true; dc.Dispose(); } } catch (Exception ex) { return(new JsonResult { Data = new { status = status, mes = mes, v = v } }); //throw ex; } } else { status = false; } return(new JsonResult { Data = new { status = status, mes = mes, v = v } }); }
private void StartMigration() { CompanyMaster companyMaster = new CompanyMaster(); ItemMaster itemMaster = new ItemMaster(); PersonRouteMaster personRouteMaster = new PersonRouteMaster(); PersonalLedgerMaster personalLedgerMaster = new PersonalLedgerMaster(); AccountLedgerMaster accountLedgerMaster = new AccountLedgerMaster(); SupplierLedgerMaster supplierLedgerMaster = new SupplierLedgerMaster(); CustomerLedgerMaster customerLedgerMaster = new CustomerLedgerMaster(); BillOutstanding billOutstanding = new BillOutstanding(); FIFO fifo = new FIFO(); PurchaseSaleBookHeaderMigration purchaseSaleBookHeaderMigration = new PurchaseSaleBookHeaderMigration(); PurchaseSaleBookLineItemMigration purchaseSaleBookLineItemMigration = new PurchaseSaleBookLineItemMigration(); TRN trn = new TRN(); ReceiptPaymentMigration receiptPayment = new ReceiptPaymentMigration(); BillOutStandingsAudjustmentMigration billOsAdjustment = new BillOutStandingsAudjustmentMigration(); int result = 0; int rowIndex = 0; SetProcessingText(grdDataMigration, "Company Master", rowIndex, "Processing", result, true); result = companyMaster.InsertCompanyMasterData(); SetProcessingText(grdDataMigration, "Company Master", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "ASM", rowIndex, "Processing", result, true); result = personRouteMaster.InsertASMData(); SetProcessingText(grdDataMigration, "ASM", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "RSM", rowIndex, "Processing", result, true); result = personRouteMaster.InsertRSMData(); SetProcessingText(grdDataMigration, "RSM", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "ZSM", rowIndex, "Processing", result, true); result = personRouteMaster.InsertZSMData(); SetProcessingText(grdDataMigration, "ZSM", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Sales Man", rowIndex, "Processing", result, true); result = personRouteMaster.InsertSalesManData(); SetProcessingText(grdDataMigration, "Sales Man", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Area", rowIndex, "Processing", result, true); result = personRouteMaster.InsertAreaData(); SetProcessingText(grdDataMigration, "Area", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Route", rowIndex, "Processing", result, true); result = personRouteMaster.InsertRouteData(); SetProcessingText(grdDataMigration, "Route", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Personal Ledger", rowIndex, "Processing", result, true); result = personalLedgerMaster.InsertPersonalLedgerMasterData(); SetProcessingText(grdDataMigration, "Personal Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Control Codes", rowIndex, "Processing", result, true); result = accountLedgerMaster.InsertControlCodesData(); SetProcessingText(grdDataMigration, "Control Codes", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Income Ledger", rowIndex, "Processing", result, true); result = accountLedgerMaster.InsertIncomeLedgerData(); SetProcessingText(grdDataMigration, "Income Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Expenditure Ledger", rowIndex, "Processing", result, true); result = accountLedgerMaster.InsertExpenditureLedgerData(); SetProcessingText(grdDataMigration, "Expenditure Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Transaction Ledger", rowIndex, "Processing", result, true); result = accountLedgerMaster.InsertTransactionLedgerData(); SetProcessingText(grdDataMigration, "Transaction Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "General Ledger", rowIndex, "Processing", result, true); result = accountLedgerMaster.InsertGeneralLedgerData(); SetProcessingText(grdDataMigration, "General Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Purchase Ledger", rowIndex, "Processing", result, true); result = accountLedgerMaster.InsertPurchaseLedgerData(); SetProcessingText(grdDataMigration, "Purchase Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Sale Ledger", rowIndex, "Processing", result, true); result = accountLedgerMaster.InsertSaleLedgerData(); SetProcessingText(grdDataMigration, "Sale Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Item Master", rowIndex, "Processing", result, true); result = itemMaster.InsertItemMasterData(); SetProcessingText(grdDataMigration, "Item Master", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Supplier Ledger", rowIndex, "Processing", result, true); result = supplierLedgerMaster.InsertSupplierLedgerMasterData(); SetProcessingText(grdDataMigration, "Supplier Ledger", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Customer Ledger", rowIndex, "Processing", result, true); result = customerLedgerMaster.InsertCustomerLedgerMasterData(); //confirm mapping columns for columns having comments in CustomerLedgerMaster SetProcessingText(grdDataMigration, "Customer Ledger", rowIndex, "Completed", result, false); //result = 0; //rowIndex += 1; //SetProcessingText(grdDataMigration, "Customer Compnay Discount Ref", rowIndex, "Processing", result, true); //result = customerLedgerMaster.InsertCustomerCompanyReferenceData(); //SetProcessingText(grdDataMigration, "Customer Compnay Discount Ref", rowIndex, "Completed", result, false); //result = 0; //rowIndex += 1; //SetProcessingText(grdDataMigration, "Suppiier Compnay Discount Ref", rowIndex, "Processing", result, true); //result = supplierLedgerMaster.InsertSupplierCompanyReferenceData(); //SetProcessingText(grdDataMigration, "Suppiier Compnay Discount Ref", rowIndex, "Completed", result, false); /*------------------------------------------------------------*/ result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "PurchaseSaleBookHeaderData", rowIndex, "Processing", result, true); result = purchaseSaleBookHeaderMigration.InsertPurchaseSaleBookHeaderData(); SetProcessingText(grdDataMigration, "PurchaseSaleBookHeaderData", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "PurchaseSaleBookLineItemData", rowIndex, "Processing", result, true); result = purchaseSaleBookLineItemMigration.InsertPurchaseSaleBookLineItemData(); SetProcessingText(grdDataMigration, "PurchaseSaleBookLineItemData", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Fifo", rowIndex, "Processing", result, true); result = fifo.InsertFIFOData(); SetProcessingText(grdDataMigration, "Fifo", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "Bill Outstanding", rowIndex, "Processing", result, true); result = billOutstanding.InsertBillOutstandingData(); SetProcessingText(grdDataMigration, "Bill Outstanding", rowIndex, "Completed", result, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "TRN", rowIndex, "Processing", result, true); trn.InsertTRNData(); SetProcessingText(grdDataMigration, "TRN", rowIndex, "Completed", 0, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "ReceiptPayment", rowIndex, "Processing", result, true); result = receiptPayment.InsertReceiptPaymentData(); SetProcessingText(grdDataMigration, "ReceiptPayment", rowIndex, "Completed", 0, false); result = 0; rowIndex += 1; SetProcessingText(grdDataMigration, "BillOutStandingsAudjustment", rowIndex, "Processing", result, true); result = billOsAdjustment.InsertBillOutStandingsAudjustmentData(); SetProcessingText(grdDataMigration, "BillOutStandingsAudjustment", rowIndex, "Completed", 0, false); /* --------------------------------------- ---------------------------------------*/ MessageBox.Show("Process Completed"); }
public void ConfigureCustomerLedger(CustomerLedgerMaster model) { txtCustSupplierName.Text = model.CustomerLedgerName; }
private void btnSave_Click(object sender, EventArgs e) { try { //Set the cursor to appear as busy Cursor.Current = Cursors.WaitCursor; Choice choice; LocalCentral localCentral; CustomerLedgerMaster customerLedgerMaster = new CustomerLedgerMaster(); if (String.IsNullOrWhiteSpace(txtCustSupplierName.Text)) { MessageBox.Show("Customer Name " + Constants.Messages.RequiredField); return; } customerLedgerMaster.CustomerLedgerId = this.customerLedgerID; //values from User Control customerLedgerMaster.CustomerLedgerName = txtCustSupplierName.Text; customerLedgerMaster.CustomerLedgerShortName = txtShortName.Text; customerLedgerMaster.Address = txtAddress.Text; customerLedgerMaster.ContactPerson = txtContactPerson.Text; customerLedgerMaster.Telephone = txtTelephone.Text; customerLedgerMaster.Mobile = txtMobile.Text; customerLedgerMaster.OfficePhone = txtPhoneO.Text; customerLedgerMaster.ResidentPhone = txtPhoneR.Text; customerLedgerMaster.EmailAddress = txtEmailAddress.Text; customerLedgerMaster.OpeningBal = ExtensionMethods.SafeConversionDecimal(txtOpeningBal.Text); customerLedgerMaster.CreditDebit = Convert.ToString(cbxCreditDebit.SelectedItem); customerLedgerMaster.TaxRetail = Convert.ToString(cbxTaxRetail.SelectedItem); customerLedgerMaster.Status = Convert.ToBoolean(cbxStatus.SelectedItem); //values from User this form customerLedgerMaster.ZSMId = String.IsNullOrWhiteSpace(tbxZSM.Text) ? null : (int?)tbxZSM.Tag; customerLedgerMaster.RSMId = String.IsNullOrWhiteSpace(tbxRSM.Text) ? null : (int?)tbxRSM.Tag; customerLedgerMaster.ASMId = String.IsNullOrWhiteSpace(tbxASM.Text) ? null : (int?)tbxASM.Tag; customerLedgerMaster.AreaId = String.IsNullOrWhiteSpace(tbxSalesman.Text) ? null : (int?)tbxSalesman.Tag; customerLedgerMaster.SalesManId = String.IsNullOrWhiteSpace(tbxArea.Text) ? null : (int?)tbxArea.Tag; customerLedgerMaster.RouteId = String.IsNullOrWhiteSpace(tbxRoute.Text) ? null : (int?)tbxRoute.Tag; customerLedgerMaster.DLNo = tbxDL.Text; customerLedgerMaster.GSTNo = tbxGST.Text; customerLedgerMaster.CINNo = tbxCIN.Text; customerLedgerMaster.LINNo = tbxLIN.Text; customerLedgerMaster.ServiceTaxNo = tbxServiceTax.Text; customerLedgerMaster.PANNo = tbxPAN.Text; customerLedgerMaster.CreditLimit = ExtensionMethods.SafeConversionInt(tbxCredtLimit.Text) ?? default(int); customerLedgerMaster.CustomerTypeID = (cbxCustomerType.SelectedItem as CustomerType).CustomerTypeId; Enum.TryParse <Choice>(cbxLessExcise.SelectedValue.ToString(), out choice); customerLedgerMaster.IsLessExcise = choice == Choice.Yes; customerLedgerMaster.InterestTypeID = (cbxRateType.SelectedItem as RateType).RateTypeId; customerLedgerMaster.SaleBillFormat = tbxSaleBillFormat.Text; customerLedgerMaster.MaxOSAmount = ExtensionMethods.SafeConversionDecimal(tbxMaxOSAmount.Text); customerLedgerMaster.MaxBillAmount = ExtensionMethods.SafeConversionDecimal(tbxMaxBillAmmount.Text); customerLedgerMaster.MaxNumOfOSBill = ExtensionMethods.SafeConversionInt(tbxMaxNumberOfOSBill.Text); customerLedgerMaster.MaxGracePeriod = ExtensionMethods.SafeConversionInt(tbxMaxGracePeriod.Text); Enum.TryParse <Choice>(cbxFollowConditionStrictly.SelectedValue.ToString(), out choice); customerLedgerMaster.IsFollowConditionStrictly = choice == Choice.Yes; customerLedgerMaster.Discount = ExtensionMethods.SafeConversionDecimal(tbxDiscount.Text); Enum.TryParse <LocalCentral>(cbxLocaLCentral.SelectedValue.ToString(), out localCentral); customerLedgerMaster.CentralLocal = localCentral == LocalCentral.L ? "L" : "C"; ///Get All the mapping for Company discount /// customerLedgerMaster.CustomerCopanyDiscountList = dgvCompanyDiscount.Rows .Cast <DataGridViewRow>() .Where(r => !String.IsNullOrWhiteSpace(Convert.ToString(r.Cells["Normal"].Value)) || !String.IsNullOrWhiteSpace(Convert.ToString(r.Cells["Breakage"].Value)) || !String.IsNullOrWhiteSpace(Convert.ToString(r.Cells["Expired"].Value)) ).Select(x => new CustomerCopanyDiscount() { CompanyID = (x.DataBoundItem as CustomerCopanyDiscount).CompanyID, Normal = (x.DataBoundItem as CustomerCopanyDiscount).Normal, Breakage = (x.DataBoundItem as CustomerCopanyDiscount).Breakage, Expired = (x.DataBoundItem as CustomerCopanyDiscount).Expired, CustomerItemDiscountMapping = (x.DataBoundItem as CustomerCopanyDiscount).CustomerItemDiscountMapping }).ToList(); int _result = 0; if (isInEditMode) { _result = applicationFacade.UpdateCustomerLedger(customerLedgerMaster); } else { _result = applicationFacade.AddCustomerLedger(customerLedgerMaster); } //Make the Cursor to default Cursor.Current = Cursors.Default; if (_result > 0) { this.Close(); } else { MessageBox.Show(Constants.Messages.ErrorOccured); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void frmCustomerLedgerMasterAddUpdate_Fill_UsingExistingItem(CustomerLedgerMaster customerLedgerMaster) { if (customerLedgerMaster != null) { ///Set CustomerId /// this.customerLedgerID = customerLedgerMaster.CustomerLedgerId; ///Fill user control data /// txtCode.Text = customerLedgerMaster.CustomerLedgerCode; txtCustSupplierName.Text = customerLedgerMaster.CustomerLedgerName; txtShortName.Text = customerLedgerMaster.CustomerLedgerShortName; txtAddress.Text = customerLedgerMaster.Address; txtContactPerson.Text = customerLedgerMaster.ContactPerson; txtTelephone.Text = customerLedgerMaster.Telephone; txtMobile.Text = customerLedgerMaster.Mobile; txtPhoneO.Text = customerLedgerMaster.OfficePhone; txtPhoneR.Text = customerLedgerMaster.ResidentPhone; txtEmailAddress.Text = customerLedgerMaster.EmailAddress; txtOpeningBal.Text = Convert.ToString(customerLedgerMaster.OpeningBal); cbxCreditDebit.SelectedItem = customerLedgerMaster.CreditDebit == "C" ? Enums.TransType.C : Enums.TransType.D; cbxTaxRetail.SelectedItem = customerLedgerMaster.TaxRetail == "T" ? Enums.TaxRetail.T : Enums.TaxRetail.R; cbxStatus.SelectedItem = customerLedgerMaster.Status ? Enums.Status.Active : Enums.Status.Inactive; tbxZSM.Text = customerLedgerMaster.ZSMName; tbxZSM.Tag = customerLedgerMaster.ZSMId; tbxRSM.Text = customerLedgerMaster.RSMName; tbxRSM.Tag = customerLedgerMaster.RSMId; tbxASM.Text = customerLedgerMaster.ASMName; tbxASM.Tag = customerLedgerMaster.ASMId; tbxSalesman.Text = customerLedgerMaster.SalesmanName; tbxSalesman.Tag = customerLedgerMaster.SalesManId; tbxArea.Text = customerLedgerMaster.AreaName; tbxArea.Tag = customerLedgerMaster.AreaId; tbxRoute.Text = customerLedgerMaster.RouteName; tbxRoute.Tag = customerLedgerMaster.RouteId; tbxDL.Text = customerLedgerMaster.DLNo; tbxGST.Text = customerLedgerMaster.GSTNo; tbxCIN.Text = customerLedgerMaster.CINNo; tbxLIN.Text = customerLedgerMaster.LINNo; tbxServiceTax.Text = customerLedgerMaster.ServiceTaxNo; tbxPAN.Text = customerLedgerMaster.PANNo; tbxCredtLimit.Text = Convert.ToString(customerLedgerMaster.CreditLimit); cbxCustomerType.SelectedValue = customerLedgerMaster.CustomerTypeID; cbxLessExcise.SelectedItem = customerLedgerMaster.IsLessExcise ? Choice.Yes : Choice.No; cbxRateType.SelectedValue = customerLedgerMaster.InterestTypeID; tbxSaleBillFormat.Text = customerLedgerMaster.SaleBillFormat; tbxMaxOSAmount.Text = Convert.ToString(customerLedgerMaster.MaxOSAmount); tbxMaxBillAmmount.Text = Convert.ToString(customerLedgerMaster.MaxBillAmount); tbxMaxNumberOfOSBill.Text = Convert.ToString(customerLedgerMaster.MaxNumOfOSBill); tbxMaxGracePeriod.Text = Convert.ToString(customerLedgerMaster.MaxGracePeriod); cbxFollowConditionStrictly.SelectedItem = customerLedgerMaster.IsFollowConditionStrictly ? Choice.Yes : Choice.No; tbxDiscount.Text = Convert.ToString(customerLedgerMaster.Discount); cbxLocaLCentral.SelectedItem = customerLedgerMaster.CentralLocal == "L" ? LocalCentral.L : LocalCentral.C; } }