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