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 datagridBind() { try { dgReceivableAmt.AutoGenerateColumns = false; int rowNo = 1; _entities = new MicroAccountsEntities1(); var data = _entities.tbl_AccLedger.Where(x => x.tbl_AccGroup.groupName == "Sundry Creditors").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 == "Cr") { 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 dgPaymentDetails_DoubleClick(object sender, EventArgs e) { if (dgPaymentDetails.CurrentRow.Index != -1) { _entities = new MicroAccountsEntities1(); var gID = Convert.ToInt32(dgPaymentDetails.CurrentRow.Cells[0].Value); var data = _entities.tbl_Entry.Where(x => x.voucherRefNo == gID).FirstOrDefault(); // txtGroupName.Text = lblhiddenGName.Text = data.groupName; cmbLedgerDR.SelectedValue = data.drId; cmbLedgerCR.SelectedValue = data.crId; updateVouId = data.voucherRefNo; txtAmt.Text = amtFormat.comma(data.amt).ToString(); txtRemark.Text = data.remarks; btnCreate.Text = "Update"; } }
private void cmbKarat_SelectedIndexChanged(object sender, EventArgs e) { try { _entities = new MicroAccountsEntities1(); var dateToday = DateTime.Now.Date; if (cmbKarat.SelectedIndex == 0) { var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().eighteenC; amtFormat = new AmtFormatting(); txtKRate.Text = amtFormat.comma(rate); } else if (cmbKarat.SelectedIndex == 1) { var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().twentyTwoC; amtFormat = new AmtFormatting(); txtKRate.Text = amtFormat.comma(rate); } else if (cmbKarat.SelectedIndex == 2) { var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().twentyThreeC; amtFormat = new AmtFormatting(); txtKRate.Text = amtFormat.comma(rate); } else if (cmbKarat.SelectedIndex == 3) { var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().fineGold; amtFormat = new AmtFormatting(); txtKRate.Text = amtFormat.comma(rate); } else if (cmbKarat.SelectedIndex == 4) { var rate = _entities.DailyRates.Where(x => x.date == dateToday).FirstOrDefault().hallmark; amtFormat = new AmtFormatting(); txtKRate.Text = amtFormat.comma(rate); } } catch (Exception x) { } }
private void DashBoard_Load(object sender, EventArgs e) { try { dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "dd-MM-yyyy"; dateTimePicker2.Format = DateTimePickerFormat.Custom; dateTimePicker2.CustomFormat = "dd-MM-yyyy"; dataGridBind(); _entities = new MicroAccountsEntities1(); DateTime todayDate = DateTime.Today.Date; var data = _entities.DailyRates.Where(x => x.date == todayDate).FirstOrDefault(); if (data == null) { btnEnterRates.Enabled = true; } else { btnEnterRates.Enabled = false; } lblFine.Text = amtFormat.comma(data.fineGold).ToString(); lbl22C.Text = amtFormat.comma(data.twentyTwoC).ToString(); lbl23C.Text = amtFormat.comma(data.twentyThreeC).ToString(); lblhallMarkBuyBack.Text = amtFormat.comma(data.hallmarkBuyBack).ToString(); lblHallMark.Text = amtFormat.comma(data.hallmark).ToString(); lblSilver.Text = amtFormat.comma(data.silver).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 PaymentReceiptBillReference_Load(object sender, EventArgs e) { try { // if (passedVoucherType == 1) { //payment mate _entities = new MicroAccountsEntities1(); var isDataPresent = _entities.tbl_EntryDetails.Where(x => x.voucherRefNo == this.passedVoucherNo).FirstOrDefault(); if (isDataPresent == null) { cmbBillRef.SelectedIndex = -1; cmbBInd(idPassedToCmbArray); } else { AmtFormatting amtFormat = new AmtFormatting(); comestoUpdate = true; cmbRefType.SelectedIndex = 1; idPassedToCmbArray = new List <long?>(); idPassedToCmbArray.Add(0); cmbBInd(idPassedToCmbArray); //calling combobox method btnCreate.Text = "Update"; _entities = new MicroAccountsEntities1(); var data = _entities.tbl_EntryDetails.Where(x => x.voucherRefNo == this.passedVoucherNo).ToList(); int id = 1; idPassedToCmbArray = new List <long?>(); foreach (var item in data) { idPassedToCmbArray.Add(item.purchaseSalesIds); // paymentDetailsTotalAmt += item.amtPaid; var billNo = _entities.tbl_PurchaseMaster.Where(x => x.pId == item.purchaseSalesIds).FirstOrDefault(); dgBillRef.Rows.Add( item.purchaseSalesIds, "#", billNo.refNo, billNo.date, amtFormat.comma(item.amtPaid), item.pDetailsId ); id = id + 1; } datagridId = data.Count; lblRows.Text = datagridId.ToString() + " Rows"; } } //else { //receipt mate } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void txtRate_Leave(object sender, EventArgs e) { try { btnCreate.Enabled = true; lblBtnError.Visible = false; if (txtItemCode.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtItemCode, "Enter item Code."); txtItemCode.Focus(); panel3.Visible = true; lblError.Text = "Enter item code."; } else if (txtQty.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtQty, "Enter qty."); txtQty.Focus(); panel3.Visible = true; lblError.Text = "Enter qty."; } else if (txtWeight.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtWeight, "Enter item weight."); txtWeight.Focus(); panel3.Visible = true; lblError.Text = "Enter item weight."; } //else if (cmbKarat.SelectedIndex == 0 || cmbKarat.Text == string.Empty) //{ // errorProvider1.Clear(); // errorProvider1.SetError(cmbKarat, "Enter karat."); // cmbKarat.Focus(); // panel3.Visible = true; // lblError.Text = "Enter karat."; //} else if (txtKRate.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtKRate, "Enter karat Rate."); txtKRate.Focus(); panel3.Visible = true; lblError.Text = "Enter karat Rate."; } else if (txtMaking.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtMaking, "Enter making."); txtMaking.Focus(); panel3.Visible = true; lblError.Text = "Enter making."; } else if (txtRate.Text == string.Empty) { errorProvider1.Clear(); errorProvider1.SetError(txtRate, "Enter rate."); txtRate.Focus(); panel3.Visible = true; lblError.Text = "Enter rate."; } else { errorProvider1.Clear(); if (txtItemCode.Text != string.Empty && txtQty.Text != string.Empty && txtWeight.Text != string.Empty && cmbKarat.Text != string.Empty && txtMaking.Text != string.Empty && txtRate.Text != string.Empty) { if (datagridEdit) { // MessageBox.Show( dgPurchaseItem.Rows[datagridId].Cells); dgSalesItem.Rows[datagridId].Cells[1].Value = txtItemCode.Text; dgSalesItem.Rows[datagridId].Cells[2].Value = txtQty.Text; dgSalesItem.Rows[datagridId].Cells[3].Value = txtWeight.Text; dgSalesItem.Rows[datagridId].Cells[4].Value = cmbUnit.Text; if (cmbKarat.SelectedIndex == 0) { dgSalesItem.Rows[datagridId].Cells[5].Value = 0; } else { dgSalesItem.Rows[datagridId].Cells[5].Value = cmbKarat.Text; } dgSalesItem.Rows[datagridId].Cells[6].Value = txtKRate.Text; dgSalesItem.Rows[datagridId].Cells[7].Value = txtMaking.Text; dgSalesItem.Rows[datagridId].Cells[8].Value = txtRate.Text; this.datagridEdit = false; var dgWeight = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[3].Value); var dgMelting = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[5].Value); var dgmaking = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[7].Value); var dgrate = Convert.ToDecimal(dgSalesItem.Rows[datagridId].Cells[8].Value); } else { var kartType = ""; if (cmbKarat.SelectedIndex == 0) { kartType = "0"; } else { kartType = cmbKarat.Text; } dgSalesItem.Rows.Add(id.ToString(), txtItemCode.Text, txtQty.Text, txtWeight.Text, cmbUnit.Text, kartType, txtKRate.Text, txtMaking.Text, txtRate.Text); id = id + 1; } ttlMaking += Convert.ToDecimal(txtMaking.Text); //ttlKarat += Convert.ToDecimal(cmbKarat.Text); if (cmbUnit.Text == "Kg") { decimal grams = Convert.ToDecimal(txtWeight.Text) * 1000; ttlWeight = ttlWeight + grams; } else { ttlWeight = ttlWeight + Convert.ToDecimal(txtWeight.Text); } ttlRate = ttlRate + Convert.ToDecimal(txtRate.Text); } txtTotalMaking.Text = ttlMaking.ToString(); //txtTotalKarat.Text = ttlKarat.ToString(); double kg = Convert.ToDouble(ttlWeight) / 1000; if (kg > 0) { txtTotalWeight.Text = kg.ToString(); lblUnit.Text = "Kg"; } else { txtTotalWeight.Text = ttlWeight.ToString(); lblUnit.Text = "Gram"; } txtTotalRate.Text = amtFormat.comma(ttlRate).ToString(); clearDetails(); txtItemCode.Focus(); errorProvider1.Clear(); txtAmtInWords.Text = ""; ConvertNoToWord convertToWord = new ConvertNoToWord(); var rats = Convert.ToDecimal(txtTotalRate.Text.Trim().ToString()); txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(rats)).ToLower(); } } catch (Exception x) { MessageBox.Show("Something went wrong. Contact your system administrator"); } }
private void showAvailableData() { clear(); clearDetails(); btnCreate.Text = "Update"; _entities = new MicroAccountsEntities1(); var data = _entities.tbl_PurchaseMaster.Where(x => x.pId == passedPid).FirstOrDefault(); txtRefNo.Text = data.refNo; dateTimePicker1.Text = data.date.ToString(); txtLedgerName.Text = _entities.tbl_AccLedger.Where(x => x.Id == data.ledgerId).FirstOrDefault().ledgerName; txtTotalMelting.Text = data.totalMelting.ToString(); txtTotalMaking.Text = data.totalMaking.ToString(); txtTotalAmt.Text = amtFormat.comma(data.totalAmt).ToString(); txtTotalWeight.Text = data.totalWeight.ToString(); txtTotalFine.Text = data.totalFine.ToString(); txtTotalPurchMelting.Text = data.totalPurchaseMelting.ToString(); ttlWeight = Convert.ToDecimal(txtTotalWeight.Text) * 1000; ttlMelting = Convert.ToDecimal(txtTotalMelting.Text); ttlRate = Convert.ToDecimal(txtTotalAmt.Text); ttlMaking = Convert.ToDecimal(txtTotalMaking.Text); ttlFine = Convert.ToDecimal(txtTotalFine.Text); ttlPurchaseMelting = Convert.ToDecimal(txtTotalPurchMelting.Text); txtAmtInWords.Text = ""; ConvertNoToWord convertToWord = new ConvertNoToWord(); //int totalRate = Convert.ToInt32(txtTotalRate.Text); txtAmtInWords.Text = convertToWord.ConvertNumbertoWords(Convert.ToInt32(data.totalAmt)).ToLower(); _entities = new MicroAccountsEntities1(); var purchaseDetailsData = _entities.tbl_PurchaseDetail.Where(x => x.purchaseID == passedPid).ToList(); id = 1; foreach (var item in purchaseDetailsData) { var itemCode = _entities.tbl_ItemMaster.Where(x => x.id == item.productID).FirstOrDefault().itemCode; dgPurchaseItem.Rows.Add( id.ToString(), itemCode, item.qty, item.weight, item.unit, item.karat, item.kRate, item.melting, item.purchaseMelting, item.fine, item.making, item.rate); id = id + 1; } var checkLedgername = _entities.tbl_AccLedger.Where(x => x.ledgerName == txtLedgerName.Text.Trim().ToString()).FirstOrDefault(); decimal drLedgerId = Convert.ToDecimal(checkLedgername.Id); CrDrDifference crdrDiff = new CrDrDifference(); string valueAmt = crdrDiff.DifferenceCrDr(Convert.ToInt32(drLedgerId), 0); lblBalance.Text = valueAmt; }