protected void gvDeposits_Sorting(object sender, GridViewSortEventArgs e)
{
try
{
string strExpression = e.SortExpression;
string strDirection = ViewState["SortDirection"].ToString();
objBal = new ClsBAL();
DataSet ds = objBal.GetAgentDeposits(Convert.ToInt32(ddlAgents.SelectedItem.Value.ToString()));
DataTable dt = ds.Tables[0];
DataView dv = new DataView(dt);
dv.Sort = strExpression + strDirection;
gvDeposits.DataSource = dv;
gvDeposits.DataBind();
if (strDirection == " ASC") { ViewState["SortDirection"] = " DESC"; } else { ViewState["SortDirection"] = " ASC"; }
}
catch (Exception ex)
{
lblMsg.InnerHtml = ex.Message;
throw;
}
}
void BindDeposits()
{
objBal = new ClsBAL();
DataSet ds = objBal.GetAgentDeposits(Convert.ToInt32(ddlAgents.SelectedItem.Value.ToString()));
Userid = ds.Tables[0].Rows[0]["UserId"].ToString();
gvDeposits.DataSource = ds;
gvDeposits.DataBind();
}
protected void btnUpdateStatus_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in gvDeposits.Rows)
{
Label lblDepositedRequestId = (Label)row.FindControl("lblDepositRequestId");
Label lblAgentId = (Label)row.FindControl("lblAgentId");
Label lblAgentname = (Label)row.FindControl("lblAgentname");
Label lblemailId = (Label)row.FindControl("lblemailId");
Label lblAmount = (Label)row.FindControl("lblAmount");
Label lblDepositType = (Label)row.FindControl("lblDepositType");
Label lblTransactionNumber = (Label)row.FindControl("lblTransactionNumber");
Label lblDetails = (Label)row.FindControl("lblDetails");
Label lblDepositBank = (Label)row.FindControl("lblDepositBank");
Label lblChequeDrawnBank = (Label)row.FindControl("lblChequeDrawnBank");
Label lblChequeIssueDate = (Label)row.FindControl("lblChequeIssueDate");
Label lblChequeNo = (Label)row.FindControl("lblChequeNo");
Label lblStatus = (Label)row.FindControl("lblStatus");
DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus");
ClsBAL obj = new ClsBAL();
DateTime? dtime = null;
if (lblStatus.Text == "Requested")
{
if (ddlStatus.SelectedValue == "Deposited")
{
if (lblChequeIssueDate.Text != "")
{
dtime = Convert.ToDateTime(lblChequeIssueDate.Text);
}
lblMsg.InnerText = obj.UpdateDepositRequest(Convert.ToInt32(lblAgentId.Text), Convert.ToDouble(lblAmount.Text),
lblTransactionNumber.Text, lblDepositType.Text, lblDepositBank.Text, lblChequeDrawnBank.Text, dtime,
lblChequeNo.Text, Convert.ToInt32(Session["UserID"].ToString()), Convert.ToInt32(lblDepositedRequestId.Text), lblDetails.Text, ddlStatus.SelectedValue.ToString());
//System.Data.DataSet ds = objBal.GetAgentById(Convert.ToInt32(lblAgentId.Text));
//DeductAgentBalance(Convert.ToInt32(lblAgentId.Text), Convert.ToDouble(0.00),
// Convert.ToInt32(ds.Tables[0].Rows[0]["UserId"].ToString()), lblDepositType.Text, Convert.ToDouble(lblAmount.Text.ToString()),
// Convert.ToDouble(0.00), Convert.ToInt32(0.00));
objBal = new ClsBAL();
DataSet ds = objBal.GetAgentDeposits(Convert.ToInt32(lblAgentId.Text));
string Userid = ds.Tables[0].Rows[0]["UserId"].ToString();
DeductAgentBalance(Convert.ToInt32(lblAgentId.Text), Convert.ToDouble(0.00),
Convert.ToInt32(Userid), lblDepositType.Text, Convert.ToDouble(lblAmount.Text),
Convert.ToDouble(0.00), Convert.ToInt32(0.00));
if (lblMsg.InnerText.ToString() == "Amount has been deposited.")
{
lblMsg.InnerText = lblMsg.InnerText.ToString();
BindDepositRequests();
#region
string Body = "Hello <b>" + lblAgentname.Text + "</b>," +
"<br /><br />Let us welcome you with lovejourney.in " +
"Following are your Added Balance details. <br/> <br/>" +
"Email ID :<b><b>" + lblemailId.Text.Trim() + "</b><br />" +
"Added Amount:<b><b>" + lblAmount.Text + "</b><br />" +
"<br /><br />We thank you for registering with lovejourney.in and please " +
"do not hesitate<br /> to write to us at <a href='mailto:[email protected]'>Mail </a><b> " +
"should you have any questions. <br /><br />Best Regards, <br />Administrator<br /> <a href='http://lovejourney.in'> lovejourney.in</a>" +
"<br /><br />";
MailSender.SendEmail(lblemailId.Text.Trim(), "*****@*****.**", "*****@*****.**", "lovejourney-Deposit", Body);
#endregion
}
}
//lblStatus.Visible = false;
//ddlStatus.Visible = true;
}
//else
//{
// lblStatus.Visible = true;
// ddlStatus.Visible = false;
//}
}
}