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));
        }
Esempio n. 2
0
        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);
        }