public void InsertInvoice(ASCAmount ascamount, string UserName, string AscId, string BranchId, string regionid, int Month, int Year, int iscarryforward)
{ // needs to replace and calls once time
InvoiceAmount objinvoice = new InvoiceAmount();
InvoiceAmount invoice = objinvoice.BindInvoiveAmount(1); // change the value 1 to other if amount will change in future
//Month = DateTime.Now.Month - 1;
//if (Month == 0)
//{
// Month = 12;
//}
try
{
SqlParameter[] sqlParamI =
{
new SqlParameter("@ascid", AscId),
new SqlParameter("@ASCUserID", UserName),
new SqlParameter("@regionid", regionid),
new SqlParameter("@BranchId", BranchId),
new SqlParameter("@Month", Month),
new SqlParameter("@Year", Year),
//new SqlParameter("@UserName",UserName), sry amount replace as total complaint
new SqlParameter("@Localwhc18Repr", ascamount.txtLWH18),
new SqlParameter("@LocalWHC24Repr", ascamount.txtLWH24),
new SqlParameter("@LocalWHC48Repr", ascamount.txtLWH72),
new SqlParameter("@LocalWHC72Repr", ascamount.txtLWH120),
new SqlParameter("@LocalWHC120Repr", ascamount.txtLWH72120),
new SqlParameter("@LocalWHC121Repr", ascamount.txtLWHgreater120),
new SqlParameter("@LocalWOHC18Repr", ascamount.txtLWOH18),
new SqlParameter("@LocalWOHC24Repr", ascamount.txtLWOH24),
new SqlParameter("@LocalWOHC48Repr", ascamount.txtLWOH72),
new SqlParameter("@LocalWOHC72Repr", ascamount.txtLWOH120),
new SqlParameter("@LocalWOHC120Repr", ascamount.txtLWOH72120),
new SqlParameter("@LocalWOHC121Repr", ascamount.txtLWOHgreater120),
//
new SqlParameter("@OUTWHC18Repr", ascamount.txtOWH18),
new SqlParameter("@OUTWHC24Repr", ascamount.txtOWH24),
new SqlParameter("@OUTWHC48Repr", ascamount.txtOWH72),
new SqlParameter("@OUTWHC72Repr", ascamount.txtOWH120),
new SqlParameter("@OUTWHC120Repr", ascamount.txtOWH72120),
new SqlParameter("@OUTWHC121Repr", ascamount.txtOWHgreater120),
new SqlParameter("@OUTWOHC18Repr", ascamount.txtOWOH18),
new SqlParameter("@OUTWOHC24Repr", ascamount.txtOWOH24),
new SqlParameter("@OUTWOHC48Repr", ascamount.txtOWOH72),
new SqlParameter("@OUTWOHC72Repr", ascamount.txtOWOH120),
new SqlParameter("@OUTWOHC120Repr", ascamount.txtOWOH72120),
new SqlParameter("@OUTWOHC121Repr", ascamount.txtOWOHgreater120),
/////
// repair
new SqlParameter("@LocalWHC18Rep", ascamount.lblLWHURep18),
new SqlParameter("@LocalWHC24Rep", ascamount.lblLWHURep24),
new SqlParameter("@LocalWHC48Rep", ascamount.lblLWHURep72),
new SqlParameter("@LocalWHC72Rep", ascamount.lblLWHURep120),
new SqlParameter("@LocalWHC120Rep", ascamount.lblLWHURep72120),
new SqlParameter("@LocalWHC121Rep", ascamount.lblLWHURepgreater120),
new SqlParameter("@LocalWOHC18Rep", ascamount.lblLWOHURep18),
new SqlParameter("@LocalWOHC24Rep", ascamount.lblLWOHURep24),
new SqlParameter("@LocalWOHC48Rep", ascamount.lblLWOHURep72),
new SqlParameter("@LocalWOHC72Rep", ascamount.lblLWOHURep120),
new SqlParameter("@LocalWOHC120Rep", ascamount.lblLWOHURep72120),
new SqlParameter("@LocalWOHC121Rep", ascamount.lblLWOHURepgreater120),
new SqlParameter("@OUTWHC18Rep", ascamount.lblOWHURep18),
new SqlParameter("@OUTWHC24Rep", ascamount.lblOWHURep24),
new SqlParameter("@OUTWHC48Rep", ascamount.lblOWHURep72),
new SqlParameter("@OUTWHC72Rep", ascamount.lblOWHURep120),
new SqlParameter("@OUTWHC120Rep", ascamount.lblOWHURep72120),
new SqlParameter("@OUTWHC121Rep", ascamount.lblOWHURepgreater120),
new SqlParameter("@OUTWOHC18Rep", ascamount.lblOWOHURep18),
new SqlParameter("@OUTWOHC24Rep", ascamount.lblOWOHURep24),
new SqlParameter("@OUTWOHC48Rep", ascamount.lblOWOHURep72),
new SqlParameter("@OUTWOHC72Rep", ascamount.lblOWOHURep120),
new SqlParameter("@OUTWOHC120Rep", ascamount.lblOWOHURep72120),
new SqlParameter("@OUTWOHC121Rep", ascamount.lblOWOHURepgreater120),
//
new SqlParameter("@RepairandReplacementLocalInstutional", ascamount.RepairandReplacementLocalInstutional),
new SqlParameter("@RepairandReplacementOutstationInstitutional", ascamount.RepairandReplacementOutstationInstitutional),
new SqlParameter("@LocalLogisticsCharges", "0"),
new SqlParameter("@OutstationLogisticsCharges", "0"),
// amount to be paid
new SqlParameter("@LocalWHC18ReprAmt", invoice.lblLWHU18),
new SqlParameter("@LocalWHC24ReprAmt", invoice.lblLWHU24),
new SqlParameter("@LocalWHC48ReprAmt", invoice.lblLWHU72),
new SqlParameter("@LocalWHC72ReprAmt", invoice.lblLWHU120),
new SqlParameter("@LocalWHC120ReprAmt", invoice.lblLWHU72120),
new SqlParameter("@LocalWHC121ReprAmt", invoice.lblLWHUgreater120),
new SqlParameter("@LocalWOHC18ReprAmt", invoice.lblLWOHU18),
new SqlParameter("@LocalWOHC24ReprAmt", invoice.lblLWOHU24),
new SqlParameter("@LocalWOHC48ReprAmt", invoice.lblLWOHU72),
new SqlParameter("@LocalWOHC72ReprAmt", invoice.lblLWOHU120),
new SqlParameter("@LocalWOHC120ReprAmt", invoice.lblLWOHU72120),
new SqlParameter("@LocalWOHC121ReprAmt", invoice.lblLWOHUgreater120),
new SqlParameter("@OUTWHC18ReprAmt", invoice.lblOWHU18),
new SqlParameter("@OUTWHC24ReprAmt", invoice.lblOWHU24),
new SqlParameter("@OUTWHC48ReprAmt", invoice.lblOWHU72),
new SqlParameter("@OUTWHC72ReprAmt", invoice.lblOWHU120),
new SqlParameter("@OUTWHC120ReprAmt", invoice.lblOWHU72120),
new SqlParameter("@OUTWHC121ReprAmt", invoice.lblOWHUgreater120),
new SqlParameter("@OUTWOHC18ReprAmt", invoice.lblOWOHU18),
new SqlParameter("@OUTWOHC24ReprAmt", invoice.lblOWOHU24),
new SqlParameter("@OUTWOHC48ReprAmt", invoice.lblOWOHU72),
new SqlParameter("@OUTWOHC72ReprAmt", invoice.lblOWOHU120),
new SqlParameter("@OUTWOHC120ReprAmt", invoice.lblOWOHU72120),
new SqlParameter("@OUTWOHC121ReprAmt", invoice.lblOWOHUgreater120),
// replacement
new SqlParameter("@LocalWHC18RepAmt", invoice.lblLWHARep18),
new SqlParameter("@LocalWHC24RepAmt", invoice.lblLWHARep24),
new SqlParameter("@LocalWHC48RepAmt", invoice.lblLWHARep72),
new SqlParameter("@LocalWHC72RepAmt", invoice.lblLWHARep120),
new SqlParameter("@LocalWHC120RepAmt", invoice.lblLWHARep72120),
new SqlParameter("@LocalWHC121RepAmt", invoice.lblLWHARepgreater120),
new SqlParameter("@LocalWOHC18RepAmt", invoice.lblLWOHARep18),
new SqlParameter("@LocalWOHC24RepAmt", invoice.lblLWOHARep24),
new SqlParameter("@LocalWOHC48RepAmt", invoice.lblLWOHARep72),
new SqlParameter("@LocalWOHC72RepAmt", invoice.lblLWOHARep120),
new SqlParameter("@LocalWOHC120RepAmt", invoice.lblLWOHARep72120),
new SqlParameter("@LocalWOHC121RepAmt", invoice.lblLWOHARepgreater120),
new SqlParameter("@OUTWHC18RepAmt", invoice.lblOWHARep18),
new SqlParameter("@OUTWHC24RepAmt", invoice.lblOWHARep24),
new SqlParameter("@OUTWHC48RepAmt", invoice.lblOWHARep72),
new SqlParameter("@OUTWHC72RepAmt", invoice.lblOWHARep120),
new SqlParameter("@OUTWHC120RepAmt", invoice.lblOWHARep72120),
new SqlParameter("@OUTWHC121RepAmt", invoice.lblOWHARepgreater120),
new SqlParameter("@OUTWOHC18RepAmt", invoice.lblOWOHARep18),
new SqlParameter("@OUTWOHC24RepAmt", invoice.lblOWOHARep24),
new SqlParameter("@OUTWOHC48RepAmt", invoice.lblOWOHARep72),
new SqlParameter("@OUTWOHC72RepAmt", invoice.lblOWOHARep120),
new SqlParameter("@OUTWOHC120RepAmt", invoice.lblOWOHARep72120),
new SqlParameter("@OUTWOHC121RepAmt", invoice.lblOWOHARepgreater120),
//
new SqlParameter("@RepairandReplacementLocalInstutionalAmt", invoice.lblRepLoU),
new SqlParameter("@RepairandReplacementOutstationInstitutionalAmt", invoice.lblRepOoA),
new SqlParameter("@LocalLogisticsChargesAmt", "0"),
new SqlParameter("@OutstationLogisticsChargesAmt", "0"),
new SqlParameter("@Quantity", ascamount.lblQuanityfd),
new SqlParameter("@UnitPrice", ascamount.lblfdUnitPrice),
new SqlParameter("@Amount", ascamount.Amount),
new SqlParameter("@iscarryforward", iscarryforward),
}; //usp_fanpaymentcalulation
int i = objSql.ExecuteNonQuery(CommandType.StoredProcedure, "usp_fanpaymentcalulation", sqlParamI);
}
catch (Exception ex)
{
// also track to save in table
Util.WriteToFile("exception msg " + ex.Message + " Time " + DateTime.Now + " AscId: " + AscId + "BranchId " + BranchId + "regionid " + regionid + "Month " + Month + "Year " + Year);
}
}
protected void calculate(string Username, int month, int year, string RegionId, string BranchId, string AscId, int carryforward)
{
try
{
CommonClass common = new API.CommonClass();
DataSet ds = null; DataSet instutionalds = null; DataSet invoiceDetails = null;
if (carryforward == 0) //current month
{
ds = common.GenenerateInvoiceForFanSC(Username, month, year, "usp_GenenerateInvoiceForFanSC", carryforward);
instutionalds = InstutionalDetails(Username, month, year, "GenerateInvoiceInstitutionalFan", carryforward);
invoiceDetails = common.GetInvoiceDetails(year, month, AscId, BranchId, RegionId, Username, "GenerateInvoiceFan");
}
else if (carryforward == 1) // old month
{
ds = common.GenenerateInvoiceForFanSC(Username, month, year, "usp_GenenerateInvoiceForFanSC", carryforward);
instutionalds = InstutionalDetails(Username, month, year, "GenerateInvoiceInstitutionalFan", carryforward);
}
ASCAmount objASC = new ASCAmount();
if (ds != null && instutionalds != null)
{
int countL = 0, countO = 0;
foreach (DataRow drs in instutionalds.Tables[0].Rows)
{
if (drs["Activity"].ToString().Equals("L"))
{
countL = countL + 1;
}
if (drs["Activity"].ToString().Equals("O"))
{
countO = countO + 1;
}
}
objASC.RepairandReplacementLocalInstutional = countL.ToString();
objASC.RepairandReplacementOutstationInstitutional = countO.ToString();
//complaint count
if (ds.Tables[0].Rows.Count > 0)
{
objASC.txtLWH18 = ds.Tables[0].Rows[0]["<=18 Hours"].ToString();
objASC.txtLWH24 = ds.Tables[0].Rows[0]["18<Hours<=24"].ToString();
objASC.txtLWH72 = ds.Tables[0].Rows[0]["24<Hours<=48"].ToString();
objASC.txtLWH120 = ds.Tables[0].Rows[0]["48<Hours>=72"].ToString();
objASC.txtLWH72120 = ds.Tables[0].Rows[0]["72<Hours>=120"].ToString();
objASC.txtLWHgreater120 = ds.Tables[0].Rows[0][">120Hours"].ToString();
//
objASC.txtLWOH18 = ds.Tables[0].Rows[1]["<=18 Hours"].ToString();
objASC.txtLWOH24 = ds.Tables[0].Rows[1]["18<Hours<=24"].ToString();
objASC.txtLWOH72 = ds.Tables[0].Rows[1]["24<Hours<=48"].ToString();
objASC.txtLWOH120 = ds.Tables[0].Rows[1]["48<Hours>=72"].ToString();
objASC.txtLWOH72120 = ds.Tables[0].Rows[1]["72<Hours>=120"].ToString();
objASC.txtLWOHgreater120 = ds.Tables[0].Rows[1][">120Hours"].ToString();
//
objASC.txtOWH18 = ds.Tables[0].Rows[2]["<=18 Hours"].ToString();
objASC.txtOWH24 = ds.Tables[0].Rows[2]["18<Hours<=24"].ToString();
objASC.txtOWH72 = ds.Tables[0].Rows[2]["24<Hours<=48"].ToString();
objASC.txtOWH120 = ds.Tables[0].Rows[2]["48<Hours>=72"].ToString();
objASC.txtOWH72120 = ds.Tables[0].Rows[2]["72<Hours>=120"].ToString();
objASC.txtOWHgreater120 = ds.Tables[0].Rows[2][">120Hours"].ToString();
//
objASC.txtOWOH18 = ds.Tables[0].Rows[3]["<=18 Hours"].ToString();
objASC.txtOWOH24 = ds.Tables[0].Rows[3]["18<Hours<=24"].ToString();
objASC.txtOWOH72 = ds.Tables[0].Rows[3]["24<Hours<=48"].ToString();
objASC.txtOWOH120 = ds.Tables[0].Rows[3]["48<Hours>=72"].ToString();
objASC.txtOWOH72120 = ds.Tables[0].Rows[3]["72<Hours>=120"].ToString();
objASC.txtOWOHgreater120 = ds.Tables[0].Rows[3][">120Hours"].ToString();
}
///////Replacement//////////////////////////////// complaint count
if (ds.Tables[1].Rows.Count > 0)
{
objASC.lblLWHURep18 = ds.Tables[1].Rows[0]["<=18 Hours"].ToString();
objASC.lblLWHURep24 = ds.Tables[1].Rows[0]["18<Hours<=24"].ToString();
objASC.lblLWHURep72 = ds.Tables[1].Rows[0]["24<Hours<=48"].ToString();
objASC.lblLWHURep120 = ds.Tables[1].Rows[0]["48<Hours>=72"].ToString();
objASC.lblLWHURep72120 = ds.Tables[1].Rows[0]["72<Hours>=120"].ToString();
objASC.lblLWHURepgreater120 = ds.Tables[1].Rows[0][">120Hours"].ToString();
//
objASC.lblLWOHURep18 = ds.Tables[1].Rows[1]["<=18 Hours"].ToString();
objASC.lblLWOHURep24 = ds.Tables[1].Rows[1]["18<Hours<=24"].ToString();
objASC.lblLWOHURep72 = ds.Tables[1].Rows[1]["24<Hours<=48"].ToString();
objASC.lblLWOHURep120 = ds.Tables[1].Rows[1]["48<Hours>=72"].ToString();
objASC.lblLWOHURep72120 = ds.Tables[1].Rows[1]["72<Hours>=120"].ToString();
objASC.lblLWOHURepgreater120 = ds.Tables[1].Rows[1][">120Hours"].ToString();
//
objASC.lblOWHURep18 = ds.Tables[1].Rows[2]["<=18 Hours"].ToString();
objASC.lblOWHURep24 = ds.Tables[1].Rows[2]["18<Hours<=24"].ToString();
objASC.lblOWHURep72 = ds.Tables[1].Rows[2]["24<Hours<=48"].ToString();
objASC.lblOWHURep120 = ds.Tables[1].Rows[2]["48<Hours>=72"].ToString();
objASC.lblOWHURep72120 = ds.Tables[1].Rows[2]["72<Hours>=120"].ToString();
objASC.lblOWHURepgreater120 = ds.Tables[1].Rows[2][">120Hours"].ToString();
//
objASC.lblOWOHURep18 = ds.Tables[1].Rows[3]["<=18 Hours"].ToString();
objASC.lblOWOHURep24 = ds.Tables[1].Rows[3]["18<Hours<=24"].ToString();
objASC.lblOWOHURep72 = ds.Tables[1].Rows[3]["24<Hours<=48"].ToString();
objASC.lblOWOHURep120 = ds.Tables[1].Rows[3]["48<Hours>=72"].ToString();
objASC.lblOWOHURep72120 = ds.Tables[1].Rows[3]["72<Hours>=120"].ToString();
objASC.lblOWOHURepgreater120 = ds.Tables[1].Rows[3][">120Hours"].ToString();
}
if (invoiceDetails != null && carryforward == 0)
{
foreach (DataRow dr in invoiceDetails.Tables[0].Rows)
{
if (dr["ActivityParameter_SNo"].ToString().Equals("0"))
{
objASC.lblQuanityfd = dr["Quantity"].ToString();
objASC.lblfdUnitPrice = dr["UnitPrice"].ToString();
objASC.Amount = Convert.ToString(dr["Amount"].ToString());
}
}
}
else
{
objASC.lblQuanityfd = "0";
objASC.lblfdUnitPrice = "0.00";
objASC.Amount = "0.00";
}
if (common == null)
{
common = new CommonClass();
}
common.InsertInvoice(objASC, Username, AscId, BranchId, RegionId, month, year, carryforward);
}
}
catch (Exception ex)
{
Util.WriteToFile("function calculate " + ex.Message);
}
}