public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptSummStoreInventory rpt = new RptSummStoreInventory();
rpt.Site = this.Site;
return(rpt);
}
private void Acc_SummaryofStoreInventoryAndSummaryofMonthlyInvPerBrand()
{
ReportDocument rpt;
string rptDocCachedKey = null;
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["IRMSConnectionString"].ConnectionString);
conn.Open();
SqlCommand cmd = new SqlCommand();
if (Request.QueryString["rptnameSOI"] == "rptSummMonthlyInvPerBrand")
{
rptDocCachedKey = "rptSummMonthlyInvPerBrand";
if (Cache[rptDocCachedKey] != null)
{
rpt = (RptSummaryofMonthlyInvPerBrand)Cache[rptDocCachedKey];
}
else
{
rpt = new RptSummaryofMonthlyInvPerBrand();
Cache.Insert(rptDocCachedKey, rpt);
}
if (Request.QueryString["customertype"] == "PROVINCIAL")
{
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptSummaryofMonthlyInvPerBrandProv '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "','" + Request.QueryString["brand"] + "', '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else if (Request.QueryString["customertype"] == "DEPT. STORE")
{
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptSummaryofMonthlyInvPerBrandDept '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "','" + Request.QueryString["brand"] + "', '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else
{
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptSummaryofMonthlyInvPerBrandBoutique '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "','" + Request.QueryString["brand"] + "', '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
}
else
{
rptDocCachedKey = "RptSummStoreInventory";
if (Cache[rptDocCachedKey] != null)
{
rpt = (RptSummStoreInventory)Cache[rptDocCachedKey];
}
else
{
rpt = new RptSummStoreInventory();
Cache.Insert(rptDocCachedKey, rpt);
}
if (Request.QueryString["customertype"] == "PROVINCIAL")
{
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptStoreSummInvProv '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "','" + Request.QueryString["brand"] + "', '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else if (Request.QueryString["customertype"] == "DEPT. STORE")
{
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptStoreSummInvDept '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "','" + Request.QueryString["brand"] + "', '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
else
{
cmd.Connection = conn;
cmd.CommandTimeout = 3000;
cmd.CommandText = "GenRptStoreSummInvBoutique '" + Request.QueryString["datefrom"] + "','" + Request.QueryString["dateto"] + "','" + Request.QueryString["brand"] + "', '" + Session["USER_NAME"] + "'";
cmd.ExecuteNonQuery();
}
}
DataBaseLogIn(rpt);
ParameterField prmUserName = new ParameterField();
ParameterField prmCustType = new ParameterField();
ParameterField prmBrandName = new ParameterField();
ParameterFields prmList = new ParameterFields();
prmUserName.ParameterFieldName = "username";
prmBrandName.ParameterFieldName = "brandname";
prmCustType.ParameterFieldName = "custtype";
ParameterDiscreteValue prmUserNameValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmBrandNameValue = new ParameterDiscreteValue();
ParameterDiscreteValue prmCustTypeValue = new ParameterDiscreteValue();
prmUserNameValue.Value = Session["USER_NAME"];
prmBrandNameValue.Value = Request.QueryString["brand"];
prmCustTypeValue.Value = Request.QueryString["customertype"];
prmUserName.CurrentValues.Add(prmUserNameValue);
prmBrandName.CurrentValues.Add(prmBrandNameValue);
prmCustType.CurrentValues.Add(prmCustTypeValue);
prmList.Add(prmUserName);
prmList.Add(prmBrandName);
prmList.Add(prmCustType);
crvDailyReport.ParameterFieldInfo = prmList;
crvDailyReport.ReportSource = rpt;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptSummStoreInventory rpt = new RptSummStoreInventory();
rpt.Site = this.Site;
return rpt;
}