public void BindGridView(int pageNo)
{
int pageSize = 15;
GDV.PageSize = pageSize;
try
{
string sQuery = "sp_GetProductByCustomPaging '" + pageNo + "','" + pageSize + "','" + Session["DealerCode"].ToString() + "', 'P'";
if (objMBL.ExecuteQuery(sQuery, ref ds))
{
Session["Parts"] = ds;
GDV.VirtualItemCount = Convert.ToInt32(ds.Tables[1].Rows[0]["Total"]);
GDV.DataSource = ds.Tables[0];
GDV.DataBind();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
}
}
protected void gv_PSF_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
DataSet ds_update = new DataSet();
TextBox txtComplain = (TextBox)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("txtComplain");
TextBox txtRemakrs = (TextBox)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("txtRemarks");
DropDownList ddlSatisfied = (DropDownList)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("ddl_Satisfied");
Label JobCode = (Label)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("lblJobCode");
Label TransType = (Label)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("lblTransType");
Label TransCode = (Label)grdPostServiceFollowup.Rows[e.RowIndex].FindControl("lblTransCode");
ds_update = (DataSet)Session["PostServiceFollowUp"];
//Uzair
foreach (DataRow dr in ds_update.Tables[0].Rows)
{
if (dr["JobCardCode"].ToString().Trim() == JobCode.Text.Trim())
{
dr["Complain"] = txtComplain.Text;
dr["Remarks"] = txtRemakrs.Text;
dr["Satisfied"] = ddlSatisfied.SelectedValue;
dr["FollowUpDate"] = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"));
}
}
grdPostServiceFollowup.EditIndex = -1;
grdPostServiceFollowup.DataSource = ds_update;
grdPostServiceFollowup.DataBind();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (TransType.Text == "JobCard")
{
string sql = "update CRM_Post_PostServiceFollowup set Satisfied = '" + ddlSatisfied.SelectedValue.ToString() + "', Remarks = '" + txtRemakrs.Text + "' , FollowUpDate ='" + sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")) + "'" +
", Complain = '" + txtComplain.Text + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' and TransCode = '" + TransCode.Text + "' ";
myFunc.ExecuteQuery(sql, Trans);
}
else if (TransType.Text == "Invoice")
{
string sql = "update CRM_Post_PostServiceFollowup set Satisfied = '" + ddlSatisfied.SelectedValue.ToString() + "', Remarks = '" + txtRemakrs.Text + "' , FollowUpDate ='" + sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")) + "'" +
", Complain = '" + txtComplain.Text + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' and JobCardCode = '" + JobCode.Text + "' ";
myFunc.ExecuteQuery(sql, Trans);
}
}
Session["PostServiceFollowUp"] = ds_update;
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
//ObjTrans.CommittTransaction(ref Trans);
ObjTrans.RollBackTransaction(ref Trans);
lblMessage.Visible = true;
lblMessage.Text = ex.Message;
}
}
private void Load_ddlParts()
{
string sQuery;
//string[] Columns = new string[] { "PartItemNo", "ItemDesc" };
//sysfunc.GetMultiColumnsDDL(ddlFailedPart, Columns, "Item", "DealerCode = '" + Session["DealerCode"].ToString() + "'", "PartItemNo", "", false, false);
//sysfunc.FillDropDown(ddlPart1, "select PartItemNo , ItemDesc from Item where DealerCode = '" + Session["DealerCode"].ToString() + "' ", "ItemDesc", "PartItemNo", "Select");
//sysfunc.FillDropDown(ddlPart2, "select PartItemNo , ItemDesc from Item where DealerCode = '" + Session["DealerCode"].ToString() + "' ", "ItemDesc", "PartItemNo", "Select");
//sysfunc.FillDropDown(ddlPart3, "select PartItemNo , ItemDesc from Item where DealerCode = '" + Session["DealerCode"].ToString() + "' ", "ItemDesc", "PartItemNo", "Select");
//sysfunc.FillDropDown(ddlPart4, "select PartItemNo , ItemDesc from Item where DealerCode = '" + Session["DealerCode"].ToString() + "' ", "ItemDesc", "PartItemNo", "Select");
try
{
if (Session["Parts"] == null)
{
sQuery = "SP_SelectParts '" + Session["DealerCode"].ToString() + "', 'P'";
if (sysfuncs.ExecuteQuery(sQuery, ref ds))
{
Session["Parts"] = ds;
}
}
}
catch (ThreadAbortException e)
{
//lblmessage.Text += "<br /> child thread - exception";
}
finally
{
//lblmessage.Text += "<br /> child thread - unable to catch the exception";
}
}
protected void btnWarSave_Click(object sender, EventArgs e)
{
DateTime TRDate = DateTime.ParseExact(txtTRDate.Text, "dd-MM-yyyy", null);
DateTime ApprovalDate = DateTime.ParseExact(txtAprovalDate.Text, "dd-MM-yyyy", null);
try
{
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
string sql = "update PPRMaster set TRNo = '" + txtTRNo.Text + "' , TRDate = '" + TRDate + "' , ApprovalNo = '" + txtAprovalNo.Text + "' , ApprovalDate = '" + ApprovalDate + "', ApprovalStatus = '" + ddlAppSt.SelectedValue.ToString().Trim() + "' , ComplainRemarks = '" + txtComplainRemarks.Text + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' And PPRCode = '" + ddlPRNo.SelectedValue.Trim() + "'";
sysFuncs.ExecuteQuery(sql, Trans);
}
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
lblMsg.Visible = true;
lblMsg.ForeColor = Color.Red;
lblMsg.Text = ex.Message;
}
ClearWarrantyTab();
}
protected void ddljob_category_SelectedIndexChanged(object sender, EventArgs e)
{
String sql = "select DefJobCode,DefJobDesc,LaborAccount,StandardTime,BayCode from DefaultJob where DealerCode in('" + Session["DealerCode"] + "','COMON') and JobCatCode = '" + ddljob_category.SelectedValue + "'";
SysFunctions sysFunc = new SysFunctions();
DataTable dt = new DataTable();
DataSet ds = new DataSet();
sysFunc.ExecuteQuery(sql, ref ds);
if (ds.Tables[0].Rows.Count > 0)
{
gv_labor.DataSource = ds;
gv_labor.DataBind();
Session["JobsDS"] = ds;
}
else
{
Create_Grid();
}
Session["LaborDS"] = ds;
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
if (myFunc.CodeExists("Customer", "DealerCode='" + Session["DealerCode"].ToString() + "' And CusCode='" + ddCustomerCode.Text + "' And NIC='" + txtNICNo.Text + "'", Session["DealerCode"].ToString()) == false)
{
string chkCNIC = string.Empty;
ds = new DataSet();
myFunc.ExecuteQuery("Select * From Customer Where DealerCode='" + Session["DealerCode"].ToString() + "' And CusCode<>'" + ddCustomerCode.Text + "'", ref ds);
if (ds.Tables[0].Rows.Count != 0)
{
//if (ds.Tables[0].Rows[0]["NIC"].ToString().Trim() != string.Empty)
//{
foreach (DataRow dtRow in ds.Tables[0].Rows)
{
if (dtRow["NIC"].ToString().Trim() != string.Empty)
{
if (dtRow["NIC"].ToString() == txtNICNo.Text.Trim())
{
//ObjGenral.UserMsg(lblMsg, Color.Red, "CNIC Number is already exist", txtNIC);
lblMSG.Text = txtNICNo.Text + " CNIC Number is already exist";
PopupControlMSG.ShowOnPageLoad = true;
chkCNIC = "Y";
break;
}
}
}
if (chkCNIC == "Y")
{
return;
}
// }
}
}
if (InsertCustomer())
{
if (ddCustomerCode.Text == "")
{
lblMSG.Text = "Customer add successfully (" + AutoGenCode + ")";
}
else
{
lblMSG.Text = "Customer information updated";
}
PopupControlMSG.ShowOnPageLoad = true;
btnClear_Click(btnClear, EventArgs.Empty);
//lblMsg.Text = "Customer Add Successfully '" + AutoGenCode + "'";
//lblMsg.ForeColor = Color.Green;
//ClearAll();
}
}
catch (Exception ex)
{
SendAlert("Error:" + ex.ToString());
}
}
protected void BtnRemove_Labor_Click(object sender, ImageClickEventArgs e)
{
DataSet dsdelete = new DataSet();
try
{
dsdelete = (DataSet)Session["LaborDS"];
ImageButton BtnLnk2 = (ImageButton)sender;
GridViewRow rowGv = (GridViewRow)BtnLnk2.Parent.Parent;
int rowGvIndex = rowGv.RowIndex;
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
string sql = "delete from LaborDetail where DealerCode = '" + Session["DealerCode"].ToString() + "' and DefJobCode = '" + ddljob_code.SelectedValue + "' and ProdCode = '" + dsdelete.Tables[0].Rows[rowGvIndex]["Product"].ToString() + "' and VersionCode = '" + dsdelete.Tables[0].Rows[rowGvIndex]["Version"].ToString() + "'";
myFunc.ExecuteQuery(sql, Trans);
}
dsdelete.Tables[0].Rows[rowGvIndex].Delete();
dsdelete.Tables[0].AcceptChanges();
if (dsdelete.Tables[0].Rows.Count == 0)
{
DataRow dr = dsdelete.Tables[0].NewRow();
dsdelete.Tables[0].Rows.Add(dr);
}
gv_labor.DataSource = dsdelete.Tables[0];
gv_labor.DataBind();
Session["LaborDS"] = dsdelete;
ObjTrans.CommittTransaction(ref Trans);
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
public bool UpdatePost(string StockRetNo, ref SqlTransaction Trans)
{
string Update_Qry = " Exec sp_PostStockReturnActivity '" + StockRetNo + "','" + Session["DealerCode"].ToString() + "'";
try
{
if (SysFunc.ExecuteQuery(Update_Qry, Trans) == true)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
SysFunc.UserMsg(LbErr, Color.Red, ex.Message);
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2503", "002"))
{
Response.Redirect("~/Test.aspx");
}
if (!sec.UserRight("2503", "003"))
{
Response.Redirect("~/Test.aspx");
}
try
{
if (txtEmail1.Text != "")
{
if (!txtEmail1.Text.Contains('@'))
{
lblmsg.Visible = true;
lblmsg.Text = "Enter Valid Email Address";
lblmsg.ForeColor = Color.Red;
txtEmail1.Focus();
return;
}
}
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
string sql = "UPDATE Dealer SET [DealerDesc] = '" + txtDealerName.Text.Trim() + "' ,[Address1] = '" + txtAddress1.Text + "',[Address2] ='" + txtAddress2.Text + "',[Address3] ='" + txtAddress3.Text + "' " +
",[SaleTaxNo] = '" + txtTaxReg.Text + "',[Phone1] = '" + txtPhone1.Text + "',[Phone2] = '" + txtPhone2.Text + "',[Email] = '" + txtEmail1.Text + "',[Fax] = '" + txtFax.Text + "',[NTN] = '" + txtNTN.Text + "'" +
",[UpdUser] = '" + Session["UserName"].ToString() + "',[UpdDate] = '" + SysFunc.SaveDate(DateTime.Now.ToString("dd/MM/yyyy")) + "',[UpdTerm] = '" + GlobalVar.mUserIPAddress + "'" +
",[PST] = '" + txtPSTPerc.Text + "',[HandlingCharges] = '" + Convert.ToDecimal(txtHandling.Text.Replace(" ", "").Trim() == "" ? "0" : txtHandling.Text.Replace(" ", "").Trim()) + "' ,[CreditLimit] = '" + txtCreditLimit.Text + "' ,[Logo] = '" + Session["Logo"].ToString() + "' WHERE DealerCode = '" + Session["DealerCode"].ToString() + "'";
SysFunc.ExecuteQuery(sql, Trans);
}
ObjTrans.CommittTransaction(ref Trans);
lblmsg.Visible = true;
lblmsg.ForeColor = System.Drawing.Color.Green;
lblmsg.Text = "Profile Updated";
}
catch (Exception ex)
{
//ObjTrans.CommittTransaction(ref Trans);
ObjTrans.RollBackTransaction(ref Trans);
lblmsg.Visible = true;
lblmsg.ForeColor = System.Drawing.Color.Red;
lblmsg.Text = ex.Message;
}
}
public void childthreadcall()
{
try
{
string sQuery = "SP_SelectCustomerForLookUp '" + Session["DealerCode"].ToString() + "'";
if (myFunc.ExecuteQuery(sQuery, ref ds))
{
Session["Parts"] = ds;
}
}
catch (ThreadAbortException e)
{
//lblmessage.Text += "<br /> child thread - exception";
}
finally
{
//lblmessage.Text += "<br /> child thread - unable to catch the exception";
}
}
protected void getData()
{
ColumnsName = Session["ColumnsName"].ToString();
AppendWhere = Session["AppendInWhere"].ToString();
if (Session["AppendOrderby"] != null)
{
AppendOrderby = Session["AppendOrderby"].ToString();
}
if (Request.QueryString["Grp"] != null)
{
AppendInGroupBy = Request.QueryString["Grp"].ToString();
}
string sQuery;
if (LookUpPageId.ToString() != string.Empty)
{
clsLookUp clp = new clsLookUp();
if (AppendInGroupBy != string.Empty)
{
if (txtSearch.Text != string.Empty)
{
if (AppendWhere != string.Empty)
{
sQuery = ColumnsName + " Where " + AppendWhere + " and " +
rdblColumns.SelectedValue.ToString() + " like '%" + txtSearch.Text.Trim() + "%' " + AppendInGroupBy;
}
else
{
sQuery = ColumnsName + " Where " +
rdblColumns.SelectedValue.ToString() + " like '%" + txtSearch.Text.Trim() + "%' " + AppendInGroupBy;
}
}
else
{
if (AppendWhere != string.Empty)
{
sQuery = ColumnsName + " Where " + AppendWhere + " " + AppendInGroupBy;
}
else
{
sQuery = ColumnsName + " " + AppendInGroupBy;
}
}
}
else
{
if (txtSearch.Text != string.Empty)
{
if (AppendWhere != string.Empty)
{
sQuery = ColumnsName + " Where " + AppendWhere + " and " +
rdblColumns.SelectedValue.ToString() + " like '%" + txtSearch.Text.Trim() + "%'";
}
else
{
sQuery = ColumnsName + " Where " +
rdblColumns.SelectedValue.ToString() + " like '%" + txtSearch.Text.Trim() + "%'";
}
}
else
{
if (AppendWhere != string.Empty)
{
sQuery = ColumnsName + " Where " + AppendWhere;
}
else
{
sQuery = ColumnsName;
}
}
}
if (AppendOrderby != string.Empty)
{
sQuery = sQuery + " " + AppendOrderby;
}
if (txtSearch.Text == string.Empty)
{
if (sysfuns.ExecuteQuery(sQuery, ref ds))
{
GDV.AllowPaging = true;
GDV.PageSize = 15;
//Session["Parts"] = ds;
Session["SearchParts"] = ds;
GDV.DataSource = ds;
GDV.DataBind();
//GDV.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
else
{
if (sysfuns.ExecuteQuery(sQuery, ref ds))
{
GDV.AllowPaging = false;
//GDV.PageSize = 15;
//Session["Parts"] = ds;
Session["SearchParts"] = ds;
GDV.DataSource = ds;
GDV.DataBind();
//GDV.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
if (!sec.UserRight("2579", "006"))
{
Response.Redirect("~/Test.aspx");
}
if (ddlVendor.SelectedIndex == 0)
{
lblMessage.Text = "Please select vendor";
return;
}
string mn = txtMonth.Text.Substring(0, 2);
string yr = txtMonth.Text.Substring(3, 4);
string strdate = yr + "/" + mn + "/01";
if (!myFunc.isDateTime(strdate))
{
lblMessage.Text = "Please enter valid month";
txtMonth.Focus();
return;
}
lblMessage.Text = "Creating Report";
SqlDataReader reader = null;
string sTemp = "", StrVendorCode = "", StrMonth = "", StrYear = "";
StrMonth = mn;
StrYear = yr;
StrVendorCode = ddlVendor.SelectedValue;
RD.Load(Server.MapPath("../rptStockBalanceNew.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 = "'Stock Summary'";
RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Request.ServerVariables["REMOTE_ADDR"].ToString() + "'";
RD.DataDefinition.FormulaFields["UserId"].Text = "'User'";
//RD.DataDefinition.FormulaFields["FromCode"].Text = "'For the Month " + MonthName(Mid(txtMonth._String, 1, 2)) + " " & Mid(txtMonth._String, 4, 7) & "'"
RD.DataDefinition.FormulaFields["FromCode"].Text = "'For the Month " + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToInt32(StrMonth)) + " " + StrYear + "'";
if (myFunc.ExecuteQuery("Exec sp_StockBalance_TotalJobCards '" + Session["DealerCode"].ToString() + "','" + myFunc.SaveDate("01/" + StrMonth + "/" + StrYear) + "'", ref reader) == true)
{
while (reader.Read())
{
sTemp = reader[0].ToString();
}
}
reader.Close();
GetStockBalanceData(StrVendorCode, StrMonth, StrYear);
RD.DataDefinition.FormulaFields["SGPPurchasesFromPSMC"].Text = "'" + SGPPurchasesFromPSMC.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["OtherPurchases"].Text = "'" + OtherPurchases.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["LubricantPurchases"].Text = "'" + LubricantPurchases.ToString("n") + "' ";
//RD.DataDefinition.FormulaFields["SGOPurchases"].Text = "'" + SGOPurchases.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'";
RD.DataDefinition.FormulaFields["SGPPartsConsumption"].Text = "'" + SGPPartsConsumption.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["SGPPartsSales"].Text = "'" + SGPPartsSales.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["SGPPartsSalesAccess"].Text = "'" + SGPPartsSalesAccess.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["OtherPartsConsumption"].Text = "'" + OtherPartsConsumption.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["OtherPartsSales"].Text = "'" + OtherPartsSales.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["LubricantConumptionAndSales"].Text = "'" + (LubricantConsumption + LubricantSales).ToString("n") + "' ";
//RD.DataDefinition.FormulaFields["SGOConsumption"].Text = "'" + SGOConsumption.ToString("n") + "' ";
//RD.DataDefinition.FormulaFields["SGOConsumptionLiter"].Text = "'" + SGOConsumptionLiter.ToString("n") + "' ";
//RD.DataDefinition.FormulaFields["SGOSales"].Text = "'" + SGOSales.ToString("n") + "' ";
//RD.DataDefinition.FormulaFields["SGOSalesLiter"].Text = "'" + SGOSalesLiter.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["SGPStock_Opening"].Text = "'" + SGPStock_Opening.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["OtherStock_Opening"].Text = "'" + OtherStock_Opening.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["LubricantStock_Opening"].Text = "'" + LubricantStock_Opening.ToString("n") + "' ";
//RD.DataDefinition.FormulaFields["SGO_Opening"].Text = "'" + SGO_Opening.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["SGPStock_Closing"].Text = "'" + SGPStock_Closing.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["OtherStock_Closing"].Text = "'" + OtherStock_Closing.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["LubricantStock_Closing"].Text = "'" + LubricantStock_Closing.ToString("n") + "' ";
//RD.DataDefinition.FormulaFields["SGO_Closing"].Text = "'" + SGO_Closing.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["TotalPurchaseReturn"].Text = "'" + TotalPurchaseReturn.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["TotalSalesReturnPlusStockReturn"].Text = "'" + TotalSalesPlusStockReturn.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["PROther"].Text = "'" + PROther.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["PRSGP"].Text = "'" + PRSGP.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["SRSGP"].Text = "'" + SRSGP.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["SROther"].Text = "'" + SROther.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["TotalSalesReturn"].Text = "'" + TotalSalesReturn.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["StockReturnSGP"].Text = "'" + StockReturnSGP.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["StockReturnOther"].Text = "'" + StockReturnOther.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["TotalStockReturn"].Text = "'" + TotalStockReturn.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["ChargeOutSGP"].Text = "'" + ChargeOutSGP.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["ChargeOutOther"].Text = "'" + ChargeOutOther.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["TotalChargeOut"].Text = "'" + TotalChargeOut.ToString("n") + "' ";
RD.DataDefinition.FormulaFields["TotalJobcard"].Text = "'" + sTemp + "'";
RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'";
//RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'";
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
//Session["RD"] = RD;
//string FilePath = Server.MapPath("~") + "\\Download\\";
//string FileName = "StockBalance" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf";
//string File = FilePath + FileName;
//string URL = "../../../../Download/rptViewerService.aspx?ReportID=StockBalance";
//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);
}
