public OperationResult InsertVehicleData(InsertVehcielModel model) { OperationResult or; try { or = new VehicelBl().InsertNewVehicle(model); } catch (Exception ex) { throw ex; } return(or); }
public OperationResult UpdateVehicleData(InsertVehcielModel vehciel) { OperationResult or; try { or = new VehicelBl().UpdateVehicleData(vehciel); } catch (Exception ex) { throw ex; } return(or); }
public OperationResult InsertNewVehicle(InsertVehcielModel vehciel) { var be = new BusinessException(); OperationResult or = new OperationResult(); using (IDbConnection db = new SqlConnection(TransportationConstants.Cn)) { if (db.State == ConnectionState.Closed) { db.Open(); } try { var result = db.Query <int>("Mob_InsertNewVehcile", new { VId = vehciel.VId, UserID = vehciel.UserID, VehicleCategoryId = vehciel.vCategoryNameId, WeightCapacity = vehciel.vWeight, VehicleModelId = vehciel.vModelId, OperationCard = vehciel.OperationCard, ManufactureYear = vehciel.manufactureYear, InsuranceNo = vehciel.insuranceNumber, PlatNumber = vehciel.platNumber }, commandType: CommandType.StoredProcedure).SingleOrDefault(); db.Close(); if (result > 0) { or.Result = result; } else { or.Result = 0; } return(or); } catch (Exception e) { throw e; } } }