public JsonResult Insert_VSMaster(VehicleStockVM VehStockVM) { bool result = false; string msg = "Failed to save record.."; result = VehicleUpdateMethods.Insert_VSMaster(VehStockVM, Session["DealerCode"].ToString()); if (result) { msg = "Successfully Added"; } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }
public static bool Insert_VSMaster(VehicleStockVM model, string dealerCode) { try { SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@ChasisNo", model.ChasisNo), //1 new SqlParameter("@EngineNo", model.EngineNo), //2 new SqlParameter("@CusCode", model.CusCode), //3 new SqlParameter("@BrandCode", model.BrandCode), //4 new SqlParameter("@ProdCode", model.ProdCode), //5 new SqlParameter("@ColorCode", model.ColorCode), //6 new SqlParameter("@RegNo", model.RegNo), //9 new SqlParameter("@RegDate", model.RegDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.RegDate)), //10 new SqlParameter("@InvoiceNo", model.InvoiceNo), //11 new SqlParameter("@InvoiceDate", model.InvoiceDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.InvoiceDate)), //12 new SqlParameter("@OrderNo", model.OrderNo), //13 new SqlParameter("@OrderDate", model.OrderDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.OrderDate)), //14 new SqlParameter("@BookingRefNo", model.BookingRefNo), //15 new SqlParameter("@BookingRefDate", model.BookingRefDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.BookingRefDate)), //16 new SqlParameter("@BookRecDate", model.BookRecDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.BookRecDate)), //17 new SqlParameter("@BookIssueDate", model.BookIssueDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.BookIssueDate)), //18 new SqlParameter("@InsCompCode", model.InsCompCode), //19 new SqlParameter("@InsPolicyNo", model.InsPolicyNo), //20 new SqlParameter("@InsDate", model.InsDate == null ?(object)DBNull.Value :sysfun.SaveDate(model.InsDate)) //21 }; //if (ObjTrans.BeginTransaction(ref Trans) == true) //{ // sysfun.ExecuteSP_NonQuery("SP_Update_VehicleStock", param, Trans); // IsSaved = true; //} if (sysfun.ExecuteSP_NonQuery("SP_Update_VehicleStock", param)) { IsSaved = true; } } catch (Exception) { throw; } return(IsSaved); }
public static bool Insert_VSMaster(VehicleStockVM model, string dealerCode, ref string msg) { try { strAutoCode = model.ChasisNo; SqlParameter[] param = { new SqlParameter("@DealerCode", dealerCode), //0 new SqlParameter("@ChasisNo", model.ChasisNo), //1 new SqlParameter("@EngineNo", model.EngineNo), //2 new SqlParameter("@CusCode", model.CusCode), //3 new SqlParameter("@BrandCode", model.BrandCode), //4 new SqlParameter("@ProdCode", model.ProdCode), //5 new SqlParameter("@ColorCode", model.ColorCode), //6 new SqlParameter("@RegNo", model.RegNo), //9 new SqlParameter("@RegDate", model.RegDate == null ? (object)DBNull.Value : model.RegDate), //10 new SqlParameter("@InvoiceNo", model.InvoiceNo), //11 new SqlParameter("@InvoiceDate", model.InvoiceDate == null ? (object)DBNull.Value : model.InvoiceDate), //12 new SqlParameter("@OrderNo", model.OrderNo), //13 new SqlParameter("@OrderDate", model.OrderDate == null ? (object)DBNull.Value : model.OrderDate), //14 new SqlParameter("@BookingRefNo", model.BookingRefNo), //15 new SqlParameter("@BookingRefDate", model.BookingRefDate == null ? (object)DBNull.Value : model.BookingRefDate), //16 new SqlParameter("@BookRecDate", model.BookRecDate == null ? (object)DBNull.Value : model.BookRecDate), //17 new SqlParameter("@BookIssueDate", model.BookIssueDate == null ? (object)DBNull.Value : model.BookIssueDate), //18 new SqlParameter("@InsCompCode", model.InsCompCode), //19 new SqlParameter("@InsPolicyNo", model.InsPolicyNo), //20 new SqlParameter("@InsDate", model.InsDate == null ?(object)DBNull.Value : model.InsDate), //21 new SqlParameter("@TransportDelivery", model.TransportDelivery == null ?(object)DBNull.Value : model.TransportDelivery) //22 }; if (ObjTrans.BeginTransaction(ref Trans) == true) { if (sysfun.ExecuteSP_NonQuery("SP_Update_VehicleStock", param)) { IsSaved = true; } } } catch (Exception ex) { msg = ex.Message; } return(IsSaved); }