protected void LoadMasterData()
{
if (ddlDRNo.SelectedIndex == 0)
{
clearAll();
return;
}
SqlDataReader dr_emp = null;
DataTable dt = new DataTable();
SqlParameter[] dsParam =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@FIRCode", SqlDbType.Char, 8)
};
dsParam[0].Value = Session["DealerCode"].ToString();
dsParam[1].Value = ddlDRNo.SelectedValue.Trim();
sysfunc.ExecuteSP("sp_GetFIRMaster", dsParam, ref dr_emp);
dt.Load(dr_emp);
txtSRNo.Text = dt.Rows[0]["FIRCode"].ToString().Trim();
txtDate.Text = dt.Rows[0]["FIRDate"].ToString().Trim();
txtRegNo.Text = dt.Rows[0]["RegNo"].ToString().Trim();
txtModelCode.Text = dt.Rows[0]["VersionCode"].ToString().Trim();
txtEngineNo.Text = dt.Rows[0]["EngineNo"].ToString().Trim();
ddlVinNo.SelectedValue = dt.Rows[0]["ChassisNo"].ToString().Trim();
txtKM.Text = dt.Rows[0]["KM"].ToString().Trim();
txtSubject.Text = dt.Rows[0]["Subject"].ToString().Trim();
txtFailedPart.Text = dt.Rows[0]["ItemCode"].ToString();
txtFailureDate.Text = dt.Rows[0]["ProblemDate"].ToString().Trim();
txtInspDate.Text = dt.Rows[0]["InspectionDate"].ToString().Trim();
txtPrblmCause.Text = dt.Rows[0]["Problem"].ToString().Trim();
txtCorAction.Text = dt.Rows[0]["CorrectiveAction"].ToString().Trim();
txtCustComp.Text = dt.Rows[0]["CusComment"].ToString().Trim();
txtCustName.Text = dt.Rows[0]["CusDesc"].ToString().Trim();
txtAddress.Text = dt.Rows[0]["address"].ToString().Trim();
txtPhnNo.Text = dt.Rows[0]["Phone1"].ToString().Trim();
txtWarantyBookNo.Text = dt.Rows[0]["InvoiceNo"].ToString().Trim();
txtDelDate.Text = dt.Rows[0]["DeliveryDate"].ToString().Trim();
txtPart1.Text = dt.Rows[0]["Part1"].ToString().Trim();
txtPart1Desc.Text = dt.Rows[0]["Part1D"].ToString().Trim();
txtPart2.Text = dt.Rows[0]["Part2"].ToString().Trim();
txtPart2Desc.Text = dt.Rows[0]["Part2D"].ToString().Trim();
txtPart3.Text = dt.Rows[0]["Part3"].ToString().Trim();
txtPart3Desc.Text = dt.Rows[0]["Part3D"].ToString().Trim();
txtPart4.Text = dt.Rows[0]["Part4"].ToString().Trim();
txtPart4Desc.Text = dt.Rows[0]["Part4D"].ToString().Trim();
ddlStatus.SelectedValue = dt.Rows[0]["Status"].ToString();
ddlResult.SelectedValue = dt.Rows[0]["Result"].ToString();
txtRoNo.Text = dt.Rows[0]["RoNo"].ToString();
txtRepairDate.Text = dt.Rows[0]["RoDate"].ToString();
txtRequest.Text = dt.Rows[0]["Request"].ToString();
txtFollowUpDate.Text = dt.Rows[0]["followupdate"].ToString();
txtKeyNo.Text = dt.Rows[0]["KeyNo"].ToString();
txtSerial.Text = dt.Rows[0]["SerialNo"].ToString();
}
public ActionResult GatePass()
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
string DealerCode = Session["DealerCode"].ToString();
string old = grl.GetStringValuesAgainstCodes("TransCode", Session["TransCode"].ToString(), "GatePassCode", "GatePassTemp", " and Module='Sales'", Session["DealerCode"].ToString());
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@DONo", SqlDbType.VarChar)
};
param[0].Value = DealerCode;
param[1].Value = old;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_DeliveryOrderGatePass", param, ref rder))
{
data.SP_DeliveryOrderGatePass.Load(rder);
}
RD.Load(Server.MapPath("~/Reports/rptGatePass.rpt"));
//RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Delivery Order Gate Pass'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "ProductReceiptReport.pdf"));
}
catch
{
throw;
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
SysFunction sysFunc = new SysFunction();
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@TicketNo", SqlDbType.Char), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtTicketNo.Text;
SqlDataReader rder = null;
// Store Procedure check and load
if (sysFunc.ExecuteSP("SP_Report_Complaint", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_Report_Complaint.Load(rder); // DataSet SP
}
// Load in crystal report
//RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt"));
RD.Load(Server.MapPath("/Reports/rptComplaint.rpt"));
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAdress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Complain'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
// RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
// RD.DataDefinition.FormulaFields["ComplaintTypeCode"] = "'"+txtTicketNo.Text+"'";
// mention paper size
//RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~/Download/");
string FileName = "CounterSalesDetail" + Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
Session["RD"] = RD;
string URL;
URL = "../../../Download/rptViewerService.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@PPRCOde", SqlDbType.Char), //1
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlPRNo.SelectedValue;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_PPR_Report", param, ref rder))
{
data.SP_PPR_Report.Load(rder);
}
RD.Load(Server.MapPath("~\\Modules\\Service\\ServiceReports\\TRReport.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Warranty Report'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
// convert and show
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "TRReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
Session["RD"] = RD;
//RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
string URL;
URL = "../../../Download/rptViewerService.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
public ActionResult Exports( )
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
string dealerCode = Session["DealerCode"].ToString();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
//new SqlParameter("@BuyingCode",SqlDbType.Char)
};
param[0].Value = dealerCode;
// param[1].Value = EnquiryId;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
try
{
if (sysFunc.ExecuteSP("Select_DealFailYes", param, ref rder))
{
data.EnforceConstraints = false;
data.Select_DealFailYes.Load(rder);
}
RD.Load(Server.MapPath("~/Reports/Sale/DealFailReport.rpt"));
// RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Deal Fail Evaluation Details'";
//RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["FrontImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic01"].ToString() + "'";
//RD.DataDefinition.FormulaFields["BackImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic02"].ToString() + "'";
//RD.DataDefinition.FormulaFields["LeftImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic03"].ToString() + "'";
//RD.DataDefinition.FormulaFields["RightImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic04"].ToString() + "'";
//RD.DataDefinition.FormulaFields["TopImg"].Text = "'" + data.Select_BuyingCodeReport.Rows[0]["Pic05"].ToString() + "'";
RD.Database.Tables[0].SetDataSource(data);
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "InstallmentReceiptReport.pdf"));
}
catch
{
throw;
}
}
public static string Get_DeliveryChkList(string enquiryId, string dealerCode, string type)
{
string json = "";
var Serializer = new JavaScriptSerializer();
SqlDataReader rder = null;;
List <DeliveryCheckListVM> lst = new List <DeliveryCheckListVM>();
try
{
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", dealerCode), //1
new SqlParameter("@JobCardCode", enquiryId) //1
};
if (sysfun.ExecuteSP("sp_DeliveryDocList", sqlParam, ref rder))
{
while (rder.Read())
{
byte[] myimg = (byte[])rder["DocImage"];
lst.Add(new DeliveryCheckListVM
{
BookChkListCode = rder["DelChkListCode"].ToString(),
DelChkListDesc = rder["DelChkListDesc"].ToString(),
//ContentType = sdr["ContentType"].ToString(),
Image = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length),
});
// Session["Image"] = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length);
}
}
json = Serializer.Serialize(lst);
}
catch (Exception ex)
{
throw;
}
//try
//{
// string sql = "Select DelChkListCode from VehicleDelChkList where DeliveryNo = '" + enquiryId + "' and DealerCode ='"+ dealerCode + "' and Type = '"+ type + "'";
// dt = sysfun.GetData(sql);
// if (dt != null && dt.Rows.Count > 0)
// {
// lst = EnumerableExtension.ToList<DeliveryCheckListVM>(dt);
// }
// json = Serializer.Serialize(lst);
//}
//catch (Exception ex)
//{
// throw;
//}
return(json);
}
public ActionResult Export(string EnquiryId, string DealerCode)
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@CusCode", SqlDbType.VarChar)
};
param[0].Value = DealerCode;
param[1].Value = EnquiryId;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_InstallmentLedgerReport", param, ref rder))
{
data.SP_InstallmentLedgerReport.Load(rder);
}
RD.Load(Server.MapPath("~/Reports/InstallmentLedgerReport.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'CUSTOMER INSTALLMENT LEDGER'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "ProductReceiptReport.pdf"));
}
catch
{
throw;
}
}
public static string Get_BookingChkList(string enquiryId, string DealerCode)
{
string json = "";
var Serializer = new JavaScriptSerializer();
SqlDataReader rder = null;
List <DeliveryCheckListVM> lst = new List <DeliveryCheckListVM>();
try
{
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", DealerCode), //1
new SqlParameter("@JobCardCode", enquiryId) //1
};
if (sysfun.ExecuteSP("sp_BookOrdDocList", sqlParam, ref rder))
{
while (rder.Read())
{
byte[] myimg = (byte[])rder["DocImage"];
lst.Add(new DeliveryCheckListVM
{
BookChkListCode = rder["BookChklistCode"].ToString(),
DelChkListDesc = rder["DelChkListDesc"].ToString(),
//ContentType = sdr["ContentType"].ToString(),
Image = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length),
});
// Session["Image"] = "data:image/png;base64," + Convert.ToBase64String(myimg, 0, myimg.Length);
}
}
json = Serializer.Serialize(lst);
}
catch (Exception ex)
{
throw;
}
return(json);
}
public void InvoicePrint(string EnquiryId, string DealerCode)
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@EnquiryId", SqlDbType.VarChar)
};
param[0].Value = DealerCode;
param[1].Value = EnquiryId;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_EventDetail_Select", param, ref rder))
{
data.SP_EventDetail_Select.Load(rder);
}
this.HttpContext.Session["rptSource"] = data;
}
public ActionResult ExportBuyingDetail(string todate, string fromdate)
{
string dealerCode = Session["DealerCode"].ToString();
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@fromDate", SqlDbType.DateTime),
new SqlParameter("@ToDate", SqlDbType.DateTime),
};
param[0].Value = dealerCode;
param[1].Value = sysfunc.SaveDate(todate);
param[2].Value = sysfunc.SaveDate(fromdate);
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("Select_ExchangeVehicle_DetailReportData", param, ref rder))
{
data.EnforceConstraints = false;
data.Select_ExchangeVehicle_DetailReportData.Load(rder);
}
RD.Load(Server.MapPath("~/Reports/VehicleExchangeDetail.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Exchange Details '";
//RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + fromdate + "'";
RD.DataDefinition.FormulaFields["ToDate"].Text = "'" + todate + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "InstallmentReceiptReport.pdf"));
}
catch
{
throw;
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2580", "006"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (txtFromDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date");
return;
}
else if (txtToDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date");
return;
}
//if (ddlVendorCode.SelectedIndex == 0)
//{
// sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Vendor Option");
// return;
//}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar), //2
new SqlParameter("@VendorCode", SqlDbType.VarChar) //3
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFunc.SaveDate(txtFromDate.Text);
param[2].Value = sysFunc.SaveDate(txtToDate.Text);
param[3].Value = ddlVendorCode.SelectedValue.ToString().Trim();
SqlDataReader rder = null;
//SP_VendorLedger_Report
// Store Procedure check and load
if (sysFunc.ExecuteSP("SP_VendorLedger_Report", param, ref rder)) //Database SP
{
data.SP_VendorLedger_Report.Load(rder); // DataSet SP
}
// Load in crystal report
//RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt"));
RD.Load(Server.MapPath("../crptVendorLedgerReport.rpt"));
// mention paper size
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
//RD.Load(Server.MapPath("../../SpareReports/rptInvoices.rpt"));
// RD.Load(Server.MapPath("../rptJobHistory.rpt"));
//RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + "'";
// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Email", "Dealer") + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Vendor Ledger Report" + "\"";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//// convert and show
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "VendorLedgerReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
////RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlEmployee.SelectedIndex == 0)
{
cleardata();
cbActive.Checked = false;
return;
}
try
{
btn_save.Text = "Update";
DataTable dt = new DataTable();
SqlDataReader dr_emp = null;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@EmpCode", SqlDbType.Char), //1
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlEmployee.SelectedItem.Value;
SysFunc.ExecuteSP("SP_Select_DealerEmp", param, ref dr_emp);
dt.Load(dr_emp);
if (dt.Rows[0]["Active"].ToString() == "Y")
{
cbActive.Checked = true;
}
else
{
cbActive.Checked = false;
}
txtEmpID.Text = dt.Rows[0]["EmpID"].ToString().Trim();
txtEmp_name.Text = dt.Rows[0]["EmpName"].ToString();
txtdob.Text = dt.Rows[0]["DOB"].ToString();
txtcontact_no.Text = dt.Rows[0]["ContactNo"].ToString();
txtnic_no.Text = dt.Rows[0]["CNIC"].ToString();
txtjoining_date.Text = dt.Rows[0]["JoiningDate"].ToString();
txtleaving_date.Text = dt.Rows[0]["LeavingDate"].ToString();
ddldesig_code.SelectedValue = dt.Rows[0]["DesigCode"].ToString();
ddldep_code.SelectedValue = dt.Rows[0]["DeptCode"].ToString();
txtexp.Text = dt.Rows[0]["Experience"].ToString();
txtremarks.Text = dt.Rows[0]["Remarks"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["Picture"].ToString()))
{
Image1.ImageUrl = dt.Rows[0]["Picture"].ToString();
}
else
{
Image1.ImageUrl = "~/Images/BlankProfile.jpg";
}
}
catch (Exception ex)
{
success_add_item.Visible = true;
success_add_item.ForeColor = Color.Red;
success_add_item.Text = ex.Message;
}
}
protected void Print(object sender, EventArgs e)
{
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SysFunction sysFunc = new SysFunction();
DateTime fromDate = DateTime.ParseExact(txtFromDate.Text, "yyyy-MM-dd", null);
DateTime toDate = DateTime.ParseExact(txtToDate.Text, "yyyy-MM-dd", null);
//string FDate = sysFunc.SaveDate(txtFromDate.Text).ToString();
//string TDate = sysFunc.SaveDate(txtToDate.Text).ToString();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar), //2
new SqlParameter("@Satisfied", SqlDbType.Char)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = fromDate;
param[2].Value = toDate;
param[3].Value = ddlStatus.SelectedValue.ToString().Trim();
SqlDataReader rder = null;
if (sysFunc.ExecuteSP("sp_PostServiceFollowup_Rpt", param, ref rder))
{
data.sp_PostServiceFollowup_Rpt.Load(rder);
}
RD.Load(Server.MapPath("../PSFReport.rpt"));
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserID"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + " POST SERVICE FOLLOWUP SUMMARY" + "\"";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\Images\\havoline.png'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
RD.Database.Tables[0].SetDataSource(data);
// convert and show
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "crtPSF" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
Session["RD"] = RD;
//RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
string URL;
URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1200,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
protected void btnBillReport_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2583", "006"))
{
Response.Redirect("~/Test.aspx");
}
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@BillingNo", SqlDbType.VarChar) //1
};
param[0].Value = Session["DealerCode"].ToString();
if (ddlBillingNo.SelectedIndex == 0)
{
lblMessage.Text = "Please Select Billing No. first";
return;
}
else
{
param[1].Value = ddlBillingNo.SelectedValue.ToString().Trim();
}
SqlDataReader rder = null;
if (sysFunc.ExecuteSP("Sp_JENBillingRpt", param, ref rder))
{
data.EnforceConstraints = false;
data.Sp_JENBillingRpt.Load(rder);
}
RD.Load(Server.MapPath("~/Modules/Service/ServiceReports/rptClaimMemo.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Warranty Claim Memo'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
// convert and show
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "BillingReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
Session["RD"] = RD;
//RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
string URL;
URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
public ActionResult Export(string EnquiryId, string Type, string FromDate, string ToDate)
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar), //2
new SqlParameter("@Type", SqlDbType.VarChar)
};
param[0].Value = dealerCode;
param[1].Value = sysfunc.SaveDate(FromDate);
param[2].Value = sysfunc.SaveDate(ToDate);
param[3].Value = Type;
try
{
SqlDataReader rder = null;
if (EnquiryId == "Vehicle Receipt")
{
sysfunc.ExecuteSP("SP_ProdRecMaster_Report", param, ref rder);
data.EnforceConstraints = false;
data.SP_ProdRecMaster_Report.Load(rder);
RD.Load(Server.MapPath("~/Reports/crptProdRecMasterReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Vehicle Receipt Detail'";
}
else if (EnquiryId == "Delivery Order")
{
sysfunc.ExecuteSP("SP_VehicleDeliveryMaster_Report", param, ref rder);
data.EnforceConstraints = false;
data.SP_VehicleDeliveryMaster_Report.Load(rder);
RD.Load(Server.MapPath("~/Reports/crptVehicleDeliveryReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Delivery Order Detail'";
}
else if (EnquiryId == "Pending Booking Number")
{
sysfunc.ExecuteSP("SP_Select_PendingBookingNumber", param, ref rder);
data.EnforceConstraints = false;
data.SP_Select_PendingBookingNumber.Load(rder);
RD.Load(Server.MapPath("~/Reports/PendingBookingNo.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Booking Number'";
}
else if (EnquiryId == "Pending Invoice Number")
{
sysfunc.ExecuteSP("SP_Select_PendingVehicleReceipt", param, ref rder);
data.EnforceConstraints = false;
data.SP_Select_PendingVehicleReceipt.Load(rder);
RD.Load(Server.MapPath("~/Reports/PendingInvoice.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Vehicle Receipt'";
}
else if (EnquiryId == "Pending Payments")
{
sysfunc.ExecuteSP("SP_PendingPaymentsReport", param, ref rder);
data.EnforceConstraints = false;
data.SP_PendingPaymentsReport.Load(rder);
RD.Load(Server.MapPath("~/Reports/PendingPaymentsReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Payments'";
}
else
{
sysfunc.ExecuteSP("SP_BookingOrderDetailReport", param, ref rder);
data.EnforceConstraints = false;
data.SP_BookingOrderDetailReport.Load(rder);
RD.Load(Server.MapPath("~/Reports/BookingOrderDetailReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Booking Order Detail'";
}
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "ProductReceiptReport.pdf"));
}
catch
{
throw;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2586", "006"))
{
Response.Redirect("~/Test.aspx");
}
if (dtFrom.Text == "" || dtTo.Text == "")
{
MessageBox.Show("Please select dates", "Message");
return;
}
Data.DSReports data = new Data.DSReports();
SqlDataReader rder = null;
DataTable dt = new DataTable();
ReportDocument RD = new ReportDocument();
DateTime FromDate;
DateTime ToDate;
string FDate = myFunc.SaveDate(dtFrom.Text).ToString();
string TDate = myFunc.SaveDate(dtTo.Text).ToString();
FromDate = Convert.ToDateTime(FDate);
ToDate = Convert.ToDateTime(TDate);
//ReportDocument RD = new ReportDocument();
//DataSet dsRpt = new DataSet();
DXBMS.Data.DataSet1 objDsReports = new Data.DataSet1();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar), //2
new SqlParameter("@VehicleCategory", SqlDbType.VarChar),
new SqlParameter("@ChassisNo", SqlDbType.VarChar), //2
new SqlParameter("@EngineNo", SqlDbType.VarChar),
new SqlParameter("@RegNo", SqlDbType.VarChar),
new SqlParameter("@RptType", SqlDbType.VarChar),
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = FromDate;
param[2].Value = ToDate;
param[3].Value = rbStatus.SelectedItem.Value.ToString();
param[4].Value = "";
param[5].Value = "";
param[6].Value = "";
param[7].Value = "Warranty";
if (sysfunc.ExecuteSP("SP_PPR_Detail_Report", param, ref rder))
{
//data.SP_selectjobcategorydetail.Load(rder);
data.EnforceConstraints = false;
data.SP_PPR_Detail_Report.Load(rder);
}
RD.Load(Server.MapPath("~/Modules/Service/ServiceReports/rptWarrantyDetailHCV.rpt"));
// RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Warranty Claim Report'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["Pic1"].Text = "'" + Server.MapPath("~") + dt.Rows[0]["item"].ToString() + "'";
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//convert and show
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "BillingReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
public ActionResult Export(string Type, string rptType, string FromDate, string ToDate)
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
SqlDataReader rder = null;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar), //2
new SqlParameter("@Type", SqlDbType.VarChar),
new SqlParameter("@RptType", SqlDbType.VarChar)
};
if (rptType == "VS")
{
param[0].Value = dealerCode;
param[1].Value = sysfunc.SaveDate(FromDate);
param[2].Value = sysfunc.SaveDate(ToDate);
param[3].Value = Type;
param[4].Value = "VS";
sysfunc.ExecuteSP("SP_VehicleStock_Report_New", param, ref rder);
data.EnforceConstraints = false;
data.SP_VehicleStock_Report.Load(rder);
RD.Load(Server.MapPath("~/Reports/VehicleStockReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Vehicle Stock'";
}
else if (rptType == "ID")
{
param[0].Value = dealerCode;
param[1].Value = sysfunc.SaveDate(FromDate);
param[2].Value = sysfunc.SaveDate(ToDate);
param[3].Value = Type;
param[4].Value = "ID";
sysfunc.ExecuteSP("SP_VehicleStock_Report_New", param, ref rder);
data.EnforceConstraints = false;
data.SP_VehicleStock_Report.Load(rder);
RD.Load(Server.MapPath("~/Reports/VehicleStockReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Invoice Detail'";
}
else
{
param[0].Value = dealerCode;
param[1].Value = sysfunc.SaveDate(FromDate);
param[2].Value = sysfunc.SaveDate(ToDate);
param[3].Value = Type;
param[4].Value = "PI";
sysfunc.ExecuteSP("SP_VehicleStock_Report_New", param, ref rder);
data.EnforceConstraints = false;
data.SP_VehicleStock_Report.Load(rder);
RD.Load(Server.MapPath("~/Reports/VehicleStockReport.rpt"));
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Pending Invoice Detail'";
}
try
{
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + sysfunc.GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'F:\CRM\CRM_V3\CRM_V3\assets\images" + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "ProductReceiptReport.pdf"));
}
catch
{
throw;
}
}
public ActionResult Export(string EnquiryId, string DealerCode)
{
DSReports data = new DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char),
new SqlParameter("@EnquiryId", SqlDbType.VarChar)
};
param[0].Value = DealerCode;
param[1].Value = EnquiryId;
SqlDataReader rder = null;
SysFunction sysFunc = new SysFunction();
if (sysFunc.ExecuteSP("SP_Select_ProdRec_Print", param, ref rder))
{
data.EnforceConstraints = false;
data.SP_Select_ProdRec_Print.Load(rder);
}
// SqlParameter[] param2 =
//{
// new SqlParameter("@DealerCode",SqlDbType.Char),
// new SqlParameter("@DONo",SqlDbType.VarChar),
// new SqlParameter("@Type",SqlDbType.VarChar)
// };
// param2[0].Value = DealerCode;
// param2[1].Value = EnquiryId;
// param2[2].Value = "VR";
// if (sysFunc.ExecuteSP("SP_GetDeliveryCheckList", param2, ref rder))
// {
// data.SP_GetDeliveryCheckList.Load(rder);
// }
RD.Load(Server.MapPath("~/Reports/VehicleReceipt.rpt"));
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "'Vehicle Receipt Report'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
//RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
try
{
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "ProductReceiptReport.pdf"));
}
catch
{
throw;
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2567", "006"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (txtFromDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date");
return;
}
else if (txtToDate.Text == "")
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date");
return;
}
if (ddlUtilityAudit.SelectedIndex == 0)
{
sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Utility Audit Option");
return;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@FromDate", SqlDbType.VarChar), //1
new SqlParameter("@ToDate", SqlDbType.VarChar) //2
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = sysFunc.SaveDate(txtFromDate.Text);
param[2].Value = sysFunc.SaveDate(txtToDate.Text);
SqlDataReader rder = null;
if (ddlUtilityAudit.SelectedValue == "Estimate")
{
if (sysFunc.ExecuteSP("SP_EstimateReport_pSelect", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
if (ddlUtilityAudit.SelectedValue == "JobCard")
{
if (sysFunc.ExecuteSP("SP_JobCardReport_pSelect", param, ref rder)) //Database SP
{
data.EnforceConstraints = false;
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "CounterSale")
{
if (sysFunc.ExecuteSP("SP_CounterSaleMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice")
{
if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "PayRec")
{
if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "GRN")
{
if (sysFunc.ExecuteSP("SP_GRNMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
else if (ddlUtilityAudit.SelectedValue == "ChargeOut")
{
if (sysFunc.ExecuteSP("SP_ChargeOutMaster_pSelect", param, ref rder)) //Database SP
{
data.SP_JobCardMaster.Load(rder); // DataSet SP
}
}
RD.Load(Server.MapPath("../crpUtilityAuditReport.rpt"));
// mention paper size
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
//RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
if (ddlUtilityAudit.SelectedValue == "Estimate")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Estimate Report" + "\"";
}
if (ddlUtilityAudit.SelectedValue == "JobCard")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Job Card Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "CounterSale")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Counter Sale Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Invoice Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "PayRec")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Payment Receipt Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "GRN")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GRN Report" + "\"";
}
else if (ddlUtilityAudit.SelectedValue == "ChargeOut")
{
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Stock Adjustment Report" + "\"";
}
//RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = RD.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
DirectoryInfo info = new DirectoryInfo(FilePath);
if (!info.Exists)
{
info.Create();
}
string path = Path.Combine(FilePath, FileName);
using (FileStream outputFileStream = new FileStream(path, FileMode.Create))
{
stream.CopyTo(outputFileStream);
}
stream.Dispose(); stream.Close();
string URL = "../../../../Download/PrintReport.aspx";
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
//// convert and show
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "UtilityAuditReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?ReportID=" + FileName;
//string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
//ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}
catch (Exception ex)
{
sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message);
}
}
protected void BtnPrint_Click(object sender, EventArgs e)
{
Data.DSReports data = new Data.DSReports();
ReportDocument RD = new ReportDocument();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FeedBackCode", SqlDbType.Char, 8), //1
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlfeedbackNo.SelectedValue.Trim();
SqlDataReader rder = null;
// Stored Procedure check and load
if (sysFunc.ExecuteSP("SP_FeedBackMaster_Print", param, ref rder)) //Database SP
{
data.SP_FeedBackMaster_Print.Load(rder); // DataSet SP
}
// Load in crystal report
//RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt"));
//RD.Load(Server.MapPath("../crtStockAdjustment.rpt"));
RD.Load(Server.MapPath("Reports/FeedBackReport.rpt"));
// mention paper size
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
////RD.Load(Server.MapPath("../../SpareReports/rptInvoices.rpt"));
//// RD.Load(Server.MapPath("../rptJobHistory.rpt"));
////RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + "'";
//// RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Email", "Dealer") + "'";
//RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "DealerDesc", "Dealer") + "'";
//RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Address1", "Dealer") + "" +
// sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Address2", "Dealer") + "" +
// sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Address3", "Dealer") + " (" +
// sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + ") '";
//RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "SaleTaxNo", "Dealer") + "'";
//RD.DataDefinition.FormulaFields["NTN"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "NTN", "Dealer") + "'";
////RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'";
////RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'";
////RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'";
//RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
//RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "STOCK ADJUSTMENT REPORT" + "\"";
////RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
////RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//// RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
RD.Database.Tables[0].SetDataSource(data);
// convert and show
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "FeedBackQuestions" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
string URL;
URL = "../../Download/OpenPDF.aspx?FileName=" + FileName;
string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1000,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');";
ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true);
}