private void LoadGrid(string DCNumber, string PONumber, string DealerCode)
{
DataTable dtParts = new DataTable();
DataTable dt = new DataTable();
DataSet dsParts = new DataSet();
SqlDataReader dr = null;
string mPONo = "";
string mDCNo = "";
if (PONumber == "")
{
mPONo = Session["PONumber"].ToString();
}
else
{
mPONo = PONumber;
}
if (DCNumber == "")
{
mDCNo = Session["DCNumber"].ToString();
}
else
{
mDCNo = DCNumber;
}
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@PONO", SqlDbType.Char, 10)
};
param[0].Value = this.Session["DealerCode"].ToString();
param[1].Value = mPONo;
myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr);
dtParts.Load(dr);
//ds = (DataSet)ViewState["ObjPOds"];
dt = (DataTable)this.Session["DCTable"];
dt.Rows.Clear();
if (dtParts.Rows.Count != 0)
{
foreach (DataRow dRow in dtParts.Rows)
{
SqlParameter[] paramPO_Parts =
{
new SqlParameter("@PONO", SqlDbType.Char, 10),
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@ItemCode", SqlDbType.Char, 10)
};
paramPO_Parts[0].Value = mPONo;
paramPO_Parts[1].Value = this.Session["DealerCode"].ToString();
paramPO_Parts[2].Value = dRow["ItemCode"].ToString();
dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo_New", paramPO_Parts);
DataRow row = dt.NewRow();
row["Sno"] = dt.Rows.Count + 1;
row["PartItemNo"] = dsParts.Tables[0].Rows[0]["PartItemNo"].ToString();
row["PartItemName"] = dsParts.Tables[0].Rows[0]["ItemDesc"].ToString();
row["unit"] = dsParts.Tables[0].Rows[0]["Unit"].ToString();
row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString();
row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
//row["Selected"] = true;
dt.Rows.Add(row);
}
}
Session["DCTable"] = dt;
gv_DC.DataSource = dt;
gv_DC.DataSourceID = null;
gv_DC.DataBind();
}
catch (Exception ex)
{
//ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo);
}
}
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;
}
private void AddNewRow()
{
SqlDataReader dr = null;
//DataSet ds = new DataSet();
DataTable dt = new DataTable();
//DropDownList ddlParts = (DropDownList)GvMain.FooterRow.FindControl("ddlParts");
//TextBox txtFooterQty = (TextBox)GvMain.FooterRow.FindControl("txtFooterQty");
SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@SIRNo", SqlDbType.Char, 8), };
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = ddlSirNo.SelectedValue.ToString();
SysFunc.ExecuteSP("Sp_SirDetail_Items_Select", param, ref dr);
if (dr.HasRows)
{
dt.Load(dr);
GvMain.DataSource = dt;
GvMain.DataBind();
}
else
{
createPartsDT();
}
//ds = (DataSet)Session["dsParts"];
//DataRow row = ds.Tables[0].NewRow();
//foreach (DataRow drTable in dt.Rows)
//{
// ////Get OH stock
// //DataSet dsOHStock = new DataSet();
// //dsOHStock = SysFunc.PartStock(drTable["ItemCode"].ToString(), Session["DealerCode"].ToString());
// //decimal DTotalStock = Convert.ToDecimal(dsOHStock.Tables[0].Rows[0]["Balance"]);
// ///////////////////////////////////////////////////////
// //Get Avg Cost
// DataSet dsAvgCost = new DataSet();
// decimal DAvgCost = 0;
// dsAvgCost = SysFunc.ItemAvgCost(drTable["ItemCode"].ToString(), Session["DealerCode"].ToString());
// if (dsAvgCost.Tables[0].Rows.Count != 0)
// {
// DAvgCost = Convert.ToDecimal(dsAvgCost.Tables[0].Rows[0]["Cost"]);
// }
// //////////////////////////////////////////////////////
// row["ItemCode"] = drTable["ItemCode"].ToString();
// row["PartItemNo"] = drTable["PartItemNo"].ToString();
// row["ItemDesc"] = drTable["ItemDesc"].ToString();
// row["Location"] = drTable["Location"].ToString();
// row["Quantity"] = drTable["Quantity"].ToString();
// row["BalQty"] = drTable["BalQty"].ToString();
// //row["OHStock"] = "0";
// row["OLStock"] = "0";
// row["AvgCost"] = DAvgCost.ToString();
// row["Amount"] = "0";
// ds.Tables[0].Rows.Add(row);
//}
//GvMain.DataSource = dt;
//GvMain.DataBind();
//Session["dsParts"] = ds;
//////////////////////
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session["UserName"] == null)
{
Response.Redirect("~/Main/login.aspx");
}
RD = new ReportDocument();
ReportID = Request.QueryString["ReportID"];
if (ReportID == "GSTInvoiceCounterSale")
{
SqlParameter[] param =
{
new SqlParameter("@SaleInvNo", SqlDbType.Char, 10),
new SqlParameter("@dealerCode", SqlDbType.Char, 10)
};
param[0].Value = Request.QueryString["CounterNo"];
param[1].Value = Session["DealerCode"].ToString();
dsRpt = myFunc.SP_Spare_Get_rptGSTInvoiceCounterSale(param);
RD.Load(Server.MapPath("~/Modules/Reports/SpareReports/rptGSTInvoiceCounterSale.rpt"));
}
if (ReportID == "PartStock")
{
string ReportIDStock = "";
ReportIDStock = Request.QueryString["abc"];
//ReportDocument RD = new ReportDocument();
DataSet dsRpt = new DataSet();
//DataSet objDsReports = new DataSet();
DataSetPartStockReport objDSReports = new DataSetPartStockReport();
//DSReports objDsReports = new DSReports();
//DSReports objDsReports = new DSReports();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@Param", SqlDbType.VarChar, 20), //0
};
param[0].Value = this.Session["DealerCode"].ToString();
//param[1].Value = ReportIDStock;
param[1].Value = "--Select--";
//ds = myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param);
if (myFunc.ExecuteSP("sp_PartsStockSourceWiseNew", param, ref rder))
{
objDSReports.sp_PartsStockSourceWiseNew.Load(rder);
}
// if (myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param))
// {
// //objDsReports.sp_PartsStockSourceWiseNew.Load(rder);
// objDSReports.sp_PartsStockSourceWiseNew.Load(rder);
// //rder.Close();
// objDSReports = myFunc.FillDataSet("sp_PartsStockSourceWiseNew", param);
// objDsReports = myFunc.FillDataSet("sp_PartsStockSourceWiseNew", param);
// sql = "exec sp_PartsStockSourceWiseNew '00001','--Select--'";
// dt = myFunc.GetData(sql);
// int tr = dt.Rows.Count;
////W:\Work\imran suhail\BMS\DXBMS\DXBMS\Modules\Reports\SpareReports\rptPartsStockStatusNew.rpt
////W:\Work\imran suhail\BMS\DXBMS\DXBMS\Modules\Criteria\POView.aspx
// }
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Load(Server.MapPath("~/Modules/Reports/SpareReports/rptPartsStockStatusNew.rpt"));
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + this.Session["UserName"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + Request.QueryString["FrmDate"].ToString() + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + Request.QueryString["ToDate"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "C.I Standard Report" + "\"";
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].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.Database.Tables[0].SetDataSource(objDSReports);
//RD.Database.Tables[0].SetDataSource(dt);
//CrystalReportViewer1.ReportSource = RD;
//RD.Database.Tables[0].SetDataSource(objDsReports);
}
CrystalReportViewer1.ReportSource = RD;
//CrystalReportViewer1.ShowFirstPage();
var connectionInfo = new ConnectionInfo();
connectionInfo.ServerName = "AZHARDELL";
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;
}
Session["RDSpare"] = RD;
//crReportDocument = new ReportDocument();
//crReportDocument = (ReportDocument)Session["RDSpare"];
//CrystalReportViewer1.ReportSource = crReportDocument;
}
/// <summary>
/// Will work after load JobCard or Invoice Data ddl
/// </summary>
private void DisplayItem()
{
string SIRNo = string.Empty;
DataSet dsAvg = new DataSet();
try
{
SqlDataReader dr = null;
txtItemCode.Text = ddlParts.SelectedValue.ToString().Trim();
if (rdCounterSale.Checked)
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@IssueNo", SqlDbType.Char, 8),
new SqlParameter("@ItemCode", SqlDbType.Char, 8),
new SqlParameter("@SaleInvNo", SqlDbType.Char, 8)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtIssueNo.Text.Trim();
param[2].Value = txtItemCode.Text.Trim();
param[3].Value = ddlSaleInvNo.SelectedValue.ToString();
SysFunc.ExecuteSP("sp_Part_Info_SalesReturn_CS", param, ref dr);
if (dr.HasRows)
{
dr.Read();
txtLocCode.Text = dr["PartsTransLocCode"].ToString();
txtLocDesc.Text = dr["PartsTransLocDesc"].ToString();
txtRate.Text = dr["Rate"].ToString();
txtInvQuantity.Text = dr["IssueQty"].ToString();
txtUnitCode.Text = dr["UnitCode"].ToString();
txtUnit.Text = dr["UnitDesc"].ToString();
txtAvgCost.Text = dr["AvgCost"].ToString();
txtRemainingQty.Text = dr["Remaining_Qty"].ToString();
}
}
else if (rdJobCard.Checked)
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5),
new SqlParameter("@IssueNo", SqlDbType.Char, 8),
new SqlParameter("@ItemCode", SqlDbType.Char, 8),
new SqlParameter("@JobCardCode", SqlDbType.Char, 8)
};
param[0].Value = Session["DealerCode"].ToString();
param[1].Value = txtIssueNo.Text.Trim();
param[2].Value = txtItemCode.Text.Trim();
param[3].Value = ddlSaleInvNo.SelectedValue.ToString();
SysFunc.ExecuteSP("sp_Part_Info_SalesReturn_JC", param, ref dr);
if (dr.HasRows)
{
dr.Read();
txtLocCode.Text = dr["PartsTransLocCode"].ToString();
txtLocDesc.Text = dr["PartsTransLocDesc"].ToString();
txtRate.Text = dr["Price"].ToString();
txtInvQuantity.Text = dr["IssueQty"].ToString();
txtUnitCode.Text = dr["UnitCode"].ToString();
txtUnit.Text = dr["UnitDesc"].ToString();
txtAvgCost.Text = dr["AvgCost"].ToString();
txtRemainingQty.Text = dr["Remaining_Qty"].ToString();
}
}
}
catch (Exception ex)
{
LbErr.Text = ex.Message;
}
}
protected void PrintReport(string sp_Name, string ReportTitle, string ReportName)
{
RD = new ReportDocument();
ReportID = "PartStock";
string ReportIDStock = "";
//ReportIDStock = Request.QueryString["abc"];
ReportIDStock = radioItemType.SelectedItem.Value.ToString();
DataSet dsRpt = new DataSet();
DataSetPartStockReport objDSReports = new DataSetPartStockReport();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@Param", SqlDbType.VarChar, 20), //0
new SqlParameter("@FromPartItemNo", SqlDbType.VarChar, 20),
new SqlParameter("@ToPartItemNo", SqlDbType.VarChar, 20)
};
param[0].Value = this.Session["DealerCode"].ToString();
//param[1].Value = ReportIDStock;
param[1].Value = ReportIDStock;
if (!chkAllItem.Checked)
{
//param[2].Value = ddlFromCode.SelectedValue;
//param[3].Value = ddlToCode.SelectedValue;
param[2].Value = txtFromItemcode.Text;
param[3].Value = txtToItemcode.Text;
}
else
{
param[2].Value = "";
param[3].Value = "Z";
}
//ds = myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param);
if (myFunc.ExecuteSP(sp_Name, param, ref rder))
{
objDSReports.sp_PartsStockSourceWiseNew.Load(rder);
}
else
{
lblErr.Text = "No record found!";
return;
}
rder.Close();
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
RD.Load(Server.MapPath("../" + ReportName + ".rpt"));
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + this.Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + GlobalVar.mUserIPAddress + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + Request.QueryString["FrmDate"].ToString() + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + Request.QueryString["ToDate"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + ReportTitle + "\"";
RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
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.Database.Tables[0].SetDataSource(objDSReports);
Session["RD"] = RD;
//RD.Database.Tables[0].SetDataSource(objDsReports);
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);
//crReportDocument = new ReportDocument();
//crReportDocument = (ReportDocument)Session["RDSpare"];
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = Request.QueryString["ReportID"] + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
////crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS");
////crReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, File);
//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 PrintReport(string sp_Name, string ReportTitle, string ReportName)
{
RD = new ReportDocument();
ReportID = "PartStock";
string ReportIDStock = "";
//ReportIDStock = Request.QueryString["abc"];
ReportIDStock = radioItemType.SelectedItem.Value.ToString();
DataSet dsRpt = new DataSet();
DataSetPartStockReport objDSReports = new DataSetPartStockReport();
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0
new SqlParameter("@Param", SqlDbType.VarChar, 20), //0
new SqlParameter("@@FromPartItemNo", SqlDbType.VarChar, 20),
new SqlParameter("@@ToPartItemNo", SqlDbType.VarChar, 20)
};
param[0].Value = this.Session["DealerCode"].ToString();
//param[1].Value = ReportIDStock;
param[1].Value = ReportIDStock;
if (!chkAllItem.Checked)
{
param[2].Value = glFromItemPartNo.Text;
param[3].Value = glToItemPartNo.Text;
}
else
{
param[2].Value = "";
param[3].Value = "Z";
}
//ds = myFunc.ExecuteSP_NonQuery("sp_PartsStockSourceWiseNew", param);
if (myFunc.ExecuteSP(sp_Name, param, ref rder))
{
objDSReports.sp_PartsStockSourceWiseNew.Load(rder);
}
else
{
lblErr.Text = "No record found!";
return;
}
RD.PrintOptions.PaperSize = PaperSize.PaperA4;
//RD.Load(Server.MapPath("~/Modules/Reports/SpareReports/rptPartsStockStatusNew.rpt"));
//txtPartItemDesc.Text = Server.MapPath("~/Modules/Reports/SpareReports/rptPartsStockStatusNew.rpt");
//return;
RD.Load(Server.MapPath("../" + ReportName + ".rpt"));
RD.DataDefinition.FormulaFields["UserID"].Text = "'" + this.Session["UserName"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + GlobalVar.mUserIPAddress + "'";
RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'";
RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'";
//RD.DataDefinition.FormulaFields["FromDate"].Text = "'" + Request.QueryString["FrmDate"].ToString() + "'";
//RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + Request.QueryString["ToDate"].ToString() + "'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + ReportTitle + "\"";
RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'";
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["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
RD.Database.Tables[0].SetDataSource(objDSReports);
//RD.Database.Tables[0].SetDataSource(dt);
//CrystalReportViewer1.ReportSource = RD;
//CrystalReportViewer1.ReportSource = RD;
////CrystalReportViewer1.ShowFirstPage();
//var connectionInfo = new ConnectionInfo();
//connectionInfo.ServerName = "AZHARDELL";
//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;
//}
Session["RDSpare"] = RD;
//RD.Database.Tables[0].SetDataSource(objDsReports);
crReportDocument = new ReportDocument();
crReportDocument = (ReportDocument)Session["RDSpare"];
string FilePath = Server.MapPath("~") + "\\Download\\";
string FileName = Request.QueryString["ReportID"] + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
string File = FilePath + FileName;
//crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS");
crReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, File);
string URL;
URL = "../../../../Download/OpenPdf.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);
}
private void LoadGrid(string DCNumber, string PONumber, string DealerCode)
{
DataTable dtParts = new DataTable();
DataSet ds = new DataSet();
DataSet dsParts = new DataSet();
SqlDataReader dr = null;
string mPONo = "";
string mDCNo = "";
if (PONumber == "")
{
mPONo = this.Session["PONumber"].ToString();
}
else
{
mPONo = PONumber;
}
//if (DCNumber == "")
//{
// mDCNo = this.Session["DCNumber"].ToString();
//}
//else
//{
// mDCNo = DCNumber;
//}
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@PONO", SqlDbType.Char, 10)
};
param[0].Value = this.Session["DealerCode"].ToString();
param[1].Value = mPONo;
myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr);
dtParts.Load(dr);
//ds = (DataSet)ViewState["ObjPOds"];
ds = (DataSet)this.Session["DCDataSet"];
ds.Tables["DCItems"].Rows.Clear();
if (dtParts.Rows.Count != 0)
{
foreach (DataRow dRow in dtParts.Rows)
{
SqlParameter[] paramPO_Parts =
{
new SqlParameter("@PONO", SqlDbType.Char, 10),
new SqlParameter("@DealerCode", SqlDbType.Char, 10),
new SqlParameter("@ItemCode", SqlDbType.Char, 10)
};
paramPO_Parts[0].Value = mPONo;
paramPO_Parts[1].Value = this.Session["DealerCode"].ToString();
paramPO_Parts[2].Value = dRow["ItemCode"].ToString();
dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo", paramPO_Parts);
DataRow row = ds.Tables["DCItems"].NewRow();
row["Sno"] = ds.Tables["DCItems"].Rows.Count + 1;
row["PartItemNo"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "PartItemNo", "Item");
row["PartItemName"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "ItemDesc", "Item");
row["unit"] = myFunc.GetStringValuesAgainstCodes("UnitCode='" + dRow["UnitCode"].ToString() + "'", "unit", "UnitDesc");
row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString();
row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
if (DCNumber == "")
{
row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString();
}
else
{
row["DCQuantity"] = myFunc.GetDCQty(DCNumber, dRow["ItemCode"].ToString());
}
row["Selected"] = true;
ds.Tables["DCItems"].Rows.Add(row);
}
//if (GridViewDC.VisibleRowCount > 0)
//{
// CheckBox chkSelect;
// TextBox txtDCQty;
// Label lblBalQty;
// foreach (GridViewRow gvr in GridViewDC.Rows)
// {
// chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect");
// txtDCQty = (TextBox)gvr.Cells[6].FindControl("txtDCQuantity");
// lblBalQty = (Label)gvr.Cells[5].FindControl("LbBalanceQuantity");
// chkSelect.Checked = true;
// txtDCQty.Text = lblBalQty.Text;
// //chkSelect.Enabled = false;
// }
//}
//txtVendorNo.Text = dsVendorInfo.Tables[0].Rows[0]["vendorCode"].ToString();
//txtVendorDesc.Text = dsVendorInfo.Tables[0].Rows[0]["vendorDesc"].ToString();
}
Session["DCDataSet"] = ds;
GridViewDC.DataSource = ds.Tables["DCItems"];
GridViewDC.DataSourceID = null;
GridViewDC.DataBind();
}
catch (Exception ex)
{
//ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo);
}
}
