protected void ImgBtnExport_Click(object sender, ImageClickEventArgs e)
{
if (ViewState["Summary"] != null)
{
DataTable DtGrd = (DataTable)ViewState["Summary"];
string PURINVNO = string.Empty;
if (DtGrd.Rows.Count > 0)
{
GridView GridExp = new GridView();
GridExp.DataSource = DtGrd;
GridExp.DataBind();
Obj_Comm.Export("ListOfReceipts.xls", GridExp);
}
else
{
Obj_Comm.ShowPopUpMsg("No Data Found To Export..!", this.Page);
GridReceiptList.DataSource = null;
GridReceiptList.DataBind();
}
}
else
{
Obj_Comm.ShowPopUpMsg("No Data Found To Export..!", this.Page);
SetInitialRow();
}
}
public void SetInitialRow()
{
try
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("Property", typeof(string)));
dt.Columns.Add(new DataColumn("PartyName", typeof(string)));
dt.Columns.Add(new DataColumn("UnitNo", typeof(string)));
dt.Columns.Add(new DataColumn("CompanyName", typeof(string)));
dt.Columns.Add(new DataColumn("ReceiptNo", typeof(string)));
dt.Columns.Add(new DataColumn("ReceiptDate", typeof(string)));
dt.Columns.Add(new DataColumn("VoucherAmt", typeof(decimal)));
dt.Columns.Add(new DataColumn("#", typeof(int)));
dt.Columns.Add(new DataColumn("ForTheMonth", typeof(string)));
dr = dt.NewRow();
dr["#"] = 0;
dr["Property"] = "";
dr["PartyName"] = "";
dr["UnitNo"] = "";
dr["CompanyName"] = "";
dr["ReceiptNo"] = "";
dr["ReceiptDate"] = "";
dr["VoucherAmt"] = 0;
dr["ForTheMonth"] = "";
dt.Rows.Add(dr);
ViewState["Summary"] = dt;
GridReceiptList.DataSource = dt;
GridReceiptList.DataBind();
dt = null;
dr = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void ReportGrid()
{
try
{
StrCondition = string.Empty;
if (ChkFrmDate.Checked == true)
{
StrCondition = StrCondition + " and RV.ReceiptDate between '" + Convert.ToDateTime(txtFromDate.Text).ToString("MM-dd-yyyy") + "' AND '" + Convert.ToDateTime(txtToDate.Text).ToString("MM-dd-yyyy") + "' ";
}
if (Convert.ToInt32(ddlProperty.SelectedValue) > 0)
{
StrCondition = StrCondition + " and RV.PropertyId='" + (ddlProperty.SelectedValue) + "' ";
}
if (!string.IsNullOrEmpty(ddlParty.Text) && Convert.ToInt32(ddlParty.SelectedValue) > 0)
{
StrCondition = StrCondition + " and RV.PartyId='" + (ddlParty.SelectedValue) + "' ";
}
if (!string.IsNullOrEmpty(ddlCompany.Text) && Convert.ToInt32(ddlCompany.SelectedValue) > 0)
{
StrCondition = StrCondition + " and PM.CompanyId='" + (ddlCompany.SelectedValue) + "' ";
}
if (!string.IsNullOrEmpty(txtUnitNo.Text))
{
StrCondition = StrCondition + " RV.UnitNo='" + (txtUnitNo.Text) + "' ";
}
DS = Obj_Receipt.GetReceiptMaster(StrCondition, out StrError);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
ViewState["Summary"] = DS.Tables[0];
GridReceiptList.DataSource = DS.Tables[0];
GridReceiptList.DataBind();
if (!FlagPrint)
{
ImgBtnPrint.Visible = false;
ImgBtnExport.Visible = true;
ImgPDF.Visible = true;
}
lblCount.Text = DS.Tables[0].Rows.Count + " Records Found";
lblCount.Visible = true;
dsExport = DS.Copy();
}
else
{
GridReceiptList.DataSource = null;
GridReceiptList.DataBind();
lblCount.Text = "No Records Found!!";
lblCount.Visible = true;
SetInitialRow();
ImgBtnPrint.Visible = false;
ImgBtnExport.Visible = false;
ImgPDF.Visible = false;
}
}
catch (Exception ex)
{
Obj_Comm.ShowPopUpMsg(ex.Message, this.Page);
}
}