//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; }
protected void BtnDelete_Click(object sender, EventArgs e) { if (!sec.UserRight("2544", "004")) { Response.Redirect("~/Test.aspx"); } try { if (SysFunc.CheckVoucherPostFlag(Session["DealerCode"].ToString(), txtVoucherNo.Text)) { SysFunc.UserMsg(LbErr, Color.Red, "Can't Edit or Delete the Voucher '" + txtVoucherNo.Text + "' is already Posted"); return; } SysFunc.UpdateJV(Session["DealerCode"].ToString(), txtVoucherNo.Text); string ItemCode = string.Empty; foreach (GridViewRow gvr in gvPurInvDetail.Rows) { ItemCode = gvr.Cells[1].Text; SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 10), //0 new SqlParameter("@PurInvNo", SqlDbType.Char, 8), //1 new SqlParameter("@GRNNo", SqlDbType.Char, 8), //2 new SqlParameter("@ItemCode", SqlDbType.Char, 8), //3 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = ddlPayInvNo.SelectedValue.ToString(); param[2].Value = ddlGRN.SelectedValue.ToString().Trim(); param[3].Value = ItemCode; if (SysFunc.ExecuteSP_NonQuery("sp_PurInvMasterDetail_Delete", param)) { SysFunc.UserMsg(LbErr, Color.Green, "Deleted Successfully"); btnClear_Click(BtnDelete, EventArgs.Empty); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Deletealert()", true); } else { SysFunc.UserMsg(LbErr, Color.Red, "Record not delete Try again"); } } } catch (Exception ex) { SysFunc.UserMsg(LbErr, Color.Red, ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { if (!sec.UserRight("2582", "002")) { Response.Redirect("~/Test.aspx"); } if (txtExtno.Text != "") { if (!sec.UserRight("2582", "003")) { Response.Redirect("~/Test.aspx"); } } TextBox[] textBoxes = { txtExtno, txtLossNo }; try { SqlParameter[] CustomerEstimate_param = { /*0*/ new SqlParameter("@DealerCode", SqlDbType.Char, 5), /*1*/ new SqlParameter("@CustomerEstimateCode", SqlDbType.Char, 8), /*2*/ new SqlParameter("@LossDate", SqlDbType.DateTime), /*3*/ new SqlParameter("@LossNo", SqlDbType.VarChar, 50), }; CustomerEstimate_param[0].Value = Session["DealerCode"].ToString(); CustomerEstimate_param[1].Value = txtExtno.Text; CustomerEstimate_param[2].Value = SysFunc.SaveDate(txtCreateDate.Text); CustomerEstimate_param[3].Value = txtLossNo.Text.Trim(); if (SysFunc.ExecuteSP_NonQuery("[sp_Update_CustomerEstimate_LossNo]", CustomerEstimate_param)) { SysFunc.UserMsg(lblMsg, Color.Green, "Record Saved Successfully: " + txtExtno.Text, txtExtno); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true); } else { SysFunc.UserMsg(lblMsg, Color.Green, "Record Not Saved Successfully: " + txtExtno.Text, txtExtno); } } catch (Exception ex) { lblMsg.Text = ex.Message; } }
private void Save_InsertMasterDetail(SqlTransaction Trans, string strIssueDate, string strReqSource, string strJobCardNO, string strInvoiceNo, ref bool Check, ref string StrReturnNo) { string StrIssueDate = ""; try { StrIssueDate = txtRetDate.Text; SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@ReturnNo", SqlDbType.Char, 8), //1 new SqlParameter("@ReturnDate", SqlDbType.DateTime), //2 new SqlParameter("@IssueNo", SqlDbType.Char, 8), //3 new SqlParameter("@ReqSource", SqlDbType.VarChar, 10), //4 new SqlParameter("@JobCardNO", SqlDbType.Char, 8), //5 new SqlParameter("@InvoiceNo", SqlDbType.Char, 8), //6 new SqlParameter("@Remarks", SqlDbType.VarChar, 70), //7 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //8 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //9 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = SysFunc.AutoGen("StockReturn", "ReturnNo", txtRetDate.Text.Trim());; param[2].Value = SysFunc.SaveDate(txtRetDate.Text); param[3].Value = ddlIssueNo.SelectedValue.ToString().Trim(); param[4].Value = strReqSource.Trim(); param[5].Value = strJobCardNO.Trim(); param[6].Value = strInvoiceNo.Trim(); param[7].Value = txtRemarks.Text.Replace("'", " "); param[8].Value = Session["UserName"].ToString(); param[9].Value = GlobalVar.mUserIPAddress;; if (SysFunc.ExecuteSP_NonQuery("sp_W2_StockReturne_Insert", param, Trans)) { StrReturnNo = param[1].Value.ToString(); for (int i = 0; i < GvMain.Rows.Count; i++) { SqlParameter[] param1 = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@ReturnNo", SqlDbType.Char, 8), //1 new SqlParameter("@ItemCode", SqlDbType.Char, 8), //2 new SqlParameter("@IssueNo", SqlDbType.Char, 8), //3 new SqlParameter("@PartsTransLocCode", SqlDbType.VarChar, 7), //4 new SqlParameter("@ReturnQty", SqlDbType.Float), //5 new SqlParameter("@Rate", SqlDbType.Float), //6 new SqlParameter("@Amount", SqlDbType.Float) //7 }; Label LbItemCode = (Label)GvMain.Rows[i].FindControl("LbItemCode"); Label LbPartsTransLocCode = (Label)GvMain.Rows[i].FindControl("LbPartsTransLocCode"); HiddenField HDPartsTransLocCode = (HiddenField)GvMain.Rows[i].FindControl("HDPartsTransLocCode"); Label LbRetQty = (Label)GvMain.Rows[i].FindControl("LbRetQty"); Label LbAmount = (Label)GvMain.Rows[i].FindControl("LbAmount"); Label LbRate = (Label)GvMain.Rows[i].FindControl("LbRate"); param1[0].Value = Session["DealerCode"].ToString(); param1[1].Value = StrReturnNo; param1[2].Value = LbItemCode.Text; param1[3].Value = ddlIssueNo.SelectedValue.ToString().Trim(); param1[4].Value = HDPartsTransLocCode.Value; param1[5].Value = LbRetQty.Text; param1[6].Value = LbRate.Text; param1[7].Value = LbAmount.Text; if (SysFunc.ExecuteSP_NonQuery("sp_W2_StockReturneDetail_Insert", param1, Trans)) { Check = true; } else { Check = false; break; } } } } catch (Exception ex) { LbErr.Text = ex.Message; } }
protected void btnLookup_Click(object sender, EventArgs e) { DataTable dtSMSApplic = new DataTable(); DataTable dtQuery = new DataTable(); DataTable dtMessage = new DataTable(); string DealerCode = "00249"; string squery = "Select * from BMS_SMSApplicable where IsActive = 'Y'"; dtSMSApplic = myFunc.GetData(squery); DataRow[] dr = dtSMSApplic.Select(); for (int j = 0; j < dr.Length; j++) { string squery1 = dtSMSApplic.Rows[j]["squery"].ToString().Trim() + "and A.DealerCode = '" + DealerCode + "'"; dtQuery = myFunc.GetData(squery1); DataRow[] drr = dtQuery.Select(); for (int i = 0; i < drr.Length; i++) { SqlParameter[] param3 = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@DMSRefNo", SqlDbType.Char, 8), new SqlParameter("@CustomerCode", SqlDbType.VarChar, 8), new SqlParameter("@CustomerDes", SqlDbType.VarChar, 50), new SqlParameter("@Module", SqlDbType.VarChar, 10), new SqlParameter("@ModuleType", SqlDbType.VarChar, 10), new SqlParameter("@SMSApplicCode", SqlDbType.Char, 5), }; if (dtQuery.Rows[i]["DMSRefNo"].ToString() != "") { param3[0].Value = Session["DealerCode"].ToString(); param3[1].Value = dtQuery.Rows[i]["DMSRefNo"].ToString(); param3[2].Value = dtQuery.Rows[i]["CustomerCode"].ToString(); param3[3].Value = dtQuery.Rows[i]["CustomerDes"].ToString(); param3[4].Value = dtQuery.Rows[i]["Module"].ToString(); param3[5].Value = dtQuery.Rows[i]["ModuleType"].ToString(); param3[6].Value = dtSMSApplic.Rows[j]["SMSApplicCode"].ToString(); myFunc.ExecuteSP_NonQuery("SP_Insert_BMS_SMSTransMaster", param3); } } //string query3 = "exec SP_SMSMessage '" + Session["DealerCode"].ToString() + "' , '" + dtSMSApplic.Rows[j]["SMSApplicCode"].ToString().Trim() + "'"; //string AutoNum = ""; //dtMessage = myFunc.GetData(query3); //drr = dtMessage.Select(); //for (int i = 0; i < drr.Length; i++) //{ // string username = "******"; // string password = "******"; // string from = "MasterMotor"; // if (dtMessage.Rows[i]["CellNo"].ToString().StartsWith("0")) // { // AutoNum = "92" + dtMessage.Rows[i]["CellNo"].ToString().Substring(dtMessage.Rows[i]["CellNo"].ToString().Length - (dtMessage.Rows[i]["CellNo"].ToString().Length - 1)); // } // string to = AutoNum; // string message = dtMessage.Rows[i]["Message"].ToString(); // //string urlString = string.Format("http://weblogin.premiumsms.pk/sendsms_url.html?Username={0}&Password={1}&From={2}&To={3}&Message={4}", username, password, from, to, message); // //Uri URI = new Uri(urlString); // //WebClient wc = new WebClient(); // //string res = wc.DownloadString(URI); // string qry = "Update BMS_SMSTransMaster set SMSText = '" + message + "' ,"+ // " SMSApplicCode = '" + dtSMSApplic.Rows[j]["SMSApplicCode"].ToString() + "' ,"+ // " SMSTo = '" + to + "', SMSFrom = '" + from + "' , "+ // " SendDate ='" + myFunc.SaveDate(DateTime.Now.ToString("dd/MM/yyyy")) + "',"+ // " where SMSTransID = '"+ dtMessage.Rows[i]["SMSTransID"].ToString() + "'"; // myFunc.ExecuteQuery_NonQuery(qry); //} } }
//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); }
private bool InsertCustomer() { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@CusCode", SqlDbType.Char, 8), //1 new SqlParameter("@CusDesc", SqlDbType.VarChar, 50), //2 new SqlParameter("@FatherHusName", SqlDbType.VarChar, 50), //3 //new SqlParameter("@AuxCusCode new SqlParameter("@Address1", SqlDbType.VarChar, 50), //4 new SqlParameter("@Address2", SqlDbType.VarChar, 50), //5 new SqlParameter("@Address3", SqlDbType.VarChar, 50), //6 new SqlParameter("@ContPerson", SqlDbType.VarChar, 50), //7 new SqlParameter("@CreditDays", SqlDbType.Int), //8 new SqlParameter("@CreditLimit", SqlDbType.Float), //9 new SqlParameter("@NIC", SqlDbType.VarChar, 50), //10 new SqlParameter("@CusTypeCode", SqlDbType.Char, 3), //11 new SqlParameter("@DOB", SqlDbType.DateTime), //12 new SqlParameter("@Phone1", SqlDbType.VarChar, 15), //13 new SqlParameter("@Phone2", SqlDbType.VarChar, 15), //14 new SqlParameter("@CellNo", SqlDbType.VarChar, 15), //15 new SqlParameter("@FaxNo", SqlDbType.VarChar, 15), //16 new SqlParameter("@Email", SqlDbType.VarChar, 50), //17 new SqlParameter("@URL", SqlDbType.VarChar, 50), //18 new SqlParameter("@NTNno", SqlDbType.VarChar, 15), //19 new SqlParameter("@AdvanceReceipt", SqlDbType.Float), //20 //new SqlParameter("@AccountCode new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //21 //new SqlParameter("@UpdDate",SqlDbType .DateTime ),//22 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //23 new SqlParameter("@SalesTaxRegNo", SqlDbType.VarChar, 30), //24 new SqlParameter("@Behavior", SqlDbType.Char, 6), //25 new SqlParameter("@Remarks", SqlDbType.VarChar, 200), //26 new SqlParameter("@Distance", SqlDbType.Int) //27 }; param[0].Value = Session["DealerCode"].ToString(); if (ddCustomerCode.Text.Trim() == string.Empty) { AutoGenCode = myFunc.GetNewMaxID("Customer", "CusCode", 8, Session["DealerCode"].ToString()); //txtCustCode.Text = AutoGenCode; param[1].Value = AutoGenCode; } else { param[1].Value = ddCustomerCode.Text; } param[2].Value = txtCustomerName.Text.Trim().ToUpper(); param[3].Value = txtFatherHusband.Text.Trim().ToUpper(); param[4].Value = txtAddress1.Text.Trim().ToUpper(); param[5].Value = txtAddress2.Text.Trim().ToUpper(); param[6].Value = txtAddress3.Text.Trim().ToUpper(); param[7].Value = txtContactPerson.Text.Trim().ToUpper(); if (spnCreditDays.Text.Trim() == "") { spnCreditDays.Text = "0"; param[8].Value = spnCreditDays.Text; } else { param[8].Value = spnCreditDays.Text; } if (txtCreditLimit.Text.Trim() == "") { txtCreditLimit.Text = "0.00"; param[9].Value = txtCreditLimit.Text; } else { param[9].Value = txtCreditLimit.Text; } param[10].Value = txtNICNo.Text; param[11].Value = cmbCustomerType.Text; if (dpDOB.Date.Year > 1900) { param[12].Value = dpDOB.Date; } param[13].Value = txtPhoneNumber.Text; param[14].Value = txtPhoneNumber2.Text; param[15].Value = txtCellNumber.Text; param[16].Value = txtFaxNumber.Text; param[17].Value = txtEmail.Text; param[18].Value = txtURL.Text; param[19].Value = txtNTNNo.Text; param[20].Value = DBNull.Value; param[21].Value = Session["UserName"].ToString(); //param[22].Value = ObjGenral.SaveDate(DateTime.Now.ToString("dd/MM/yyyy")); param[22].Value = GlobalVar.mUserIPAddress; // SessionInformation.MachineIP; param[23].Value = txtSaleTaxRegNo.Text; param[24].Value = "GOOD"; param[25].Value = DBNull.Value; if (txtDistance.Text == "") { txtDistance.Text = "0"; param[26].Value = txtDistance.Text; } else { param[26].Value = txtDistance.Text; } if (myFunc.ExecuteSP_NonQuery("sp_Sales_Insert_Customer", param)) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { if (myFunc.CodeExists("JobCardMaster", "EngineNo", txtEngNo.Text.Trim(), " And GatePass='' ")) { lblMSG.Text = "Can not update this Engine number use in Job Card " + txtEngNo.Text; PopupControlMSG.ShowOnPageLoad = true; return; } else { lblMasg.Text = ""; } if (myFunc.CodeExists("JobCardMaster", "ChassisNo", txtChassisNo.Text.Trim(), " And GatePass='' ")) { lblMSG.Text = "Can not update this Chassis number use in Job Card " + txtChassisNo.Text; PopupControlMSG.ShowOnPageLoad = true; return; } else { lblMasg.Text = ""; } //TextBox[] textBoxes = { txtCustomerCode, txtEndUser, txtRegDate, txtRegNo, txtEngineNo, txtChassisNo, txtProduct, txtInvoiceNo, txtInvoiceDate }; if (txtCustomerName.Text.Trim() == "" || txtEndUserName.Text.Trim() == "" || txtChassisNo.Text.Trim() == "" || txtEngNo.Text.Trim() == "") { return; } else { /// Validate from SMIS Database of Engine number /// DataSet dsValidate = new DataSet(); DateTime InvDate = dpInvoiceDate.Date; if (cmbBrand.Value.ToString().Trim() == "001") { //if (InvDate >= Convert.ToDateTime("2009-10-01")) //{ // SqlParameter[] paramData = { // new SqlParameter("@EngineNo",SqlDbType.VarChar,5), // new SqlParameter ("@Chk" ,SqlDbType.Char,1) // }; // paramData[0].Value = txtEngNo.Text; // paramData[1].Value = "Y"; // dsValidate = SqlHelper.ExecuteDataset(GlobalVar.mCon, "sp_2W_Get_NewVehicleInfo_SDMS", paramData); // if (dsValidate.Tables[0].Rows.Count > 0) // { // if (dsValidate.Tables[0].Rows[0]["ChasisNo"].ToString() != txtChassisNo.Text.Trim()) // { // lblMSG.Text = "Enter valid Chassis No."+ txtChassisNo.Text; // PopupControlMSG.ShowOnPageLoad = true; // return; // } // if (dsValidate.Tables[0].Rows[0]["ProdCode"].ToString() != cmbProdCode.Text.Trim()) // { // lblMSG.Text = "Enter valid Product Code." + cmbProdCode.Text; // PopupControlMSG.ShowOnPageLoad = true; // return; // } // //if(txtInvoiceNo.Text .Trim () > // //if (dsValidate.Tables[0].Rows[0]["InvoiceNo"].ToString() != txtInvoiceNo.Text.Trim()) // //{ // // grl.UserMsg(lblMasg, Color.Red, "Enter valid InvoiceNo.", txtInvoiceNo ); // // return; // //} // //if (Convert.ToDateTime (dsValidate.Tables[0].Rows[0]["InvoiceDate"].ToString ()).ToString ("dd/MM/yyyy") != InvDate.ToString ("dd/MM/yyyy")) // //{ // // grl.UserMsg(lblMasg, Color.Red, "Enter valid InvoiceDate.", txtInvoiceDate ); // // return; // //} // if (dsValidate.Tables[0].Rows[0]["VersionCode"].ToString() != txtVersion.Text) // { // lblMSG.Text = "Enter valid Version Code" + txtVersion.Text; // PopupControlMSG.ShowOnPageLoad = true; // return; // } // } // else // { // lblMSG.Text = "Enter valid Engine No." + txtEngNo.Text; // PopupControlMSG.ShowOnPageLoad = true; // return; // } //} } //////////////////////////////////////////////// SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.VarChar, 5), //0 new SqlParameter("@CusCode", SqlDbType.VarChar, 8), //1 new SqlParameter("@EndUserCode", SqlDbType.Char, 8), //2 new SqlParameter("@CtdDate", SqlDbType.DateTime), //3 new SqlParameter("@RegNo", SqlDbType.VarChar, 15), //4 new SqlParameter("@ChassisNo", SqlDbType.VarChar, 30), //5 new SqlParameter("@EngineNo", SqlDbType.VarChar, 30), //6 new SqlParameter("@BrandCode", SqlDbType.Char, 3), //7 new SqlParameter("@ProdCode", SqlDbType.VarChar, 10), //8 new SqlParameter("@VersionCode", SqlDbType.Char, 3), //9 new SqlParameter("@ColorCode", SqlDbType.Char, 5), //10 new SqlParameter("@InvoiceNo", SqlDbType.VarChar, 25), //11 new SqlParameter("@InvoiceDate", SqlDbType.DateTime), //12 new SqlParameter("@InsCompCode", SqlDbType.Char, 4), //13 new SqlParameter("@InsPolicyNo", SqlDbType.VarChar, 25), //14 new SqlParameter("@LossNo", SqlDbType.VarChar, 15), //15 new SqlParameter("@MeterReading", SqlDbType.VarChar, 10), //16 new SqlParameter("@MonthReading", SqlDbType.VarChar, 4), //17 new SqlParameter("@Remarks", SqlDbType.VarChar, 100), //18 new SqlParameter("@UpdUser", SqlDbType.VarChar, 30), //19 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 30) //20 }; // 101 = Not Available // 102 = Not Understand param[0].Value = Session["DealerCode"].ToString(); param[1].Value = cmbCustomerCode.Text.Trim().ToUpper(); param[2].Value = cmbEndUser.Text.Trim().ToUpper(); param[3].Value = myFunc.SaveDate(dpRegDate.Text); param[4].Value = txtRegNo.Text.Trim().ToUpper().ToUpper(); param[5].Value = txtChassisNo.Text.Trim().ToUpper(); param[6].Value = txtEngNo.Text.Trim().ToUpper(); param[7].Value = cmbBrand.Value.ToString().Trim(); param[8].Value = cmbProdCode.Text.Trim(); param[9].Value = txtVersion.Text.Trim(); param[10].Value = cmbColorCode.Text.Trim(); param[11].Value = txtInvoiceNo.Text.Trim(); param[12].Value = myFunc.SaveDate(dpInvoiceDate.Text); param[13].Value = cmbInsCode.Text.Trim(); param[14].Value = txtPolicyNo.Text.Trim(); param[15].Value = "102"; // new SqlParameter("@LossNo",SqlDbType.VarChar,15), param[16].Value = "101"; // new SqlParameter("@MeterReading",SqlDbType.VarChar,10), param[17].Value = "101"; // new SqlParameter("@MonthReading",SqlDbType.VarChar,4), param[18].Value = "101"; // new SqlParameter("@Remarks",SqlDbType.VarChar,100), param[19].Value = Session["UserName"].ToString().ToUpper(); param[20].Value = Environment.MachineName; //select * from brand where BrandCode='' //select * from version Where Version='' //select * from customer where CusCode='' //select * from vehicle where BrandCode=='' and ProdCode='' and VersionCode='' and ColorCode //select * from color where ColorCode = '' try { if ((myFunc.IsExist("CusCode", cmbCustomerCode.Text, "Customer", Session["DealerCode"].ToString()) == true)) { if ((myFunc.IsExist("BrandCode", cmbBrand.Value.ToString(), "Brand", Session["DealerCode"].ToString()) == true)) { if ((myFunc.IsExist("VersionCode", txtVersion.Text, "Vehicle", Session["DealerCode"].ToString()) == true)) { // apStr = " and versioncode=" + txtVersion.Text + " and ProdCode='" + txtProduct.Text + "'"; if ((myFunc.IsExist("ColorCode", cmbColorCode.Text, "Vehicle", Session["DealerCode"].ToString()) == true)) { if (!myFunc.IsExist("RegNo", txtRegNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()) & !myFunc.IsExist("ChassisNo", txtChassisNo.Text, "CustomerVehicle", Session["DealerCode"].ToString()) & !myFunc.IsExist("EngineNo", txtEngNo.Text, "CustomerVehicle", Session["DealerCode"].ToString())) { if (myFunc.ExecuteSP_NonQuery("sp_CustomerVehicle_Insert", param)) { lblMSG.Text = "Record Saved!" + txtVersion.Text; PopupControlMSG.ShowOnPageLoad = true; GetDataLoaded(true, false); btnDelete.Enabled = true; } else { lblMSG.Text = "Record Not Saved!"; PopupControlMSG.ShowOnPageLoad = true; } } else { apStr = " and ChassisNo ='" + txtChassisNo.Text + "' and jobstatus = null and GatePass = null"; if (myFunc.IsExist("ChassisNo", txtChassisNo.Text, "JobCardMaster", Session["DealerCode"].ToString()) & myFunc.IsExist("EngineNo", txtEngNo.Text, "JobCardMaster", Session["DealerCode"].ToString())) { if (myFunc.IsExist("ChassisNo", txtChassisNo.Text, "JobCardMaster", Session["DealerCode"].ToString(), apStr)) { lblMSG.Text = "Record can not be updated"; PopupControlMSG.ShowOnPageLoad = true; return; } else { if (myFunc.ExecuteSP_NonQuery("sp_CustomerVehicle_Update", param)) { // objMBLL.ShowMessageBox("Record Updated", txtCustomerCode); lblMSG.Text = "Record Updated"; PopupControlMSG.ShowOnPageLoad = true; GetDataLoaded(true, false); } else { lblMSG.Text = "Record Not updated"; PopupControlMSG.ShowOnPageLoad = true; } } } else { if (myFunc.ExecuteSP_NonQuery("sp_CustomerVehicle_Update", param)) { //objMBLL.ShowMessageBox("Record Updated", txtCustomerCode); lblMSG.Text = "Record updated"; PopupControlMSG.ShowOnPageLoad = true; GetDataLoaded(true, false); } else { lblMSG.Text = "Record can not be updated"; PopupControlMSG.ShowOnPageLoad = true; } } } } } else { //objMBLL.ShowMessageBox("'Version' not exist! ", txtCustomerCode); lblMSG.Text = "Version not exist"; PopupControlMSG.ShowOnPageLoad = true; } } else { lblMSG.Text = "Product not exist!"; PopupControlMSG.ShowOnPageLoad = true; } } else { lblMSG.Text = "Brand not exist"; PopupControlMSG.ShowOnPageLoad = true; } } catch (Exception ex) { var LineNumber = new StackTrace(ex, true).GetFrame(0).GetFileLineNumber(); lblMSG.Text = "Error : " + ex.Message + "/" + ex.StackTrace.ToString() + "/" + LineNumber.ToString(); PopupControlMSG.ShowOnPageLoad = true; } } }
private bool InsertPPRMaster(SqlTransaction Trans) { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@PPRCode", SqlDbType.Char, 8), //1 new SqlParameter("@JobCardCode", SqlDbType.Char, 8), //2 new SqlParameter("@PPRDate", SqlDbType.DateTime), //3 new SqlParameter("@CusCode", SqlDbType.Char, 8), //4 new SqlParameter("@UserName", SqlDbType.Char, 75), //5 new SqlParameter("@UserAddress1", SqlDbType.VarChar, 100), //6 new SqlParameter("@UserPhoneNo", SqlDbType.Char, 50), //7 new SqlParameter("@VehEngineNo", SqlDbType.VarChar, 30), //8 new SqlParameter("@VehChassisNo", SqlDbType.VarChar, 30), //9 new SqlParameter("@VehRegNo", SqlDbType.Char, 15), //10 new SqlParameter("@InvoiceDate", SqlDbType.DateTime), //11 new SqlParameter("@MeterReadingKM", SqlDbType.Char, 5), //12 new SqlParameter("@DateOfProblem", SqlDbType.DateTime), //13 new SqlParameter("@RoadCondition", SqlDbType.Char, 10), //14 new SqlParameter("@NoOfProblems", SqlDbType.Int), //15 new SqlParameter("@CompletionDate", SqlDbType.DateTime), //16 new SqlParameter("@PostFlag", SqlDbType.Char, 1), //17 new SqlParameter("@DelFlag", SqlDbType.Char, 1), //18 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //19 //new SqlParameter("@UpdDate",SqlDbType.DateTime),//20 //new SqlParameter("@UpdTime",SqlDbType.DateTime),//21 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //20 new SqlParameter("@TransferStatus", SqlDbType.Char, 1), //21 new SqlParameter("@Status", SqlDbType.Char, 1), //22 new SqlParameter("@Remarks", SqlDbType.VarChar, 200), //23 new SqlParameter("@TotalAmount", SqlDbType.Float), //24 new SqlParameter("@SaleDealerCode", SqlDbType.Char, 5), //25 new SqlParameter("@SaleDealerName", SqlDbType.VarChar, 100), //26 }; param[0].Value = Session["DealerCode"].ToString(); if (ddlPRNo.SelectedValue == "0" || ddlPRNo.SelectedValue.ToString().Trim() == "__/_____") { param[1].Value = sysFuncs.AutoGen("PPRMaster", "PPRCode", DateTime.Now.ToString("dd-MM-yyyy")); //txtPPRNo.Text = param[1].Value.ToString(); ViewState["PPRCode"] = param[1].Value.ToString(); } else { param[1].Value = ddlPRNo.SelectedValue; } //param[1].Value =txtPPRNo.Text; param[2].Value = txtJobCardNo.Text; param[3].Value = sysFuncs.SaveDate(txtPPRDate.Text); param[4].Value = txtCustCode.Text; param[5].Value = txtUserName.Text; param[6].Value = txtUserAddress.Text; param[7].Value = txtPhoneNo.Text; param[8].Value = txtEngNo.Text; param[9].Value = txtChasisNo.Text; param[10].Value = txtRegNo.Text; param[11].Value = sysFuncs.SaveDate(txtInvDate.Text); param[12].Value = txtKM.Text; param[13].Value = sysFuncs.SaveDate(dtProblemDate.Text); param[14].Value = ddlRoadCond.SelectedValue; param[15].Value = 1; param[16].Value = sysFuncs.SaveDate(dtComplitionDate.Text); param[17].Value = "N"; param[18].Value = "N"; param[19].Value = Session["UserName"].ToString(); //param[19].Value = ObjGenral.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); //param[20].Value = ObjGenral.SaveTime(DateTime.Now.ToString("HH:MM")); param[20].Value = GlobalVar.mUserIPAddress; param[21].Value = "C"; param[22].Value = "C"; param[23].Value = txtCompletionDesc.Text; param[24].Value = txtPPRTotalAmount.Text; param[25].Value = ""; param[26].Value = ""; if (sysFuncs.ExecuteSP_NonQuery("sp_2W_Service_Insert_PPRMaster", param, Trans)) { return(true); } else { return(false); } }
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 gv_PSF_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { DataSet ds_update = new DataSet(); TextBox txtLetterSentDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtLetterSentDate"); TextBox txtCallDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtCallDate"); TextBox txtSmsDate = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtSmsDate"); TextBox txtRemarks = (TextBox)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("txtRemarks"); Label JobCode = (Label)grdNextDueMaintenance.Rows[e.RowIndex].FindControl("lblJobCode"); ds_update = (DataSet)Session["NextDueMaintenance"]; //Uzair foreach (DataRow dr in ds_update.Tables[0].Rows) { if (dr["JobCardCode"].ToString().Trim() == JobCode.Text.Trim()) { dr["LetterSentDate"] = sysFunc.SaveDate(txtLetterSentDate.Text); if (txtCallDate.Text == "") { dr["CalledDate10Day"] = null; } else { dr["CalledDate10Day"] = sysFunc.SaveDate(txtCallDate.Text); } if (txtSmsDate.Text == "") { dr["SMSSendDate"] = null; } else { dr["SMSSendDate"] = sysFunc.SaveDate(txtSmsDate.Text); } dr["Remarks2Day"] = txtRemarks.Text.Trim(); } } grdNextDueMaintenance.EditIndex = -1; grdNextDueMaintenance.DataSource = ds_update; grdNextDueMaintenance.DataBind(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), new SqlParameter("@JObCardCode", SqlDbType.Char, 8), new SqlParameter("@LetterSentDate", SqlDbType.DateTime), new SqlParameter("@CalledDate10Day", SqlDbType.DateTime), new SqlParameter("@SMSSendDate", SqlDbType.DateTime), new SqlParameter("@Remarks2Day", SqlDbType.VarChar, 50) }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = JobCode.Text; if (txtLetterSentDate.Text == "") { param[2].Value = null; } else { param[2].Value = sysFunc.SaveDate(txtLetterSentDate.Text); } if (txtCallDate.Text == "") { param[3].Value = null; } else { param[3].Value = sysFunc.SaveDate(txtCallDate.Text); } if (txtSmsDate.Text == "") { param[4].Value = null; } else { param[4].Value = sysFunc.SaveDate(txtSmsDate.Text); } param[5].Value = txtRemarks.Text.Trim(); if (ObjTrans.BeginTransaction(ref Trans) == true) { myFunc.ExecuteSP_NonQuery("[sp_SP_CRM_PostSales_NextDueMaintenance_Update]", param, Trans); //string sql = "update CRM_PostSales_NextDueMaintenance set LetterSentDate = '" + sysFunc.SaveDate(txtLetterSentDate.Text) + "', Remarks2Day = '" + txtRemarks.Text + "' , CalledDate10Day ='" + sysFunc.SaveDate(txtCallDate.Text) + "'" + // ", SMSSendDate = '" + sysFunc.SaveDate(txtSmsDate.Text) + "' where DealerCode = '" + Session["DealerCode"].ToString() + "' and JobCardCode = '" + JobCode.Text + "' "; //myFunc.ExecuteQuery(sql, Trans); } lblMessage.Visible = true; lblMessage.ForeColor = Color.Green; lblMessage.Text = "Record " + JobCode.Text + " Updated"; Session["NextDueMaintenance"] = ds_update; ObjTrans.CommittTransaction(ref Trans); } catch (Exception ex) { //ObjTrans.CommittTransaction(ref Trans); ObjTrans.RollBackTransaction(ref Trans); lblMessage.Visible = true; lblMessage.Text = ex.Message; } }
protected void BtnSavePartLocation_Click(object sender, EventArgs e) { if (!sec.UserRight("2540", "004")) { Response.Redirect("~/Test.aspx"); } string StrPartLocationCode = "", StrPartLocationDesc = ""; TextBox[] textBoxes = { txtPartLocationDesc }; if (!MasterValidation(textBoxes)) { return; } try { if (txtPartLocationCode.Text.Trim() == string.Empty) { StrPartLocationCode = SysFunc.GetNewMaxID("PartsLocation", "PartsLocCode", 2, Session ["DealerCode"].ToString()); } else { if (!sec.UserRight("2540", "003")) { Response.Redirect("~/Test.aspx"); } StrPartLocationCode = txtPartLocationCode.Text.Trim(); } StrPartLocationDesc = txtPartLocationDesc.Text.Trim(); SqlParameter[] param = { new SqlParameter("@DealerCode", Session["DealerCode"].ToString()), new SqlParameter("@partsLocCode", StrPartLocationCode), new SqlParameter("@partsLocDesc", StrPartLocationDesc), new SqlParameter("@UpdUser", Session["UserName"].ToString()), new SqlParameter("@Updtem", GlobalVar.mUserIPAddress) }; //ObjDLL.SP_Spare_Insert_partslocation(param); if (SysFunc.ExecuteSP_NonQuery("SP_Spare_Insert_partslocation", param)) { SysFunc.UserMsg(LbErr, Color.Green, "Location saved successfully Last Code is :" + StrPartLocationCode, txtPartLocationCode); Load_ddlLocCode(); ddlLocCode.SelectedValue = StrPartLocationCode; ClearSubLoc(); txtAutoPartLocCode.Text = ddlLocCode.SelectedValue.ToString(); txtPartLocationCode.Text = ddlLocCode.SelectedValue.ToString(); } else { SysFunc.UserMsg(LbErr, Color.Red, "Location not save try again", txtPartLocationCode); } } catch (Exception ex) { SysFunc.UserMsg(LbErr, Color.Red, ex.Message, txtPartLocationCode); } }