Exemple #1
0
        public bool UpdateVehicleMasterDs(VehicleMasterDs vehicleMasterDs)
        {
            bool returnvalue = false;

            DynamicParameters param = new DynamicParameters();

            param.Add("@UniversityId", vehicleMasterDs.UniversityId);
            param.Add("@VehicleId", vehicleMasterDs.VehicleId);
            param.Add("@RegistrationNumber", vehicleMasterDs.RegistrationNumber);
            param.Add("@Description", vehicleMasterDs.Description);
            param.Add("@OwnerNumber", vehicleMasterDs.OwnerNumber);
            param.Add("@WeightCapacity", vehicleMasterDs.WeightCapacity);
            param.Add("@VehicleStatus", vehicleMasterDs.VehicleStatus);
            param.Add("@RegistrationDate", DateTime.Today);
            param.Add("@InsuranceDetails", vehicleMasterDs.InsuranceDetails);
            param.Add("@InsuranceExpiryDate", DateTime.Today);
            param.Add("@Active", 1);
            param.Add("@lastupdateddt", DateTime.UtcNow);
            param.Add("@lastupdatedby", 1);


            _db.Open();
            var val = _db.Execute("YSP_UpdateVehicleMaster", param, commandType: CommandType.StoredProcedure);

            if (val > 0)
            {
                returnvalue = true;
            }

            _db.Close();
            return(returnvalue);
        }
Exemple #2
0
        public IHttpActionResult UpdateVehicleMasterDs(VehicleMasterDs vehicleMasterDs)
        {
            var isupdate = _vehicleMasterRepository.UpdateVehicleMasterDs(vehicleMasterDs);

            if (isupdate == true)
            {
                return(Ok(isupdate));
            }
            return(BadRequest());
        }