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