private void yearly() { dgv_InterestDetail.Rows.Clear(); DataTable dtFiancialYear = _objFinancialYear.getFinancialYear(); try { double sum = 0; int i; int j = 0; int year = Convert.ToInt32(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).Year + Convert.ToDateTime(dtFiancialYear.Rows[0]["endyear"].ToString()).Year); for (i = 0; i < dtFiancialYear.Rows.Count; i++) { string space = " to"; string StartDate = (dtFiancialYear.Rows[i]["startyear"].ToString()); string EndDate = (dtFiancialYear.Rows[i]["endyear"].ToString()); string yera3 = StartDate + space + EndDate; double dtInterstTotal = _objGirviCommon.getInterestTotal(StartDate, EndDate); dgv_InterestDetail.Rows.Add(yera3, dtInterstTotal); } dgv_InterestDetail.Rows.Add("एकुण व्याज", sum.ToString()); dgv_InterestDetail.Rows[dgv_InterestDetail.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Red; dgv_InterestDetail.Rows[dgv_InterestDetail.Rows.Count - 1].DefaultCellStyle.ForeColor = Color.White; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void FillGrid() { dgv_YearsDetail.Rows.Clear(); DataTable dtyear = _objFinancialYear.getFinancialYear(); for (int i = 0; i < dtyear.Rows.Count; i++) { dgv_YearsDetail.Rows.Add(); dgv_YearsDetail.Rows[i].Cells["StartYear"].Value = dtyear.Rows[i]["startyear"].ToString(); dgv_YearsDetail.Rows[i].Cells["EndYear"].Value = dtyear.Rows[i]["endyear"].ToString(); dgv_YearsDetail.Rows[i].Cells["id"].Value = dtyear.Rows[i]["id"].ToString(); if (Convert.ToBoolean(dtyear.Rows[i]["isSelected"].ToString()) == true) { dgv_YearsDetail.Rows[i].Cells["SelectedYear"].Value = true; } else { dgv_YearsDetail.Rows[i].Cells["SelectedYear"].Value = false; } } }
private void FillGrid() { DataTable dtBalanceSheet = _objGirviCommon.getAllGirviData(); DataTable dtFiancialYear = _objFinancialYear.getFinancialYear(); int month = Convert.ToInt32(Convert.ToDateTime(dtFiancialYear.Rows[0]["startyear"].ToString()).Month); }
private void Refresh() { DataTable dt = _a.getallssetting(); // Get crystal report list DirectoryInfo DirInfo = new DirectoryInfo(Environment.CurrentDirectory); foreach (FileInfo fi in DirInfo.GetFiles("*.rpt")) { cmb_SaleBillInterState.Items.Add(fi.Name); cmb_SaleBillOtherState.Items.Add(fi.Name); cmb_estimate.Items.Add(fi.Name); cmb_PurchaseBill.Items.Add(fi.Name); cmb_ServiceInc.Items.Add(fi.Name); } //2 Barcode txt_barcode.Text = dt.Rows[0]["BarcodeCount"].ToString(); //4 Bill Count txt_print.Text = dt.Rows[0]["BillCount"].ToString(); //1 Barcode Check if (dt.Rows[0]["Barcode"].ToString() == "Yes") { rbt_yes1.Checked = true; } else { rbt_No1.Checked = true; } //3 Barcode Type cmb_BarcodeType.Text = dt.Rows[0]["BarcodeType"].ToString(); //Bill Type cmb_BillType.Text = dt.Rows[0]["BillType"].ToString(); //4 maintain cmb_maintain.Text = dt.Rows[0]["Maintenance"].ToString(); //5 Set Crystal Report cmb_SaleBillInterState.Text = _a.GetSaleBillName().Rows[0]["SaleBill"].ToString(); cmb_SaleBillOtherState.Text = _a.GetSaleBillName().Rows[6]["SaleBill"].ToString(); cmb_estimate.Text = _a.GetSaleBillName().Rows[1]["SaleBill"].ToString(); cmb_PurchaseBill.Text = _a.GetSaleBillName().Rows[2]["SaleBill"].ToString(); cmb_ServiceInc.Text = _a.GetSaleBillName().Rows[3]["SaleBill"].ToString(); //6 payment form if (dt.Rows[0]["PaymentForm"].ToString() == "1") { rbt_PaymentYes.Checked = true; } else { rbt_PaymentNo.Checked = true; } //7 Get Financial Year DataTable yr = _f.getFinancialYear(); string start = yr.Rows[0]["startyear"].ToString(); string end = yr.Rows[0]["endyear"].ToString(); dtp_start.Value = Convert.ToDateTime(start); dtp_end.Value = Convert.ToDateTime(end); //8 Estimate Payment Form if (dt.Rows[0]["EstimatePayment"].ToString() == "1") { rbt_EstPayYes.Checked = true; } else { rbt_EstPayNo.Checked = true; } //9 Extra Charges Included cmb_ExtraCharges.Text = dt.Rows[0]["ExtraChargesInc"].ToString(); //10 GST Rate if (dt.Rows[0]["GSTRate"].ToString() == "1") { rbt_GSTInc.Checked = true; } else { rbt_GSTExc.Checked = true; } }