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);
}
