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