protected void ibtnExportPDFAppTableDoc_Click(object sender, ImageClickEventArgs e)
{
if (GridAC.Rows.Count > 0)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition",
"attachment;filename=MembershipAccount.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridAC.AllowPaging = false;
GridAC.DataSource = GetDataSource();
GridAC.DataBind();
GridAC.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
}
protected void ibtnExportExcelAppTableDoc_Click(object sender, ImageClickEventArgs e)
{
try
{
GridAC.AllowPaging = false;
GridAC.DataSource = GetDataSource();
GridAC.DataBind();
if (GridAC.Rows.Count > 0)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=AccountDDReport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridAC.RenderControl(hw);
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
catch (FormatException ex)
{
}
}
protected void btnVeiw_OnClick(object sender, EventArgs e)
{
try
{
string qry = "";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
if (rbtnICE.Checked == true)
{
lblGridTitle.Text = "Date: " + txtDateFrom.Text + " To: " + txtDateto.Text.ToString();
qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where SubDate Between '" + Convert.ToDateTime(txtDateFrom.Text, dtinfo) + "' and '" + Convert.ToDateTime(txtDateto.Text, dtinfo) + "' order by SubDate Desc";
}
else if (rbtnIM.Checked == true)
{
lblGridTitle.Text = "IMID: " + txtIMID.Text.ToString() + " and Session: " + lblSessionHidden.Text.ToString();
qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where Session='" + lblSessionHidden.Text.ToString() + "' and IMID='" + txtIMID.Text.ToString() + "' order by SubDate Desc";
}
else if (rbtnDiary.Checked == true)
{
lblGridTitle.Text = "Diary No. " + txtDiary.Text.ToString();
qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where DiaryNo='" + txtDiary.Text.ToString() + "' order by SubDate Desc";
}
else if (rbtnDDNO.Checked == true)
{
lblGridTitle.Text = "DD No. " + txtDiary.Text.ToString();
qry = "select IMID,DiaryNo,Session,SubDate as Date,AmtFor,DDDate,DDNO,Bank,Narration,Amt as Amount from FeeAC where DDNO='" + txtDiary.Text.ToString() + "' and Session='" + lblSessionHidden.Text.ToString() + "' order by SubDate Desc";
}
SqlDataAdapter ad = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
ad.Fill(dt);
GridAC.DataSource = dt;
GridAC.DataBind();
if (GridAC.Rows.Count > 0)
{
GridAC.Focus();
}
else
{
btnView.Focus();
}
}
catch (FormatException ex)
{
GridAC.DataBind();
if (GridAC.Rows.Count > 0)
{
GridAC.Focus();
}
else
{
btnView.Focus();
}
}
finally
{
con.Close();
con.Dispose();
}
}
protected void ibtnExportDocAppTableDoc_click(object sender, ImageClickEventArgs e)
{
if (GridAC.Rows.Count > 0)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=MembershipAccount.doc");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-word ";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridAC.AllowPaging = false;
GridAC.DataSource = GetDataSource();
GridAC.DataBind();
GridAC.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
protected void btnVeiw_OnClick(object sender, EventArgs e)
{
string qry = "";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
lblGridTitle.Text = "IMID " + txtIMID.Text.ToString();
if (ddlType.SelectedValue == "All")
{
qry = "select FeeType,Amt as Amount,SubDate,SubType,YearFrom,YearTo,Bank,AcountNo,DD,Balance,TransType from MemberFee where ID='" + txtIMID.Text + "' and YearFrom='" + lblSessionHidden.Text + "' ORDER BY TransID DESC ";
}
else
{
qry = "select FeeType,Amt as Amount,SubDate,SubType,YearFrom,YearTo,Bank,AcountNo,DD,Balance,TransType from MemberFee where ID='" + txtIMID.Text + "' and YearFrom='" + lblSessionHidden.Text + "' and SubType='" + ddlType.SelectedValue + "' ORDER BY TransID DESC ";
}
SqlDataAdapter ad = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
ad.Fill(dt);
GridAC.DataSource = dt;
GridAC.DataBind();
}
protected void btnVeiw_OnClick(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Conn"]);
string qry = "";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
dtinfo.DateSeparator = "/";
con.Close(); con.Open();
if (rbtnICE.Checked == true)
{
lblGridTitle.Text = "Date: " + txtDateFrom.Text + " To: " + txtDateto.Text.ToString();
qry = "select IMID,DiaryNo,Session,Date,Amount,Type,Balance,Details from Account where Date Between '" + Convert.ToDateTime(txtDateFrom.Text, dtinfo) + "' and '" + Convert.ToDateTime(txtDateto.Text, dtinfo) + "' ORDER BY SN DESC";
}
else if (rbtnIM.Checked == true)
{
lblGridTitle.Text = "IMID: " + txtIMID.Text.ToString() + " and Session: " + lblSessionHidden.Text.ToString();
qry = "select IMID,DiaryNo,Session,Date,Amount,Type,Balance,Details from Account where Session='" + lblSessionHidden.Text.ToString() + "' and IMID='" + txtIMID.Text.ToString() + "' ORDER BY SN DESC";
}
else if (rbtnDiary.Checked == true)
{
lblGridTitle.Text = "Diary No. " + txtDiary.Text.ToString();
qry = "select IMID,DiaryNo,Session,Date,Amount,Type,Balance,Details from Account where DiaryNo='" + txtDiary.Text.ToString() + "' ORDER BY SN DESC";
}
SqlDataAdapter ad = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
ad.Fill(dt);
GridAC.DataSource = dt;
GridAC.DataBind();
GridAC.Focus();
}
catch (SqlException ex)
{
}
catch (FormatException ex)
{
}
}
protected void GridAC_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridAC.PageIndex = e.NewPageIndex;
GridAC.DataSource = GetDataSource();
GridAC.DataBind();
}