void bindCrCMB(string LedgerName) { if (passedVoucherType == 1 || passedVoucherType == 2) //Payment & Receipt { #region Payment _Receipt_Cr_CMB_Bind _entities = new MicroAccountsEntities1(); var grpIdCre = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Creditors").FirstOrDefault().groupId; var grpIdDeb = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Debtors").FirstOrDefault().groupId; var data1 = _entities.tbl_AccLedger.Where(x => x.ledgerName != LedgerName && x.groupId == grpIdCre || x.groupId == grpIdDeb && x.type == 0).OrderBy(x => x.ledgerName).ToList(); List <AccLedgerVm> modelList = new List <AccLedgerVm>(); AccLedgerVm select = new AccLedgerVm(); //for adding --select-- at 0'th pos in both cmb select.Id = 0; select.ledgerNameWithCreditors = "--Select--"; modelList.Add(select); foreach (var item in data1) { AccLedgerVm acc = new AccLedgerVm(); acc.Id = item.Id; acc.ledgerNameWithCreditors = item.ledgerName; modelList.Add(acc); } var data2 = _entities.tbl_AccLedger.Where(x => x.ledgerName != LedgerName && x.type == 1).OrderBy(x => x.ledgerName).ToList(); foreach (var item in data2) { AccLedgerVm acc = new AccLedgerVm(); acc.Id = item.Id; acc.ledgerNameWithCreditors = item.ledgerName; modelList.Add(acc); } // modelList = modelList.OrderBy(x => x.ledgerNameWithCreditors).ToList(); /*cmb Datasource does not accepts modellist with orderby * clause so we have to save modellist with orderby clause * in the modellist and the pass the model list to the * cmb datasouce.*/ cmbLedgerCR.DataSource = modelList; cmbLedgerCR.DisplayMember = "ledgerNameWithCreditors"; cmbLedgerCR.ValueMember = "Id"; cmbLedgerCR.AutoCompleteCustomSource.Clear(); foreach (var item in modelList.OrderBy(x => x.ledgerNameWithCreditors)) { cmbLedgerCR.AutoCompleteCustomSource.Add(item.ledgerNameWithCreditors.ToString()); } cmbLedgerCR.Text = ""; cmbLedgerCR.SelectedIndex = 0; #endregion } else if (passedVoucherType == 3) //Journal { #region Journal_CR_CMB_Bind _entities = new MicroAccountsEntities1(); var grpIdCre = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Creditors").FirstOrDefault().groupId; var grpIdDeb = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Debtors").FirstOrDefault().groupId; var data1 = _entities.tbl_AccLedger.Where(x => x.ledgerName != LedgerName && x.groupId == grpIdCre || x.groupId == grpIdDeb && x.type == 0).OrderBy(x => x.ledgerName).ToList(); List <AccLedgerVm> modelList = new List <AccLedgerVm>(); AccLedgerVm select = new AccLedgerVm(); //for adding --select-- at 0'th pos in both cmb select.Id = 0; select.ledgerNameWithCreditors = "--Select--"; modelList.Add(select); foreach (var item in data1) { AccLedgerVm acc = new AccLedgerVm(); acc.Id = item.Id; acc.ledgerNameWithCreditors = item.ledgerName; modelList.Add(acc); } // modelList = modelList.OrderBy(x => x.ledgerNameWithCreditors).ToList(); /*cmb Datasource does not accepts modellist with orderby * clause so we have to save modellist with orderby clause * in the modellist and the pass the model list to the * cmb datasouce.*/ cmbLedgerCR.DataSource = modelList; cmbLedgerCR.DisplayMember = "ledgerNameWithCreditors"; cmbLedgerCR.ValueMember = "Id"; cmbLedgerCR.AutoCompleteCustomSource.Clear(); foreach (var item in modelList.OrderBy(x => x.ledgerNameWithCreditors)) { cmbLedgerCR.AutoCompleteCustomSource.Add(item.ledgerNameWithCreditors.ToString()); } cmbLedgerCR.Text = ""; cmbLedgerCR.SelectedIndex = 0; #endregion } else // Contra { #region Contra_CR_CMB_Bind _entities = new MicroAccountsEntities1(); var data1 = _entities.tbl_AccLedger.Where(x => x.ledgerName != LedgerName && x.type == 1).OrderBy(x => x.ledgerName).ToList(); List <AccLedgerVm> modelList = new List <AccLedgerVm>(); AccLedgerVm select = new AccLedgerVm(); //for adding --select-- at 0'th pos in both cmb select.Id = 0; select.ledgerNameWithCreditors = "--Select--"; modelList.Add(select); foreach (var item in data1) { AccLedgerVm acc = new AccLedgerVm(); acc.Id = item.Id; acc.ledgerNameWithCreditors = item.ledgerName; modelList.Add(acc); } // modelList = modelList.OrderBy(x => x.ledgerNameWithCreditors).ToList(); /*cmb Datasource does not accepts modellist with orderby * clause so we have to save modellist with orderby clause * in the modellist and the pass the model list to the * cmb datasouce.*/ cmbLedgerCR.DataSource = modelList; cmbLedgerCR.DisplayMember = "ledgerNameWithCreditors"; cmbLedgerCR.ValueMember = "Id"; cmbLedgerCR.AutoCompleteCustomSource.Clear(); foreach (var item in modelList.OrderBy(x => x.ledgerNameWithCreditors)) { cmbLedgerCR.AutoCompleteCustomSource.Add(item.ledgerNameWithCreditors.ToString()); } cmbLedgerCR.Text = ""; cmbLedgerCR.SelectedIndex = 0; #endregion } }
void dataGridBind() { try { int rowNo = 1; dgLedgerDetails.AutoGenerateColumns = false; _entities = new MicroAccountsEntities1(); List <AccLedgerVm> modelList = new List <AccLedgerVm>(); var data = _entities.tbl_AccLedger.OrderByDescending(x => x.Id); foreach (var item in data) { AccLedgerVm model = new AccLedgerVm(); model.rowNo = rowNo; model.Id = item.Id; model.ledgerName = item.ledgerName; model.groupName = _entities.tbl_AccGroup.Where(x => x.groupId == item.groupId).FirstOrDefault().groupName; if (item.opBalanceDC == "D") { model.opBalanceDC = "Dr " + item.opBalance; } else { model.opBalanceDC = "Cr " + item.opBalance; } if (item.createdDate == null) { model.createdDate = "--"; } else { model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt"); } if (item.updatedDate == null) { model.updateDate = "--"; } else { model.updateDate = Convert.ToDateTime(item.updatedDate).ToString("dd-MM-yyyy hh:mm tt"); } modelList.Add(model); rowNo++; } dgLedgerDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } catch (Exception x) { //MessageBox.Show(x.ToString()); } }
void bindDrCMB() { if (passedVoucherType == 1 || passedVoucherType == 2) //Payment & Receipt { #region Payment_Receipt_CR_CMB_Bind _entities = new MicroAccountsEntities1(); var grpIdCre = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Creditors").FirstOrDefault().groupId; var grpIdDeb = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Debtors").FirstOrDefault().groupId; var data1 = _entities.tbl_AccLedger.Where(x => x.groupId == grpIdCre || x.groupId == grpIdDeb && x.type == 0).OrderBy(x => x.ledgerName).ToList(); List <AccLedgerVm> modelList = new List <AccLedgerVm>(); AccLedgerVm select = new AccLedgerVm(); //for adding --select-- at 0'th pos in both cmb select.Id = 0; select.ledgerNameWithCreditors = "--Select--"; modelList.Add(select); foreach (var item in data1) { AccLedgerVm acc = new AccLedgerVm(); acc.Id = item.Id; acc.ledgerNameWithCreditors = item.ledgerName; modelList.Add(acc); } cmbLedgerDR.DataSource = modelList; cmbLedgerDR.DisplayMember = "ledgerNameWithCreditors"; cmbLedgerDR.ValueMember = "Id"; cmbLedgerDR.AutoCompleteCustomSource.Clear(); foreach (var item in modelList.OrderBy(x => x.ledgerNameWithCreditors)) { cmbLedgerDR.AutoCompleteCustomSource.Add(item.ledgerNameWithCreditors.ToString()); } #endregion } else if (passedVoucherType == 3) //Journal { #region Journal_CR_CMB_Bind _entities = new MicroAccountsEntities1(); var grpIdCre = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Creditors").FirstOrDefault().groupId; var grpIdDeb = _entities.tbl_AccGroup.Where(x => x.groupName == "Sundry Debtors").FirstOrDefault().groupId; var data1 = _entities.tbl_AccLedger.Where(x => x.groupId == grpIdCre || x.groupId == grpIdDeb && x.type == 0).OrderBy(x => x.ledgerName).ToList(); List <AccLedgerVm> modelList = new List <AccLedgerVm>(); AccLedgerVm select = new AccLedgerVm(); //for adding --select-- at 0'th pos in both cmb select.Id = 0; select.ledgerNameWithCreditors = "--Select--"; modelList.Add(select); foreach (var item in data1) { AccLedgerVm acc = new AccLedgerVm(); acc.Id = item.Id; acc.ledgerNameWithCreditors = item.ledgerName; modelList.Add(acc); } cmbLedgerDR.DataSource = modelList; cmbLedgerDR.DisplayMember = "ledgerNameWithCreditors"; cmbLedgerDR.ValueMember = "Id"; cmbLedgerDR.AutoCompleteCustomSource.Clear(); foreach (var item in modelList.OrderBy(x => x.ledgerNameWithCreditors)) { cmbLedgerDR.AutoCompleteCustomSource.Add(item.ledgerNameWithCreditors.ToString()); } #endregion } else // Contra { #region Contra_CR_CMB_Bind _entities = new MicroAccountsEntities1(); var data1 = _entities.tbl_AccLedger.Where(x => x.type == 1).OrderBy(x => x.ledgerName).ToList(); List <AccLedgerVm> modelList = new List <AccLedgerVm>(); AccLedgerVm select = new AccLedgerVm(); //for adding --select-- at 0'th pos in both cmb select.Id = 0; select.ledgerNameWithCreditors = "--Select--"; modelList.Add(select); foreach (var item in data1) { AccLedgerVm acc = new AccLedgerVm(); acc.Id = item.Id; acc.ledgerNameWithCreditors = item.ledgerName; modelList.Add(acc); } cmbLedgerDR.DataSource = modelList; cmbLedgerDR.DisplayMember = "ledgerNameWithCreditors"; cmbLedgerDR.ValueMember = "Id"; cmbLedgerDR.AutoCompleteCustomSource.Clear(); foreach (var item in modelList.OrderBy(x => x.ledgerNameWithCreditors)) { cmbLedgerDR.AutoCompleteCustomSource.Add(item.ledgerNameWithCreditors.ToString()); } #endregion } }