private void ExportToExcelNew()
{
//CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
//SqlConnection conn = null;
string FromDate = txtFromDate.Text;
string ToDate = txtToDate.Text;
try
{
//conn = new SqlConnection(obj.GetConnectionString());
//conn.Open();
//bool b = ValidateInput();
//if (b == true)
{
//GridView gvvc = new GridView();
//CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
string Stateid = App_Code.Global.GetSelectState(ref lstState, false);
string siteid = App_Code.Global.GetSelectState(ref lstSiteId, false);
string CustGroup = App_Code.Global.GetSelectState(ref lstCustGroup, false);
string BuList = App_Code.Global.GetSelectBUList(ref lstbu, false);
string CustList = App_Code.Global.GetSelectCustMaster(ref lstCust, false);
string query = "EXEC USP_GETVRSSPDISCOUNTREPORT '"
+ Stateid + "','"
+ siteid + "','"
+ BuList + "','"
+ CustGroup + "','"
+ CustList + "','"
+ Session["USERID"].ToString() + "','"
+ Session["LOGINTYPE"].ToString() + "','"
+ FromDate + "','"
+ ToDate + "' ";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
SqlParameter stateIdParam = new SqlParameter("@STATEID", SqlDbType.NVarChar, 5000);
stateIdParam.Value = Stateid;
sqlParameters.Add(stateIdParam);
SqlParameter siteIdParam = new SqlParameter("@SITEID", SqlDbType.NVarChar, 5000);
siteIdParam.Value = siteid;
sqlParameters.Add(siteIdParam);
SqlParameter buParam = new SqlParameter("@BU", SqlDbType.NVarChar, 5000);
buParam.Value = BuList;
sqlParameters.Add(buParam);
SqlParameter custgroupParam = new SqlParameter("@CUSTGROUP", SqlDbType.NVarChar, 5000);
custgroupParam.Value = CustGroup;
sqlParameters.Add(custgroupParam);
SqlParameter customerParam = new SqlParameter("@CUSTOMER", SqlDbType.NVarChar, 5000);
customerParam.Value = CustList;
sqlParameters.Add(customerParam);
SqlParameter userCodeParam = new SqlParameter("@USERCODE", SqlDbType.NVarChar, 20);
userCodeParam.Value = Session["USERID"].ToString();
sqlParameters.Add(userCodeParam);
SqlParameter userTypeParam = new SqlParameter("@USERTYPE", SqlDbType.Int);
userTypeParam.Value = Session["LOGINTYPE"].ToString();
sqlParameters.Add(userTypeParam);
SqlParameter fromDateParam = new SqlParameter("@FROMDATE", SqlDbType.DateTime);
fromDateParam.Value = FromDate;
sqlParameters.Add(fromDateParam);
SqlParameter toDateParam = new SqlParameter("@TODATE", SqlDbType.DateTime);
toDateParam.Value = ToDate;
sqlParameters.Add(toDateParam);
DataSet ds = CreamBellFramework.GetDataSetFromStoredProcedure("USP_GETVRSSPDISCOUNTREPORT", sqlParameters.ToArray());
// string query = "EXEC USP_GETVRSSPDISCOUNTREPORT '" + lstState.SelectedValue + "','" + Session["SiteCode"].ToString() + "','" + lstbu.SelectedValue + "','" + lstCustGroup.SelectedValue + "','" + lstCust.SelectedItem.Value + "','" + Session["USERID"].ToString() + "','" + Session["LOGINTYPE"].ToString() + "','" + FromDate + "','" + ToDate + "' ";
//using (SqlCommand cmd = new SqlCommand(query))
//{
// cmd.CommandTimeout = 600;
// using (SqlDataAdapter sda = new SqlDataAdapter())
// {
// cmd.Connection = obj.GetConnection();
// sda.SelectCommand = cmd;
// using (DataSet ds = new DataSet())
// {
//sda.Fill(ds);
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(ds.Tables[0], "Detail");
wb.Worksheets.Add(ds.Tables[1], "Summary");
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=VRSSpecialDiscountReport.xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
}
// }
// }
//}
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
if (ex.Message.ToString() != "Thread was being aborted.")
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", "alert('" + ex.Message.ToString().Replace("'", "") + "');", true);
}
//LblMessage.Text = ex.Message.ToString();
}
//finally
//{
// if (conn != null)
// {
// if (conn.State == ConnectionState.Open)
// {
// conn.Close();
// conn.Dispose();
// }
// }
//}
}
private void ShowReportByFilter()
{
//CreamBell_DMS_WebApps.App_Code.Global objGlobal = new CreamBell_DMS_WebApps.App_Code.Global();
//SqlConnection conn = null;
//SqlCommand cmd = null;
//DataTable dtDataByfilter = null;
//string query = string.Empty;
//try
//{
// conn = new SqlConnection(objGlobal.GetConnectionString());
// conn.Open();
// cmd = new SqlCommand();
// cmd.Connection = conn;
// cmd.CommandTimeout = 100;
// cmd.CommandType = CommandType.StoredProcedure;
// query = "[dbo].[ACX_USP_KEYCUSTOMERSALEREPORT]";
// cmd.CommandText = query;
// DateTime now = Convert.ToDateTime(txtToDate.Text);
// now = now.AddMonths(1);
// //DateTime lastDay = new DateTime(now.Year, now.Month, 1);
// cmd.Parameters.AddWithValue("@FROMDATE", Convert.ToDateTime(txtFromDate.Text));
// cmd.Parameters.AddWithValue("@TODATE", Convert.ToDateTime(txtToDate.Text));
// cmd.Parameters.AddWithValue("@UserType", Convert.ToString(Session["LOGINTYPE"]));
// cmd.Parameters.AddWithValue("@UserCode", Convert.ToString(Session["USERID"]));
// if (ddlSiteId.SelectedIndex < 0)
// {
// if (Convert.ToString(Session["LOGINTYPE"]) == "3")
// {
// string siteid = "";
// DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
// foreach (DataRow row in dt.Rows)
// {
// if (siteid == "")
// siteid = Convert.ToString(row["DISTRIBUTOR"]);
// else
// siteid += "," + row["DISTRIBUTOR"];
// }
// }
// }
// else if (ddlSiteId.SelectedIndex > 0)
// {
// cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
// }
// else if (ddlSiteId.SelectedItem.Text != "All...")
// {
// cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
// }
// else
// {
// if (Convert.ToString(Session["LOGINTYPE"]) == "3")
// {
// string siteid = "";
// DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
// foreach (DataRow row in dt.Rows)
// {
// if (siteid == "")
// siteid = Convert.ToString(row["DISTRIBUTOR"]);
// else
// siteid += "," + row["DISTRIBUTOR"];
// }
// cmd.Parameters.AddWithValue("@SiteId", siteid);
// }
// else
// cmd.Parameters.AddWithValue("@SiteId", "");
// }
// if (DDLBusinessUnit.SelectedIndex >= 1)
// {
// cmd.Parameters.AddWithValue("@BUCODE", DDLBusinessUnit.SelectedItem.Value.ToString());
// }
// else
// {
// cmd.Parameters.AddWithValue("@BUCODE", "");
// }
// dtDataByfilter = new DataTable();
// dtDataByfilter.Load(cmd.ExecuteReader());
// LoadDataInReportViewer(dtDataByfilter);
DataTable dtDataByfilter = null;
try
{
SqlParameter[] sqlParameters = null;
SqlParameter sqlParameterFROMDATE = new SqlParameter("@FROMDATE", Convert.ToDateTime(txtFromDate.Text));
SqlParameter sqlParameterTODATE = new SqlParameter("@TODATE", Convert.ToDateTime(txtToDate.Text));
SqlParameter sqlParameterUserType = new SqlParameter("@UserType", Convert.ToString(Session["LOGINTYPE"]));
SqlParameter sqlParameterUserCode = new SqlParameter("@UserCode", Convert.ToString(Session["USERID"]));
SqlParameter sqlParameterSiteId = null;
SqlParameter sqlParameterBUCODE = null;
if (ddlSiteId.SelectedIndex < 0)
{
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
string siteid = "";
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
foreach (DataRow row in dt.Rows)
{
if (siteid == "")
{
siteid = Convert.ToString(row["DISTRIBUTOR"]);
}
else
{
siteid += "," + row["DISTRIBUTOR"];
}
}
}
}
else if (ddlSiteId.SelectedIndex > 0 || ddlSiteId.SelectedItem.Text != "All...")
{
//cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
sqlParameterSiteId = new SqlParameter("@SiteId", ddlSiteId.SelectedItem.Value);
}
//else if (ddlSiteId.SelectedItem.Text != "All...")
//{
// //cmd.Parameters.AddWithValue("@SiteId", ddlSiteId.SelectedItem.Value);
// sqlParameterSiteId = new SqlParameter("@SiteId", ddlSiteId.SelectedItem.Value);
//}
else
{
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
string siteid = "";
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
foreach (DataRow row in dt.Rows)
{
if (siteid == "")
{
siteid = Convert.ToString(row["DISTRIBUTOR"]);
}
else
{
siteid += "," + row["DISTRIBUTOR"];
}
}
// cmd.Parameters.AddWithValue("@SiteId", siteid);
sqlParameterSiteId = new SqlParameter("@SiteId", siteid);
}
else
{
sqlParameterSiteId = new SqlParameter("@SiteId", "");// cmd.Parameters.AddWithValue("@SiteId", "");
}
}
if (DDLBusinessUnit.SelectedIndex >= 1)
{
//cmd.Parameters.AddWithValue("@BUCODE", DDLBusinessUnit.SelectedItem.Value.ToString());
sqlParameterBUCODE = new SqlParameter("@BUCODE", DDLBusinessUnit.SelectedItem.Value.ToString());
}
else
{
// cmd.Parameters.AddWithValue("@BUCODE", "");
sqlParameterBUCODE = new SqlParameter("@BUCODE", "");
}
sqlParameters = new SqlParameter[] { sqlParameterFROMDATE, sqlParameterTODATE, sqlParameterUserType, sqlParameterUserCode, sqlParameterSiteId, sqlParameterBUCODE };
dtDataByfilter = CreamBellFramework.GetDataFromStoredProcedure("[dbo].[ACX_USP_KEYCUSTOMERSALEREPORT]", sqlParameters);
LoadDataInReportViewer(dtDataByfilter);
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
this.LblMessage.Visible = true;
this.LblMessage.Text = "► " + ex.Message.ToString();
}
//finally
//{
// if (conn != null)
// {
// if (conn.State.ToString() == "Open") { conn.Close(); }
// }
//}
}
private void ShowCustomerMaster()
{
string siteid, StateCode;
int count = 0;
string FromDate = txtFromDate.Text;
string ToDate = txtToDate.Text;
siteid = StateCode = "";
foreach (System.Web.UI.WebControls.ListItem litem in lstState.Items)
{
if (litem.Selected)
{
count += 1;
if (StateCode.Length == 0)
{
StateCode = "" + litem.Value.ToString() + "";
}
else
{
StateCode += "," + litem.Value.ToString() + "";
}
}
}
foreach (System.Web.UI.WebControls.ListItem litem in lstSiteId.Items)
{
if (litem.Selected)
{
count += 1;
if (siteid.Length == 0)
{
siteid = "" + litem.Value.ToString() + "";
}
else
{
siteid += "," + litem.Value.ToString() + "";
}
}
}
string query = "EXEC ACX_USP_OpenSaleOrder '"
+ StateCode + "','" +
siteid.ToString() + "','" +
Session["DATAAREAID"].ToString() + "','" +
FromDate + "','" +
ToDate + "','" +
Convert.ToString(Session["USERID"]) + "','" +
Convert.ToString(Session["LOGINTYPE"]) + "'";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
SqlParameter stateCodeParam = new SqlParameter("@StateCode", SqlDbType.NVarChar, 5000);
stateCodeParam.Value = StateCode;
sqlParameters.Add(stateCodeParam);
SqlParameter siteCodeParam = new SqlParameter("@Site_Code", SqlDbType.NVarChar, 5000);
siteCodeParam.Value = siteid.ToString();
sqlParameters.Add(siteCodeParam);
SqlParameter dataAreaIdParam = new SqlParameter("@DATAAREAID", SqlDbType.NVarChar, 4);
dataAreaIdParam.Value = Session["DATAAREAID"].ToString();
sqlParameters.Add(dataAreaIdParam);
SqlParameter startDateParam = new SqlParameter("@StartDate", SqlDbType.Date);
startDateParam.Value = FromDate;
sqlParameters.Add(startDateParam);
SqlParameter endDateParam = new SqlParameter("@EndDate", SqlDbType.Date);
endDateParam.Value = ToDate;
sqlParameters.Add(endDateParam);
SqlParameter userCodeParam = new SqlParameter("@UserCode", SqlDbType.NVarChar, 50);
userCodeParam.Value = Session["USERID"].ToString();
sqlParameters.Add(userCodeParam);
SqlParameter userTypeParam = new SqlParameter("@UserType", SqlDbType.NVarChar, 50);
userTypeParam.Value = Session["LOGINTYPE"].ToString();
sqlParameters.Add(userTypeParam);
DataTable dtCustomer = CreamBellFramework.GetDataFromStoredProcedure("ACX_USP_OpenSaleOrder", sqlParameters.ToArray());
if (dtCustomer.Rows.Count > 0)
{
rptCustomers.DataSource = dtCustomer;
rptCustomers.DataBind();
}
}
private void ShowReportByFilter()
{
CreamBell_DMS_WebApps.App_Code.Global objGlobal = new Global();
DataTable dtDataByfilter = null;
try
{
#region oldCode
//conn = new SqlConnection(objGlobal.GetConnectionString());
//cmd = new SqlCommand();
//cmd.CommandTimeout = 0;
//cmd.CommandType = CommandType.StoredProcedure;
//query = "usp_GetCustomerOutstandingAgingReport";
//cmd.CommandText = query;
//if (!string.IsNullOrEmpty(txt30.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@FirstParm", txt30.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@FirstParm", 0);
//}
//if (!string.IsNullOrEmpty(txt60.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@SecondParm", txt60.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@SecondParm", 0);
//}
//if (!string.IsNullOrEmpty(txt90.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@Third", txt90.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@Third", 0);
//}
//if (!string.IsNullOrEmpty(txt120.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@Fourth", txt120.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@Fourth", 0);
//}
//if (!string.IsNullOrEmpty(txtOver120.Text.Trim()))
//{
// cmd.Parameters.AddWithValue("@FiveParm", txtOver120.Text.Trim());
//}
//else
//{
// cmd.Parameters.AddWithValue("@FiveParm", 0);
//}
//string strStateCode = "";
//string strSiteCode = "";
//if (Convert.ToString(Session["LOGINTYPE"]) == "3") {
// strStateCode = ucRoleFilters.GetCommaSepartedStateId();
// strSiteCode = ucRoleFilters.GetCommaSepartedSiteId();
//} else {
// foreach (ListItem item in chkListState.Items)
// {
// if (item.Selected)
// {
// if (strStateCode == "")
// {
// strStateCode += "" + item.Value.ToString() + "";
// }
// else
// {
// strStateCode += "," + item.Value.ToString() + "";
// }
// }
// }
// foreach (ListItem item in chkListSite.Items)
// {
// if (item.Selected)
// {
// if (strSiteCode == "")
// {
// strSiteCode += "" + item.Value.ToString() + "";
// }
// else
// {
// strSiteCode += "," + item.Value.ToString() + "";
// }
// }
// }
//}
//if (strStateCode.Length > 0)
//{
// cmd.Parameters.AddWithValue("@STATECODE", strStateCode);
//}
//else
//{
// cmd.Parameters.AddWithValue("@STATECODE", "");
//}
//if (strSiteCode.Length > 0)
//{
// cmd.Parameters.AddWithValue("@SiteCode", strSiteCode);
//}
//else
//{
// cmd.Parameters.AddWithValue("@SiteCode", "");
//}
//string strCustomerGroup = "";
//foreach (ListItem item in chkListCustomerGroup.Items)
//{
// if (item.Selected)
// {
// if (strCustomerGroup == "")
// {
// strCustomerGroup += "" + item.Value.ToString() + "";
// }
// else
// {
// strCustomerGroup += "," + item.Value.ToString() + "";
// }
// }
//}
//if (strCustomerGroup.Length > 0)
//{
// cmd.Parameters.AddWithValue("@Cust_Group", strCustomerGroup);
//}
//else
//{
// cmd.Parameters.AddWithValue("@Cust_Group", "");
//}
//string strCustomerName = "";
//foreach (ListItem item in chkCustomerName.Items)
//{
// if (item.Selected)
// {
// if (strCustomerName == "")
// {
// strCustomerName = item.Value.ToString();
// }
// else
// {
// strCustomerName += "," + item.Value.ToString() + "";
// }
// }
//}
//if (strCustomerName.Length > 0)
//{
// cmd.Parameters.AddWithValue("@Customer_Code", strCustomerName);
//}
//else
//{
// cmd.Parameters.AddWithValue("@Customer_Code", "");
//}
//dtDataByfilter = new DataTable();
//cmd.Connection = objGlobal.GetConnection();
//dtDataByfilter.Load(cmd.ExecuteReader());
#endregion
SqlParameter[] sqlParameters = null;
SqlParameter sqlParameterFirstParm = null;
SqlParameter sqlParameterSecondParm = null;
SqlParameter sqlParameterThird = null;
SqlParameter sqlParameterFourth = null;
SqlParameter sqlParameterFiveParm = null;
SqlParameter sqlParameterSTATECODE = null;
SqlParameter sqlParameterSiteCode = null;
SqlParameter sqlParameterCust_Group = null;
SqlParameter sqlParameterCustomer_Code = null;
if (!string.IsNullOrEmpty(txt30.Text.Trim()))
{
sqlParameterFirstParm = new SqlParameter("@FirstParm", txt30.Text.Trim());
}
else
{
sqlParameterFirstParm = new SqlParameter("@FirstParm", 0);
sqlParameterFirstParm.Value = 0;
}
if (!string.IsNullOrEmpty(txt60.Text.Trim()))
{
sqlParameterSecondParm = new SqlParameter("@SecondParm", txt60.Text.Trim());
}
else
{
sqlParameterSecondParm = new SqlParameter("@SecondParm", 0);
sqlParameterSecondParm.Value = 0;
}
if (!string.IsNullOrEmpty(txt90.Text.Trim()))
{
sqlParameterThird = new SqlParameter("@Third", txt90.Text.Trim());
}
else
{
sqlParameterThird = new SqlParameter("@Third", 0);
sqlParameterThird.Value = 0;
}
if (!string.IsNullOrEmpty(txt120.Text.Trim()))
{
sqlParameterFourth = new SqlParameter("@Fourth", txt120.Text.Trim());
}
else
{
sqlParameterFourth = new SqlParameter("@Fourth", 0);
sqlParameterFourth.Value = 0;
}
if (!string.IsNullOrEmpty(txtOver120.Text.Trim()))
{
sqlParameterFiveParm = new SqlParameter("@FiveParm", txtOver120.Text.Trim());
}
else
{
sqlParameterFiveParm = new SqlParameter("@FiveParm", 0);
sqlParameterFiveParm.Value = 0;
}
string strStateCode = "";
string strSiteCode = "";
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
strStateCode = ucRoleFilters.GetCommaSepartedStateId();
strSiteCode = ucRoleFilters.GetCommaSepartedSiteId();
}
else
{
foreach (ListItem item in chkListState.Items)
{
if (item.Selected)
{
if (strStateCode == "")
{
strStateCode += "" + item.Value.ToString() + "";
}
else
{
strStateCode += "," + item.Value.ToString() + "";
}
}
}
foreach (ListItem item in chkListSite.Items)
{
if (item.Selected)
{
if (strSiteCode == "")
{
strSiteCode += "" + item.Value.ToString() + "";
}
else
{
strSiteCode += "," + item.Value.ToString() + "";
}
}
}
}
if (strStateCode.Length > 0)
{
sqlParameterSTATECODE = new SqlParameter("@STATECODE", strStateCode);
}
else
{
sqlParameterSTATECODE = new SqlParameter("@STATECODE", "");
}
if (strSiteCode.Length > 0)
{
sqlParameterSiteCode = new SqlParameter("@SiteCode", strSiteCode);
}
else
{
sqlParameterSiteCode = new SqlParameter("@SiteCode", "");
}
string strCustomerGroup = "";
foreach (ListItem item in chkListCustomerGroup.Items)
{
if (item.Selected)
{
if (strCustomerGroup == "")
{
strCustomerGroup += "" + item.Value.ToString() + "";
}
else
{
strCustomerGroup += "," + item.Value.ToString() + "";
}
}
}
if (strCustomerGroup.Length > 0)
{
sqlParameterCust_Group = new SqlParameter("@Cust_Group", strCustomerGroup);
}
else
{
sqlParameterCust_Group = new SqlParameter("@Cust_Group", "");
}
string strCustomerName = "";
foreach (ListItem item in chkCustomerName.Items)
{
if (item.Selected)
{
if (strCustomerName == "")
{
strCustomerName = item.Value.ToString();
}
else
{
strCustomerName += "," + item.Value.ToString() + "";
}
}
}
if (strCustomerName.Length > 0)
{
sqlParameterCustomer_Code = new SqlParameter("@Customer_Code", strCustomerName);
}
else
{
sqlParameterCustomer_Code = new SqlParameter("@Customer_Code", "");
}
sqlParameters = new SqlParameter[] { sqlParameterFirstParm, sqlParameterSecondParm, sqlParameterThird, sqlParameterFourth, sqlParameterFiveParm, sqlParameterSTATECODE,
sqlParameterSiteCode, sqlParameterCust_Group, sqlParameterCustomer_Code };
dtDataByfilter = CreamBellFramework.GetDataFromStoredProcedure("dbo.usp_GetCustomerOutstandingAgingReport", sqlParameters);
LoadDataInReportViewer(dtDataByfilter);
}
catch (Exception ex)
{
this.LblMessage.Visible = true;
this.LblMessage.Text = "► " + ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
objGlobal.CloseSqlConnection();
}
}
