protected void gvLocation_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HiddenField hfLocationID = (HiddenField)e.Row.FindControl("hfLocationID");
GridView gvTRANS = (GridView)e.Row.FindControl("gvTRANS");
List <TRANS> tRANSs = new List <TRANS>();
tRANSs = TRANSManager.GetTRANSByAgnetIDnLocationIDByDateNAmountStatus(status, int.Parse(hfLocationID.Value), int.Parse(ddlAgent.SelectedValue), txtFromDate.Text, txtToDate.Text, int.Parse(txtMoney.Text == "" ? "0" : txtMoney.Text));
decimal sendingAmount = 0;
decimal fees = 0;
decimal discount = 0;
decimal Total = 0;
foreach (TRANS tRANS in tRANSs)
{
sendingAmount += tRANS.TRANSAMOUNT;
fees += tRANS.TRANSFEES;//+ tRANS.TRANSOTHERFEES; because in the sp we have added already
discount += decimal.Parse(tRANS.TRANSPROMOCODE);
Total += tRANS.TRANSTOTALAMOUNT;
if (Session["userType"].ToString() != "Location")
{
tRANS.IsPending = false;
//if (((AGENT)Session["aGENT"]).AGENTID == 4)//if the admin
//{
tRANS.IsEdit = true;
//}
//else
//{
// tRANS.IsEdit = false;
//}
}
else
{
tRANS.IsEdit = false;
}
if (tRANS.TotalAmountWitinLastTenDays >= decimal.Parse(txtAmountForFindingSUS.Text))
{
tRANS.TotalAmountWitinLastTenDaysText = "<b style='color:red;'>" + tRANS.TotalAmountWitinLastTenDays.ToString("0,0.00") + "</b>";
}
else
{
tRANS.TotalAmountWitinLastTenDaysText = "<b style='color:Green;'>" + tRANS.TotalAmountWitinLastTenDays.ToString("0,0.00") + "</b>";
}
}
gvTRANS.DataSource = tRANSs;
gvTRANS.DataBind();
Label lblSubTotalSendingAmount = (Label)e.Row.FindControl("lblSubTotalSendingAmount");
Label lblSubTotalFees = (Label)e.Row.FindControl("lblSubTotalFees");
Label lblSubTotalDiscount = (Label)e.Row.FindControl("lblSubTotalDiscount");
Label lblSubTotalTotalAmount = (Label)e.Row.FindControl("lblSubTotalTotalAmount");
lblSubTotalSendingAmount.Text = string.Format("{0:C}", double.Parse(sendingAmount.ToString()));
lblSubTotalFees.Text = string.Format("{0:C}", double.Parse(fees.ToString()));
lblSubTotalDiscount.Text = string.Format("{0:C}", double.Parse(discount.ToString()));
lblSubTotalTotalAmount.Text = string.Format("{0:C}", double.Parse(Total.ToString()));
lblSubTotalSendingAmountTotal.Text = string.Format("{0}", double.Parse(lblSubTotalSendingAmountTotal.Text) + double.Parse(sendingAmount.ToString()));
lblSubTotalFeesTotal.Text = string.Format("{0}", double.Parse(lblSubTotalFeesTotal.Text) + double.Parse(fees.ToString()));
lblSubTotalDiscountTotal.Text = string.Format("{0}", double.Parse(lblSubTotalDiscountTotal.Text) + double.Parse(discount.ToString()));
lblSubTotalTotalAmountTotal.Text = string.Format("{0}", double.Parse(lblSubTotalTotalAmountTotal.Text) + double.Parse(Total.ToString()));
lblTotalno.Text = (tRANSs.Count + int.Parse(lblTotalno.Text)).ToString();
if (Total > 0)
{
tblTotal.Visible = true;
}
}
}
protected void gvLocation_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HiddenField hfLocationID = (HiddenField)e.Row.FindControl("hfLocationID");
GridView gvTRANS = (GridView)e.Row.FindControl("gvTRANS");
List <TRANS> tRANSs = new List <TRANS>();
tRANSs = TRANSManager.GetTRANSByAgnetIDnLocationIDByDateNAmountStatus(status, int.Parse(hfLocationID.Value), int.Parse(ddlAgent.SelectedValue), txtFromDate.Text, txtToDate.Text, int.Parse(txtMoney.Text == "" ? "0" : txtMoney.Text));
decimal sendingAmount = 0;
decimal fees = 0;
decimal discount = 0;
decimal Total = 0;
foreach (TRANS tRANS in tRANSs)
{
if (hfCustomerIDnSUS.Value != "")
{
if (!hfCustomerIDnSUS.Value.Contains(";" + tRANS.CUSTID + "-"))
{
bool NeedVarification = true;
try{
if (DateTime.Parse(tRANS.USERNAME) > DateTime.Today)
{
NeedVarification = false;
hfCustomerIDnSUS.Value += ";" + tRANS.CUSTID + "-N";
tRANS.IsSUS = false;
tRANS.IsNotSUS = !tRANS.IsSUS;
}
}catch (Exception ex)
{
}
if (NeedVarification)
{
if (varifySUS(tRANS.CUSTFNAME, tRANS.CUSTMNAME, tRANS.CUSTLNAME) == "Y")
{
hfCustomerIDnSUS.Value += ";" + tRANS.CUSTID + "-Y";
tRANS.IsSUS = true;
tRANS.IsNotSUS = !tRANS.IsSUS;
}
else
{
hfCustomerIDnSUS.Value += ";" + tRANS.CUSTID + "-N";
tRANS.IsSUS = false;
tRANS.IsNotSUS = !tRANS.IsSUS;
}
}
}
else
{
foreach (string item in hfCustomerIDnSUS.Value.Split(';'))
{
if (item.Contains("-"))
{
if (item.Split('-')[0] == tRANS.CUSTID.ToString())
{
if (item.Split('-')[1] == "Y")
{
tRANS.IsSUS = true;
tRANS.IsNotSUS = !tRANS.IsSUS;
}
else
{
tRANS.IsSUS = false;
tRANS.IsNotSUS = !tRANS.IsSUS;
}
break;
}
}
}
}
}
else
{
if (varifySUS(tRANS.CUSTFNAME, tRANS.CUSTMNAME, tRANS.CUSTLNAME) == "Y")
{
hfCustomerIDnSUS.Value += ";" + tRANS.CUSTID + "-Y";
tRANS.IsSUS = true;
tRANS.IsNotSUS = !tRANS.IsSUS;
}
else
{
hfCustomerIDnSUS.Value += ";" + tRANS.CUSTID + "-N";
tRANS.IsSUS = false;
tRANS.IsNotSUS = !tRANS.IsSUS;
}
}
}
if (chkLoadSUSCustmer.Checked)
{
for (int i = 0; i < tRANSs.Count; i++)
{
if (hfCustomerIDnSUS.Value != "")
{
if (hfCustomerIDnSUS.Value.Contains(";" + tRANSs[i].CUSTID + "-"))
{
foreach (string item in hfCustomerIDnSUS.Value.Split(';'))
{
if (item.Contains("-"))
{
if (item.Split('-')[0] == tRANSs[i].CUSTID.ToString())
{
if (item.Split('-')[1] == "N")
{
tRANSs.RemoveAt(i);
i--;
}
break;
}
}
}
}
}
}
}
foreach (TRANS tRANS in tRANSs)
{
sendingAmount += tRANS.TRANSAMOUNT;
fees += tRANS.TRANSFEES;//+ tRANS.TRANSOTHERFEES; because in the sp we have added already
discount += decimal.Parse(tRANS.TRANSPROMOCODE);
Total += tRANS.TRANSTOTALAMOUNT;
if (Session["userType"].ToString() != "Location")
{
tRANS.IsPending = false;
//if (((AGENT)Session["aGENT"]).AGENTID == 4)//if the admin
//{
tRANS.IsEdit = true;
//}
//else
//{
// tRANS.IsEdit = false;
//}
}
else
{
tRANS.IsEdit = false;
}
}
//lblCUSTID.Text = hfCustomerIDnSUS.Value;
gvTRANS.DataSource = tRANSs;
gvTRANS.DataBind();
Label lblSubTotalSendingAmount = (Label)e.Row.FindControl("lblSubTotalSendingAmount");
Label lblSubTotalFees = (Label)e.Row.FindControl("lblSubTotalFees");
Label lblSubTotalDiscount = (Label)e.Row.FindControl("lblSubTotalDiscount");
Label lblSubTotalTotalAmount = (Label)e.Row.FindControl("lblSubTotalTotalAmount");
lblSubTotalSendingAmount.Text = string.Format("{0:C}", double.Parse(sendingAmount.ToString()));
lblSubTotalFees.Text = string.Format("{0:C}", double.Parse(fees.ToString()));
lblSubTotalDiscount.Text = string.Format("{0:C}", double.Parse(discount.ToString()));
lblSubTotalTotalAmount.Text = string.Format("{0:C}", double.Parse(Total.ToString()));
lblSubTotalSendingAmountTotal.Text = string.Format("{0}", double.Parse(lblSubTotalSendingAmountTotal.Text) + double.Parse(sendingAmount.ToString()));
lblSubTotalFeesTotal.Text = string.Format("{0}", double.Parse(lblSubTotalFeesTotal.Text) + double.Parse(fees.ToString()));
lblSubTotalDiscountTotal.Text = string.Format("{0}", double.Parse(lblSubTotalDiscountTotal.Text) + double.Parse(discount.ToString()));
lblSubTotalTotalAmountTotal.Text = string.Format("{0}", double.Parse(lblSubTotalTotalAmountTotal.Text) + double.Parse(Total.ToString()));
lblTotalno.Text = (tRANSs.Count + int.Parse(lblTotalno.Text)).ToString();
if (Total > 0)
{
tblTotal.Visible = true;
}
}
}
