public void ConfigurePersonRoute(PersonRouteMaster model) { if (model != null) { this.cbPersonRouteType.Text = model.RecordTypeNme; this.cbPersonRouteType.Enabled = false; { this.NextPersonRoute = new PersonRouteMaster() { RecordTypeNme = model.RecordTypeNme, RecordTypeId = (int)this.cbPersonRouteType.SelectedValue }; } List <DataGridViewRow> filteredRow = dgvPersonRoute.Rows.OfType <DataGridViewRow>().Where(x => (int)x.Cells["PersonRouteID"].Value == model.PersonRouteID).ToList(); if (filteredRow.Count > 0) { dgvPersonRoute.ClearSelection(); filteredRow.First().Selected = true; filteredRow.First().Cells["PersonRouteCode"].Selected = true; } else { if (dgvPersonRoute.RowCount > 0) { dgvPersonRoute.ClearSelection(); dgvPersonRoute.Rows.OfType <DataGridViewRow>().First().Selected = true; dgvPersonRoute.Rows.OfType <DataGridViewRow>().First().Cells["PersonRouteCode"].Selected = true; } } } }
private void FrmPersonRouteMaster_FormClosed(object sender, FormClosedEventArgs e) { try { ExtensionMethods.RemoveChildFormToPanel(this, (Control)sender, ExtensionMethods.MainPanel); PersonRouteMaster lastSelectedPersonRoute = (sender as frmPersonRouteMaster).LastSelectedPersonRoute; if (lastSelectedPersonRoute != null) { if (lastSelectedPersonRoute.PersonRouteID > 0) { switch (lastSelectedPersonRoute.RecordTypeNme) { case Constants.RecordType.AREADISPLAYNAME: { tbxArea.Text = lastSelectedPersonRoute.PersonRouteName; tbxArea.Tag = lastSelectedPersonRoute.PersonRouteID; dgvCompanyDiscount.Focus(); } break; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { try { PersonRouteMaster model = new PersonRouteMaster(); model.PersonRouteID = this.PersonRouteMaster.PersonRouteID; model.RecordTypeId = (int)cbPersonRouteType.SelectedValue; Status status; Enum.TryParse <Status>(cbxStatus.SelectedValue.ToString(), out status); model.Status = status == Status.Active; model.PersonRouteName = tbPersonRouteName.Text; model.PersonRouteCode = this.PersonRouteMaster.PersonRouteCode; var result = this.PersonRouteMaster.RecordTypeId > 0 && this.PersonRouteMaster.PersonRouteID > 0 ? applicationFacade.UpdatePersonRoute(model) : applicationFacade.AddPersonRoute(model); if (result > 0) { this.PersonRouteID = result; } this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int UpdatePersonRoute(PersonRouteMaster p) { try { return(new PersonRouteMasterBiz(this.LoggedInUser).UpdatePersonRoute(p)); } catch (Exception) { throw; } }
private void C_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (sender is TextBox) { TextBox activePersonRouteType = sender as TextBox; string activePersonRouteTypeString = String.Empty; bool isValidTextbox = false; switch (activePersonRouteType.Name) { case "tbxArea": { activePersonRouteType = tbxArea; activePersonRouteTypeString = Constants.RecordType.AREADISPLAYNAME; isValidTextbox = true; } break; } if (isValidTextbox && String.IsNullOrWhiteSpace(activePersonRouteType.Text)) { PersonRouteMaster personRouteMaster = new PersonRouteMaster() { RecordTypeNme = activePersonRouteTypeString, PersonRouteID = ExtensionMethods.SafeConversionInt(Convert.ToString(activePersonRouteType.Tag)) ?? 0, PersonRouteName = activePersonRouteType.Text }; frmPersonRouteMaster frmPersonRouteMaster = new frmPersonRouteMaster(); frmPersonRouteMaster.IsInChildMode = true; //Set Child UI ExtensionMethods.AddChildFormToPanel(this, frmPersonRouteMaster, ExtensionMethods.MainPanel); frmPersonRouteMaster.WindowState = FormWindowState.Maximized; frmPersonRouteMaster.FormClosed += FrmPersonRouteMaster_FormClosed; frmPersonRouteMaster.Show(); frmPersonRouteMaster.ConfigurePersonRoute(personRouteMaster); } else { SendKeys.Send("{TAB}"); } } else { SendKeys.Send("{TAB}"); } } }
protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { //Add if (keyData == (Keys.F9)) { if ((cbPersonRouteType.SelectedItem as PharmaBusinessObjects.Common.RecordType).RecordTypeId != 0) { PersonRouteMaster pmNext = new PersonRouteMaster() { RecordTypeNme = (cbPersonRouteType.SelectedItem as PharmaBusinessObjects.Common.RecordType).RecordTypeName, RecordTypeId = (cbPersonRouteType.SelectedItem as PharmaBusinessObjects.Common.RecordType).RecordTypeId }; AddEditPersonRoute(pmNext); } else { AddEditPersonRoute(NextPersonRoute); } } else if (keyData == Keys.F3) { EditPersonRoute(); } else if (keyData == Keys.Down) { dgvPersonRoute.Focus(); } 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)); }
public frmPersonRouteMasterAddUpdate(PersonRouteMaster personRouteMaster) { try { InitializeComponent(); ExtensionMethods.SetChildFormProperties(this); applicationFacade = new ApplicationFacade(ExtensionMethods.LoggedInUser); if (personRouteMaster != null) { this.PersonRouteMaster = personRouteMaster; } else { this.PersonRouteMaster = new PersonRouteMaster(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnAddNew_Click(object sender, EventArgs e) { try { if ((cbPersonRouteType.SelectedItem as PharmaBusinessObjects.Common.RecordType).RecordTypeId != 0) { PersonRouteMaster pmNext = new PersonRouteMaster() { RecordTypeNme = (cbPersonRouteType.SelectedItem as PharmaBusinessObjects.Common.RecordType).RecordTypeName, RecordTypeId = (cbPersonRouteType.SelectedItem as PharmaBusinessObjects.Common.RecordType).RecordTypeId }; AddEditPersonRoute(pmNext); } else { AddEditPersonRoute(NextPersonRoute); } } 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"); }