public JsonResult Insert_VehicleReturnMaster(VehicleReturnMasterVM VRMasterVM) { bool result = false; string msg = "Failed to save record.."; result = VehicleMethods.Insert_VehicleReturnMaster(VRMasterVM); if (result) { msg = "Successfully Added"; } return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet)); }
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); }