private void button1_Click(object sender, EventArgs e) { try { int rowNo = 1; dgPurchaseDetails.AutoGenerateColumns = false; _entities = new MicroAccountsEntities1(); List <PurchaseMasterVM> purchaseMasterList = new List <PurchaseMasterVM>(); List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>(); DateTime fromdate = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null); DateTime todate = DateTime.ParseExact(dateTimePicker2.Text, "dd-MM-yyyy", null); if (fromdate > todate) { MessageBox.Show("Invalid date entered. Select valid dates"); return; } else { if (txtSearch.Text == string.Empty) { data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate).OrderByDescending(x => x.pId).ToList(); } else { data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate && x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.pId).ToList(); } foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; model.pId = item.pId; model.refNo = item.refNo; model.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName; model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy"); model.totalWeight = item.totalWeight; model.totalAmt = item.totalAmt; model.totalMelting = item.totalMelting; model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt"); model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt"); purchaseMasterList.Add(model); rowNo++; } dgPurchaseDetails.DataSource = purchaseMasterList; lblTotalRows.Text = purchaseMasterList.Count.ToString(); } } catch (Exception x) { } }
private void txtSearch_KeyUp(object sender, KeyEventArgs e) { try { int rowNo = 1; dgPurchaseDetails.AutoGenerateColumns = false; totalAmts = 0; if (txtSearch.Text == string.Empty) { dataGridBind(); return; } _entities = new KBBQEntities(); List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>(); var data = _entities.tbl_PurchaseMaster.Where(x => x.refNo.Contains(txtSearch.Text.Trim()) || x.partyName.Contains(txtSearch.Text.Trim())).OrderByDescending(x => x.pId); foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; model.pId = item.pId; model.refNo = item.refNo; model.partyName = item.partyName; model.remarks = item.remarks; model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy"); model.totalWeight = item.totalWeight; model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt"); if (item.updateDate == null) { model.updateDate = "--"; } else { model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt"); } totalAmts += item.totalAmt; modelList.Add(model); rowNo++; } dgPurchaseDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); lblTotalAmt.Text = amtFormat.comma(totalAmts); } 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); }
private void dataGridBind() { try { int rowNo = 1; totalAmts = 0; dgPurchaseDetails.AutoGenerateColumns = false; _entities = new KBBQEntities(); List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>(); var data = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId); foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; model.pId = item.pId; model.refNo = item.refNo; model.partyName = item.partyName; model.remarks = item.remarks; model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy"); model.totalWeight = item.totalWeight; model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt"); if (item.updateDate == null) { model.updateDate = "--"; } else { model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt"); } modelList.Add(model); totalAmts += item.totalAmt; rowNo++; } lblTotalAmt.Text = amtFormat.comma(totalAmts); dgPurchaseDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
void dataGridBind() { try { int rowNo = 1; dgPurchaseDetails.AutoGenerateColumns = false; _entities = new MicroAccountsEntities1(); List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>(); var data = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId); foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; model.pId = item.pId; model.refNo = item.refNo; model.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName; model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy"); model.totalWeight = item.totalWeight; model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); model.totalMelting = item.totalMelting; model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt"); if (item.updateDate == null) { model.updateDate = "--"; } else { model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt"); } modelList.Add(model); rowNo++; } dgPurchaseDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void txtSearch_KeyUp(object sender, KeyEventArgs e) { try { int rowNo = 1; dgPurchaseDetails.AutoGenerateColumns = false; _entities = new MicroAccountsEntities1(); List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>(); var data = _entities.tbl_PurchaseMaster.Where(x => x.refNo.Contains(txtSearch.Text) || x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text)).OrderByDescending(x => x.pId); foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; model.pId = item.pId; model.refNo = item.refNo; model.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName; model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy"); model.totalWeight = item.totalWeight; model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); model.totalMelting = item.totalMelting; model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt"); model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt"); modelList.Add(model); rowNo++; } dgPurchaseDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } catch (Exception x) { } }
private void datagridBind(string type) { try { dgPurchaseReport.AutoGenerateColumns = false; dgSalesReport.AutoGenerateColumns = false; ttlAmt = 0; int rowNo = 1; _entities = new MicroAccountsEntities1(); List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>(); List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>(); List <SalesMasterVM> modelListSales = new List <SalesMasterVM>(); List <tbl_SalesMaster> dataSales = new List <tbl_SalesMaster>(); if (type == "--All--") { #region PurchaseData data = _entities.tbl_PurchaseMaster.ToList(); foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; DateTime dt = Convert.ToDateTime(item.date).Date; model.monthYear = dt.Date.ToString("dd-MM-yyyy"); model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); rowNo++; modelList.Add(model); ttlAmt += Convert.ToDecimal(item.totalAmt); lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } dgPurchaseReport.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); #endregion #region Salesregion ttlAmt = 0; rowNo = 1; dataSales = new List <tbl_SalesMaster>(); dataSales = _entities.tbl_SalesMaster.ToList(); foreach (var item in dataSales) { SalesMasterVM model = new SalesMasterVM(); model.rowNo = rowNo; DateTime dt = Convert.ToDateTime(item.date).Date; model.monthYear = dt.Date.ToString("dd-MM-yyyy"); model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); rowNo++; modelListSales.Add(model); ttlAmt += Convert.ToDecimal(item.totalAmt); lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } dgSalesReport.DataSource = modelListSales; lblSalesRow.Text = modelList.Count.ToString(); #endregion } else if (type == "Month") { #region Purchase Data ttlAmt = 0; rowNo = 1; dgPurchaseReport.DataSource = null; dgPurchaseReport.Rows.Clear(); _entities = new MicroAccountsEntities1(); data = new List <tbl_PurchaseMaster>(); data = _entities.tbl_PurchaseMaster.ToList(); string dates = ""; decimal?amt = 0; int rowId = -1; foreach (var item in data) { var date = Convert.ToDateTime(item.date).Date; string dd = date.ToString("MMM"); if (dd != dates) { dgPurchaseReport.Rows.Add("0", rowNo, dd); dates = dd; amt = 0; rowId++; } amt += item.totalAmt; dgPurchaseReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt); rowNo++; ttlAmt += item.totalAmt; lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblTotalRows.Text = rowNo.ToString(); #endregion #region Sales Data ttlAmt = 0; rowNo = 1; dgSalesReport.DataSource = null; dgSalesReport.Rows.Clear(); _entities = new MicroAccountsEntities1(); dataSales = new List <tbl_SalesMaster>(); dataSales = _entities.tbl_SalesMaster.ToList(); dates = ""; amt = 0; rowId = -1; foreach (var item in dataSales) { var date = Convert.ToDateTime(item.date).Date; string dd = date.ToString("MMM"); if (dd != dates) { dgSalesReport.Rows.Add("0", rowNo, dd); dates = dd; amt = 0; rowId++; } amt += item.totalAmt; dgSalesReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt); rowNo++; ttlAmt += item.totalAmt; lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblSalesRow.Text = rowNo.ToString(); #endregion } else { #region Purchase Data ttlAmt = 0; rowNo = 1; dgPurchaseReport.DataSource = null; dgPurchaseReport.Rows.Clear(); _entities = new MicroAccountsEntities1(); data = new List <tbl_PurchaseMaster>(); data = _entities.tbl_PurchaseMaster.ToList(); string dates = ""; decimal?amt = 0; int rowId = -1; foreach (var item in data) { var date = Convert.ToDateTime(item.date).Date; string dd = date.ToString("yyyy"); if (dd != dates) { dgPurchaseReport.Rows.Add("0", rowNo, dd); dates = dd; amt = 0; rowId++; } amt += item.totalAmt; dgPurchaseReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt); rowNo++; ttlAmt += item.totalAmt; lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblTotalRows.Text = rowNo.ToString(); #endregion #region Sales Data ttlAmt = 0; rowNo = 1; dgSalesReport.DataSource = null; dgSalesReport.Rows.Clear(); _entities = new MicroAccountsEntities1(); dataSales = new List <tbl_SalesMaster>(); dataSales = _entities.tbl_SalesMaster.ToList(); dates = ""; amt = 0; rowId = -1; foreach (var item in dataSales) { var date = Convert.ToDateTime(item.date).Date; string dd = date.ToString("yyyy"); if (dd != dates) { dgSalesReport.Rows.Add("0", rowNo, dd); dates = dd; amt = 0; rowId++; } amt += item.totalAmt; dgSalesReport.Rows[rowId].Cells[3].Value = amtFormat.comma(amt); rowNo++; ttlAmt += item.totalAmt; lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblSalesRow.Text = rowNo.ToString(); #endregion } } catch (Exception x) { } }
private void cmbBInd(List <long?> val) { _entities = new MicroAccountsEntities1(); // var idss = _entities.tbl_PurchaseMaster.Where(x => x.ledgerId == passedLedgerId).FirstOrDefault().pId; // var checkBillNo=_entities.tbl_PaymentDetails.Where(x=>x.purchaseId==) if (passedVoucherType == 1) { #region for purchase(Payment) List <tbl_PurchaseMaster> data; if (val.Contains(0) || val.Count == 0) { data = new List <tbl_PurchaseMaster>(); data = _entities.tbl_PurchaseMaster.Where(x => x.ledgerId == passedLedgerId).ToList(); } else { data = new List <tbl_PurchaseMaster>(); data = _entities.tbl_PurchaseMaster.Where(x => x.ledgerId == passedLedgerId && !val.Contains(x.pId)).ToList(); } List <PurchaseMasterVM> modelLst = new List <PurchaseMasterVM>(); PurchaseMasterVM model = new PurchaseMasterVM(); model.combineRefNo = "--Select--"; modelLst.Add(model); foreach (var item in data) { var dataPaymentDetails = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == item.pId).ToList(); foreach (var items in dataPaymentDetails) { paymentDetailsTotalAmt += items.amtPaid; } if ((item.totalAmt - paymentDetailsTotalAmt) >= 0) { model = new PurchaseMasterVM(); model.pId = item.pId; model.combineRefNo = "Ref. No: " + item.refNo + " | Amount: " + (item.totalAmt - paymentDetailsTotalAmt); modelLst.Add(model); } paymentDetailsTotalAmt = 0; } cmbBillRef.DataSource = modelLst; cmbBillRef.DisplayMember = "combineRefNo"; cmbBillRef.ValueMember = "pId"; #endregion } else { #region for Sales(Receipt) List <tbl_SalesMaster> data; if (val.Contains(0) || val.Count == 0) { data = new List <tbl_SalesMaster>(); data = _entities.tbl_SalesMaster.Where(x => x.ledgerId == passedLedgerId).ToList(); } else { data = new List <tbl_SalesMaster>(); data = _entities.tbl_SalesMaster.Where(x => x.ledgerId == passedLedgerId && !val.Contains(x.sId)).ToList(); } List <PurchaseMasterVM> modelLst = new List <PurchaseMasterVM>(); PurchaseMasterVM model = new PurchaseMasterVM(); model.combineRefNo = "--Select--"; modelLst.Add(model); foreach (var item in data) { var dataPaymentDetails = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == item.sId).ToList(); foreach (var items in dataPaymentDetails) { paymentDetailsTotalAmt += items.amtPaid; } if ((item.totalAmt - paymentDetailsTotalAmt) >= 0) { model = new PurchaseMasterVM(); model.pId = item.sId; model.combineRefNo = "Ref. No: " + item.billNo + " | Amount: " + (item.totalAmt - paymentDetailsTotalAmt); modelLst.Add(model); } paymentDetailsTotalAmt = 0; } cmbBillRef.DataSource = modelLst; cmbBillRef.DisplayMember = "combineRefNo"; cmbBillRef.ValueMember = "pId"; #endregion } }
private void dataBind() { try { // if (dgBillRef.Rows.Count > 0) { int count = 0; var id = Convert.ToInt32(cmbBillRef.SelectedValue); //int checkDatagridId = Convert.ToInt32(dgBillRef.Rows[datagridId].Cells[0].Value); foreach (DataGridViewRow dr in dgBillRef.Rows) { if (Convert.ToInt32(dr.Cells[0].Value) == id) { count = 1; } } if (count != 1 && !deleteDataGridRow) { if (passedAmt > 0) { if (datagridId == 0) { idPassedToCmbArray = new List <long?>(); } _entities = new MicroAccountsEntities1(); if (passedVoucherType == 1) { #region for Purchase(Payment) var data = _entities.tbl_PurchaseMaster.Where(x => x.pId == id).FirstOrDefault(); PurchaseMasterVM pvm = new PurchaseMasterVM(); pvm.IdForGrid = data.pId; pvm.refNoBillNoForGrid = data.refNo; var checkPayDetailsData = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == id).ToList(); if (checkPayDetailsData != null) { foreach (var item in checkPayDetailsData) { totalAmtPaymentDetails += item.amtPaid; } totalAmtPaymentDetails = data.totalAmt - totalAmtPaymentDetails; } else { totalAmtPaymentDetails = data.totalAmt; } pvm.totalAmt = totalAmtPaymentDetails; dgBillRef.Rows.Add(pvm); dgBillRef.Rows[datagridId].Cells[0].Value = data.pId; dgBillRef.Rows[datagridId].Cells[1].Value = "#"; dgBillRef.Rows[datagridId].Cells[2].Value = data.refNo; dgBillRef.Rows[datagridId].Cells[3].Value = data.date; if (totalAmtPaymentDetails > passedAmt) { dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt; } else if (totalAmtPaymentDetails < passedAmt) { dgBillRef.Rows[datagridId].Cells[4].Value = totalAmtPaymentDetails; idPassedToCmbArray.Add(data.pId); cmbBInd(idPassedToCmbArray); } else if (totalAmtPaymentDetails == passedAmt) { dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt; idPassedToCmbArray.Add(data.pId); cmbBInd(idPassedToCmbArray); } passedAmt = passedAmt - Convert.ToDecimal(dgBillRef.Rows[datagridId].Cells[4].Value); datagridId++; lblRows.Text = datagridId.ToString() + " Rows"; //Number of rows showing label count = 0; #endregion } else if (passedVoucherType == 2) { #region for Sales(Receipt) var data = _entities.tbl_SalesMaster.Where(x => x.sId == id).FirstOrDefault(); SalesMasterVM pvm = new SalesMasterVM(); pvm.IdForGrid = data.sId; pvm.refNoBillNoForGrid = data.billNo; var checkPayDetailsData = _entities.tbl_EntryDetails.Where(x => x.purchaseSalesIds == id).ToList(); if (checkPayDetailsData != null) { foreach (var item in checkPayDetailsData) { totalAmtPaymentDetails += item.amtPaid; } totalAmtPaymentDetails = data.totalAmt - totalAmtPaymentDetails; } else { totalAmtPaymentDetails = data.totalAmt; } pvm.totalAmt = totalAmtPaymentDetails; dgBillRef.Rows.Add(pvm); dgBillRef.Rows[datagridId].Cells[0].Value = data.sId; dgBillRef.Rows[datagridId].Cells[1].Value = "#"; dgBillRef.Rows[datagridId].Cells[2].Value = data.billNo; dgBillRef.Rows[datagridId].Cells[3].Value = data.date; if (totalAmtPaymentDetails > passedAmt) { dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt; } else if (totalAmtPaymentDetails < passedAmt) { dgBillRef.Rows[datagridId].Cells[4].Value = totalAmtPaymentDetails; idPassedToCmbArray.Add(data.sId); cmbBInd(idPassedToCmbArray); } else if (totalAmtPaymentDetails == passedAmt) { dgBillRef.Rows[datagridId].Cells[4].Value = passedAmt; idPassedToCmbArray.Add(data.sId); cmbBInd(idPassedToCmbArray); } passedAmt = passedAmt - Convert.ToDecimal(dgBillRef.Rows[datagridId].Cells[4].Value); datagridId++; lblRows.Text = datagridId.ToString() + " Rows"; //Number of rows showing label count = 0; #endregion } } //else //{ // MessageBox.Show("Something went wrong. Cannot add this row."); //} } //else //{ // MessageBox.Show("Cannot add same row."); //} } } catch (Exception x) { } }
private void datagridBind(string type) { try { dgPurchaseReport.AutoGenerateColumns = false; dgSalesReport.AutoGenerateColumns = false; ttlAmt = 0; int rowNo = 1; _entities = new KBBQEntities(); List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>(); List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>(); List <DetailSettlementVM> modelListSales = new List <DetailSettlementVM>(); List <detailsSettlement> dataSales = new List <detailsSettlement>(); if (type == "--All--") { #region PurchaseData data = _entities.tbl_PurchaseMaster.ToList(); foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; DateTime dt = Convert.ToDateTime(item.date).Date; model.monthYear = dt.Date.ToString("dd-MM-yyyy"); model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); model.KOT = item.refNo; rowNo++; modelList.Add(model); ttlAmt += Convert.ToDecimal(item.totalAmt); lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } dgPurchaseReport.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); #endregion #region Salesregion ttlAmt = 0; rowNo = 1; dataSales = new List <detailsSettlement>(); dataSales = _entities.detailsSettlements.ToList(); foreach (var item in dataSales) { DetailSettlementVM model = new DetailSettlementVM(); model.rowNo = rowNo; DateTime dt = Convert.ToDateTime(item.paidDate).Date; model.monthYear = dt.Date.ToString("dd-MM-yyyy"); model.AmountPaid = Convert.ToDecimal(amtFormat.comma(item.bill)); model.KOT = item.receiptno; rowNo++; modelListSales.Add(model); ttlAmt += Convert.ToDecimal(item.bill); _entities = new KBBQEntities(); var checkForAdvancePay = _entities.tblAdvBookings.Where(x => x.recptNo == item.receiptno).FirstOrDefault(); if (checkForAdvancePay != null) { ttlAmt += checkForAdvancePay.advancePayment; model.advancePaid = checkForAdvancePay.advancePayment; } else { model.advancePaid = 0; } lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } dgSalesReport.DataSource = modelListSales; lblSalesRow.Text = modelList.Count.ToString(); #endregion } else if (type == "Month") { #region Purchase Data ttlAmt = 0; rowNo = 1; dgPurchaseReport.DataSource = null; dgPurchaseReport.Rows.Clear(); _entities = new KBBQEntities(); data = new List <tbl_PurchaseMaster>(); data = _entities.tbl_PurchaseMaster.ToList(); string dates = ""; decimal?amt = 0; int rowId = -1; foreach (var item in data) { var date = Convert.ToDateTime(item.date).Date; string dd = date.ToString("MMM"); if (dd != dates) { dgPurchaseReport.Rows.Add("0", rowNo, "--", dd); dates = dd; amt = 0; rowId++; } amt += item.totalAmt; dgPurchaseReport.Rows[rowId].Cells[4].Value = amtFormat.comma(amt); rowNo++; ttlAmt += item.totalAmt; lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblTotalRows.Text = modelList.Count.ToString(); #endregion #region Sales Data ttlAmt = 0; rowNo = 1; dgSalesReport.DataSource = null; dgSalesReport.Rows.Clear(); _entities = new KBBQEntities(); dataSales = new List <detailsSettlement>(); dataSales = _entities.detailsSettlements.ToList(); dates = ""; amt = 0; rowId = -1; decimal?advPay = 0; foreach (var item in dataSales) { var date = Convert.ToDateTime(item.paidDate).Date; string dd = date.ToString("MMM"); if (dd != dates) { dgSalesReport.Rows.Add("0", rowNo, "--", dd); dates = dd; amt = 0; rowId++; } amt += item.bill; dgSalesReport.Rows[rowId].Cells[5].Value = amtFormat.comma(amt); ttlAmt += item.bill; _entities = new KBBQEntities(); var checkForAdvancePay = _entities.tblAdvBookings.Where(x => x.recptNo == item.receiptno).FirstOrDefault(); if (checkForAdvancePay != null) { ttlAmt += checkForAdvancePay.advancePayment; advPay += checkForAdvancePay.advancePayment; dgSalesReport.Rows[rowId].Cells[4].Value = advPay; } rowNo++; lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblSalesRow.Text = modelList.Count.ToString(); #endregion } else { #region Purchase Data ttlAmt = 0; rowNo = 1; dgPurchaseReport.DataSource = null; dgPurchaseReport.Rows.Clear(); _entities = new KBBQEntities(); data = new List <tbl_PurchaseMaster>(); data = _entities.tbl_PurchaseMaster.ToList(); string dates = ""; decimal?amt = 0; int rowId = -1; foreach (var item in data) { var date = Convert.ToDateTime(item.date).Date; string dd = date.ToString("yyyy"); if (dd != dates) { dgPurchaseReport.Rows.Add("0", rowNo, "--", dd); dates = dd; amt = 0; rowId++; } amt += item.totalAmt; dgPurchaseReport.Rows[rowId].Cells[4].Value = amtFormat.comma(amt); rowNo++; ttlAmt += item.totalAmt; lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblTotalRows.Text = modelList.Count.ToString(); #endregion #region Sales Data ttlAmt = 0; rowNo = 1; dgSalesReport.DataSource = null; dgSalesReport.Rows.Clear(); _entities = new KBBQEntities(); dataSales = new List <detailsSettlement>(); dataSales = _entities.detailsSettlements.ToList(); dates = ""; amt = 0; rowId = -1; decimal?advPay = 0; foreach (var item in dataSales) { var date = Convert.ToDateTime(item.paidDate).Date; string dd = date.ToString("yyyy"); if (dd != dates) { dgSalesReport.Rows.Add("0", rowNo, "--", dd); dates = dd; amt = 0; rowId++; } amt += item.bill; dgSalesReport.Rows[rowId].Cells[5].Value = amtFormat.comma(amt); rowNo++; ttlAmt += item.bill; _entities = new KBBQEntities(); var checkForAdvancePay = _entities.tblAdvBookings.Where(x => x.recptNo == item.receiptno).FirstOrDefault(); if (checkForAdvancePay != null) { ttlAmt += checkForAdvancePay.advancePayment; advPay += checkForAdvancePay.advancePayment; dgSalesReport.Rows[rowId].Cells[4].Value = advPay; } lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } lblSalesRow.Text = modelList.Count.ToString(); #endregion } } catch (Exception x) { } }
private void btnDatSearcsh_Click(object sender, EventArgs e) { DateTime fromdate = DateTime.ParseExact(dtpFromDate.Text, "dd-MM-yyyy", null); DateTime todate = DateTime.ParseExact(dtpToDate.Text, "dd-MM-yyyy", null); if (todate.Date < fromdate.Date) { MessageBox.Show("Invalid Date Entered", "Error - King Bar beque Restaurant", MessageBoxButtons.OK, MessageBoxIcon.Error); dtpToDate.Focus(); return; } List <PurchaseMasterVM> modelList = new List <PurchaseMasterVM>(); List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>(); List <DetailSettlementVM> modelListSales = new List <DetailSettlementVM>(); List <detailsSettlement> dataSales = new List <detailsSettlement>(); #region PurchaseData _entities = new KBBQEntities(); data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate).ToList(); int rowNo = 1; foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; DateTime dt = Convert.ToDateTime(item.date).Date; model.monthYear = dt.Date.ToString("dd-MM-yyyy"); model.totalAmt = Convert.ToDecimal(amtFormat.comma(item.totalAmt)); model.KOT = item.refNo; rowNo++; modelList.Add(model); ttlAmt += Convert.ToDecimal(item.totalAmt); lblTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } dgPurchaseReport.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); #endregion #region Salesregion ttlAmt = 0; rowNo = 1; dataSales = new List <detailsSettlement>(); dataSales = _entities.detailsSettlements.Where(x => x.paidDate >= fromdate && x.paidDate <= todate).ToList(); foreach (var item in dataSales) { DetailSettlementVM model = new DetailSettlementVM(); model.rowNo = rowNo; DateTime dt = Convert.ToDateTime(item.paidDate).Date; model.monthYear = dt.Date.ToString("dd-MM-yyyy"); model.AmountPaid = Convert.ToDecimal(amtFormat.comma(item.bill)); model.KOT = item.receiptno; rowNo++; modelListSales.Add(model); ttlAmt += Convert.ToDecimal(item.bill); lblSalesTotalAmt.Text = amtFormat.comma(ttlAmt).ToString(); } dgSalesReport.DataSource = modelListSales; lblSalesRow.Text = modelList.Count.ToString(); #endregion }
private void RptPurchase_Load(object sender, EventArgs e) { try { cnn.Open(); //SqlDataAdapter dap = new SqlDataAdapter("SELECT tbl_PurchaseMaster.*, tbl_AccLedger.* FROM tbl_AccLedger INNER JOIN tbl_PurchaseMaster ON tbl_AccLedger.Id = tbl_PurchaseMaster.ledgerId where refNo='" + this.passedId + "'", cnn); //PurchaseDataSet ds = new PurchaseDataSet(); //dap.Fill(ds, "DataTable1"); _en = new MicroAccountsEntities1(); var data = _en.tbl_PurchaseMaster.ToList(); List <PurchaseMasterVM> listVm = new List <PurchaseMasterVM>(); foreach (var item in data) { PurchaseMasterVM vm = new PurchaseMasterVM(); vm.ledgerName = _en.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName; listVm.Add(vm); } ReportDataSource datasource = new ReportDataSource(); datasource.Name = "DataSet1"; datasource.Value = listVm; this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(datasource); ReportDataSource datasource1 = new ReportDataSource(); _en = new MicroAccountsEntities1(); var data1 = _en.tbl_PurchaseDetail.ToList(); List <PurchaseDetailsVM> DetailslistVm = new List <PurchaseDetailsVM>(); foreach (var item in data1) { PurchaseDetailsVM vm = new PurchaseDetailsVM(); vm.purchaseID = item.purchaseID; DetailslistVm.Add(vm); } datasource1.Name = "DataSet2"; datasource1.Value = DetailslistVm; this.reportViewer1.LocalReport.DataSources.Add(datasource1); //reportViewer1.LocalReport.ReportEmbeddedResource = "Redport1.rdlc"; //ReportDataSource datasource = new ReportDataSource("PurchaseDataSet", ds.Tables[0]); //this.reportViewer1.LocalReport.DataSources.Clear(); //this.reportViewer1.LocalReport.DataSources.Add(data.ToList()); this.reportViewer1.RefreshReport(); cnn.Close(); } catch (Exception x) { MessageBox.Show(x.ToString()); } this.reportViewer1.RefreshReport(); //this.reportViewer1.RefreshReport(); }
private void button1_Click(object sender, EventArgs e) { try { int rowNo = 1; totalAmts = 0; dgPurchaseDetails.AutoGenerateColumns = false; _entities = new KBBQEntities(); List <PurchaseMasterVM> purchaseMasterList = new List <PurchaseMasterVM>(); List <tbl_PurchaseMaster> data = new List <tbl_PurchaseMaster>(); DateTime fromdate = DateTime.ParseExact(dateFrom.Text, "dd-MM-yyyy", null); DateTime todate = DateTime.ParseExact(dateTo.Text, "dd-MM-yyyy", null); if (fromdate > todate) { MessageBox.Show("Invalid date entered. Select valid dates"); return; } else { if (txtSearch.Text == string.Empty) { if (dateFrom.Text == DateTime.Now.Date.ToString("dd-MM-yyyy") && dateTo.Text == DateTime.Now.Date.ToString("dd-MM-yyyy")) { data = _entities.tbl_PurchaseMaster.OrderByDescending(x => x.pId).ToList(); } else { data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate).OrderByDescending(x => x.pId).ToList(); } } else { if (dateFrom.Text == DateTime.Now.Date.ToString("dd-MM-yyyy") && dateTo.Text == DateTime.Now.Date.ToString("dd-MM-yyyy")) { data = _entities.tbl_PurchaseMaster.Where(x => x.refNo.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.pId).ToList(); } else { data = _entities.tbl_PurchaseMaster.Where(x => x.date >= fromdate && x.date <= todate && x.refNo.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.pId).ToList(); } } foreach (var item in data) { PurchaseMasterVM model = new PurchaseMasterVM(); model.rowNo = rowNo; model.pId = item.pId; model.refNo = item.refNo; model.date = Convert.ToDateTime(item.date).ToString("dd-MM-yyyy"); model.totalWeight = item.totalWeight; model.totalAmt = item.totalAmt; model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt"); if (item.updateDate == null) { model.updateDate = "--"; } else { model.updateDate = Convert.ToDateTime(item.updateDate).ToString("dd-MM-yyyy hh:mm tt"); } purchaseMasterList.Add(model); totalAmts += item.totalAmt; rowNo++; } lblTotalAmt.Text = amtFormat.comma(totalAmts); dgPurchaseDetails.DataSource = purchaseMasterList; lblTotalRows.Text = purchaseMasterList.Count.ToString(); } } catch (Exception x) { } }