示例#1
0
        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 JsonResult Insert_Exchange(VehicleExchangeVM Objects)
        {
            string dealerCode = Session["DealerCode"].ToString();
            bool   result     = false;

            string msg = "Failed to save record..";


            result = VehicleExchangeMethods.Insert_Exchange(Objects, dealerCode);

            if (result)
            {
                msg = "Successfully Added";
            }

            return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
        }