private void txtLedgerName_KeyUp(object sender, KeyEventArgs e)
{
try
{
int rowNo = 1;
dgLedgerDetails.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
List <LedgerDetailsVM> ledgerDetailsListVM = new List <LedgerDetailsVM>();
List <tbl_LedgerDetails> data;
if (txtLedgerName.Text == "")
{
data = _entities.tbl_LedgerDetails.ToList();
}
else
{
data = _entities.tbl_LedgerDetails.Where(x => x.tbl_AccLedger.ledgerName.Contains(txtLedgerName.Text.Trim().ToString())).ToList();
}
foreach (var item in data)
{
LedgerDetailsVM list = new LedgerDetailsVM();
list.rowNo = rowNo;
list.id = item.ledgerId;
list.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName;
var grpId = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().groupId;
list.groupName = _entities.tbl_AccGroup.Where(x => x.groupId == grpId).FirstOrDefault().groupName.ToString();
list.contact = item.contact;
list.address = item.address;
var drcr = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().opBalanceDC;
if (drcr == "D")
{
list.OpBalWithDC = "Dr " + _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().opBalance;
}
else
{
list.OpBalWithDC = "Cr " + _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().opBalance;
}
ledgerDetailsListVM.Add(list);
rowNo++;
}
dgLedgerDetails.DataSource = ledgerDetailsListVM;
lblTotalRows.Text = ledgerDetailsListVM.Count.ToString();
}
catch (Exception x)
{
}
}
private void txtLedgerName_KeyUp(object sender, KeyEventArgs e)
{
try
{
dgReceivableAmt.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new MicroAccountsEntities1();
List <tbl_AccLedger> data = new List <tbl_AccLedger>();
if (txtLedgerName.Text == "")
{
data = _entities.tbl_AccLedger.Where(x => x.tbl_AccGroup.groupName == "Sundry Debtors").ToList();
}
else
{
data = _entities.tbl_AccLedger.Where(x => x.tbl_AccGroup.groupName == "Sundry Debtors" && x.ledgerName.Contains(txtLedgerName.Text.ToString())).ToList();
}
List <LedgerDetailsVM> modelList = new List <LedgerDetailsVM>();
decimal ttlAmt = 0;
foreach (var item in data)
{
LedgerDetailsVM model = new LedgerDetailsVM();
CrDrDifference crdrDiff = new CrDrDifference();
string valueAmt = crdrDiff.DifferenceCrDr(Convert.ToInt32(item.Id), 0);
string valueAmtDR = valueAmt.Substring(0, 2);
if (valueAmtDR == "Dr")
{
string pAmtString = valueAmt.Substring(3);
model.rowNo = rowNo;
model.id = item.Id;
model.ledgerName = item.ledgerName.ToString();
model.pendingAmt = Convert.ToDecimal(amtFormat.comma(Convert.ToDecimal(pAmtString)));
rowNo++;
modelList.Add(model);
ttlAmt += Convert.ToDecimal(pAmtString);
lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString();
}
}
dgReceivableAmt.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
}
}
private void addPurchaseMaster()
{
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedId).ToList();
List <PurchaseMasterVM> listVm = new List <PurchaseMasterVM>();
List <LedgerDetailsVM> LedgerlistVm = new List <LedgerDetailsVM>();
foreach (var item in data)
{
PurchaseMasterVM vm = new PurchaseMasterVM();
vm.date = Convert.ToDateTime(item.date).Date.ToString("dd-MM-yyyy");
vm.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName;
vm.ledgerId = item.ledgerId;
vm.pId = item.pId;
vm.refNo = item.refNo;
vm.remarks = item.remarks;
vm.totalFine = item.totalFine;
vm.totalMaking = item.totalMaking;
vm.totalMelting = item.totalMelting;
vm.totalWeight = item.totalWeight;
vm.unit = item.unit;
vm.totalAmt = item.totalAmt;
ConvertNoToWord toWord = new ConvertNoToWord();
vm.amtinWord = toWord.ConvertNumbertoWords(Convert.ToInt32(item.totalAmt));
listVm.Add(vm);
LedgerDetailsVM ll = new LedgerDetailsVM();
ll.contact = _entities.tbl_LedgerDetails.Where(x => x.ledgerId == item.ledgerId).FirstOrDefault().contact;
ll.address = _entities.tbl_LedgerDetails.Where(x => x.ledgerId == item.ledgerId).FirstOrDefault().address.Trim();
LedgerlistVm.Add(ll);
}
ReportDataSource datasource = new ReportDataSource("DataSet1", listVm);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(datasource);
datasource = new ReportDataSource("DataSet3", LedgerlistVm);
this.reportViewer1.LocalReport.DataSources.Add(datasource);
}
public void dataGridBind()
{
try
{
int rowNo = 1;
dgCustomerDetails.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
ledgerDetailsListVM = new List <LedgerDetailsVM>();
var data = _entities.tbl_LedgerDetails.Where(x => x.tbl_AccLedger.tbl_AccGroup.groupName == "Sundry Debtors").ToList();
foreach (var item in data)
{
LedgerDetailsVM list = new LedgerDetailsVM();
list.rowNo = rowNo;
list.id = item.ledgerId;
list.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName;
var grpId = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().groupId;
list.groupName = _entities.tbl_AccGroup.Where(x => x.groupId == grpId).FirstOrDefault().groupName.ToString();
list.contact = item.contact;
list.address = item.address;
var drcr = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().opBalanceDC;
if (drcr == "D")
{
list.OpBalWithDC = "Dr " + _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().opBalance;
}
else
{
list.OpBalWithDC = "Cr " + _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().opBalance;
}
ledgerDetailsListVM.Add(list);
rowNo++;
}
dgCustomerDetails.DataSource = ledgerDetailsListVM;
lblTotalRows.Text = ledgerDetailsListVM.Count.ToString();
}
catch (Exception x)
{
}
}
