protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//LoadData();
if (ddlMonth.SelectedValue == "0")
{
Response.Write("<script>alert('Please select Month.....!')</script>");
}
else if (ddlYear.SelectedValue == "0")
{
Response.Write("<script>alert('Please select Year.....!')</script>");
}
else
{
string Sql = "SELECT Id ,SendFrom,SendTo,sentMessage,TotalSent,Totallength,TotalSms,balance ,EntryDate " +
"FROM PromotionalSendSMSReport where SendFrom='" + Convert.ToString(Session["Mobile"]) + "'";
if (ddlMonth.SelectedValue != "0")
{
Sql = Sql + " and datePart(month,PromotionalSendSMSReport.EntryDate)=" + ddlMonth.SelectedValue.ToString() + "";
}
if (ddlYear.SelectedValue != "0")
{
Sql = Sql + " and datePart(Year,PromotionalSendSMSReport.EntryDate)=" + ddlYear.SelectedItem.Text.ToString() + "";
}
Sql = Sql + " order by id desc";
DataSet ds = cc.ExecuteDataset(Sql);
GvBalence.DataSource = ds.Tables[0];
GvBalence.DataBind();
foreach (GridViewRow row in GvBalence.Rows)
{
string Data = row.Cells[2].Text.ToString();
Data = "Mobile List";
row.Cells[2].Text = Data;
}
foreach (GridViewRow row in GvBalence.Rows)
{
string Data = row.Cells[8].Text.ToString();
Data = DateSplit(Data);
row.Cells[8].Text = Data;
}
}
}
catch (Exception ex)
{ }
}
protected void btnDwn_Click(object sender, EventArgs e)
{
try
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=BalenceTillReport.xls");
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GvBalence.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}
catch (Exception ex)
{
throw ex;
}
}
private void show()
{
try
{
string Sql = "select * from SMSBalanceReport where ";
if (ddlMonth.SelectedValue != "0")
{
Sql = Sql + " datePart(month,SMSBalanceReport.SendDate)= '" + ddlMonth.SelectedValue + "' and ";
}
if (ddlYear.SelectedValue != "0")
{
Sql = Sql + " datePart(Year,SMSBalanceReport.SendDate)='" + ddlYear.SelectedItem.Text + "' and";
}
Sql = Sql + " MobileNo='" + Convert.ToString(Session["Mobile"]) + "' order by Id desc";
DataSet ds = cc.ExecuteDataset(Sql);
GvBalence.DataSource = ds.Tables[0];
GvBalence.DataBind();
}
catch (Exception ex)
{
}
}
public void LoadData()
{
try
{
string Sql = "SELECT Top(100) Id ,SendFrom,SendTo,sentMessage,TotalSent,Totallength,TotalSms,balance ,EntryDate " +
"FROM PromotionalSendSMSReport where SendFrom='" + Convert.ToString(Session["Mobile"]) + "'";
if (ddlMonth.SelectedValue != "0")
{
Sql = Sql + " and datePart(month,PromotionalSendSMSReport.EntryDate)=" + ddlMonth.SelectedValue.ToString() + "";
}
if (ddlYear.SelectedValue != "0")
{
Sql = Sql + " and datePart(Year,PromotionalSendSMSReport.EntryDate)=" + ddlYear.SelectedItem.Text.ToString() + "";
}
Sql = Sql + " order by id desc";
DataSet ds = cc.ExecuteDataset(Sql);
if (ds.Tables[0].Rows.Count > 0)
{
GvBalence.DataSource = ds.Tables[0];
GvBalence.DataBind();
}
foreach (GridViewRow row in GvBalence.Rows)
{
string Data = row.Cells[2].Text.ToString();
Data = "Mobile List";
row.Cells[2].Text = Data;
}
foreach (GridViewRow row in GvBalence.Rows)
{
string Data = row.Cells[8].Text.ToString();
Data = DateSplit(Data);
row.Cells[8].Text = Data;
}
}
catch (Exception ex)
{ }
}