public ExtraHeaveyBill GetExtraHeaveyBill(string token, string code) { if (token != secKey) { return(null); } ExtraHeaveyBill _ExtraHeaveyBill = new ExtraHeaveyBill(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetExtraHeaveyBill(code, DateTime.Now.AddMonths(-1)); StringBuilder filterExp = new StringBuilder(); if (dt != null && dt.Rows.Count > 0) { DataView dv = dt.DefaultView; filterExp.AppendFormat("LEN(CODE) = {0} ", (code.Length).ToString()); string cd = utility.GetColumnValue(dt.Rows[0], "CODE"); string name = utility.GetColumnValue(dt.Rows[0], "NAME"); string billMonth = utility.GetColumnValue(dt.Rows[0], "BillingMonth"); _ExtraHeaveyBill = new ExtraHeaveyBill(cd, name, billMonth, dt); } return(_ExtraHeaveyBill); }
public ExtraHeaveyBillRegion GetExtraHeaveyBillRegion(string token, string code) { if (token != secKey) { return(null); } ExtraHeaveyBillRegion _ExtraHeaveyBillRegion = new ExtraHeaveyBillRegion(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetExtraHeaveyBillRegion(code, DateTime.Now.AddMonths(-1)); if (dt != null) { DataView dv = dt.DefaultView; dv.Sort = "CODE DESC"; DataTable dt1 = dv.ToTable(); if (dt1 != null) { string billMonth = utility.GetColumnValue(dt1.Rows[0], "BillingMonth"); _ExtraHeaveyBillRegion = new ExtraHeaveyBillRegion(billMonth, dt1); } } return(_ExtraHeaveyBillRegion); }
public DefaulterSummary GetDefaulterSummaryAmnt(string token, string code, string type, string status, string tariff) { if (token != secKey) { return(null); } DefaulterSummary _DefaulterSummary = new DefaulterSummary(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetDefSummAmntSlab(code, DateTime.Now.AddMonths(-1), type, status, tariff); if (dt != null && dt.Rows.Count > 0) { DataView dv = dt.DefaultView; dv.Sort = "CODE DESC"; DataTable dt1 = dv.ToTable(); if (dt1 != null) { string billMonth = utility.GetColumnValue(dt1.Rows[0], "BILLMONTH"); string cd = utility.GetColumnValue(dt1.Rows[0], "CODE"); string name = utility.GetColumnValue(dt1.Rows[0], "NAME"); _DefaulterSummary = new DefaulterSummary(billMonth, cd, name, dt1); } } return(_DefaulterSummary); }
public DefectMeterSumMonWise GetDefectMeterSumMonWise(string token, string code) { if (token != secKey) { return(null); } DefectMeterSumMonWise _DefectMeterSumMonWise = new DefectMeterSumMonWise(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetDefectMeterSumMonWise(code, DateTime.Now.AddMonths(-1)); if (dt != null) { DataView dv = dt.DefaultView; dv.Sort = "CODE DESC"; DataTable dt1 = dv.ToTable(); if (dt1 != null) { string billMonth = utility.GetColumnValue(dt1.Rows[0], "BILLMONTH"); string cd = utility.GetColumnValue(dt1.Rows[0], "CODE"); _DefectMeterSumMonWise = new DefectMeterSumMonWise(billMonth, cd, dt1); } } return(_DefectMeterSumMonWise); }
public string GetCollVsCompAssmnt(string token, string code = "1") { string secKey = System.Configuration.ConfigurationManager.AppSettings["SECKEY"].ToString(); string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["CONSTR"].ToString(); DataTable dt; utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); StringBuilder jsonString = new StringBuilder(); jsonString.Append("{"); jsonString.Append(@"""CollVsCompAssmnt"":{"); StringBuilder filterExp = new StringBuilder(); string ret = "error"; if (token != secKey) { return("Ivalid Token."); } try { if (!string.IsNullOrEmpty(code)) { filterExp.AppendFormat("LEN(SDIVCODE) >= {0} and LEN(SDIVCODE) <= {1}", (code.Length).ToString(), (code.Length + 1).ToString()); } dt = objDbuTil.GetCollVsCompAssmnt(code); if (dt != null) { int i = 0; DataView dv = dt.DefaultView; dv.RowFilter = filterExp.ToString(); dv.Sort = "SRT_ORDER2 ASC"; foreach (DataRowView dr in dv) { util.GetCollVsCompAssmntPJSON1(dv.ToTable(), jsonString, dr["SDIVCODE"].ToString()); if (i == dv.ToTable().Rows.Count - 1) { jsonString.Append("}"); } else { jsonString.Append("},"); } i++; } } jsonString.Append("}"); jsonString.Append("}"); ret = jsonString.ToString(); } catch (Exception ex) { ret = ex.ToString(); } return(ret); }
public List <TheftMND> GetTheftFromMND(string token, string refNo) { DataTable dt; utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); StringBuilder filterExp = new StringBuilder(); List <TheftMND> theftData = new List <TheftMND>(); if (token != secKey) { return(null); } dt = objDbuTil.getTheftData(refNo); if (dt != null) { foreach (DataRow dr in dt.Rows) { theftData.Add(new TheftMND(dr["BILL_MNTH"].ToString(), dr["NOTE_NO"].ToString(), dr["ADJ_DT"].ToString(), dr["UNITS"].ToString(), dr["AMOUNT"].ToString(), dr["PAY_AGAINTS_DET"].ToString())); } } return(theftData); }
public CreditAdjustments GetCRAdjustments(string token, string code, string BatchFrom, string BatchTo, char unitFlag) { if (token != secKey) { return(null); } CreditAdjustments _CreditAdjustments = new CreditAdjustments(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetCRAdjustments(code, DateTime.Now.AddMonths(-1), BatchFrom, BatchTo, unitFlag); if (dt != null) { DataView dv = dt.DefaultView; dv.Sort = "CODE DESC"; DataTable dt1 = dv.ToTable(); if (dt1 != null) { string billMonth = utility.GetColumnValue(dt1.Rows[0], "BILLMONTH"); string cd = utility.GetColumnValue(dt1.Rows[0], "CODE"); string name = utility.GetColumnValue(dt1.Rows[0], "NAME"); _CreditAdjustments = new CreditAdjustments(billMonth, cd, name, dt1); } } return(_CreditAdjustments); }
public List <MonLosses> GetPrgsLosses(string token, string code) { DataTable dt; utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); List <MonLosses> prgsLosseses = new List <MonLosses>(); StringBuilder filterExp = new StringBuilder(); if (token != secKey) { return(null); } if (!string.IsNullOrEmpty(code)) { filterExp.AppendFormat("LEN(SDIV) >= {0} and LEN(SDIV) <= {1}", (code.Length).ToString(), (code.Length + 1).ToString()); } dt = objDbuTil.getPrgsLosses(code, DateTime.Now.AddMonths(-1)); if (dt != null) { //int i = 0; DataView dv = dt.DefaultView; dv.RowFilter = filterExp.ToString(); dv.Sort = "SRT_ORDER2 ASC"; foreach (DataRowView dr in dv) { prgsLosseses.Add(new MonLosses(dr)); } } return(prgsLosseses); }
public DefectiveDetails GetDefectiveDetails(string token, string code, string age, string phase, string trf) { if (token != secKey) { return(null); } DefectiveDetails _DefectiveDetails = new DefectiveDetails(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetDefectiveMeterDetails(code, DateTime.Now.AddMonths(-1), age, phase, trf); if (dt != null && dt.Rows.Count > 0) { DataView dv = dt.DefaultView; dv.Sort = "CODE DESC"; DataTable dt1 = dv.ToTable(); if (dt1 != null) { string billMonth = utility.GetColumnValue(dt1.Rows[0], "BILL_MONTH"); string cd = utility.GetColumnValue(dt1.Rows[0], "CODE"); string name = utility.GetColumnValue(dt1.Rows[0], "NAME"); _DefectiveDetails = new DefectiveDetails(billMonth, cd, name, dt1); } } return(_DefectiveDetails); }
public List <CollectMonBilling> GetCollVsBilling(string token, string code) { DataTable dt; utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); List <CollectMonBilling> collVsBilling = new List <CollectMonBilling>(); StringBuilder filterExp = new StringBuilder(); if (token != secKey) { return(null); } if (!string.IsNullOrEmpty(code)) { filterExp.AppendFormat("LEN(SDIVCODE) >= {0} and LEN(SDIVCODE) <= {1}", (code.Length).ToString(), (code.Length + 1).ToString()); } dt = objDbuTil.GetCollVsBilling(code); if (dt != null) { //int i = 0; DataView dv = dt.DefaultView; dv.RowFilter = filterExp.ToString(); dv.Sort = "SRT_ORDER2 ASC"; foreach (DataRowView dr in dv) { collVsBilling.Add(new CollectMonBilling(dr)); } } return(collVsBilling); }
public BillStatsContainer GetBillingStatsBatchWise(string token, string code) { DataTable dtD, dtB; utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); StringBuilder filterExp = new StringBuilder(); if (token != secKey) { return(null); } if (!string.IsNullOrEmpty(code)) { filterExp.AppendFormat("LEN(CODE) >= {0} and LEN(CODE) <= {1}", (code.Length).ToString(), (code.Length + 1).ToString()); } dtD = objDbuTil.getBillingStatsDaily(code, DateTime.Now.AddMonths(-1)); dtB = objDbuTil.getBillingStatsBatchWise(code, DateTime.Now.AddMonths(-1)); if (dtD != null) { DataView dvD = dtD.DefaultView; dvD.RowFilter = filterExp.ToString(); dvD.Sort = "SRT_ORDER2 ASC"; DataView dvB = dtB.DefaultView; dvB.RowFilter = filterExp.ToString(); dvB.Sort = "SRT_ORDER2 ASC"; BillStatsContainer billStContainer = new BillStatsContainer(code, dvD.ToTable(), dvB.ToTable()); return(billStContainer); //foreach (DataRowView dr in dv) //{ // string cd = utility.GetColumnValue(dr, "CODE"); // string name = utility.GetColumnValue(dr, "NAME"); // string month = utility.GetColumnValue(dr, "MONTH"); // bStats.Add(new BillingStats(month,cd,name,dv.ToTable())); //} } return(null); }
public Bill GetBill(string kwh, string trf) { DataTable dt; utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); Bill bObj; DateTime firstDayOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); dt = objDbuTil.getBillData("1", kwh, firstDayOfMonth, lastDayOfMonth, trf); if (dt != null && dt.Rows.Count > 0) { return(new Bill(dt.Rows[0]["ENRCHRG"].ToString(), dt.Rows[0]["TR_SUR"].ToString(), "0", "0", "0", "0", "0", "0", "0", dt.Rows[0]["BILLSLABS"].ToString())); } return(null); }
public List <AssmntBatchWiseObject> GetAssesmentBatchWise(string token, string code) { if (token != secKey) { return(null); } utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.getAssesmentBatchWise(code, DateTime.Now.AddMonths(-1)); StringBuilder filterExp = new StringBuilder(); List <AssmntBatchWiseObject> coll = new List <AssmntBatchWiseObject>(); if (dt != null) { DataView dv = dt.DefaultView; if (!string.IsNullOrEmpty(code)) { filterExp.AppendFormat("LEN(SDIV_CODE) >= {0} and LEN(SDIV_CODE) <= {1}", (code.Length).ToString(), (code.Length + 1).ToString()); } dv.RowFilter = filterExp.ToString(); dv.Sort = "SRT_ORDER2 ASC"; DataView distinctview = new DataView(dt); DataTable distinctValues = distinctview.ToTable(true, "SDIV_CODE", "SDIV_NAME", "MONTH"); foreach (DataRow dr in distinctValues.Rows) { string cd = utility.GetColumnValue(dr, "SDIV_CODE"); string name = utility.GetColumnValue(dr, "SDIV_NAME"); string month = utility.GetFormatedDate(utility.GetColumnValue(dr, "MONTH")); dv.RowFilter = string.Format("SDIV_CODE = '{0}'", cd); DataTable dt1 = dv.ToTable(); coll.Add(new AssmntBatchWiseObject(cd, name, month, dt1)); } } return(coll); }
public List <CashCollection> GetCashCollSummary(string token, string code) { if (token != secKey) { return(null); } List <CashCollection> coll = new List <CashCollection>(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetCashCollSummary(code, DateTime.Now.AddMonths(-1)); StringBuilder filterExp = new StringBuilder(); if (dt != null) { DataView dv = dt.DefaultView; if (!string.IsNullOrEmpty(code)) { filterExp.AppendFormat("LEN(CODE) >= {0} and LEN(CODE) <= {1}", (code.Length).ToString(), (code.Length + 1).ToString()); } dv.RowFilter = filterExp.ToString(); dv.Sort = "SRT_ORDER2 ASC"; DataView distinctview = new DataView(dt); DataTable distinctValues = distinctview.ToTable(true, "CODE", "NAME"); foreach (DataRow dr in distinctValues.Rows) { string cd = utility.GetColumnValue(dr, "CODE"); string name = utility.GetColumnValue(dr, "NAME"); dv.RowFilter = string.Format("CODE = '{0}'", cd); DataTable dt1 = dv.ToTable(); coll.Add(new CashCollection(cd, name, dt1)); } } return(coll); }
public static string GetBillingStatus(string token) { string ret = "Error"; if (token != secKey) { return("Ivalid Token."); } try { DB_Utility objDBUTil = new DB_Utility(conStr); DataTable dt = objDBUTil.getBillingStatus(); utility util = new utility(); ret = util.DataTableToJSONWithStringBuilder(dt); } catch (Exception ex) { ret = ex.ToString(); } return(ret); }
public List <FeederLosses> GetFeederLosses(string token) { if (token != secKey) { return(null); } List <FeederLosses> coll = new List <FeederLosses>(); utility util = new utility(); DB_Utility objDbuTil = new DB_Utility(conStr); DataTable dt = objDbuTil.GetFeederLosses(DateTime.Now.AddMonths(-1)); StringBuilder filterExp = new StringBuilder(); if (dt != null) { foreach (DataRow dr in dt.Rows) { coll.Add(new FeederLosses(dr)); } } return(coll); }
public string GetBillStatus(string token) { string secKey = System.Configuration.ConfigurationManager.AppSettings["SECKEY"].ToString(); string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["CONSTR"].ToString(); string ret = "Error"; if (token != secKey) { return("Ivalid Token."); } try { DB_Utility objDBUTil = new DB_Utility(conStr); DataTable dt = objDBUTil.getBillingStatus(); utility util = new utility(); ret = util.DataTableToJSONWithStringBuilder(dt); } catch (Exception ex) { ret = ex.ToString(); } return(ret); }