//public bool ExecuteSP(string SP_Name, SqlParameter[] param, ref SqlDataReader dr)
//{
// bool flag;
// try
// {
// GetConnection();
// dr = SqlHelper.ExecuteReader(GlobalVar.mCon, SP_Name, param);
// if (dr.HasRows) flag = true; else flag = false;
// }
// catch (Exception ex) { throw ex; }
// return flag;
//}
public DataSet FillDataSet(string SP_Name, SqlParameter[] param)
{
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.StoredProcedure, SP_Name, param);
return(ds);
}
public DataTable GetDatas(string SQL, string database)
{
try
{
//StrCCon = CConnection.GetDMISConnectionString();
//if (database == "DMIS")
//{
// StrCCon = CConnection.GetDMISConnectionString();
//}
if (database == "FAMSConnectionString")
{
StrCCon = General.GetFAMConString();
}
else
{
StrCCon = CConnection.GetConnectionString();
}
SqlDataAdapter dta = new SqlDataAdapter(SQL, StrCCon);
DataTable dt = new DataTable();
dta.Fill(dt);
StrCCon = CConnection.GetConnectionString();
return(dt);
}
catch (Exception e)
{
// msg = e.Message;
//GlobalVar.mErrorMessage = " Cretical connection Error cant continue ,please contact with concern person \n" + e.Message;
return(null);
}
}
public SysFunction()
{
//
// TODO: Add constructor logic here
//
StrCCon = CConnection.GetConnectionString();
}
public bool CodeExists(string strTableNames, string strColumnCode, string strColumeValue, string strDealerCode, ref DataSet ds)
{
try
{
//Create query to check in all tables one by one
//foreach ( sTableName in strTableNames) {
string sQuery = "SELECT * FROM " + strTableNames + " WHERE " + strColumnCode + " = '" + strColumeValue + "' AND DealerCode = '" + strDealerCode + "'";
StrCCon = CConnection.GetConnectionString();
ds = new DataSet();
ds = SqlHelper.ExecuteDataset(this.StrCCon, CommandType.Text, sQuery);
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
//clsLogger.WriteLog(e.Message, e.Source);
throw ex;
}
}
public static DataSet GetData(SqlCommand cmd, int pageIndex)
{
string strConnString = CConnection.GetConnectionString();
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds, "JobCardMaster");
DataTable dt = new DataTable("Pager");
dt.Columns.Add("PageIndex");
dt.Columns.Add("PageSize");
dt.Columns.Add("RecordCount");
dt.Rows.Add();
dt.Rows[0]["PageIndex"] = pageIndex;
dt.Rows[0]["PageSize"] = PageSize;
dt.Rows[0]["RecordCount"] = cmd.Parameters["@RecordCount"].Value;
ds.Tables.Add(dt);
return(ds);
}
}
}
}
public static string GetSaleInvoiceDetail(string TransNo, string ChasisNo, string DealerCode)
{
string json = "";
List <SelectListItem> item = new List <SelectListItem>();
var Serializer = new JavaScriptSerializer();
List <VehicleSaleMasterVM> lst = new List <VehicleSaleMasterVM>();
try
{
//var Serializer = new JavaScriptSerializer();
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", DealerCode),
new SqlParameter("@TransCode", TransNo),
new SqlParameter("@ChasisNo", ChasisNo)
};
dt = DataAccess.getDataTable("SP_Get_SaleInvoiceDetail", sqlParam, CConnection.GetConnectionString());
if (dt.Rows.Count > 0)
{
lst = EnumerableExtension.ToList <VehicleSaleMasterVM>(dt);
}
json = Serializer.Serialize(lst);
}
catch (Exception ex)
{
//throw;
}
return(json);
}
//string CCon = ConfigurationManager.AppSettings["ConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
CrystalReportViewer1.DisplayGroupTree = false;
RD = new ReportDocument();
ReportID = Request.QueryString["ReportID"];
if (ReportID == "PartItemLedger")
{
string StrToDateFrom = "", StrDateTo = "";
RD = new ReportDocument();
dsrpt = new DataSet1();
// PartItemLedger.sp_ItemStockLedger_select.Load(ds.CreateDataReader());
DataSet ds = new DataSet();
//DataSet ds1 = new DataSet();
StrToDateFrom = Request.QueryString["FromDate"];
StrDateTo = Request.QueryString["ToDate"];
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@ToPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@OpeningDate", SqlDbType.VarChar, 10), //0
new SqlParameter("@ToDate", SqlDbType.VarChar, 10), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = Request.QueryString["FromCode"].ToString();
param[2].Value = Request.QueryString["ToCode"].ToString();
param[3].Value = Convert.ToDateTime(StrToDateFrom).ToString("yyyy-MM-dd");
param[4].Value = Convert.ToDateTime(StrDateTo).ToString("yyyy-MM-dd");
ObjSysFunc.ExecuteSP_NonQuery("sp_PartItemLedger", param);
ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.Text, "sp_tempItemStockLedger_Select '" + Session["DealerCode"].ToString() + "'");
//dsrpt.sp_tempItemStockLedger_Select.Load(ds.CreateDataReader());
RD.Load(base.Server.MapPath("rptItemStockLedger.rpt"));
//RD.Load(base.Server.MapPath("rptLedger.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["UserID"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["FromDate"].ToString()).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(Request.QueryString["ToDate"].ToString()).ToString("dd/MM/yyyy") + "\"";
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["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "ITEM STOCK LEDGER REPORT" + "\"";
RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'";
// RD.SetDataSource(dsrpt.sp_tempItemStockLedger_Select.DataSet);
}
CrystalReportViewer1.ReportSource = RD;
}
public bool ExecuteQuery_NonQuery(string strQuery)
{
bool flag;
try
{
StrCCon = CConnection.GetConnectionString();
SqlHelper.ExecuteNonQuery(StrCCon, CommandType.Text, strQuery);
flag = true;
}
catch (Exception exception)
{
flag = false;
throw exception;
}
return(flag);
}
public bool ExecuteSP_NonQuery(string SP_Name, SqlParameter[] param)
{
bool flag;
try
{
//GetConnection().toString;
StrCCon = CConnection.GetConnectionString();
SqlHelper.ExecuteNonQuery(StrCCon, CommandType.StoredProcedure, SP_Name, param);
flag = true;
}
catch (Exception exception)
{
flag = false;
throw exception;
}
return(flag);
}
public bool ExecuteSP(string SP_Name, SqlParameter[] param, ref SqlDataReader dr)
{
bool flag;
try
{
StrCCon = CConnection.GetConnectionString();
dr = SqlHelper.ExecuteReader(StrCCon, SP_Name, param);
if (dr.HasRows)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception ex) { throw ex; }
return(flag);
}
/* new methods starts general methods */
public DataTable GetData(string SQL)
{
try
{
if (StrCCon == String.Empty)
{
StrCCon = CConnection.GetConnectionString();
}
SqlDataAdapter dta = new SqlDataAdapter(SQL, StrCCon);
DataTable dt = new DataTable();
dta.Fill(dt);
return(dt);
}
catch (Exception e)
{
//GlobalVar.mErrorMessage = " Cretical connection Error cant continue ,please contact with concern person \n" + e.Message;
return(null);
}
}
public bool ExecuteQuery(string sQuery, ref SqlDataReader dr)
{
bool flag;
try
{
StrCCon = CConnection.GetConnectionString();
dr = SqlHelper.ExecuteReader(StrCCon, CommandType.Text, sQuery);
if (dr.HasRows)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception exception) { throw exception; }
return(flag);
}
public static bool Insert_Service(ServiceVM model)
{
try
{
if (string.IsNullOrEmpty(model.VehExpCode))
{
//strAutoCode = sysfun.GetNewMaxID("UCS_Buying", "BuyingCode", 8, dealerCode);
strAutoCode = sysfun.GetNewMaxID("VehExpHead", "VehExpCode", 5, model.DealerCode);
}
else
{
strAutoCode = model.VehExpCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", "COMON"), //0
new SqlParameter("@VehExpCode", strAutoCode), //1
new SqlParameter("@VehExpDesc", model.VehExpDesc), //2
new SqlParameter("@DefaultValue", model.DefaultValue), //2
new SqlParameter("@AccountCode", model.AccountCode), //2
new SqlParameter("@UpdUser", AuthBase.UserId), //3
new SqlParameter("@UpdTerm", General.CurrentIP) //4
};
dt = DataAccess.getDataTable("Sp_Insert_Service", param, CConnection.GetConnectionString());
if (dt.Rows.Count > 0)
{
}
IsSaved = true;
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (txtGatePassCode.Text == "")
{
sysfun.UserMsg(lblMessage, Color.Green, "Please Select GatePass ");
return;
}
if (!sec.UserRight("2590", "004"))
{
Response.Redirect("~/Test.aspx");
}
string CCon = CConnection.GetConnectionString();
SqlDataAdapter dta = new SqlDataAdapter("Select Post from GatePassTemp where CompCode='" + Session["DealerCode"].ToString() + "' and GatePassCode='" + txtGatePassCode.Text + "' and DelFlag<>'Y' ", CCon);
DataTable dt = new DataTable();
dta.Fill(dt);
if (dt.Rows.Count > 0)
{
string Postflag = dt.Rows[0]["Post"].ToString();
if (Postflag == "Y")
{
sysfun.UserMsg(lblMessage, Color.Red, "GatePass Can't Be Edit or Delete. . .! It is Already Posted. ");
return;
}
}
string sql = "Update GatePassTemp set DelFlag='Y' where GatePassCode='" + txtGatePassCode.Text + "'";
if (sysfun.ExecuteQuery_NonQuery(sql))
{
sysfun.UserMsg(lblMessage, Color.Green, "GatePass Deleted");
}
}
protected void BtnPrint_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2550", "006"))
{
Response.Redirect("~/Test.aspx");
}
if (ddlSRNO.SelectedIndex == 0)
{
SysFunc.UserMsg(LbErr, Color.Red, "Select Sales Return number first ");
return;
}
else
{
LbErr.Text = "";
}
ReportDocument RD;
Data.DSReports dsRpt1 = new Data.DSReports();
RD = new ReportDocument();
DataSet ds = new DataSet();
ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.Text, "sp_SaleReturn_Report '" + Session["DealerCode"].ToString() + "', '" + ddlSRNO.SelectedValue.ToString().Trim() + "'");
dsRpt1.sp_SaleReturn_Report.Load(ds.CreateDataReader());
RD.Load(Server.MapPath("../SpareReports/rptSaleReturnReport.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["UserID"].Text = "'" + Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(FromDate).ToString("dd/MM/yyyy") + "\"";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(ToDate).ToString("dd/MM/yyyy") + "\"";
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["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "SALES RETURN" + "\"";
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["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.SetDataSource(dsrpt.sp_tempItemStockLedger_Select.DataSet);
RD.SetDataSource(dsRpt1);
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();
RD.Dispose(); RD.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);
//CrystalReportViewer1.ReportSource = RD;
//Session["RDSpare"] = RD;
//RD.Database.Tables[0].SetDataSource(objDsReports);
// crReportDocument = new ReportDocument();
// crReportDocument = RD; // (ReportDocument)Session["RDSpare"];
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "SalesReturn" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//Session["RD"] = RD;
//string URL;
//URL = "../../../../Download/rptViewerService.aspx?FileName=" + FileName;
////URL = FilePath + "OpenPdf.aspx?FileName=" + FileName;
////txtPartItemDesc.Text = URL;
//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 btnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlGType.SelectedValue == "0")
{
sysfun.UserMsg(lblMessage, Color.Red, "Please Select GatePass Type First!", txtRegNo);
}
if (ddlModule.SelectedValue == "0")
{
sysfun.UserMsg(lblMessage, Color.Red, "Please Select Trans Type First!", txtRegNo);
}
if (txtGatePassCode.Text == "")
{
if (!sec.UserRight("2590", "002"))
{
Response.Redirect("~/Test.aspx");
}
Autostr = myFunc.AutoGen("GatePassTemp", "GatePassCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"));
}
else
{
if (!sec.UserRight("2590", "003"))
{
Response.Redirect("~/Test.aspx");
}
Autostr = txtGatePassCode.Text;
string CCon = CConnection.GetConnectionString();
SqlDataAdapter dta = new SqlDataAdapter("Select Post from GatePassTemp where CompCode='" + Session["DealerCode"].ToString() + "' and GatePassCode='" + txtGatePassCode.Text + "' and DelFlag<>'Y' ", CCon);
DataTable dt = new DataTable();
dta.Fill(dt);
if (dt.Rows.Count > 0)
{
string Postflag = dt.Rows[0]["Post"].ToString();
if (Postflag == "Y")
{
sysfun.UserMsg(lblMessage, Color.Red, "GatePass Can't Be Edit or Delete. . .! It is Already Posted. ");
return;
}
}
}
SqlParameter[] GatePass_param =
{
/*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5),
/*1*/ new SqlParameter("@GatePassCode", SqlDbType.Char, 8),
/*2*/ new SqlParameter("@GatePassDate", SqlDbType.DateTime),
/*4*/ new SqlParameter("@TransCode", SqlDbType.VarChar, 8),
/*3*/ new SqlParameter("@GatePassType", SqlDbType.Char, 1),
/*4*/ new SqlParameter("@Remarks", SqlDbType.Char, 100),
/*6*/ new SqlParameter("@Module", SqlDbType.VarChar, 50),
/*7*/ new SqlParameter("@UpdUser", SqlDbType.Char, 50),
/*8*/ new SqlParameter("@UpdTerm", SqlDbType.Char, 50),
/*9*/ new SqlParameter("@DelFlag", SqlDbType.Char, 1),
/*10*/ new SqlParameter("@InvoiceNo", SqlDbType.VarChar, 8),
/*11*/ new SqlParameter("@InDate", SqlDbType.DateTime),
/*12*/ new SqlParameter("@InTime", SqlDbType.DateTime),
/*13*/ new SqlParameter("@OutDate", SqlDbType.DateTime),
/*14*/ new SqlParameter("@OutTime", SqlDbType.DateTime),
};
GatePass_param[0].Value = Session["DealerCode"].ToString();
GatePass_param[1].Value = Autostr;
GatePass_param[2].Value = sysfun.SaveDate(txtGatePassDate.Text);
GatePass_param[3].Value = "";
GatePass_param[4].Value = ddlGType.SelectedValue;
GatePass_param[5].Value = txtRemarks.Text;
GatePass_param[6].Value = ddlModule.SelectedValue;
GatePass_param[7].Value = Session["UserName"].ToString();
GatePass_param[8].Value = GlobalVar.mUserIPAddress;
GatePass_param[9].Value = "N";
GatePass_param[10].Value = "";
GatePass_param[11].Value = sysfun.SaveDate(txtInDate.Text);
GatePass_param[12].Value = Convert.ToDateTime(txtInTime.Text).ToString("HH:mm");
GatePass_param[13].Value = sysfun.SaveDate(txtOutDate.Text);
GatePass_param[14].Value = Convert.ToDateTime(txtOutTime.Text).ToString("HH:mm");;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (txtGatePassCode.Text == "")
{
if (myFunc.ExecuteSP_NonQuery("[Sp_Insert_GatePassTemp_GPForm]", GatePass_param, Trans))
{
bool a = (rowsInVehicle(gvVehicle) == true ? Inser_JobCardDetail() : false);
}
}
else
{
if (myFunc.ExecuteSP_NonQuery("[Sp_Insert_GatePassTemp_GPForm]", GatePass_param, Trans))
{
bool a = (rowsInVehicle(gvVehicle) == true ? Inser_JobCardDetail() : false);
}
}
}
if (ObjTrans.CommittTransaction(ref Trans) == true)
{
lblMessage.ForeColor = Color.Green;
if (txtGatePassCode.Text.Trim() == "") //ddlJobCardCode.SelectedIndex
{
lblMessage.Text = "Record Saved Successfully: " + Autostr;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true);
}
else
{
lblMessage.Text = "Record Updated Successfully: " + Autostr;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true);
}
}
else
{
ObjTrans.RollBackTransaction(ref Trans);
sysfun.UserMsg(lblMessage, Color.Red, "Record not saved Try again. Or contact to support team ");
}
ClearGatePassTextBoxes();
}
catch (Exception ex)
{
sysfun.UserMsg(lblMessage, Color.Red, ex.Message, txtGatePassCode);
}
}
protected void btnPrint_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2590", "006"))
{
Response.Redirect("~/Test.aspx");
}
ReportDocument rpt, crReportDocument, RD;
PdfDocument outputDocument = new PdfDocument();
string strCriteria, rptTitle;
DateTime FromDate, ToDate;
SqlDataReader rder;
SysFunctions myFunc = new SysFunctions();
Data.DSReports DSReports = new Data.DSReports();
RD = new ReportDocument();
string CCon = CConnection.GetConnectionString();
// PartItemLedger.sp_ItemStockLedger_select.Load(ds.CreateDataReader());
DataSet ds = new DataSet();
//if (txtTransCode.Text.Trim() != "")
//{
// ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_GatePassMaster_Print '" + this.Session["DealerCode"].ToString() + "','" + txtGatePassCode.Text + "'");
//}
//else
//{
// ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_W2_GatePass_VehicleDetail_Select '" + this.Session["DealerCode"].ToString() + "','" + txtGatePassCode.Text + "'");
//}
// QRCodeEncoder encoder = new QRCodeEncoder();
// Bitmap bi = encoder.Encode(ds.Tables[0].Rows[0]["DealerCode"].ToString() + "" + ds.Tables[0].Rows[0]["JobCardCode"].ToString());
// bi.SetPixel(10, 10, Color.Red);
// bi.Save(Server.MapPath("~/Images/QrCode.jpg"), System.Drawing.Imaging.ImageFormat.Jpeg);
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "_sp_GatePassTempForm '" + this.Session["DealerCode"].ToString() + "','" + txtGatePassCode.Text + "'");
DSReports.EnforceConstraints = false;
DSReports._sp_GatePassTempForm.Load(ds.CreateDataReader());
string FileRptPath = Server.MapPath("~/Modules/Service/ServiceReports/");
RD.Load(Server.MapPath("~/Modules/Service/ServiceReports/rptGatePassForm.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 = "'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.DataDefinition.FormulaFields["QRCode"].Text = "'" + Server.MapPath("~") + "/Images/QrCode.jpg'";
//DataTable dt = new DataTable();
//string sql = "Select Logo from Dealer where DealerCode = '" + Session["DealerCode"].ToString() + "'";
//dt = myFunc.GetData(sql);
//RD.DataDefinition.FormulaFields["Logo"].Text = "'"+dt.Rows[0]["Logo"].ToString()+"'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
// CrystalReportViewer1.ReportSource = rpt;
RD.SetDataSource(DSReports.sp_JobCardMaster_Print.DataSet);
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["UserName"] == null)
{
Response.Redirect("~/Main/login.aspx");
}
rpt = new ReportDocument();
String StrReportID, Type;
Type = Request.QueryString["Type"];
StrReportID = Request.QueryString["ReportID"];
if (StrReportID == "PaymentReceiptReport")
{
rpt.Load(Server.MapPath("rptPaymentReceiptPrint.rpt"));
strCriteria = "{PaymentReceiptMaster.ReceiptNo}='" + Request.QueryString["ReceiptNo"] + "' " +
"AND {PaymentReceiptMaster.DealerCode}='" + Session["DealerCode"].ToString() + "' " +
"AND {PaymentReceiptMaster.DelFlag} = 'N' ";
//rpt.RecordSelectionFormula = strCriteria;
rpt.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
rpt.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
rpt.DataDefinition.FormulaFields["ReportTitle"].Text = "'Payment Receipt'";
rpt.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'";
rpt.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
rpt.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
rpt.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + grl.GetStringValuesAgainstCodes("CusCode", SessionInformation.LoginID, "CellNo", "Customer") + "'";
// CrystalReportViewer1.ReportSource = rpt;
}
if (StrReportID == "CustomerEstimate")
{
//ReportDocument RD;
//string strCriteria, rptTitle;
//DateTime FromDate, ToDate;
//SqlDataReader rder;
//CustEstimateCode
SysFunctions myFunc = new SysFunctions();
Data.DSReports DsRpt = new Data.DSReports();
//DataSet1 dsRpt1 = new DataSet1();
SqlDataReader rder = null;
rpt = new ReportDocument();
string CCon = CConnection.GetConnectionString();
DataSet ds = new DataSet();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char), //0
new SqlParameter("@CustomerEstimateCode", SqlDbType.Char), //1
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = Request.QueryString["CustEstimateCode"].ToString();
DsRpt.EnforceConstraints = false;
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateMaster_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'");
DsRpt.sp_CustomerEstimateMaster_Print.Load(ds.CreateDataReader());
DsRpt.EnforceConstraints = false;
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateDetail_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'");
DsRpt.sp_CustomerEstimateDetail_Print.Load(ds.CreateDataReader());
DsRpt.EnforceConstraints = false;
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateDetailSup_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'");
DsRpt.sp_CustomerEstimateDetailSup_Print.Load(ds.CreateDataReader());
DsRpt.EnforceConstraints = false;
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateLubricates_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'");
DsRpt.sp_CustomerEstimateLubricates_Print.Load(ds.CreateDataReader());
DsRpt.EnforceConstraints = false;
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateLubricatesSup_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'");
DsRpt.sp_CustomerEstimateLubricatesSup_Print.Load(ds.CreateDataReader());
DsRpt.EnforceConstraints = false;
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimateParts_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'");
DsRpt.sp_CustomerEstimateParts_Print.Load(ds.CreateDataReader());
DsRpt.EnforceConstraints = false;
ds = SqlHelper.ExecuteDataset(CCon, CommandType.Text, "sp_CustomerEstimatePartsSup_Print '" + this.Session["DealerCode"].ToString() + "','" + Request.QueryString["CustEstimateCode"].ToString() + "'");
DsRpt.sp_CustomerEstimatePartsSup_Print.Load(ds.CreateDataReader());
DsRpt.EnforceConstraints = false;
myFunc.ExecuteSP("sp_CustomerEstimateBoutParts_Print", param, ref rder);
DsRpt.sp_CustomerEstimateBoutParts_Print.Load(rder);
DsRpt.EnforceConstraints = false;
myFunc.ExecuteSP("sp_EstimateSubletDetail_Print", param, ref rder);
DsRpt.sp_JobCardSubletDetail_Print.Load(rder);
rpt.Load(Server.MapPath("~/Modules/Service/ServiceReports/rptCustomerEstimatePrint.rpt"));
rpt.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
rpt.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
rpt.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
rpt.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
if (Type == "Insurance")
{
rpt.DataDefinition.FormulaFields["ReportTitle"].Text = "'Insurance Estimate'";
}
else
{
rpt.DataDefinition.FormulaFields["ReportTitle"].Text = "'Customer Estimate'";
}
rpt.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
rpt.DataDefinition.FormulaFields["UserId"].Text = "'" + Session["UserName"].ToString() + "'";
rpt.DataDefinition.FormulaFields["NTN"].Text = "'N.T.N # " + Session["DealerNTN"].ToString() + "'";
rpt.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'Sales Tax No. " + Session["DealerSaleTaxNo"].ToString() + " '";
//rpt.DataDefinition.FormulaFields["UserCell"].Text = "'" + GetStringValuesAgainstCodes("CusCode", , "CellNo", "Customer") + "'";
rpt.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
rpt.Database.Tables[0].SetDataSource(DsRpt);
//CrystalReportViewer1.ReportSource = rpt;
// rpt.SetDataSource(DsRpt.sp_CustomerEstimateMaster_Print.DataSet);
Session["RDService"] = rpt;
}
else
{
rpt = (ReportDocument)Session["RD"];
}
//var connectionInfo = new ConnectionInfo();
//connectionInfo.ServerName = "localhost";
//connectionInfo.DatabaseName = "BMS";
//connectionInfo.Password = "******";
//connectionInfo.UserID = "sa";
//connectionInfo.Type = ConnectionInfoType.SQL;
//connectionInfo.IntegratedSecurity = false;
//for (int i = 0; i < CrystalReportViewer1.LogOnInfo.Count; i++)
//{
// CrystalReportViewer1.LogOnInfo[i].ConnectionInfo = connectionInfo;
//}
//if (Environment.MachineName == "AZHARDELL")
//{
// rpt.SetDatabaseLogon("sa", "100372", "localhost", "BMS");
//}
//else
//{
// rpt.SetDatabaseLogon("sa", "tiger", "akramali-pc", "BMS");
//}
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = "Report.pdf";
string File = FilePath + FileName;
PdfDocument outputDocument = new PdfDocument();
Stream stream = rpt.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();
rpt.Dispose(); rpt.Close();
Session["RDService"] = rpt;
string embed = "<object data=\"{0}\" type=\"application/pdf\" width=\"1000px\" height=\"800px\">";
embed += "If you are unable to view file, you can download from <a href = \"{0}\">here</a>";
embed += " or download <a target = \"_blank\" href = \"http://get.adobe.com/reader/\">Adobe PDF Reader</a> to view the file.";
embed += "</object>";
ltEmbed.Text = string.Format(embed, ResolveUrl("~/Download/Report.pdf"));
//CrystalReportViewer1.ReportSource = rpt;
//CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
}
//protected void ddlFromCode_SelectedIndexChanged(object sender, EventArgs e)
//{
// ddlToCode.SelectedValue = ddlFromCode.SelectedValue;
//}
protected void btnPrint_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2574", "006"))
{
Response.Redirect("~/Test.aspx");
}
if (txtFromItemCode.Text == "")
{
//ObjGenral.UserMsg(lblMsg, Color.Red, "Please Select From Code ");
//ddlFromCode.Focus();
return;
}
if (txtToItemCode.Text == "")
{
//ObjGenral.UserMsg(lblMsg, Color.Red, "Please Select To Code ");
//ddlToCode.Focus();
return;
}
ReportDocument RD;
ReportDocument crReportDocument;
ReportDocument rpt;
SqlDataReader rder;
string ReportID = "";
DXBMS.Data.DataSet1 dsrpt;
SysFunctions ObjSysFunc = new SysFunctions();
string FromDate = txtFromDate.Text.Substring(6, 4) + "/" + txtFromDate.Text.Substring(3, 2) + "/" + txtFromDate.Text.Substring(0, 2);
string ToDate = txtToDate.Text.Substring(6, 4) + "/" + txtToDate.Text.Substring(3, 2) + "/" + txtToDate.Text.Substring(0, 2);
string RptName = "PartItemLedger";
RD = new ReportDocument();
string StrToDateFrom = "", StrDateTo = "";
RD = new ReportDocument();
dsrpt = new DXBMS.Data.DataSet1();
// PartItemLedger.sp_ItemStockLedger_select.Load(ds.CreateDataReader());
DataSet ds = new DataSet();
//DataSet ds1 = new DataSet();
StrToDateFrom = FromDate;
StrDateTo = ToDate;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@FromPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@ToPartCode", SqlDbType.VarChar, 50), //0
new SqlParameter("@OpeningDate", SqlDbType.VarChar, 10), //0
new SqlParameter("@ToDate", SqlDbType.VarChar, 10), //0
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtFromItemCode.Text;
param[2].Value = txtToItemCode.Text;
param[3].Value = Convert.ToDateTime(StrToDateFrom).ToString("yyyy-MM-dd");
param[4].Value = Convert.ToDateTime(StrDateTo).ToString("yyyy-MM-dd");
ObjSysFunc.ExecuteSP_NonQuery("sp_PartItemLedger", param);
ds = SqlHelper.ExecuteDataset(CConnection.GetConnectionString(), CommandType.Text, "sp_tempItemStockLedger_Select '" + Session["DealerCode"].ToString() + "'");
dsrpt.sp_tempItemStockLedger_Select.Load(ds.CreateDataReader());
//RD.Load(base.Server.MapPath("rptItemStockLedger.rpt"));
RD.Load(Server.MapPath("~/Modules/SpareParts/SpareReports/rptItemStockLedger.rpt"));
//RD.Load(Server.MapPath("~/Modules/Reports/rptStockLedgerNew.rpt"));
// //RD.Load(base.Server.MapPath("rptLedger.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["UserID"].Text = "'" + Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(FromDate).ToString("dd/MM/yyyy") + "\"";
RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(ToDate).ToString("dd/MM/yyyy") + "\"";
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["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "ITEM STOCK LEDGER REPORT" + "\"";
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["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
//RD.SetDataSource(dsrpt.sp_tempItemStockLedger_Select.DataSet);
RD.SetDataSource(dsrpt);
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);
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "PartItemLedger" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
////crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS");
//// ConnectionInfo conninfo = new ConnectionInfo();
//Session["RD"] = RD;
////RD.ExportToDisk(ExportFormatType.PortableDocFormat, File);
////crReportDocument.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);
}
