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