private void button1_Click(object sender, EventArgs e) { try { int rowNo = 1; List <SalesMasterVM> modelList = new List <SalesMasterVM>(); List <tbl_SalesMaster> data = new List <tbl_SalesMaster>(); 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_SalesMaster.Where(x => x.date >= fromdate && x.date <= todate).OrderByDescending(x => x.sId).ToList(); } else { data = _entities.tbl_SalesMaster.Where(x => x.date >= fromdate && x.date <= todate && x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text.Trim().ToString())).OrderByDescending(x => x.sId).ToList(); } foreach (var item in data) { SalesMasterVM model = new SalesMasterVM(); model.rowNo = rowNo; model.sId = item.sId; model.billNo = item.billNo; 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.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++; } dgSalesDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } } catch (Exception x) { } }
private void addSalesMaster() { _entities = new MicroAccountsEntities1(); var data = _entities.tbl_SalesMaster.Where(x => x.sId == passedId).ToList(); List <SalesMasterVM> listVm = new List <SalesMasterVM>(); List <LedgerDetailsVM> LedgerlistVm = new List <LedgerDetailsVM>(); foreach (var item in data) { SalesMasterVM vm = new SalesMasterVM(); vm.date = Convert.ToDateTime(item.date).Date.ToString("dd-MM-yyyy"); vm.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName.Trim(); vm.ledgerId = item.ledgerId; vm.sId = item.sId; vm.billNo = item.billNo; vm.remarks = item.remarks; vm.totalMaking = item.totalMaking; vm.totalKarat = item.totalKarat; vm.totalWeight = item.totalWeight; vm.unit = item.unit; AmtFormatting amtFormat = new AmtFormatting(); 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); }
void dataGridBind() { try { int rowNo = 1; dgSalesDetails.AutoGenerateColumns = false; _entities = new MicroAccountsEntities1(); List <SalesMasterVM> modelList = new List <SalesMasterVM>(); var data = _entities.tbl_SalesMaster.OrderByDescending(x => x.sId); foreach (var item in data) { SalesMasterVM model = new SalesMasterVM(); model.rowNo = rowNo; model.sId = item.sId; model.billNo = item.billNo; model.ledgerName = _entities.tbl_AccLedger.Where(x => x.Id == item.ledgerId).FirstOrDefault().ledgerName; model.date = 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); rowNo++; } dgSalesDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } catch (Exception x) { MessageBox.Show(x.ToString()); } }
private void txtLedgerName_KeyUp(object sender, KeyEventArgs e) { try { int rowNo = 1; dgSalesDetails.AutoGenerateColumns = false; _entities = new MicroAccountsEntities1(); List <SalesMasterVM> modelList = new List <SalesMasterVM>(); var data = _entities.tbl_SalesMaster.Where(x => x.billNo.Contains(txtSearch.Text) || x.tbl_AccLedger.ledgerName.Contains(txtSearch.Text)).OrderByDescending(x => x.sId); foreach (var item in data) { SalesMasterVM model = new SalesMasterVM(); model.rowNo = rowNo; model.sId = item.sId; model.billNo = item.billNo; 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.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++; } dgSalesDetails.DataSource = modelList; lblTotalRows.Text = modelList.Count.ToString(); } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
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 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) { } }