private void SaleType_Load(object sender, EventArgs e)
{
tbxSaleType.Focus();
DefaultloadForm();
laCtrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
laCtrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
laCtrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
cbxLedgerAccount.Properties.Items.Clear();
List <AccountMasterModel> lstAccounts = objAccBl.GetListofAccount();
foreach (AccountMasterModel objAccounts in lstAccounts)
{
cbxLedgerAccount.Properties.Items.Add(objAccounts.AccountName);
}
if (rbngrpRegion.SelectedIndex == 0)
{
rbngrpTranction.Properties.Items[1].Enabled = false;
rbngrpTranction.Properties.Items[2].Enabled = false;
rbngrpTranction.Properties.Items[4].Enabled = false;
}
else
{
rbngrpTranction.Properties.Items[1].Enabled = true;
rbngrpTranction.Properties.Items[2].Enabled = true;
rbngrpTranction.Properties.Items[4].Enabled = true;
}
}
private void ReceiptVoucher_Load(object sender, EventArgs e)
{
Loadtables();
dtLedger.Rows.Clear();
RepositoryItemLookUpEdit AccLookup = new RepositoryItemLookUpEdit();
DataRow drparty;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
drparty = dtLedger.NewRow();
drparty["Name"] = objAcc.AccountName;
drparty["Group"] = objAcc.Group;
drparty["Op.Bal"] = objAcc.OPBal;
drparty["Address"] = objAcc.address;
drparty["Mobile"] = objAcc.MobileNumber;
dtLedger.Rows.Add(drparty);
}
AccLookup.DataSource = dtLedger;
AccLookup.ValueMember = "Name";
AccLookup.DisplayMember = "Name";
AccLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
AccLookup.AutoSearchColumnIndex = 1;
gdvReceipt.Columns["Account"].ColumnEdit = AccLookup;
gdvReceipt.BestFitColumns();
RepositoryItemLookUpEdit riDCLookup = new RepositoryItemLookUpEdit();
riDCLookup.DataSource = new string[] { "D", "C" };
gdvReceipt.Columns["DC"].ColumnEdit = riDCLookup;
riDCLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoFilter;
riDCLookup.AutoSearchColumnIndex = 1;
dtPaymode.Rows.Clear();
DataRow drpay;
List <AccountMasterModel> lstAccount = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccount)
{
if (objAcc.AccGroupId == 72 || objAcc.AccGroupId == 73 || objAcc.AccGroupId == 74)
{
drpay = dtPaymode.NewRow();
drpay["Name"] = objAcc.AccountName;
drpay["Group"] = objAcc.Group;
drpay["Op.Bal"] = objAcc.OPBal;
drpay["Address"] = objAcc.address;
drpay["Mobile"] = objAcc.MobileNumber;
dtPaymode.Rows.Add(drpay);
}
}
cbxPayMode.Properties.DataSource = dtPaymode;
cbxPayMode.Properties.DisplayMember = "Name";
SingleEntryMode();
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
tbxVoucherSeries.Focus();
}
private void LoadAccountLedger()
{
cbxSaleAccHeadpost.Properties.Items.Clear();
cbxSaleAccHeadpostParty.Properties.Items.Clear();
cbxPurcHeadPost.Properties.Items.Clear();
cbxPurcAccountHeadPostParty.Properties.Items.Clear();
cbxAccountHeadPost.Properties.Items.Clear();
cbxAccountPost.Properties.Items.Clear();
cbxBillSundary.Properties.Items.Clear();
List <AccountMasterModel> lstAccounts = objAccBl.GetListofAccount();
foreach (AccountMasterModel objAccounts in lstAccounts)
{
cbxSaleAccHeadpost.Properties.Items.Add(objAccounts.AccountName);
cbxSaleAccHeadpostParty.Properties.Items.Add(objAccounts.AccountName);
cbxPurcHeadPost.Properties.Items.Add(objAccounts.AccountName);
cbxPurcAccountHeadPostParty.Properties.Items.Add(objAccounts.AccountName);
cbxAccountHeadPost.Properties.Items.Add(objAccounts.AccountName);
cbxAccountPost.Properties.Items.Add(objAccounts.AccountName);
cbxAccountHeadPost.Properties.Items.Add(objAccounts.AccountName);
}
List <BillSundryMasterModel> lstBillSundary = objbsBL.GetAllBillSundry();
foreach (BillSundryMasterModel objBill in lstBillSundary)
{
cbxBillSundary.Properties.Items.Add(objBill.Name);
}
}
private void cbxParty_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != '\r')
{
dtParty.Rows.Clear();
DataRow drparty;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
if (objAcc.AccGroupId == 85 || objAcc.AccGroupId == 86)
{
drparty = dtParty.NewRow();
drparty["Name"] = objAcc.AccountName;
drparty["Group"] = objAcc.Group;
drparty["Op.Bal"] = objAcc.OPBal;
drparty["Address"] = objAcc.address;
drparty["Mobile"] = objAcc.MobileNumber;
dtParty.Rows.Add(drparty);
}
}
cbxParty.Properties.DataSource = dtParty;
cbxParty.Properties.DisplayMember = "Name";
cbxParty.ShowPopup();
}
}
private void PurhcaseReturnvoucher_Load(object sender, EventArgs e)
{
LoadTables();
cbxTerms.Focus();
lactrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lactrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lactrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
LoadGridColumns();
dtParty.Rows.Clear();
DataRow drparty;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
drparty = dtParty.NewRow();
drparty["Name"] = objAcc.AccountName;
drparty["Group"] = objAcc.Group;
drparty["Op.Bal"] = objAcc.OPBal;
drparty["Address"] = objAcc.address;
drparty["Mobile"] = objAcc.MobileNumber;
dtParty.Rows.Add(drparty);
}
cbxParty.Properties.DataSource = dtParty;
cbxParty.Properties.DisplayMember = "Name";
List <MaterialCentreMasterModel> lstMt = objMcBL.GetAllMaterials();
List <string> lstMcenters = new List <string>();
foreach (MaterialCentreMasterModel objMC in lstMt)
{
lstMcenters.Add(objMC.GroupName);
}
cbxMatcenter.Properties.DataSource = lstMcenters;
List <PurchaseTypeModel> lstPurctypes = objPTBL.GetAllPurchaseType();
List <string> lstPurc = new List <string>();
foreach (PurchaseTypeModel objPurc in lstPurctypes)
{
lstPurc.Add(objPurc.PurchType);
}
cbxPurcRetType.Properties.DataSource = lstPurc;
cbxVoucherType.Properties.DataSource = new string[] { "Main" };
}
private void JournalVoucher_Load(object sender, EventArgs e)
{
dt.Columns.Add("S.No");
dt.Columns.Add("DC");
dt.Columns.Add("Account");
dt.Columns.Add("Debit");
dt.Columns.Add("Credit");
dt.Columns.Add("Narration");
dt.Columns.Add("ParentId");
dt.Columns.Add("Ac_Id");
dvgJournalMain.DataSource = dt;
dtLedger.Columns.Add("Name");
dtLedger.Columns.Add("Group");
dtLedger.Columns.Add("Op.Bal");
dtLedger.Columns.Add("Address");
dtLedger.Columns.Add("Mobile");
dtLedger.Rows.Clear();
RepositoryItemLookUpEdit AccLookup = new RepositoryItemLookUpEdit();
DataRow drparty;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
drparty = dtLedger.NewRow();
drparty["Name"] = objAcc.AccountName;
drparty["Group"] = objAcc.Group;
drparty["Op.Bal"] = objAcc.OPBal;
drparty["Address"] = objAcc.address;
drparty["Mobile"] = objAcc.MobileNumber;
dtLedger.Rows.Add(drparty);
}
AccLookup.DataSource = dtLedger;
AccLookup.ValueMember = "Name";
AccLookup.DisplayMember = "Name";
AccLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
AccLookup.AutoSearchColumnIndex = 1;
gdvJournalDetails.Columns["Account"].ColumnEdit = AccLookup;
gdvJournalDetails.BestFitMaxRowCount = 5;
AccLookup.AutoSearchColumnIndex = 1;
AccLookup.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.None;
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
RepositoryItemLookUpEdit riDCLookup = new RepositoryItemLookUpEdit();
riDCLookup.DataSource = new string[] { "D", "C" };
gdvJournalDetails.Columns["DC"].ColumnEdit = riDCLookup;
riDCLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoFilter;
riDCLookup.AutoSearchColumnIndex = 1;
riDCLookup.DropDownRows = 0;
}
private void Purhcasevoucher_Load(object sender, EventArgs e)
{
cbxTerms.Focus();
LoadTables();
LoadGridColumns();
ItemMode();
dtParty.Rows.Clear();
DataRow drparty;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
drparty = dtParty.NewRow();
drparty["Name"] = objAcc.AccountName;
drparty["Group"] = objAcc.Group;
drparty["Op.Bal"] = objAcc.OPBal;
drparty["Address"] = objAcc.address;
drparty["Mobile"] = objAcc.MobileNumber;
dtParty.Rows.Add(drparty);
}
cbxParty.Properties.DataSource = dtParty;
cbxParty.Properties.DisplayMember = "Name";
List <MaterialCentreMasterModel> lstMt = objMcBL.GetAllMaterials();
List <string> lstMcenters = new List <string>();
foreach (MaterialCentreMasterModel objMC in lstMt)
{
lstMcenters.Add(objMC.GroupName);
}
cbxMatcenter.Properties.DataSource = lstMcenters;
List <PurchaseTypeModel> lstPurctypes = objPTBL.GetAllPurchaseType();
List <string> lstPurc = new List <string>();
foreach (PurchaseTypeModel objPurc in lstPurctypes)
{
lstPurc.Add(objPurc.PurchType);
}
cbxPurcType.Properties.DataSource = lstPurc;
cbxVoucherType.Properties.DataSource = new string[] { "Main" };
}
private void LoadAccountColumn()
{
RepositoryItemLookUpEdit AccountsLookup = new RepositoryItemLookUpEdit();
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
List <string> lstAccount = new List <string>();
foreach (AccountMasterModel objAccounts in lstAccounts)
{
lstAccount.Add(objAccounts.AccountName);
}
AccountsLookup.DataSource = lstAccount;
AccountsLookup.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
AccountsLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
AccountsLookup.AutoSearchColumnIndex = 1;
dvgChequeIssueDetails.Columns["Account"].ColumnEdit = AccountsLookup;
dvgChequeIssueDetails.BestFitColumns();
}
private void Salesman_Load(object sender, EventArgs e)
{
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
cbxDefCommMode.SelectedIndex = 0;
cbxDefFreeze.SelectedIndex = 1;
cbxEnableDefComm.SelectedIndex = 0;
cbxPurchaseDebited.SelectedIndex = 0;
cbxPurchaseDebitMode.SelectedIndex = 0;
cbxSaleDebitMode.SelectedIndex = 0;
cbxSalesDebited.SelectedIndex = 0;
List <AccountMasterModel> lstaccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objaccount in lstaccounts)
{
cbxSalesAccountCredited.Properties.Items.Add(objaccount.AccountName);
cbxSalesDebited.Properties.Items.Add(objaccount.AccountName);
cbxPurchaseDebited.Properties.Items.Add(objaccount.AccountName);
}
}
private void CreditNote_Load(object sender, EventArgs e)
{
Loadtables();
dtLedger.Rows.Clear();
RepositoryItemLookUpEdit AccLookup = new RepositoryItemLookUpEdit();
DataRow drparty;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
drparty = dtLedger.NewRow();
drparty["Name"] = objAcc.AccountName;
drparty["Group"] = objAcc.Group;
drparty["Op.Bal"] = objAcc.OPBal;
drparty["Address"] = objAcc.address;
drparty["Mobile"] = objAcc.MobileNumber;
dtLedger.Rows.Add(drparty);
}
AccLookup.DataSource = dtLedger;
AccLookup.ValueMember = "Name";
AccLookup.DisplayMember = "Name";
AccLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
AccLookup.AutoSearchColumnIndex = 0;
gdvCredit.Columns["Account"].ColumnEdit = AccLookup;
gdvCredit.BestFitColumns();
RepositoryItemLookUpEdit riDCLookup = new RepositoryItemLookUpEdit();
riDCLookup.DataSource = new string[] { "D", "C" };
gdvCredit.Columns["DC"].ColumnEdit = riDCLookup;
riDCLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoFilter;
riDCLookup.AutoSearchColumnIndex = 0;
lactrlSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lactrlDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lactrlUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
}
private void PaymentVoucher_Load(object sender, EventArgs e)
{
dtAcc.Columns.Add("S.No");
dtAcc.Columns.Add("DC");
dtAcc.Columns.Add("Account");
dtAcc.Columns.Add("Debit");
dtAcc.Columns.Add("Credit");
dtAcc.Columns.Add("Amount");
dtAcc.Columns.Add("Narration");
dtAcc.Columns.Add("ParentId");
dtAcc.Columns.Add("Ac_Id");
gdvMainPayment.DataSource = dtAcc;
dtLedger.Columns.Add("Name");
dtLedger.Columns.Add("Group");
dtLedger.Columns.Add("Op.Bal");
dtLedger.Columns.Add("Address");
dtLedger.Columns.Add("Mobile");
dtPayAcc.Columns.Add("Name");
dtPayAcc.Columns.Add("Group");
dtPayAcc.Columns.Add("Op.Bal");
dtPayAcc.Columns.Add("Address");
dtPayAcc.Columns.Add("Mobile");
dtAcc.Rows.Clear();
DataRow drAcc;
List <AccountMasterModel> lstAccount = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccount)
{
if (objAcc.AccGroupId == 72 || objAcc.AccGroupId == 73 || objAcc.AccGroupId == 74)
{
drAcc = dtPayAcc.NewRow();
drAcc["Name"] = objAcc.AccountName;
drAcc["Group"] = objAcc.Group;
drAcc["Op.Bal"] = objAcc.OPBal;
drAcc["Address"] = objAcc.address;
drAcc["Mobile"] = objAcc.MobileNumber;
dtPayAcc.Rows.Add(drAcc);
}
}
cbxPayMode.Properties.DataSource = dtPayAcc;
cbxPayMode.Properties.DisplayMember = "Name";
dtLedger.Rows.Clear();
RepositoryItemLookUpEdit AccLookup = new RepositoryItemLookUpEdit();
DataRow drparty;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
drparty = dtLedger.NewRow();
drparty["Name"] = objAcc.AccountName;
drparty["Group"] = objAcc.Group;
drparty["Op.Bal"] = objAcc.OPBal;
drparty["Address"] = objAcc.address;
drparty["Mobile"] = objAcc.MobileNumber;
dtLedger.Rows.Add(drparty);
}
AccLookup.DataSource = dtLedger;
AccLookup.ValueMember = "Name";
AccLookup.DisplayMember = "Name";
AccLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
AccLookup.AutoSearchColumnIndex = 1;
gdvPayment.Columns["Account"].ColumnEdit = AccLookup;
gdvPayment.BestFitColumns();
RepositoryItemLookUpEdit riDCLookup = new RepositoryItemLookUpEdit();
riDCLookup.DataSource = new string[] { "D", "C" };
gdvPayment.Columns["DC"].ColumnEdit = riDCLookup;
riDCLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoFilter;
riDCLookup.AutoSearchColumnIndex = 1;
riDCLookup.DropDownRows = 0;
lblSave.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
lblDelete.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
lblUpdate.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.OnlyInCustomization;
SingleEntryMode();
}
private void LoadGridColumns()
{
//Show Items Detais in Grid
RepositoryItemLookUpEdit ItemsLookup = new RepositoryItemLookUpEdit();
dtItems.Rows.Clear();
DataRow drItems;
List <ItemMasterModel> lstItems = objIMBL.GetAllItems();
foreach (ItemMasterModel objItems in lstItems)
{
drItems = dtItems.NewRow();
drItems["Item"] = objItems.Name;
drItems["GroupName"] = objItems.Group;
drItems["Company"] = objItems.Company;
dtItems.Rows.Add(drItems);
}
ItemsLookup.DataSource = dtItems;
ItemsLookup.ValueMember = "Item";
ItemsLookup.DisplayMember = "Item";
//ItemsLookup.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
ItemsLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
ItemsLookup.AutoSearchColumnIndex = 1;
dvgItemDetails.Columns["Item"].ColumnEdit = ItemsLookup;
dvgItemDetails.BestFitColumns();
RepositoryItemLookUpEdit BSLookup = new RepositoryItemLookUpEdit();
List <BillSundryMasterModel> lstBillSundary = objBSBL.GetAllBillSundry();
List <string> lstbs = new List <string>();
foreach (BillSundryMasterModel objBS in lstBillSundary)
{
lstbs.Add(objBS.Name);
}
BSLookup.DataSource = lstbs;
BSLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
BSLookup.AutoSearchColumnIndex = 1;
//BSLookup.ValueMember = "BillSundary";
//BSLookup.DisplayMember = "BillSundary";
dvgBsDetails.Columns["BillSundry"].ColumnEdit = BSLookup;
dvgBsDetails.BestFitColumns();
dvgItemDetails.Columns["Unit"].ColumnEdit = UnitsLookup;
dvgItemDetails.BestFitColumns();
dvgItemDetails.Columns["Per"].ColumnEdit = UnitsLookup;
dvgItemDetails.BestFitColumns();
RepositoryItemLookUpEdit PartysLookup = new RepositoryItemLookUpEdit();
dtParticulars.Rows.Clear();
DataRow drParticulars;
List <AccountMasterModel> lstAccounts = objAccBL.GetListofAccount();
foreach (AccountMasterModel objAcc in lstAccounts)
{
if (objAcc.AccGroupId == 70 || objAcc.AccGroupId == 68)
{
drParticulars = dtParticulars.NewRow();
drParticulars["Name"] = objAcc.AccountName;
drParticulars["Group"] = objAcc.Group;
drParticulars["Op.Bal"] = objAcc.OPBal;
drParticulars["Address"] = objAcc.address;
drParticulars["Mobile"] = objAcc.MobileNumber;
dtParticulars.Rows.Add(drParticulars);
}
}
PartysLookup.DataSource = dtParticulars;
PartysLookup.ValueMember = "Name";
PartysLookup.DisplayMember = "Name";
PartysLookup.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete;
PartysLookup.AutoSearchColumnIndex = 0;
dvgItemDetails.Columns["Particulars"].ColumnEdit = PartysLookup;
dvgItemDetails.BestFitColumns();
}
private void AccountList_Load(object sender, EventArgs e)
{
List <eSunSpeedDomain.AccountMasterModel> lstaccounts = objaccbl.GetListofAccount();
dvgAccountList.DataSource = lstaccounts;
}
