protected void gvLocation_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HiddenField hfAgnetID = (HiddenField)e.Row.FindControl("hfAgnetID");
GridView gvTRANS = (GridView)e.Row.FindControl("gvTRANS");
List <TRANS> tRANSs = new List <TRANS>();
tRANSs = TRANSManager.GetTRANSByAgnetIDnLocationIDsByDateNAmount(getLocationIDs(), int.Parse(hfAgnetID.Value), 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 += tRANS.TRANSPROMO;
Total += tRANS.TRANSTOTALAMOUNT;
//if (Session["userType"].ToString() != "Location")
//{
// if (((AGENT)Session["aGENT"]).AGENTID == 4)//if the admin
// {
// tRANS.IsEdit = true;
// }
// else
// {
// tRANS.IsEdit = false;
// }
//}
}
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()));
if (Total > 0)
{
tblTotal.Visible = true;
}
}
}
protected void gvLocation_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
HiddenField hfAgnetID = (HiddenField)e.Row.FindControl("hfAgnetID");
GridView gvPayment = (GridView)e.Row.FindControl("gvPayment");
List <TRANS> tRANSs = new List <TRANS>();
tRANSs = TRANSManager.GetTRANSByAgnetIDnLocationIDsByDateNAmount(getLocationIDs(), int.Parse(hfAgnetID.Value), txtFromDate.Text, txtToDate.Text, int.Parse(txtMoney.Text == "" ? "0" : txtMoney.Text));
List <TRANS> tRANSsDistinct = new List <TRANS>();
int count = 0;
for (int i = 0; i < tRANSs.Count; i++)
{
count = tRANSsDistinct.FindAll(x => x.LOCATIONID == tRANSs[i].LOCATIONID).Count;
if (count == 0)
{
tRANSsDistinct.Add(tRANSs[i]);
}
}
gvPayment.DataSource = tRANSsDistinct;
gvPayment.DataBind();
decimal totalAgentCommision = 0;
for (int i = 0; i < gvPayment.Rows.Count; i++)
{
Label lblAgentID = (Label)gvPayment.Rows[i].FindControl("lblAgentID");
lblAgentID.Text = hfAgnetID.Value.ToString();
Label lblLocationID = (Label)gvPayment.Rows[i].FindControl("lblLocationID");
Label lblPayAgentID = (Label)gvPayment.Rows[i].FindControl("lblAgentID");
Label lblTransCount = (Label)gvPayment.Rows[i].FindControl("lblTransCount");
Label lblRate = (Label)gvPayment.Rows[i].FindControl("lblRate");
Label lblFees = (Label)gvPayment.Rows[i].FindControl("lblFees");
Label lblAgentCommision = (Label)gvPayment.Rows[i].FindControl("lblAgentCommision");
Label lbllocationName = (Label)gvPayment.Rows[i].FindControl("lbllocationName");
lblPayAgentID.Text = hfAgnetID.Value.ToString();
if (lblPayAgentID.Text != "")
{
List <TRANS> tRANSsTransactionCount = new List <TRANS>();
foreach (TRANS tRANS in tRANSs)
{
if (tRANS.LOCATIONID == int.Parse(lblLocationID.Text))
{
tRANSsTransactionCount.Add(tRANS);
}
}
lblTransCount.Text = tRANSsTransactionCount.Count.ToString();
LOCATION lOCATION = new LOCATION();
lOCATION = LOCATIONManager.GetLOCATIONByID(int.Parse(lblLocationID.Text));
lblRate.Text = lOCATION.AGENTRATE.ToString();
lbllocationName.Text = lOCATION.BRANCH.ToString();
List <decimal> fees = new List <decimal>();
for (int j = 0; j < tRANSsTransactionCount.Count; j++)
{
fees.Add(tRANSsTransactionCount[j].TRANSFEES + tRANSsTransactionCount[j].TRANSOTHERFEES);
}
lblFees.Text = fees.Sum().ToString();
lblAgentCommision.Text = ((decimal.Parse(lblRate.Text) * decimal.Parse(lblFees.Text)) / 100).ToString();
totalAgentCommision = decimal.Parse(lblAgentCommision.Text) + totalAgentCommision;
//just formating the currency
lblAgentCommision.Text = String.Format("{0:C}", decimal.Parse(lblAgentCommision.Text));
lblRate.Text = lOCATION.AGENTRATE.ToString() + "%";
}
}
Label lblTotalAgentCommission = (Label)gvPayment.FooterRow.FindControl("lblTotalAgentCommission");
lblTotalAgentCommission.Text = String.Format("{0:C}", totalAgentCommision);
}
}
