public IEnumerable <FDICircularIndex> GetFDICircularIndex(FDICircularIndex fDICircularIndex) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int)); ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int)); var fDICircularIndexes = dataContext.FDICircularIndexGet(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDICircularId, fDICircularIndex.FDIChapterId, Utility.TrimString(fDICircularIndex.SearchText), fDICircularIndex.IsActive, fDICircularIndex.PageNumber, fDICircularIndex.PageSize, fDICircularIndex.IsPagingRequired, Utility.TrimString(fDICircularIndex.OrderBy), Utility.TrimString(fDICircularIndex.OrderByDirection), totalPageCount, totalRecord).ToList(); var fDICircularIndexList = new List <FDICircularIndex>(); foreach (var fDICircularIndexDetail in fDICircularIndexes) { fDICircularIndexList.Add(new FDICircularIndex() { FDICircularIndexId = fDICircularIndexDetail.FDICircularIndexId, FDIChapterId = fDICircularIndexDetail.FDIChapterId, IndexNo = fDICircularIndexDetail.IndexNo, IndexName = fDICircularIndexDetail.IndexName, IndexContent = fDICircularIndexDetail.IndexContent, SortId = fDICircularIndexDetail.SortId, IsActive = fDICircularIndexDetail.IsActive, TotalPageCount = Convert.ToInt32(totalPageCount.Value), TotalRecord = Convert.ToInt32(totalRecord.Value) }); } return(fDICircularIndexList); } }
public IHttpActionResult UpdateFDICircularIndex(UpdateFDICircularIndexRequest updateFDICircularIndexRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } var fDICircularIndex = new FDICircularIndex() { FDICircularIndexId = updateFDICircularIndexRequest.FDICircularIndexId, FDIChapterId = updateFDICircularIndexRequest.FDIChapterId, IndexNo = updateFDICircularIndexRequest.IndexNo, IndexName = updateFDICircularIndexRequest.IndexName, IndexContent = updateFDICircularIndexRequest.IndexContent, SaveAfterIndexId = updateFDICircularIndexRequest.SaveAfterIndexId, ModifiedBy = Utility.UserId }; int result = iFDICircularIndex.UpdateFDICircularIndex(fDICircularIndex); switch (result) { case 1: responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircularIndex updated successfully."; break; case -2: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircularIndex already exists."; break; case -3: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircularIndex doesn't exist."; break; default: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating FDICircularIndex."; break; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating FDICircularIndex."; Utility.WriteLog("UpdateFDICircularIndex", updateFDICircularIndexRequest, "Error while updating FDICircularIndex. (FDICircularIndexAdminController)", ex.ToString()); } return(Ok(responses)); }
public int DeleteFDICircularIndex(FDICircularIndex fDICircularIndex) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FDICircularIndexDelete(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDIChapterId, fDICircularIndex.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public int UpdateFDICircularIndex(FDICircularIndex fDICircularIndex) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FDICircularIndexUpdate(fDICircularIndex.FDICircularIndexId, fDICircularIndex.FDIChapterId, Utility.TrimString(fDICircularIndex.IndexNo), Utility.TrimString(fDICircularIndex.IndexName), Utility.TrimString(fDICircularIndex.IndexContent), fDICircularIndex.SaveAfterIndexId, fDICircularIndex.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public IHttpActionResult AddFDICircularIndex(AddFDICircularIndexRequest addFDICircularIndexRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var fDICircularIndex = new FDICircularIndex() { FDIChapterId = addFDICircularIndexRequest.FDIChapterId, IndexNo = addFDICircularIndexRequest.IndexNo, IndexName = addFDICircularIndexRequest.IndexName, IndexContent = addFDICircularIndexRequest.IndexContent, SaveAfterIndexId = addFDICircularIndexRequest.SaveAfterIndexId }; int result = iFDICircularIndex.AddFDICircularIndex(fDICircularIndex); if (result > 0) { responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircularIndex added successfully."; } else if (result == -2) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircularIndex alread exists."; } else { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FDICircularIndex."; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FDICircularIndex."; Utility.WriteLog("AddFDICircularIndex", addFDICircularIndexRequest, "Error while adding FDICircularIndex. (FDICircularIndexAdminController)", ex.ToString()); } return(Ok(responses)); }
public IHttpActionResult GetFDICircularIndex([FromUri] GetFDICircularIndexRequest getFDICircularIndexRequest) { var responses = new Responses(); try { if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } if (getFDICircularIndexRequest == null) { getFDICircularIndexRequest = new GetFDICircularIndexRequest(); } if (getFDICircularIndexRequest.PageSize == null) { getFDICircularIndexRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]); } var fDICircularIndex = new FDICircularIndex() { FDICircularIndexId = getFDICircularIndexRequest.FDICircularIndexId, FDICircularId = getFDICircularIndexRequest.FDICircularId, FDIChapterId = getFDICircularIndexRequest.FDIChapterId, SearchText = getFDICircularIndexRequest.SearchText, IsActive = getFDICircularIndexRequest.IsActive, PageNumber = getFDICircularIndexRequest.PageNumber, PageSize = Convert.ToInt32(getFDICircularIndexRequest.PageSize), IsPagingRequired = (getFDICircularIndexRequest.PageNumber != null) ? true : false, OrderBy = getFDICircularIndexRequest.OrderBy, OrderByDirection = getFDICircularIndexRequest.OrderByDirection }; var fDICircularIndexes = iFDICircularIndex.GetFDICircularIndex(fDICircularIndex).OrderBy(x => x.SortId).ToList(); var fDICircularIndexList = new List <GetFDICircularIndexResponse>(); foreach (var fDICircularIndexDetail in fDICircularIndexes) { fDICircularIndexList.Add(new GetFDICircularIndexResponse() { FDICircularIndexId = Convert.ToInt32(fDICircularIndexDetail.FDICircularIndexId), FDIChapterId = Convert.ToInt32(fDICircularIndexDetail.FDIChapterId), IndexNo = fDICircularIndexDetail.IndexNo, IndexName = fDICircularIndexDetail.IndexName, IndexContent = fDICircularIndexDetail.IndexContent, SortId = fDICircularIndexDetail.SortId, IsActive = Convert.ToBoolean(fDICircularIndexDetail.IsActive), CreatedBy = fDICircularIndexDetail.CreatedBy, TotalPageCount = fDICircularIndexDetail.TotalPageCount, TotalRecord = fDICircularIndexDetail.TotalRecord }); } responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircularIndex retrieved successfully"; responses.Response = fDICircularIndexList; } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while retrieving FDICircularIndex."; Utility.WriteLog("GetFDICircularIndex", getFDICircularIndexRequest, "Error while retrieving FDICircularIndex. (FDICircularUserController)", ex.ToString()); } return(Ok(responses)); }