public AllCouriersResponse GetAllCouriers(AllCouriresRequest request) { var response = new AllCouriersResponse { ResponseStatus = ResponseStatus.Success }; var usersProvider = new UsersProvider(); try { if (request.ActionType == ActionType.Select) { response.Couriers = usersProvider.GetAllCouriers(request); } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }
public AllCouriresRequest GetAllCouriersRequest() { var request = new AllCouriresRequest { ActionType = DataBaseCommunication.Mappers.Requests.ActionType.Select }; return(request); }
internal List<Courier> GetAllCouriers(AllCouriresRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Get_All_Couriers", conn); IDataReader reader = null; List<Courier> tmp = new List<Courier>(); try { conn.Open(); reader = commandWrapper.ExecuteReader(); FillCouriers(reader, tmp, 0, int.MaxValue); MakeDboLog(request.ToString(), reader.ToString(), "dbo.Get_All_Couriers"); return tmp; } finally { if (reader != null) reader.Close(); commandWrapper.Dispose(); conn.Close(); } }