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 ddlType_IndexChanged(object sender, EventArgs e) { if (txtToDate.Text == "" && txtFromDate.Text == "") { lblMessage.Text = "Please Select Dates"; return; } LoadEmptyGrid(); lblMessage.Text = string.Empty; SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@Type", SqlDbType.Char, 3), //0 new SqlParameter("@FromDate", SqlDbType.DateTime), //0 new SqlParameter("@ToDate", SqlDbType.DateTime), //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlTypes.SelectedValue; param[2].Value = sysFunc.SaveDate(txtFromDate.Text); param[3].Value = sysFunc.SaveDate(txtToDate.Text); ds = ObjGenral.FillDataSet("sp_2W_Service_GetClaimBillingData_new", param); if (ds.Tables[0].Rows.Count > 0) { Grdbillings.DataSource = ds; Grdbillings.DataBind(); Session["JENDetail"] = ds.Tables[0]; if (ds.Tables[0].Rows.Count > 0) { foreach (GridViewRow gvr in Grdbillings.Rows) { PST = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["HandlingAmount"].ToString()) + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["PSTSubletAmount"].ToString()) + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["PSTLaborAmount"].ToString()); GST = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["GSTAmount"].ToString()); TotalAmount = TotalAmount + SysFunctions.CustomCDBL(ds.Tables[0].Rows[0]["TotalAmount"].ToString()); CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); Chk.Checked = true; //ChkBox.Checked = true; } txtLabPST.Text = PST.ToString(); txtGSTAmt.Text = GST.ToString(); txtTotalAmount.Text = TotalAmount.ToString(); //CalculatePSTPercentage(); } } else { //txtPstAmt.Text = ""; //txtPerc.Text = ""; lblMessage.Text = "No Record Found !!!"; } }
protected void btnAdjAmt_Click(object sender, EventArgs e) { if (txtins_amount.Text == "") { SysFunc.UserMsg(success_add_item, Color.Red, "Please Enter Amount First!", txtins_amount); } double InsAmt, AdvBal; AdvBal = SysFunctions.CustomCDBL(txtBalance.Text); InsAmt = SysFunctions.CustomCDBL(txtins_amount.Text); AdvBal = SysFunctions.CustomCDBL(AdvBal - InsAmt); txtBalance.Text = AdvBal.ToString(); Session["Adj"] = "Adj"; }
private int GetTotalCount() { string sql = "Select Count(*) from CustomerInvoice where Delflag='N' and DealerCode='" + Session["DealerCode"].ToString() + "'"; int count = 0; dt = new DataTable(); dt = sysfun.GetData(sql); if (dt.Rows.Count > 0) { count = Convert.ToInt16(SysFunctions.CustomCDBL(dt.Rows[0][0].ToString())); } return(count); }
private void create_row() { DropDownList ddlbrand_code = (DropDownList)gv_labor.FooterRow.FindControl("ddlbrand_code"); DropDownList ddlprod_code = (DropDownList)gv_labor.FooterRow.FindControl("ddlprod_code"); DropDownList ddlVersion_code = (DropDownList)gv_labor.FooterRow.FindControl("ddlVersion_code"); TextBox txtTaxAmt = (TextBox)gv_labor.FooterRow.FindControl("txtTaxAmt"); TextBox txtAmount = (TextBox)gv_labor.FooterRow.FindControl("txtAmount"); TextBox txtStnTime = (TextBox)gv_labor.FooterRow.FindControl("txtStnTime"); Label JobCode = (Label)gv_labor.FindControl("lblJobCode"); if (ddlbrand_code.SelectedIndex == 0) { lblMsg.Visible = true; lblMsg.Text = "Select Made"; return; } if (ddlprod_code.SelectedIndex == 0) { lblMsg.Visible = true; lblMsg.Text = "Select Product "; return; } if (ddlVersion_code.SelectedIndex == 0) { lblMsg.Visible = true; lblMsg.Text = "Select Version "; return; } if (txtTaxAmt.Text == "" || txtTaxAmt.Text == "0") { lblMsg.Visible = true; lblMsg.Text = "Tax Amount cannot be empty or Zer(0)"; return; } if (txtAmount.Text == "" || txtAmount.Text == "0") { lblMsg.Visible = true; lblMsg.Text = "Amount cannot be empty or Zer(0)"; return; } if (txtStnTime.Text == "" || txtStnTime.Text == "0") { lblMsg.Visible = true; lblMsg.Text = "Time can not be null"; return; } try { DataTable dt_newrow = new DataTable(); SysFunctions SysFuncs = new SysFunctions(); ds = new DataSet(); ds = (DataSet)Session["LaborDS"]; DataRow row = ds.Tables[0].NewRow(); row["DefJobCode"] = ddlbrand_code.SelectedItem.Value; row["Made"] = ddlbrand_code.SelectedItem.Text; row["Product"] = ddlprod_code.SelectedItem.Value; row["Version"] = ddlVersion_code.SelectedItem.Value; row["ServiceTax"] = txtTaxAmt.Text; row["Amount"] = txtAmount.Text; row["StandardTime"] = txtStnTime.Text; ds.Tables[0].Rows.Add(row); gv_labor.DataSource = ds.Tables[0]; gv_labor.DataBind(); Session["LaborDS"] = ds; } catch (Exception ex) { lblMsg.Visible = true; lblMsg.Text = ex.Message; } }
protected void btnInsert_Click(object sender, EventArgs e) { if (txtTaxHead.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Tax Head should not left blank", txtTaxHead); return; } //if (txt.Text == "") //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Customer should not left blank", txtreg); // return; //} //if (txtRemarks.Text == "") //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Remarks should not left blank", txtreg); // return; //} DataTable dt = (DataTable)Session["TaxTypeDS"]; try { string max = sysFuncs.GetNewMaxID("TaxType", "TaxID", 2, "COMON"); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@TaxID", SqlDbType.Char, 2), //1 new SqlParameter("@TaxHead", SqlDbType.VarChar, 50), //2 new SqlParameter("@TaxPer", SqlDbType.Decimal), //3 new SqlParameter("@Active", SqlDbType.Char, 1), //4 new SqlParameter("@Type", SqlDbType.VarChar, 50), //5 new SqlParameter("@TaxApplicable", SqlDbType.VarChar, 20), //6 new SqlParameter("@AccCode", SqlDbType.Char, 16), //7 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8 new SqlParameter("@UpdDate", SqlDbType.DateTime), //9 new SqlParameter("@UpdTime", SqlDbType.DateTime), //10 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), // 11 }; string activeCheck = ""; if (CheckId.Checked) { activeCheck = "Y"; } else { activeCheck = "N"; } // txtAccCode.Text = textAccCode; param[0].Value = "COMON"; param[1].Value = max; param[2].Value = txtTaxHead.Text; param[3].Value = SysFunctions.CustomCDBL(txtTaxPercent.Text); param[4].Value = activeCheck; param[5].Value = ddlType.Text; param[6].Value = ddlTaxApplicable.Text; param[7].Value = txtAccCode.Text; param[8].Value = Session["UserName"].ToString(); param[9].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); param[10].Value = DateTime.Now; param[11].Value = "1"; if (sysFunc.ExecuteSP_NonQuery("SP_Insert_TaxType", param)) { sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Record " + max + " Insert Sucessfully", txtTaxId); } else { sysFuncs.UserMsg(lblMessage, Color.Green, "Data Not Inserted", txtTaxId); } } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
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 ChkBox_CheckedChanged(object sender, EventArgs e) //{ // if (ChkBox.Checked) // { // foreach (GridViewRow gvr in Grdbillings.Rows) // { // TotalAmount = TotalAmount + Convert.ToDecimal(gvr.Cells[5].Text.Trim()); // CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); // Chk.Checked = true; // } // txtTotalAmount.Text = TotalAmount.ToString(); // CalculatePSTPercentage(); // } // else // { // foreach (GridViewRow gvr in Grdbillings.Rows) // { // CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); // Chk.Checked = false; // txtTotalAmount.Text = "0.00"; // //txtPstAmt.Text = "0.00"; // } // } //} protected void btnSave_Click(object sender, EventArgs e) { if (!sec.UserRight("2583", "002")) { Response.Redirect("~/Test.aspx"); } try { int grd = Grdbillings.Rows.Count; if (grd > 0) { //Auto Generated Code// DateTime dt = DateTime.Now; string strYear = dt.Year.ToString(); string BillNo; if (ddlBillingNo.SelectedValue.Trim() == "0") { BillNo = ObjGenral.AutoGen("JENBillMaster", "JENBillNo", DateTime.Now.ToString("dd-MM-yyyy")); } else { BillNo = ddlBillingNo.SelectedValue.Trim(); } //Auto Generated Code// string Remarks = txtRemarks.Text.Trim().ToString(); float BillRecAmount = 0; string DelFlag = "N", PostFlag = "N"; string UpdUser = Session["UserName"].ToString(); //FFI PDI Master Insert here SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FPBillNo", SqlDbType.Char, 8), //1 new SqlParameter("@BillDate", SqlDbType.DateTime), //2 new SqlParameter("@Remarks", SqlDbType.VarChar, 100), //3 new SqlParameter("@BillQty", SqlDbType.Int), //4 new SqlParameter("@BillAmount", SqlDbType.Float, 15), //5 new SqlParameter("@BillRecAmount", SqlDbType.Float, 15), //6 new SqlParameter("@DelFlag", SqlDbType.Char, 1), //7 new SqlParameter("@PostFlag", SqlDbType.Char, 1), //8 new SqlParameter("@UpdUser", SqlDbType.VarChar, 5), //9 //new SqlParameter("@UpdDate",SqlDbType.DateTime),//10 //new SqlParameter("@UpdTime",SqlDbType.DateTime),//11 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //12 new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //13 new SqlParameter("@VoucherNo", SqlDbType.VarChar, 50), //14 new SqlParameter("@VoucherFlag", SqlDbType.Char, 1), //15 new SqlParameter("@SoftwareVersion", SqlDbType.VarChar, 25), //16 new SqlParameter("@BillType", SqlDbType.VarChar, 5), //17 new SqlParameter("@VehType", SqlDbType.Char, 3), //17 new SqlParameter("@CreditNo", SqlDbType.VarChar, 50), //17 new SqlParameter("@GSTAmount", SqlDbType.Decimal, 50), //17 new SqlParameter("@SSTAmount", SqlDbType.Decimal, 50), //17 //new SqlParameter("@SSTAge",SqlDbType.Decimal,18),//18 //new SqlParameter("@SSTAmount",SqlDbType.Decimal,18),//19 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = BillNo; param[2].Value = ObjGenral.SaveDate(txtBillDate.Text); //param[2].Value = txtBillDate.Text; param[3].Value = Remarks.ToUpper(); param[4].Value = Grdbillings.Rows.Count; param[5].Value = txtTotalAmount.Text.Trim().ToString(); param[6].Value = BillRecAmount; param[7].Value = DelFlag; param[8].Value = PostFlag; param[9].Value = Session["UserName"].ToString(); //param[10].Value = ObjGenral.SaveDate(DateTime.Now.ToString()); //param[11].Value = ObjGenral.SaveTime(DateTime.Now.ToString()); param[10].Value = GlobalVar.mUserIPAddress; param[11].Value = "C"; param[12].Value = null; param[13].Value = null; param[14].Value = null; param[15].Value = ddlTypes.SelectedValue.ToString(); param[16].Value = txtCreditNo.Text; param[17].Value = txtGSTAmt.Text.Trim(); param[18].Value = txtLabPST.Text.Trim(); if (ObjTrans.BeginTransaction(ref Trans) == true) { if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillMaster_Insert", param, Trans)) { lblLastBillNo.Text = "Last Code Generated : " + " " + BillNo; } } else { lblMessage.Text = "Error"; } //FFI PDI Master Insert here //Insert Detail Data Here foreach (GridViewRow gvr in Grdbillings.Rows) { string DealerCode = Session["DealerCode"].ToString(); string PPRCode = gvr.Cells[1].Text.Trim().ToString(); string BillNoDetail = BillNo; // string Billtype = ddlTypes.SelectedValue.ToString(); string BillAmount = gvr.Cells[5].Text.Trim().ToString(); CheckBox Chk = (CheckBox)gvr.Cells[0].FindControl("ChkBox"); SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@JENBillNo", SqlDbType.Char, 8), //1 new SqlParameter("@PPRCode", SqlDbType.Char, 8), //2 new SqlParameter("@PPRDate", SqlDbType.DateTime), //3 new SqlParameter("@ChassisNo", SqlDbType.VarChar, 15), //4 new SqlParameter("@Parts", SqlDbType.Float), //5 new SqlParameter("@Sublet", SqlDbType.Float), //6 new SqlParameter("@Labor", SqlDbType.Float), //7 new SqlParameter("@TotalAmount", SqlDbType.Float), //8 new SqlParameter("@GSTAmount", SqlDbType.Float), //9 new SqlParameter("@PSTLaborAmount", SqlDbType.Float), //10 new SqlParameter("@PSTSublet", SqlDbType.Float), //11 new SqlParameter("@HandlingAmount", SqlDbType.Float), //12 }; param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = BillNoDetail; param1[2].Value = PPRCode; param1[3].Value = sysFunc.SaveDate(gvr.Cells[2].Text.Trim().ToString()); param1[4].Value = gvr.Cells[4].Text.Trim().ToString(); param1[5].Value = SysFunctions.CustomCDBL(gvr.Cells[12].Text); param1[6].Value = SysFunctions.CustomCDBL(gvr.Cells[13].Text); param1[7].Value = SysFunctions.CustomCDBL(gvr.Cells[14].Text); param1[8].Value = SysFunctions.CustomCDBL(gvr.Cells[15].Text); param1[9].Value = SysFunctions.CustomCDBL(gvr.Cells[7].Text); param1[10].Value = SysFunctions.CustomCDBL(gvr.Cells[9].Text); param1[11].Value = SysFunctions.CustomCDBL(gvr.Cells[11].Text); param1[12].Value = SysFunctions.CustomCDBL(gvr.Cells[6].Text); // param1[3].Value = Billtype; if (Chk.Checked == true) { if (ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1, Trans)) { lblMessage.Text = "Record Has been Inserted Sucessfully !!!"; ClearAll(); } // ObjGenral.ExecuteSP_NonQuery("sp_Service_JENBillDetail_Insert", param1,Trans); } //Insert Detail Data Here } } else { string script = "alert(\"User should select some Bills !!!\");"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true); } } catch (Exception ex) { ObjTrans.RollBackTransaction(ref Trans); lblMessage.Text = ex.Message; } ObjTrans.CommittTransaction(ref Trans); }
//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); }
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); }