public static string Select_SalesPersonPerformanceWithDatesRange(string dealerCode, string FromDate, string ToDate) { List <SalesPersonPerformanceVM> lst = new List <SalesPersonPerformanceVM>(); DataTable dt = new DataTable(); string FDate = sysfun.SaveDate(FromDate).ToString(); string TDate = sysfun.SaveDate(ToDate).ToString(); string json = ""; var Serializer = new JavaScriptSerializer(); try { string sql = "exec SP_SalesPersonPerformanceWithDateRange '" + AuthBase.EmpCode + "' ,'" + dealerCode + "','" + FDate + "','" + TDate + "'"; dt = sysfun.GetData(sql); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <SalesPersonPerformanceVM>(dt); } json = Serializer.Serialize(lst); } catch (Exception ex) { throw; } return(json); }
public static bool Insert_Buying(BuyingCusVehicleVM model, string dealerCode) { try { if (string.IsNullOrEmpty(model.BuyingCode)) { if (sysfun.IsExist("RegNo", model.RegNo, "UCS_Buying", dealerCode)) { return(IsSaved); } strAutoCode = sysfun.AutoGen("UCS_Buying", "BuyingCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); //strAutoCode = sysfun.GetNewMaxID("UCS_Buying", "BuyingCode", 8, dealerCode); } else { strAutoCode = model.BuyingCode; } SqlParameter[] param = { new SqlParameter("@DealerCode ", dealerCode), //0 new SqlParameter("@BuyingCode ", strAutoCode), //1 new SqlParameter("@BuyingDate ", sysfun.SaveDate(model.BuyingDate)), //3 new SqlParameter("@RegNo ", model.RegNo), //5 new SqlParameter("@KM ", model.KM), //6 new SqlParameter("@RoadTaxPaid ", model.RoadTaxPaid), //7 new SqlParameter("@RoadTaxValidUpTo ", sysfun.SaveDate(model.RoadTaxValidUpTo)), //8 new SqlParameter("@IsInsured ", model.IsInsured), //9 new SqlParameter("@InsuranceValidUpTo ", sysfun.SaveDate(model.InsuranceValidUpTo)), //10 new SqlParameter("@BuyingPrice ", Convert.ToDecimal(model.BuyingPrice)), //11 new SqlParameter("@EvaluationCode ", model.EvaluationCode), //12 new SqlParameter("@EvaluationDate ", sysfun.SaveDate(model.EvaluationDate)), //13 new SqlParameter("@Pic01 ", model.Pic01), //19 new SqlParameter("@Pic02 ", model.Pic02), //20 new SqlParameter("@Pic03 ", model.Pic03), //21 new SqlParameter("@Pic04 ", model.Pic04), //22 new SqlParameter("@Pic05 ", model.Pic05), //23 new SqlParameter("@UpdUser ", AuthBase.UserId), //24 new SqlParameter("@UpdTerm ", General.CurrentIP), //27 new SqlParameter("@LocationCode ", model.LocationCode), new SqlParameter("@BuyingMode ", model.BuyingMode) }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("Insert_Buying", param, Trans); IsSaved = true; } } catch (Exception) { throw; } return(IsSaved); }
public static bool Insert_ProdMaster(ProdReceiptVM model, string dealerCode, ref string msg) { try { if (model.RecNo == "0" || model.RecNo == "" || model.RecNo == null) { strAutoCode = sysfun.AutoGen("ProdRecMaster", "RecNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); //strAutoCode = sysfun.GetNewMaxID("ProdRecMaster", "RecNo", 8, "00166"); //recDate = DateTime.Parse( model.RecDate); } else { strAutoCode = model.RecNo; //string rec = model.RecDate; //recDate = DateTime.Parse(rec); } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@RecNo", strAutoCode), //1 new SqlParameter("@RecDate", sysfun.SaveDate(model.RecDate)), //2 new SqlParameter("@DocumentNo", model.DocumentNo), //3 new SqlParameter("@UpdUser", AuthBase.UserId), //4 new SqlParameter("@UpdTerm", General.CurrentIP), //5 new SqlParameter("@VehTypeCode", model.VehTypeCode), //6 new SqlParameter("@VehRecCode", model.VehRecCode), //7 new SqlParameter("@Segment", model.Segment.Trim()), //8 new SqlParameter("@Category", model.Category.Trim()), //9 new SqlParameter("@Usage", model.Usage.Trim()), //10 new SqlParameter("@VendorCode", model.VendorCode.Trim()), //11 new SqlParameter("@Remarks", model.Remarks), //12 new SqlParameter("@OEMAnnounceDate", sysfun.SaveDate(model.OEMAnnounceDate)), //12 new SqlParameter("@TransportID", model.TransportID), //12 new SqlParameter("@TotalVehicleAmount", model.TotalVehicleAmount) //12 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_ProdRecMaster_Insert", param, Trans); IsSaved = true; } } catch (Exception ex) { msg = ex.Message; return(false); } return(IsSaved); }
public void GetData() { string FromDate = sysfunc.SaveDate(txtFromDate.Text).ToString(); string ToDate = sysfunc.SaveDate(txtToDate.Text).ToString(); var Form = ddlForm.SelectedValue; string sqlquery = "SP_VoucherStatus_Pending '" + Session["DealerCode"].ToString() + "','" + sysfunc.SaveDate(txtFromDate.Text) + "','" + sysfunc.SaveDate(txtToDate.Text) + "','" + Form + "'"; dt = sysfunc.GetData(sqlquery); if (dt.Rows.Count > 0) { gvPendingVoucher.DataSource = dt; gvPendingVoucher.DataBind(); } }
protected void btnPrint_Click(object sender, EventArgs e) { if (!sec.UserRight("2576", "006")) { Response.Redirect("~/Test.aspx"); } if (txtFromDate.Text == "" || txtToDate.Text == "") { lblMessage.Text = "Please select date range"; return; } if (!chkSelect.Checked) { string fitm = txtFromItemCode.Text; string titm = txtToItemCode.Text; if (fitm == "" || titm == "") { lblMessage.Text = "Please select item range"; return; } } string ReportID = ReportID = "PartsSalesAndReturnDet"; //string FromDate = dpFromDate.Text.Substring(6, 4) + "/" + dpFromDate.Text.Substring(3, 2) + "/" + dpFromDate.Text.Substring(0, 2); //string ToDate = dpToDate.Text.Substring(6, 4) + "/" + dpToDate.Text.Substring(3, 2) + "/" + dpToDate.Text.Substring(0, 2); //string FromDate = txtFromDate.Date.ToString("yyyy/MM/dd"); //string ToDate = txtToDate.Date.ToString("yyyy/MM/dd"); string FromDate = sysFun.SaveDate(txtFromDate.Text).ToString(); string ToDate = sysFun.SaveDate(txtToDate.Text).ToString(); //string FromItem = ddlFromCode.SelectedValue; //string ToItem = ddlToCode.SelectedValue; string FromItem = txtFromItemCode.Text; string ToItem = txtToItemCode.Text; string PDFFileName = MakeReport(ReportID, FromDate, ToDate, FromItem, ToItem, Server.MapPath("../"), Server.MapPath("~/Download/")); URL = "../../../../Download/rptViewerService.aspx?FileName=" + PDFFileName; //URL = FilePath + "OpenPdf.aspx?FileName=" + FileName; //txtPartItemDesc.Text = URL; string fullsysURL = "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", fullsysURL, true); }
public static bool Insert_SQMaster(SaleQuotMasterVM model) { DateTime recDate; try { if (model.SaleQuotCode == "" || model.SaleQuotCode == null) { strAutoCode = sysfun.AutoGen("SaleQuotMaster", "SaleQuotCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); //strAutoCode = sysfun.GetNewMaxID("ProdRecMaster", "RecNo", 8, "00166"); //recDate = DateTime.Parse( model.RecDate); } else { strAutoCode = model.SaleQuotCode; //string rec = sysfun.SaveDate( ).ToString(); //recDate = sysfun.SaveDate(model.BookRefDate); //recDate = DateTime.Parse(rec); } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@SaleQuotCode", strAutoCode), //1 new SqlParameter("@SaleQuotDate", sysfun.SaveDate(model.SaleQuotDate)), //2 new SqlParameter("@RefLetterNo", model.RefLetterNo), //3 new SqlParameter("@ValidDays", model.ValidDays), //4 new SqlParameter("@CustomerCode", model.CustomerCode), //5 new SqlParameter("@Subject", model.Subject), //6 new SqlParameter("@UpdUser", AuthBase.UserId), //7 new SqlParameter("@UpdTerm", General.CurrentIP), //8 new SqlParameter("@PaymentTerms", model.PaymentTerms), //9 new SqlParameter("@Exemption", model.Exemption), //10 new SqlParameter("@ForceJajeure", model.ForceJajeure), //11 new SqlParameter("@Warranty", model.Warranty), //12 new SqlParameter("@DocGST", model.DocGST), //13 new SqlParameter("@DocNTN", model.DocNTN), //14 new SqlParameter("@DocBrocher", model.DocBrocher), //15 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_Insert_SaleQuotMaster", param, Trans); IsSaved = true; } } catch (Exception) { if (ObjTrans.BeginTransaction(ref Trans) == true) { ObjTrans.RollBackTransaction(ref Trans); } throw; } return(IsSaved); }
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; } }
public static bool Insert_MonthlyCommisionMaster(MonthlyCommisionVM model, ref string msg) { try { if (string.IsNullOrEmpty(model.TransCode)) { if (sysfun.IsExist("CommMonth", model.CommMonth, "MonthlyCommision", model.DealerCode, " And Service = '" + model.Service + "'")) { msg = "Monthly Commision for the Month " + model.CommMonth + " for the selected Service is already exists "; //return false; strAutoCode = sysfun.GetNewMaxID("MonthlyCommision", "TransCode", 8, model.DealerCode); } else { strAutoCode = sysfun.GetNewMaxID("MonthlyCommision", "TransCode", 8, model.DealerCode); } } else { strAutoCode = model.TransCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@TransCode", strAutoCode), //1 new SqlParameter("@TransDate", sysfun.SaveDate(model.TransDate)), //1 new SqlParameter("@CommMonth", model.CommMonth), //2 new SqlParameter("@UpdUser", AuthBase.UserId), //6 new SqlParameter("@UpdDate", DateTime.Now), //8 new SqlParameter("@UpdTerm", General.CurrentIP), //7 new SqlParameter("@Remarks", model.Remarks), //11 new SqlParameter("@Service", model.Service) //12 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { if (sysfun.ExecuteSP_NonQuery("SP_Insert_MonthlyCommision", param, Trans)) { IsSaved = true; } else { return(IsSaved); } } } catch (Exception ex) { msg = ex.Message; } return(IsSaved); }
public static bool Insert_Reversal(ReversalVM model, ref string msg) { try { if (model.ReversalID == null || model.ReversalID == "") { strAutoCode = sysfun.AutoGen("Reversal", "ReversalID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); } else { strAutoCode = model.ReversalID; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@ReversalID", strAutoCode), //1 new SqlParameter("@ReversalDate", sysfun.SaveDate(model.ReversalDate)), //2 new SqlParameter("@TransactionNo", model.TransactionNo), //3 new SqlParameter("@TrType", model.TrType), //4 new SqlParameter("@TransactionAmount", model.TransactionAmount), //5 new SqlParameter("@Remarks", model.Remarks), //6 new SqlParameter("@UpdUser", AuthBase.UserId), //7 new SqlParameter("@UpdDate", DateTime.Parse(DateTime.Now.ToShortDateString())), //7 new SqlParameter("@UpdTime", DateTime.Now), //7 new SqlParameter("@UpdTerminal", General.CurrentIP) //8 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { if (sysfun.ExecuteSP_NonQuery("SP_Insert_Reversal", param, Trans)) { IsSaved = true; } } } catch (Exception ex) { msg = ex.Message; } return(IsSaved); }
public static bool Insert_DOMaster(VehicleDeliveryMasterVM model, string dealerCode) { try { if (model.DeliveryNo == "" || model.DeliveryNo == null) { strAutoCode = sysfun.AutoGen("VehicleDeliveryMaster", "DeliveryNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); } else { strAutoCode = model.DeliveryNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@DeliveryNo", strAutoCode), //1 new SqlParameter("@DeliveryDate", sysfun.SaveDate(model.DeliveryDate)), //2 new SqlParameter("@BookRefNo", model.BookRefNo), //3 new SqlParameter("@UpdUser", AuthBase.UserId), //4 new SqlParameter("@UpdTerm", General.CurrentIP), //5 new SqlParameter("@Type", model.Type), //6 new SqlParameter("@ReceiverCode", model.ReceiverCode), //7 new SqlParameter("@Remarks", model.Remarks), //8 new SqlParameter("@Segment", model.Segment), //9 new SqlParameter("@Usage", model.Usage), //10 new SqlParameter("@CusCode", model.CusCode), //11 new SqlParameter("@VehTypeCode", model.VehTypeCode), //12 new SqlParameter("@CusContNo", model.CusContNo), //13 new SqlParameter("@EmpCode", model.EmpCode) }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param, Trans); IsSaved = true; } //if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param)) //{ // IsSaved = true; //} } catch (Exception) { //ObjTrans.RollBackTransaction(ref Trans); throw; } return(IsSaved); }
protected void OnClick_btnCheck(object sender, EventArgs e) { string FDate = sysfun.SaveDate(txtFromDate.Text).ToString(); string TDate = sysfun.SaveDate(txtToDate.Text).ToString(); String sql = "exec sp_VTB_VehicleTrackingBoard'" + Session["DealerCode"].ToString() + "' , '" + FDate + "', '" + TDate + "'"; SysFunction sysFunc = new SysFunction(); DataTable dt = new DataTable(); dt = sysFunc.GetData(sql); if (dt != null) { gvVehicleTrack.DataSource = dt; gvVehicleTrack.DataBind(); } }
public static bool Insert_Exchange(VehicleExchangeVM model, string dealerCode) { try { if (string.IsNullOrEmpty(model.ExchangeCode)) { strAutoCode = sysfun.AutoGen("UCS_ExchangeVehicle", "ExchangeCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); } else { strAutoCode = model.ExchangeCode; } SqlParameter[] param = { new SqlParameter("@DealerCode ", dealerCode), //0 new SqlParameter("@ExchangeCode ", strAutoCode), //1 new SqlParameter("@ExchangeDate ", sysfun.SaveDate(model.ExchangeDate)), //3 new SqlParameter("@LocationCode ", model.LocationCode), new SqlParameter("@TypeOfBuying ", model.BuyingMode), new SqlParameter("@BuyingCode ", model.BuyingCode), //5 new SqlParameter("@BrandCode ", model.BrandCode), //6 new SqlParameter("@ColorCode ", model.ColorCode), //7 new SqlParameter("@ProdCode ", model.ProdCode), //9 new SqlParameter("@VersionCode ", model.VersionCode), //10 new SqlParameter("@ChassisNo ", model.ChassisNo), //12 new SqlParameter("@EngineNo ", model.EngineNo), //13 new SqlParameter("@SalesPerson ", model.SalesPerson), //19 new SqlParameter("@UpdUser ", AuthBase.UserId), //24 new SqlParameter("@UpdTerm ", General.CurrentIP), //27 new SqlParameter("@NewVehicleType ", model.NewVehicleType), //9 new SqlParameter("@ExchangeRemarks ", model.ExchangeRemarks) }; sysfun.ExecuteSP_NonQuery("Insert_ExchangeVehicle", param); IsSaved = true; } catch (Exception) { throw; } return(IsSaved); }
public static bool Insert_Commision(CommisionVM model, ref string msg) { try { if (string.IsNullOrEmpty(model.CommisionCode)) { strAutoCode = sysfun.GetNewMaxID("CommisionMaster", "CommisionCode", 5, model.DealerCode); } else { strAutoCode = model.CommisionCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@CommisionCode", strAutoCode), //1 new SqlParameter("@CommisionDate", sysfun.SaveDate(model.CommisionDate)), //1 new SqlParameter("@EmpCode", model.EmpCode), //2 new SqlParameter("@ProdCode", model.ProdCode == null ? (object)DBNull.Value : model.ProdCode.ToUpper()), //3 new SqlParameter("@CommPerc", model.CommPerc == null ? "0" : model.CommPerc), //4 new SqlParameter("@CommAmount", model.CommAmount == null ? "0" : model.CommAmount), //5 new SqlParameter("@UpdUser", AuthBase.UserId), //6 new SqlParameter("@UpdDate", DateTime.Now), //8 new SqlParameter("@UpdTerm", General.CurrentIP), //7 new SqlParameter("@DelFlag", "N"), //9 new SqlParameter("@BrandCode", model.BrandCode), //10 new SqlParameter("@VersionCode", model.VersionCode), //11 new SqlParameter("@ColorCode", model.ColorCode), //12 new SqlParameter("@Service", model.Service) //12 }; if (sysfun.ExecuteSP_NonQuery("SP_Insert_CommisionMaster", param)) { IsSaved = true; } } catch (Exception ex) { msg = ex.Message; } return(IsSaved); }
public static bool Insert_VehicleReturnMaster(VehicleReturnMasterVM model) { try { if (model.ReturnCode == "" || model.ReturnCode == null) { strAutoCode = sysfun.AutoGen("VehicleReturnMaster", "ReturnCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); } else { strAutoCode = model.ReturnCode; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@VendorCode", model.VendorCode), //1 new SqlParameter("@ReturnCode", strAutoCode), //2 new SqlParameter("@ReturnDate", sysfun.SaveDate(model.ReturnDate)), //3 new SqlParameter("@Remarks", model.Remarks), //4 new SqlParameter("@GatePass", model.GatePass), //5 new SqlParameter("@DelFlag", 'N'), //6 new SqlParameter("@UpdUser", AuthBase.UserId), //7 new SqlParameter("@UpdDate", DateTime.Now), //8 new SqlParameter("@UpdTime", DateTime.Now), //9 new SqlParameter("@UpdTerm", General.CurrentIP), //10 new SqlParameter("@DealerCustomer", model.DealerCustomer), //11 new SqlParameter("@ReturnType", model.ReturnType), //12 new SqlParameter("@DocumentNo", model.DocumentNo), //13 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_Inser_VehicleReturnMaster", param, Trans); IsSaved = true; } } catch (Exception) { ObjTrans.RollBackTransaction(ref Trans); throw; } return(IsSaved); }
public static bool Insert_VehLocTransMaster(VehicleLocTransVM model, string dealerCode, ref string msg) { try { if (model.TransNo == "" || model.TransNo == null) { strAutoCode = sysfun.AutoGen("VehicleLocTransMaster", "TransNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); } else { strAutoCode = model.TransNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@TransNo", strAutoCode), //1 new SqlParameter("@TransDate", sysfun.SaveDate(model.TransDate)), //2 new SqlParameter("@FromLocCode", model.FromLocCode), //3 new SqlParameter("@ToLocCode", model.ToLocCode), //4 new SqlParameter("@UpdUser", AuthBase.UserId), //5 new SqlParameter("@UpdDate", DateTime.Now.ToShortDateString()), //6 new SqlParameter("@UpdTime", DateTime.Now.ToShortTimeString()), //7 new SqlParameter("@UpdTerm", General.CurrentIP), //8 new SqlParameter("@Remarks", model.Remarks) //9 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_Insert_VehicleLocTransMaster", param, Trans); IsSaved = true; } } catch (Exception ex) { msg = ex.Message; } return(IsSaved); }
public static bool Insert_PriceOfferNegociation(UCS_EvaluationVM model, string dealerCode) { try { if (string.IsNullOrEmpty(model.EvaluationCode)) { if (sysfun.IsExist("RegNo", model.RegNo, "UCS_EvaluationMaster", dealerCode)) { return(IsSaved); } strAutoCode = sysfun.AutoGen("UCS_EvaluationMaster", "EvaluationCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode); //strAutoCode = sysfun.GetNewMaxID("UCS_EvaluationMaster", "EvaluationCode", 8, dealerCode); } else { strAutoCode = model.EvaluationCode; } SqlParameter[] param = { new SqlParameter("@DealerCode ", dealerCode), //0 new SqlParameter("@EvaluationCode ", strAutoCode), //1 new SqlParameter("@EvaluationDate ", sysfun.SaveDate(model.EvaluationDate)), //2 new SqlParameter("@UCSourceCode ", model.UCSourceCode), //3 new SqlParameter("@RegNo ", model.RegNo), //4 new SqlParameter("@RegDate ", sysfun.SaveDate(model.RegDate)), //5 new SqlParameter("@DateOfInspection ", sysfun.SaveDate(model.DateOfInspection)), //6 new SqlParameter("@EngineNo ", model.EngineNo), //7 new SqlParameter("@ChassisNo ", model.ChassisNo), //8 new SqlParameter("@BrandCode ", model.BrandCode), //9 new SqlParameter("@ProdCode ", model.ProdCode), //10 new SqlParameter("@VersionCode ", model.VersionCode), //11 new SqlParameter("@ColorCode", model.ColorCode), //12 new SqlParameter("@CusCode ", model.CusCode), //13 new SqlParameter("@TransmissionType ", model.TransmissionType), //14 new SqlParameter("@UserName ", model.UserName), //15 new SqlParameter("@OfferCategory ", model.OfferCategory), //16 new SqlParameter("@CurrentMilage ", model.CurrentMilage), //17 new SqlParameter("@CustomerExpectedPrice", model.CustomerExpectedPrice), //18 new SqlParameter("@ExpectationCustomer ", model.ExpectationCustomer), //19 new SqlParameter("@BuyingPriceOffer ", model.BuyingPriceOffer), //20 new SqlParameter("@ReCondition ", model.ReCondition), //21 new SqlParameter("@UCSourceRemarks ", model.UCSourceRemarks), //22 new SqlParameter("@UpdUser", AuthBase.UserId), //23 new SqlParameter("@UpdTerm", General.CurrentIP), //24 new SqlParameter("@IsVerificationFromCPLC ", model.IsVerificationFromCPLC), //25 new SqlParameter("@RegistrationBook", model.RegistrationBook), //26 new SqlParameter("@SaleInvoice", model.SaleInvoice), //27 new SqlParameter("@ExchangeType", (model.OfferCategory == "Exchange" ? 'Y' : 'N')), //27 new SqlParameter("@CellNo ", model.CellNo), //21 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation", param, Trans); IsSaved = true; } //if (sysfun.ExecuteSP_NonQuery("Insert_PriceOfferNegociation", param)) //{ // IsSaved = true; //} } catch (Exception) { throw; } return(IsSaved); }
protected void btnPrint_Click(object sender, EventArgs e) { SysFunction sysFunc = new SysFunction(); Data.DSReports data = new Data.DSReports(); ReportDocument RD = new ReportDocument(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@FromDate", SqlDbType.DateTime), //1 new SqlParameter("@ToDate", SqlDbType.DateTime), //2 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = sysFunc.SaveDate(txtfromdate.Text); param[2].Value = sysFunc.SaveDate(txtToDate.Text); SqlDataReader rder = null; // Store Procedure check and load if (sysFunc.ExecuteSP("sp_2W_Service_PSTCollection", param, ref rder)) //Database SP { data.EnforceConstraints = false; data.sp_2W_Service_PSTCollection.Load(rder); // DataSet SP } // Load in crystal report //RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt")); RD.Load(Server.MapPath("/Reports/rptInputType.rpt")); RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAdress"].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 = "'Services Tax Details'"; 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["ComplaintTypeCode"] = "'"+txtTicketNo.Text+"'"; // mention paper size //RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.Database.Tables[0].SetDataSource(data); string FilePath = Server.MapPath("~/Download/"); string FileName = "CounterSalesDetail" + Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; string File = FilePath + FileName; //crReportDocument.SetDatabaseLogon("SDMS", "sdms161", "192.168.1.47", "SDMS"); RD.Database.Tables[0].SetDataSource(data); Session["RD"] = RD; //RD.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); }
public static bool Insert_TaskMaster(TaskVM model) { //DateTime DueDate = Convert.ToDateTime(model.DueDate); //DateTime StartDate = Convert.ToDateTime(model.StartDate); //DateTime EndDate = Convert.ToDateTime(model.EndDate); try { if (model.TaskID == "0") { strAutoCode = sysfun.AutoGen("CRM_TaskMaster", "TaskID", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); } else { strAutoCode = model.TaskID; } //DateTime EndTime = Convert.ToDateTime(model.EndTime); // DateTime StartTime = Convert.ToDateTime(model.StartTime); SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@TaskID", strAutoCode), //1 new SqlParameter("@AssignTo", model.AssignTo), //2 new SqlParameter("@Prospect_ID", model.Prospect_ID), //5 new SqlParameter("@DueDate", (model.DueDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.DueDate))), //6 new SqlParameter("@LeadSourceID", model.LeadSourceID), //7 new SqlParameter("@Contact", model.Contact), //8 new SqlParameter("@Email", model.Email), //9 new SqlParameter("@Lead_ID", model.Lead_ID), //12 new SqlParameter("@Comments", model.Comments), //13 new SqlParameter("@Frequency", model.Frequency), //14 new SqlParameter("@FreqTrun", model.FreqTrun), //15 new SqlParameter("@StartDate", sysfun.SaveDate(model.StartDate)), //16 new SqlParameter("@StartTime", sysfun.SaveTime(model.StartTime)), //17 new SqlParameter("@EndDate", (model.EndDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.EndDate))), //18 new SqlParameter("@EndTime", (model.EndTime == null ? (object)DBNull.Value : Convert.ToDateTime(model.EndTime))), //19 new SqlParameter("@Ongoing", model.Ongoing), //20 new SqlParameter("@Reminder", model.Reminder), //21 new SqlParameter("@ReminderTime", (model.ReminderTime == null ? (object)DBNull.Value : Convert.ToDateTime(model.ReminderTime))), //22 new SqlParameter("@StatusTypeId", model.StatusTypeId), //24 new SqlParameter("@StatusId", model.StatusId), //25 new SqlParameter("@SubjectId", model.SubjectId), //26 new SqlParameter("@TaskTypeId", model.TaskTypeId), //27 }; if (sysfun.ExecuteSP_NonQuery("SP_Insert_TaskMaster", param)) { IsSaved = true; } } catch (Exception) { throw; } return(IsSaved); }
protected void btnShowReport_Click(object sender, EventArgs e) { if (!sec.UserRight("2564", "006")) { Response.Redirect("~/Test.aspx"); } if (dtFrom.Text == "" || dtTo.Text == "") { lblMSG.Text = "Please select dates"; return; } SqlDataReader rder; ReportDocument RD = new ReportDocument(); DateTime FromDate; DateTime ToDate; string FDate = myFunc.SaveDate(dtFrom.Text).ToString(); string TDate = myFunc.SaveDate(dtTo.Text).ToString(); FromDate = Convert.ToDateTime(FDate); ToDate = Convert.ToDateTime(TDate); //ReportDocument RD = new ReportDocument(); //DataSet dsRpt = new DataSet(); DXBMS.Data.DataSet1 objDsReports = new Data.DataSet1(); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FromDate", SqlDbType.DateTime), //0 new SqlParameter("@ToDate", SqlDbType.DateTime), //0 new SqlParameter("@Status", SqlDbType.VarChar, 10), //0 new SqlParameter("@EmpCode", SqlDbType.Char, 06) //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = FromDate.ToString("yyyy-MM-dd"); param[2].Value = ToDate.ToString("yyyy-MM-dd"); param[3].Value = rbStatus.SelectedItem.Value.ToString(); param[4].Value = ddlAdvisorCode.SelectedValue; DataTable dt = new DataTable(); string sql = "exec sp_JobCardDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "','" + rbStatus.SelectedItem.Value.ToString() + "','" + ddlAdvisorCode.SelectedValue + "'"; dt = myFunc.GetData(sql); RD.Load(Server.MapPath("../rptJobCardDateWise.rpt")); RD.OpenSubreport(Server.MapPath("../JobCardSummary.rpt")); RD.DataDefinition.FormulaFields["DealerDesc"].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["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'"; 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["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Jobcard Detail Report" + "\""; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; //RD.Database.Tables[0].SetDataSource(objDsReports); //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.SetDataSource(dt); 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 = "JobCardDetail" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; //string File = FilePath + FileName; //Session["RD"] = RD; //string URL = "../../../../Download/rptViewerService.aspx?ReportID="+ FileName; //string fullURL = "window.open('" + URL + "', '_blank', 'height=800,width=1500,status=no,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,titlebar=no');"; //ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); }
public static bool Insert_BOMaster(BookOrdMasterVM model, ref string msg) { IsSaved = false; try { if (model.BookRefNo == null || model.BookRefNo == "" || model.BookRefNo == "0") { strAutoCode = sysfun.AutoGen("BookOrdMaster", "BookRefNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); } else { strAutoCode = model.BookRefNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@BookRefNo", strAutoCode), //1 new SqlParameter("@BookRefDate", sysfun.SaveDate(model.BookRefDate)), //2 new SqlParameter("@InvTypeCode", model.InvTypeCode), //3 new SqlParameter("@InvSubTypeCode", model.InvSubTypeCode), //4 new SqlParameter("@PriceTypeCode", model.PriceTypeCode), //5 new SqlParameter("@CusCode", model.CusCode), //6 new SqlParameter("@UpdUser", AuthBase.UserId), //7 new SqlParameter("@UpdTerm", General.CurrentIP), //8 new SqlParameter("@FHName", model.FHName), //9 new SqlParameter("@Address1", model.Address1), //10 new SqlParameter("@NIC", model.NIC), //11 new SqlParameter("@NTN", model.NTN), //12 new SqlParameter("@CellNo", model.CellNo), //13 new SqlParameter("@Email", model.Email), //14 new SqlParameter("@PhoneNo", model.PhoneNo), //15 new SqlParameter("@SalesPerson", model.SalesPerson), //16 new SqlParameter("@BookMode", model.BookMode), //17 new SqlParameter("@Segment", model.Segment), //18 new SqlParameter("@TaxType", model.TaxType), //19 new SqlParameter("@CusTypeCode", model.CusTypeCode), //20 new SqlParameter("@StockType", model.StockType), //21 new SqlParameter("@DeliveryLocation", model.DeliveryLocation), //22 new SqlParameter("@PaymentTerms", model.PaymentTerms), //23 new SqlParameter("@AccountOf", model.AccountOf), //24 new SqlParameter("@VehicleTotal", model.VehicleTotal), //25 new SqlParameter("@City", model.City), //26 new SqlParameter("@State", model.State), //27 new SqlParameter("@Country", model.Country), //28 new SqlParameter("@VehicleQty", model.VehicleQty), //28 new SqlParameter("@EnquiryNo", model.EnquiryNo), //28 new SqlParameter("@RemainingTotal", model.RemainingTotal), //15 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { if (sysfun.ExecuteSP_NonQuery("SP_Insert_BookOrdMaster", param, Trans)) { IsSaved = true; } else { return(IsSaved); } } //if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param)) //{ // IsSaved = true; //} } catch (Exception ex) { //ObjTrans.RollBackTransaction(ref Trans); msg = ex.Message; } return(IsSaved); }
public static bool Insert_IRMaster(ReceiptMasterVM model) { DateTime recDate; ChasisNo = model.ChasisNo; EngineNo = model.EngineNo; try { if (model.ReceiptNo == "" || model.ReceiptNo == null) { strAutoCode = sysfun.AutoGen("ReceiptMaster", "ReceiptNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode); } else { strAutoCode = model.ReceiptNo; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@ReceiptNo", strAutoCode), //1 new SqlParameter("@ReceiptDate", sysfun.SaveDate(model.ReceiptDate)), //2 new SqlParameter("@CusCode", model.CusCode), //3 new SqlParameter("@Remarks", model.Remarks), //4 new SqlParameter("@ISFullAndFinal", 'N'), //5 new SqlParameter("@FullAndFinalReceiveable", 0.0), //6 new SqlParameter("@FullAndFinalPenalty", 0.0), //7 new SqlParameter("@FullAndFinalTotalReceiveable", 0.0), //8 new SqlParameter("@FullAndFinalDiscount", 0.0), //9 new SqlParameter("@CreateDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //10 new SqlParameter("@CreateTime", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //11 new SqlParameter("@CreatedBy", AuthBase.UserId), //12 new SqlParameter("@CreateTerm", General.CurrentIP), //13 new SqlParameter("@DelFlag", 'N'), //14 new SqlParameter("@PostFlag", 'Y'), //15 new SqlParameter("@PostDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //16 new SqlParameter("@TransferStatus", 'C'), //17 new SqlParameter("@TransferDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //18 new SqlParameter("@SoftwareVersion", DBNull.Value), //19 new SqlParameter("@CommunicationVersion", DBNull.Value), //20 new SqlParameter("@EmpCode", model.EmpCode), //21 new SqlParameter("@EmpDesc", model.EmpDesc), //22 new SqlParameter("@ProdDesc", model.ProdDesc), //23 new SqlParameter("@EngineNo", model.EngineNo), //24 new SqlParameter("@ChasisNo", model.ChasisNo), //25 new SqlParameter("@Type", model.Type), //26 new SqlParameter("@OldReceiptNo", DBNull.Value), //27 new SqlParameter("@InvoiceDate", sysfun.SaveDate(model.InvoiceDate)), //28 new SqlParameter("@BalanceWithoutPenalty", 0), //28 new SqlParameter("@BalancePenalty", 0), //28 new SqlParameter("@TotalBalance", 0), //24 new SqlParameter("@LastActualTransDate", sysfun.SaveDate(model.ReceiptDate)), //25 new SqlParameter("@LastPenaltyTransDate", sysfun.SaveDate(model.ReceiptDate)), //26 new SqlParameter("@PrintCounter", DBNull.Value), //27 new SqlParameter("@InvoiceNo", model.InvoiceNo), //28 new SqlParameter("@PRBNo", model.PRBNo), //28 new SqlParameter("@SONo", model.SONo), //28 new SqlParameter("@FormName", model.FormName), //28 new SqlParameter("@TransType", model.TransType), //28 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { sysfun.ExecuteSP_NonQuery("SP_Insert_ReceiptMaster", param, Trans); IsSaved = true; } } catch (Exception) { ObjTrans.RollBackTransaction(ref Trans); throw; } return(IsSaved); }
public static bool Insert_Event(EventVM model) { try { if (model.Event_ID.Trim() == "0" || model.Event_ID.Trim() == "") { string getNextEventID = "declare @lastval varchar(14),@id int " + "set @id = (select count(*) from Event) " + "set @id=@id+1 " + "if len(@id) = 1 " + "set @lastval= '0000' " + "if len(@id) = 2 " + "set @lastval='000' " + "if len(@id) = 3 " + "set @lastval='00' " + "if len(@id) >= 4 " + "set @lastval='0' " + "declare @i varchar(14) " + "set @i = CAST(@id as varchar(14)) " + "set @lastval = @lastval+@i " + "select @lastval as eventID"; dt = DataAccess.getDataTableByQuery(getNextEventID, nullSqlParam, General.GetBMSConString()); strAutoCode = dt.Rows[0]["eventID"].ToString(); } else { strAutoCode = model.Event_ID; } SqlParameter[] param = { new SqlParameter("@DealerCode", model.DealerCode), //0 new SqlParameter("@EventID", strAutoCode), //1 new SqlParameter("@EventDate", General.CurrentDate), //2 new SqlParameter("@EventDesc", model.EventDesc.Trim()), //3 new SqlParameter("@AssignID", model.AssignID), //4 new SqlParameter("@StartDate", sysfun.SaveDate(model.StartDate)), //5 new SqlParameter("@EndDate", sysfun.SaveDate(model.EndDate)), //6 new SqlParameter("@UpdUser", AuthBase.UserId), //7 new SqlParameter("@UpdTerm", General.CurrentIP), //8 new SqlParameter("@ExpBudget", model.ExpBudget), //9 new SqlParameter("@ActBudget", model.ActBudget), //10 new SqlParameter("@Status", model.Status), //11 new SqlParameter("@Feedback", model.Feedback), //12 new SqlParameter("@EventType", model.EventType), //13 new SqlParameter("@ProdCode", model.ProdCode), //14 new SqlParameter("@VersionCode", model.VersionCode), //15 new SqlParameter("@ColorCode", model.ColorCode == "0" ? (object)DBNull.Value : model.ColorCode), //16 new SqlParameter("@BrandCode", model.BrandCode == "0" ? (object)DBNull.Value : model.BrandCode), //17 }; dt = DataAccess.getDataTable("Sp_Insert_Event", param, General.GetBMSConString()); if (dt.Rows.Count > 0) { } IsSaved = true; } catch (Exception) { throw; } return(IsSaved); }
///Insert Button protected void btnInsert_Click(object sender, EventArgs e) { if (txtunitdec.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Enter Unit Description", txtunitdec); return; } else { lblMessage.Text = string.Empty; } DataTable dt = (DataTable)Session["UnitCategoryDS"]; // Check value in GridView TextBOX foreach (DataRow dr in dt.Rows) { if (dr["UnitDesc"].ToString().ToUpper() == txtunitdec.Text.ToUpper()) { sysFunc.UserMsg(lblMessage, Color.Red, "Alredy Exist"); return; } } try { string max = sysFuncs.GetNewMaxID("Unit", "UnitCode", 4, Session["DealerCode"].ToString()); SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@UnitCode", SqlDbType.Char, 4), //1 new SqlParameter("@UnitDesc", SqlDbType.VarChar, 50), //2 new SqlParameter("@UpdUser", SqlDbType.VarChar, 50), //3 new SqlParameter("@UpdDate", SqlDbType.DateTime), //4 new SqlParameter("@UpdTime", SqlDbType.DateTime), //5 new SqlParameter("@UpdTerm", SqlDbType.VarChar, 50), //6 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = max; param[2].Value = txtunitdec.Text.ToUpper().Trim(); param[3].Value = Session["UserName"].ToString(); param[4].Value = sysFunc.SaveDate(DateTime.Now.ToString("dd-MM-yyyy")); param[5].Value = DateTime.Now; param[6].Value = "1"; sysFunc.ExecuteSP_NonQuery("SP_Insert_Unit", param); sysFunc.ClearTextBoxes(Page); createGrid(); sysFuncs.UserMsg(lblMessage, Color.Green, "Data Inserted", txtunitdec); //lblMessage.Text = "New Unit Category Inserted."; } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void btnShowReport_Click(object sender, EventArgs e) { if (!sec.UserRight("2585", "006")) { Response.Redirect("~/Test.aspx"); } SqlDataReader rder; ReportDocument RD = new ReportDocument(); DataTable dt = new DataTable(); DateTime FromDate; DateTime ToDate; if (dtFrom.Text == "" || dtTo.Text == "") { lblMSG.Text = "Please select dates"; return; } string FDate = myFunc.SaveDate(dtFrom.Text).ToString(); string TDate = myFunc.SaveDate(dtTo.Text).ToString(); FromDate = Convert.ToDateTime(FDate); ToDate = Convert.ToDateTime(TDate); DXBMS.Data.DataSet1 objDsReports = new Data.DataSet1(); if (rbStatus.SelectedItem.Text == "GST") { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FromDate", SqlDbType.DateTime), //0 new SqlParameter("@ToDate", SqlDbType.DateTime), //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = FromDate.ToString("yyyy-MM-dd"); param[2].Value = ToDate.ToString("yyyy-MM-dd"); string sql = "exec SP__Get_rptGSTDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "'"; dt = myFunc.GetData(sql); RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.Load(Server.MapPath("../GSTDetailReport.rpt")); } else if (rbStatus.SelectedItem.Text == "Combine") { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FromDate", SqlDbType.DateTime), //0 new SqlParameter("@ToDate", SqlDbType.DateTime), //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = FromDate.ToString("yyyy-MM-dd"); param[2].Value = ToDate.ToString("yyyy-MM-dd"); string sql = "exec SP__Get_rptComDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "'"; dt = myFunc.GetData(sql); RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.Load(Server.MapPath("../ConbineTaxDetail.rpt")); } else { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 5), //0 new SqlParameter("@FromDate", SqlDbType.DateTime), //0 new SqlParameter("@ToDate", SqlDbType.DateTime), //0 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = FromDate.ToString("yyyy-MM-dd"); param[2].Value = ToDate.ToString("yyyy-MM-dd"); string sql = "exec SP__Get_rptPSTDetailReport '" + Session["DealerCode"].ToString() + "','" + FromDate.ToString("yyyy-MM-dd") + "','" + ToDate.ToString("yyyy-MM-dd") + "'"; dt = myFunc.GetData(sql); RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.Load(Server.MapPath("../PSTDetailReport.rpt")); } RD.DataDefinition.FormulaFields["DealerDesc"].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["DealerFax"].Text = "'" + Session["DealerFax"].ToString() + "'"; 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["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; if (rbStatus.SelectedItem.Text == "PST") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "PST Collection" + "\""; } else if (rbStatus.SelectedItem.Text == "Combine") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Combine Tax Collection" + "\""; } else { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GST Collection" + "\""; } RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.SetDataSource(dt); // Session["RD"]=RD; //// convert and show string FilePath = Server.MapPath("~") + "\\Download\\"; string FileName = "Report.pdf"; string File = FilePath + FileName; Session["RD"] = RD; string URL; URL = "../../../../Download/OpenPdf.aspx?ReportID=" + 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); //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); }
protected void btnPrint_Click(object sender, EventArgs e) { SysFunction SysFunc = new SysFunction(); string FDate = SysFunc.SaveDate(txtFromDate.Text).ToString(); string TDate = SysFunc.SaveDate(txtToDate.Text).ToString(); PdfDocument outputDocument = new PdfDocument(); string desktopPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop); string extension = "FileName.pdf"; desktopPath += @"\" + extension; SqlDataReader rder; ReportDocument RD = new ReportDocument(); DataTable dt = new DataTable(); string sql; DataSet dsRpt = new DataSet(); DXBMS.Data.DSReports objDsReports = new Data.DSReports(); if (ViewState["SparePart"].ToString() == "PTV") { if (!sec.UserRight("2568", "006")) { Response.Redirect("~/Test.aspx"); } sql = "exec SP_PaymenttoVendor_Select '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'"; RD.Load(Server.MapPath("~/Modules/SpareParts/SpareReports/PaymentToVendorDetailReport.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "PAYMENT TO VENDOR DETAIL" + "\""; } else if (ViewState["SparePart"].ToString() == "SA") { if (!sec.UserRight("2569", "006")) { Response.Redirect("~/Test.aspx"); } sql = "exec SP_StockAdjustment_DetailReport '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'"; RD.Load(Server.MapPath("~/Modules/SpareParts/SpareReports/crtStockAdjustment.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Stock Adjustment Detail Report" + "\""; } else if (ViewState["SparePart"].ToString() == "IL") { if (!sec.UserRight("2571", "006")) { Response.Redirect("~/Test.aspx"); } sql = "exec sp2W_Spare_InvoiceDetail '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'"; RD.Load(Server.MapPath("../rptInvoices.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Invoices Detail Report" + "\""; } else if (ViewState["SparePart"].ToString() == "IR") { if (!sec.UserRight("2590", "006")) { Response.Redirect("~/Test.aspx"); } sql = "exec sp2W_Revenue_InvoiceDetail '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'"; RD.Load(Server.MapPath("../rptInvoiceRevenue.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Invoices Revenue Detail Report" + "\""; } else if (ViewState["SparePart"].ToString() == "DS") { if (!sec.UserRight("2572", "006")) { Response.Redirect("~/Test.aspx"); } string cond = ""; sql = "Sp_2W_CounterSaleDetail_rpt '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'" + cond; RD.Load(Server.MapPath("../rptCounterSaleDetail.rpt")); RD.DataDefinition.FormulaFields["FromCode"].Text = "\"" + Convert.ToDateTime(FDate.ToString()).ToString("dd/MM/yyyy") + "\""; RD.DataDefinition.FormulaFields["ToCode"].Text = "\"" + Convert.ToDateTime(TDate.ToString()).ToString("dd/MM/yyyy") + "\""; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Direct Sale Detail Report" + "\""; } else if (ViewState["SparePart"].ToString() == "GRN") { if (!sec.UserRight("2573", "006")) { Response.Redirect("~/Test.aspx"); } sql = "exec sp_GRNDetailList '" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "'"; RD.Load(Server.MapPath("../rptPartsReceivedDetail.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GRN DETAIL REPORT" + "\""; RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; } else { if (!sec.UserRight("2570", "006")) { Response.Redirect("~/Test.aspx"); } sql = "exec sp_2W_Spares_Aging'" + Session["DealerCode"].ToString() + "','" + FDate + "','" + TDate + "' ,'" + txtCustomer.Text + "'"; RD.Load(Server.MapPath("../rptCustomerWiseOutstandingSummary.rpt")); RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Wise OutStanding Summary Report" + "\""; } dt = SysFunc.GetData(sql); RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; RD.Database.Tables[0].SetDataSource(dt); 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); //RD.ExportToDisk(ExportFormatType.PortableDocFormat, File); //string URL; //URL = Page.ResolveUrl("~/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); //string URL = "../Criteria/POView.aspx?CusWise=" + "&ReportID=" + RptName.ToString() + "&fromDate=" + FromDate + "&ToDate=" + ToDate; //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 btn_save_Click(object sender, EventArgs e) { string strAutoCode = string.Empty; string active = "N"; string leavedate = txtleaving_date.Text; if (txtEmpID.BorderColor == Color.Red) { success_add_item.Visible = true; success_add_item.Text = "This Employee No. is already in use"; return; } if (cbActive.Checked == true) { active = "Y"; } if (cbActive.Checked == false) { active = "N"; } if (active == "Y" && txtleaving_date.Text.Trim() != string.Empty) { success_add_item.Visible = true; success_add_item.Text = "Remove Leaving Date If you are still Employee"; return; } if (active == "N" && txtleaving_date.Text == "") { success_add_item.Visible = true; success_add_item.Text = "Enter Leaving Date"; return; } //if(ddldep_code.SelectedValue == "001" && ddldesig_code.SelectedValue == "001") //{ // if(txtEmail.Text == "") // { // RegularExpressionValidator4.IsValid = false; // RegularExpressionValidator4.Visible = true; // RegularExpressionValidator4.ErrorMessage = "Email address is necessary"; // return; // }else // { // RegularExpressionValidator4.Visible = false; // RegularExpressionValidator4.ErrorMessage = ""; // } //} try { //join_date = Convert.ToDateTime(txtjoining_date.Text).Date; join_date = DateTime.ParseExact(txtjoining_date.Text, "dd-MM-yyyy", null); //dob_date = Convert.ToDateTime(txtdob.Text).Date; dob_date = DateTime.ParseExact(txtdob.Text, "dd-MM-yyyy", null); if (txtleaving_date.Text.Trim() != string.Empty) { leav_date = DateTime.ParseExact(txtleaving_date.Text, "dd-MM-yyyy", null); } if (ddlEmployee.SelectedIndex == 0) { strAutoCode = SysFunc.GetNewMaxID("DealerEmp", "EmpCode", 3, Session["DealerCode"].ToString()); } else { strAutoCode = ddlEmployee.SelectedItem.Value; } if (SysFunc.ValidateDate(txtdob.Text) == true) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid DOB, not greater than current Date"; return; } if (SysFunc.ValidateDate(txtjoining_date.Text) == true) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid Joining Date, not greater than current Date"; return; } if (SysFunc.ValidateDate(txtleaving_date.Text) == true && txtleaving_date.Text != string.Empty) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid Leaving, not greater than current Date"; return; } if (dob_date >= join_date) { success_add_item.Visible = true; success_add_item.Text = "Enter Valid DOB, not greater than or equal to Joining Date"; return; } if (join_date >= leav_date && txtleaving_date.Text != string.Empty) { success_add_item.Visible = true; success_add_item.Text = "Joining Date not greater than or equal to Leaving Date"; return; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@EmpCode", SqlDbType.Char), //1 new SqlParameter("@EmpID", SqlDbType.Char), //2 new SqlParameter("@EmpName", SqlDbType.VarChar), //3 new SqlParameter("@JoiningDate", SqlDbType.DateTime), //4 new SqlParameter("@ContactNo", SqlDbType.VarChar), //5 new SqlParameter("@DOB", SqlDbType.DateTime), //6 new SqlParameter("@Experience", SqlDbType.TinyInt), //7 new SqlParameter("@LeavingDate", SqlDbType.DateTime), //8 new SqlParameter("@DesigCode", SqlDbType.Char), //9 new SqlParameter("@DeptCode", SqlDbType.Char), //10 new SqlParameter("@Remarks", SqlDbType.VarChar), //11 new SqlParameter("@PrimaryTechCode", SqlDbType.Char), //12 new SqlParameter("@UserName", SqlDbType.VarChar), //13 new SqlParameter("@Password", SqlDbType.VarChar), //14 new SqlParameter("@Role", SqlDbType.VarChar), //15 new SqlParameter("@Active", SqlDbType.Char), //16 new SqlParameter("@SecurityUserID", SqlDbType.Char), //17 new SqlParameter("@CNIC", SqlDbType.Char), //18 new SqlParameter("@Picture", SqlDbType.VarChar), //19 new SqlParameter("@Email", SqlDbType.VarChar) //20 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = strAutoCode; param[2].Value = txtEmpID.Text; param[3].Value = txtEmp_name.Text; param[4].Value = join_date; param[5].Value = txtcontact_no.Text; param[6].Value = dob_date; param[7].Value = txtexp.Text; param[8].Value = SysFunc.SaveDate(txtleaving_date.Text); param[9].Value = ddldesig_code.SelectedItem.Value; param[10].Value = ddldep_code.SelectedItem.Value; param[11].Value = txtremarks.Text; param[12].Value = ""; param[13].Value = ""; param[14].Value = ""; param[15].Value = ""; param[16].Value = active; param[17].Value = string.Empty; param[18].Value = txtnic_no.Text.Trim(); param[19].Value = Session["EmployeeImagePath"].ToString(); param[20].Value = txtEmail.Text; SysFunc.ExecuteSP_NonQuery("Sp_Insert_DealerEmp", param); cleardata(); LoadDDL_EmpCode(); success_add_item.Visible = true; success_add_item.ForeColor = Color.Green; if (btn_save.Text == "Save") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Savealert()", true); } if (btn_save.Text == "Update") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "Updatealert()", true); } } catch (Exception ex) { success_add_item.Visible = true; success_add_item.Text = ex.Message; } }
protected void btnShow_Click(object sender, EventArgs e) { if (!sec.UserRight("2567", "006")) { Response.Redirect("~/Test.aspx"); } try { if (txtFromDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date"); return; } else if (txtToDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date"); return; } if (ddlUtilityAudit.SelectedIndex == 0) { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Utility Audit Option"); return; } SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar) //2 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = sysFunc.SaveDate(txtFromDate.Text); param[2].Value = sysFunc.SaveDate(txtToDate.Text); SqlDataReader rder = null; if (ddlUtilityAudit.SelectedValue == "Estimate") { if (sysFunc.ExecuteSP("SP_EstimateReport_pSelect", param, ref rder)) //Database SP { data.EnforceConstraints = false; data.SP_JobCardMaster.Load(rder); // DataSet SP } } if (ddlUtilityAudit.SelectedValue == "JobCard") { if (sysFunc.ExecuteSP("SP_JobCardReport_pSelect", param, ref rder)) //Database SP { data.EnforceConstraints = false; data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "CounterSale") { if (sysFunc.ExecuteSP("SP_CounterSaleMaster_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice") { if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "PayRec") { if (sysFunc.ExecuteSP("SP_CustomerInvoice_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "GRN") { if (sysFunc.ExecuteSP("SP_GRNMaster_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } else if (ddlUtilityAudit.SelectedValue == "ChargeOut") { if (sysFunc.ExecuteSP("SP_ChargeOutMaster_pSelect", param, ref rder)) //Database SP { data.SP_JobCardMaster.Load(rder); // DataSet SP } } RD.Load(Server.MapPath("../crpUtilityAuditReport.rpt")); // mention paper size RD.PrintOptions.PaperSize = PaperSize.PaperA4; RD.DataDefinition.FormulaFields["DealerDesc"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'"; RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'"; //RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; if (ddlUtilityAudit.SelectedValue == "Estimate") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Estimate Report" + "\""; } if (ddlUtilityAudit.SelectedValue == "JobCard") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Job Card Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "CounterSale") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Counter Sale Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "CustomerInvoice") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Customer Invoice Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "PayRec") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Payment Receipt Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "GRN") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "GRN Report" + "\""; } else if (ddlUtilityAudit.SelectedValue == "ChargeOut") { RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Stock Adjustment Report" + "\""; } //RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; // RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); 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 //string FilePath = Server.MapPath("~") + "\\Download\\"; //string FileName = "UtilityAuditReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; //string File = FilePath + FileName; //Session["RD"] = RD; //string URL; //URL = "../../../../Download/rptViewerService.aspx?ReportID=" + 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); } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
protected void btnShow_Click(object sender, EventArgs e) { if (!sec.UserRight("2580", "006")) { Response.Redirect("~/Test.aspx"); } try { if (txtFromDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select From Date"); return; } else if (txtToDate.Text == "") { sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select To Date"); return; } //if (ddlVendorCode.SelectedIndex == 0) //{ // sysFuncs.UserMsg(lblMessage, Color.Red, "Please Select Vendor Option"); // return; //} SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char), //0 new SqlParameter("@FromDate", SqlDbType.VarChar), //1 new SqlParameter("@ToDate", SqlDbType.VarChar), //2 new SqlParameter("@VendorCode", SqlDbType.VarChar) //3 }; param[0].Value = Session["DealerCode"].ToString(); param[1].Value = sysFunc.SaveDate(txtFromDate.Text); param[2].Value = sysFunc.SaveDate(txtToDate.Text); param[3].Value = ddlVendorCode.SelectedValue.ToString().Trim(); SqlDataReader rder = null; //SP_VendorLedger_Report // Store Procedure check and load if (sysFunc.ExecuteSP("SP_VendorLedger_Report", param, ref rder)) //Database SP { data.SP_VendorLedger_Report.Load(rder); // DataSet SP } // Load in crystal report //RD.Load(Server.MapPath("../PurchaseSaleReturnReport.rpt")); RD.Load(Server.MapPath("../crptVendorLedgerReport.rpt")); // mention paper size RD.PrintOptions.PaperSize = PaperSize.PaperA4; //RD.Load(Server.MapPath("../../SpareReports/rptInvoices.rpt")); // RD.Load(Server.MapPath("../rptJobHistory.rpt")); //RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Phone1", "Dealer") + "'"; // RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + sysFunc.GetStringValuesAgainstCodes("DealerCode", Session["DealerCode"].ToString(), "Email", "Dealer") + "'"; RD.DataDefinition.FormulaFields["DealerPhone"].Text = "'" + Session["DealerPhone"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerEmail"].Text = "'" + Session["DealerEmail"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; RD.DataDefinition.FormulaFields["DealerAddress"].Text = "'" + Session["DealerAddress"].ToString() + "'"; RD.DataDefinition.FormulaFields["SalesTaxNo"].Text = "'" + Session["DealerSaleTaxNo"].ToString() + "'"; RD.DataDefinition.FormulaFields["NTN"].Text = "'" + Session["DealerNTN"].ToString() + "'"; RD.DataDefinition.FormulaFields["UserID"].Text = "'" + Session["UserID"].ToString() + "'"; //RD.DataDefinition.FormulaFields["FromCode"].Text = "'" + FDate + "'"; //RD.DataDefinition.FormulaFields["ToCode"].Text = "'" + TDate + "'"; RD.DataDefinition.FormulaFields["Terminal"].Text = "'" + Environment.MachineName + "'"; RD.DataDefinition.FormulaFields["ReportTitle"].Text = "\"" + "Vendor Ledger Report" + "\""; RD.DataDefinition.FormulaFields["CompanyName"].Text = "'" + Session["DealerDesc"].ToString() + "'"; //RD.DataDefinition.FormulaFields["DealershipName"].Text = "'Authorised " + Session["ParentDesc"].ToString() + " Dealership'"; //RD.DataDefinition.FormulaFields["Pic"].Text = "'C:\\Users\\u_ahm\\OneDrive\\Documents\\Visual Studio 2010\\Projects\\WebApplication1\\WebApplication1\\" + Session["Logo"] + "'"; RD.DataDefinition.FormulaFields["Pic"].Text = "'" + Server.MapPath("~") + Session["Logo"] + "'"; RD.Database.Tables[0].SetDataSource(data); 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 //string FilePath = Server.MapPath("~") + "\\Download\\"; //string FileName = "VendorLedgerReport" + this.Session["DealerCode"].ToString() + DateTime.Now.ToString("ddMMyyyy") + ".pdf"; //string File = FilePath + FileName; //Session["RD"] = RD; ////RD.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); } catch (Exception ex) { sysFunc.UserMsg(lblMessage, System.Drawing.Color.Red, ex.Message); } }
public static bool Insert_InvDetail(List <VehicleStockVM> model2, ref string msg) { int count = 0; try { foreach (var item in model2) { if (count >= 1 || item.InvoiceNo != null) { SqlParameter[] param2 = { new SqlParameter("@DealerCode", item.DealerCode), //0 new SqlParameter("@ChassisNo", strAutoCode), //1 new SqlParameter("@InvoiceNo", item.InvoiceNo), //2 new SqlParameter("@InvoiceDate", item.InvoiceDate == null ?(object)DBNull.Value : sysfun.SaveDate(item.InvoiceDate)), //22 new SqlParameter("@Type", item.Type), //4 new SqlParameter("@DeliveredTOCustomer", item.DeliveredTOCustomer.Trim()), //5 new SqlParameter("@ReceiveFromOEM", item.ReceiveFromOEM.Trim()), //6 }; if (sysfun.ExecuteSP_NonQuery("SP_VehicleInvoiceDetail_Insert", param2, Trans) == true) { IsSaved = true; } else { ObjTrans.RollBackTransaction(ref Trans); IsSaved = false; } } count++; } ObjTrans.CommittTransaction(ref Trans); IsSaved = true; } catch (Exception ex) { ObjTrans.RollBackTransaction(ref Trans); msg = ex.Message; IsSaved = false; } return(IsSaved); }
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); } }