private void FillFormForUpdate() { SupplierLedgerMaster supplier = applicationFacade.GetSupplierLedgerById(this.SupplierId); if (supplier != null) { txtCode.Text = supplier.SupplierLedgerCode; txtCustSupplierName.Text = supplier.SupplierLedgerName; txtShortName.Text = supplier.SupplierLedgerShortName; txtAddress.Text = supplier.Address; txtContactPerson.Text = supplier.ContactPerson; txtEmailAddress.Text = supplier.EmailAddress; txtMobile.Text = supplier.Mobile; txtPhoneO.Text = supplier.OfficePhone; txtPhoneR.Text = supplier.ResidentPhone; cbxTaxRetail.SelectedItem = supplier.TaxRetail == "R" ? Enums.TaxRetail.R : Enums.TaxRetail.T; cbxStatus.SelectedItem = supplier.Status ? Enums.Status.Active : Enums.Status.Inactive; cbxCreditDebit.SelectedItem = supplier.CreditDebit == "C" ? Enums.TransType.C : Enums.TransType.D; txtOpeningBal.Text = supplier.OpeningBal.ToString(); tbxArea.Tag = supplier.AreaId; tbxArea.Text = supplier.AreaName; tbxDL.Text = supplier.DLNo; tbxGST.Text = supplier.GSTNo; tbxCIN.Text = supplier.CINNo; tbxLIN.Text = supplier.LINNo; tbxServiceTax.Text = supplier.ServiceTaxNo; tbxPAN.Text = supplier.PANNo; //todo ADD SUPPLIER PURCHASE TYPE iD //cbxPurchaseType.SelectedValue = supplier. } }
public int UpdateSupplierLedger(SupplierLedgerMaster p) { try { return(new SupplierLedgerMasterBiz(this.LoggedInUser).UpdateSupplierLedger(p)); } catch (Exception) { throw; } }
private void FormSupplierLedgerMaster_FormClosed(object sender, FormClosedEventArgs e) { try { ExtensionMethods.RemoveChildFormToPanel(this, (Control)sender, ExtensionMethods.MainPanel); SupplierLedgerMaster selectedSupplier = (sender as frmSupplierLedger).LastSelectedSupplier; if (selectedSupplier != null) { ReceiptPaymentItem receiptPaymentForSelectedCust = new ReceiptPaymentItem() { VoucherTypeCode = Constants.VoucherTypeCode.PAYMENTTOSUPPLIER, VoucherDate = ExtensionMethods.ConvertToSystemDateFormat(dtReceiptPayment.Text), LedgerType = Constants.TransactionEntityType.SupplierLedger, LedgerTypeCode = selectedSupplier.SupplierLedgerCode, LedgerTypeName = selectedSupplier.SupplierLedgerName, PaymentMode = Constants.PaymentMode.CASH, BankAccountLedgerTypeCode = Convert.ToString(txtTransactAccount.Tag), BankAccountLedgerTypeName = Convert.ToString(txtTransactAccount.Text), ChequeDate = DateTime.Now }; TransactionEntity transactionEntity = new TransactionEntity() { EntityType = Constants.TransactionEntityType.SupplierLedger, EntityCode = selectedSupplier.SupplierLedgerCode }; UpdateReceiptPaymentRow(receiptPaymentForSelectedCust); LoadGridBillOutstanding(transactionEntity); dgvPaymentToSupplier.Focus(); dgvPaymentToSupplier.CurrentCell = dgvPaymentToSupplier.Rows[dgvPaymentToSupplier.SelectedCells[0].RowIndex].Cells["ChequeNumber"]; } } 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"); }
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"); }
internal SupplierLedgerMaster GetSupplierLedgerByName(string name) { SupplierLedgerMaster master = GetSupplierLedgers(string.Empty).Where(p => p.SupplierLedgerCode.ToLower() == name.ToLower()).FirstOrDefault(); return(master); }
private void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtCustSupplierName.Text)) { throw new Exception("Supplier Name can not be blank"); } //Set the cursor to appear as busy Cursor.Current = Cursors.WaitCursor; Status status; // int areaId = 0; decimal openingBal = 0.00M; SupplierLedgerMaster supplier = new SupplierLedgerMaster(); supplier.SupplierLedgerCode = txtCode.Text; supplier.SupplierLedgerName = txtCustSupplierName.Text; supplier.SupplierLedgerShortName = txtShortName.Text; supplier.Address = txtAddress.Text; supplier.ContactPerson = txtContactPerson.Text; Enum.TryParse <Status>(cbxStatus.SelectedItem.ToString(), out status); supplier.Status = status == Status.Active; supplier.CreditDebit = (Enums.TransType)cbxCreditDebit.SelectedItem == Enums.TransType.C ? "C" : "D"; supplier.AreaId = Convert.ToInt32(tbxArea.Tag); supplier.EmailAddress = txtEmailAddress.Text; supplier.Mobile = txtMobile.Text; supplier.OfficePhone = txtPhoneO.Text; int purchaseTypeId = 0; Int32.TryParse(Convert.ToString(cbxPurchaseType.SelectedValue), out purchaseTypeId); supplier.PurchaseTypeId = purchaseTypeId; decimal.TryParse(txtOpeningBal.Text, out openingBal); supplier.OpeningBal = openingBal; supplier.ResidentPhone = txtPhoneR.Text; supplier.TaxRetail = (Enums.TaxRetail)cbxTaxRetail.SelectedItem == TaxRetail.R ? "R" : "T"; supplier.SupplierLedgerId = SupplierId; supplier.DLNo = tbxDL.Text; supplier.GSTNo = tbxGST.Text; supplier.CINNo = tbxCIN.Text; supplier.LINNo = tbxLIN.Text; supplier.ServiceTaxNo = tbxServiceTax.Text; supplier.PANNo = tbxPAN.Text; ///Get All the mapping for Company discount /// supplier.SupplierCompanyDiscountList = 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 SupplierCompanyDiscount() { CompanyID = (x.DataBoundItem as SupplierCompanyDiscount).CompanyID, Normal = (x.DataBoundItem as SupplierCompanyDiscount).Normal, Breakage = (x.DataBoundItem as SupplierCompanyDiscount).Breakage, Expired = (x.DataBoundItem as SupplierCompanyDiscount).Expired, SupplierItemDiscountMapping = (x.DataBoundItem as SupplierCompanyDiscount).SupplierItemDiscountMapping }).ToList(); int result = SupplierId > 0 ? applicationFacade.UpdateSupplierLedger(supplier) : applicationFacade.AddSupplierLedger(supplier); //Make the Cursor to default Cursor.Current = Cursors.Default; //Close this form if operation is successful if (result > 0) { this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }