public ActionResult GetById(int id) { int iCode = 200; BaseResponse response = null; try { ProviderLicense license = _service.Get(id); if (license == null) { iCode = 404; response = new ErrorResponse("Application resource not found"); } else { response = new ItemResponse <ProviderLicense> { Item = license }; } } catch (Exception ex) { iCode = 500; base.Logger.LogError(ex.ToString()); response = new ErrorResponse(ex.Message); } return(StatusCode(iCode, response)); }
public Paged <ProviderLicense> GetByCreatedBy(int pageIndex, int pageSize, int createdBy) { string procName = "dbo.Licenses_Select_ByCreatedBy"; Paged <ProviderLicense> pagedList = null; List <ProviderLicense> list = null; int totalCount = 0; _data.ExecuteCmd(procName, inputParamMapper : delegate(SqlParameterCollection param){ param.AddWithValue("@CurrentPage", pageIndex); param.AddWithValue("@ItemsPerPage", pageSize); param.AddWithValue("@CreatedBy", createdBy); }, singleRecordMapper : delegate(IDataReader reader, short set) { int startingIndex = 0; ProviderLicense pl = MapLicense(reader, out startingIndex); if (list == null) { totalCount = reader.GetSafeInt32(startingIndex += 1); list = new List <ProviderLicense>(); } list.Add(pl); }); if (list != null) { pagedList = new Paged <ProviderLicense>(list, pageIndex, pageSize, totalCount); } return(pagedList); }
private static ProviderLicense MapLicense(IDataReader reader, out int index) { index = 0; ProviderLicense license = new ProviderLicense(); license.Id = reader.GetSafeInt32(index); license.LicenseNumber = reader.GetSafeString(index += 1); license.DateExpires = reader.GetSafeDateTime(index += 1); license.CreatedBy = reader.GetSafeInt32(index += 1); license.DateCreated = reader.GetSafeDateTime(index += 1); license.ModifiedBy = reader.GetSafeInt32(index += 1); license.DateModified = reader.GetSafeDateTime(index += 1); int userProfileId = reader.GetSafeInt32(index += 1); int userId = reader.GetSafeInt32(index += 1); string firstName = reader.GetSafeString(index += 1); string lastName = reader.GetSafeString(index += 1); string mi = reader.GetSafeString(index += 1); string avatarUrl = reader.GetSafeString(index += 1); DateTime dateCreated = reader.GetSafeDateTime(index += 1); DateTime dateModified = reader.GetSafeDateTime(index += 1); int createdBy = reader.GetSafeInt32(index += 1); int modifiedBy = reader.GetSafeInt32(index += 1); int stateId = reader.GetSafeInt32(index += 1); string state = reader.GetSafeString(index += 1); string stateCode = reader.GetSafeString(index += 1); if (userProfileId > 0) { license.UserProfile = new UserProfile(); license.UserProfile.Id = userProfileId; license.UserProfile.UserId = userId; license.UserProfile.FirstName = firstName; license.UserProfile.LastName = lastName; license.UserProfile.Mi = mi; license.UserProfile.AvatarUrl = avatarUrl; license.UserProfile.DateCreated = dateCreated; license.UserProfile.DateModified = dateModified; license.UserProfile.CreatedBy = createdBy; license.UserProfile.ModifiedBy = modifiedBy; } if (stateId > 0) { license.State = new State(); license.State.Id = stateId; license.State.Name = state; license.State.Code = stateCode; } return(license); }
public ProviderLicense Get(int id) { string procName = "dbo.Licenses_Select_ById"; ProviderLicense license = null; _data.ExecuteCmd(procName, inputParamMapper : delegate(SqlParameterCollection parameterCollection) { parameterCollection.AddWithValue("@Id", id); }, singleRecordMapper : delegate(IDataReader reader, short set) { int startingIndex = 0; license = MapLicense(reader, out startingIndex); }); return(license); }