public IEnumerable <FDICircularSubIndex> GetFDICircularSubIndex(FDICircularSubIndex fDICircularSubIndex) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int)); ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int)); var fDICircularSubIndexes = dataContext.FDICircularSubIndexGet(fDICircularSubIndex.FDICircularSubIndexId, fDICircularSubIndex.FDICircularId, fDICircularSubIndex.FDICircularIndexId, Utility.TrimString(fDICircularSubIndex.SearchText), fDICircularSubIndex.IsActive, fDICircularSubIndex.PageNumber, fDICircularSubIndex.PageSize, fDICircularSubIndex.IsPagingRequired, Utility.TrimString(fDICircularSubIndex.OrderBy), Utility.TrimString(fDICircularSubIndex.OrderByDirection), totalPageCount, totalRecord).ToList(); var fDICircularSubIndexList = new List <FDICircularSubIndex>(); foreach (var fDICircularSubIndexDetail in fDICircularSubIndexes) { fDICircularSubIndexList.Add(new FDICircularSubIndex() { FDICircularSubIndexId = fDICircularSubIndexDetail.FDICircularSubIndexId, FDICircularIndexId = fDICircularSubIndexDetail.FDICircularIndexId, SubIndexNo = fDICircularSubIndexDetail.SubIndexNo, SubIndexName = fDICircularSubIndexDetail.SubIndexName, SubIndexContent = fDICircularSubIndexDetail.SubIndexContent, SortId = fDICircularSubIndexDetail.SortId, IsActive = fDICircularSubIndexDetail.IsActive, TotalPageCount = Convert.ToInt32(totalPageCount.Value), TotalRecord = Convert.ToInt32(totalRecord.Value) }); } return(fDICircularSubIndexList); } }
public IHttpActionResult UpdateFDICircularSubIndex(UpdateFDICircularSubIndexRequest updateFDICircularSubIndexRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } var fDICircularSubIndex = new FDICircularSubIndex() { FDICircularSubIndexId = updateFDICircularSubIndexRequest.FDICircularSubIndexId, FDICircularIndexId = updateFDICircularSubIndexRequest.FDICircularIndexId, SubIndexNo = updateFDICircularSubIndexRequest.SubIndexNo, SubIndexName = updateFDICircularSubIndexRequest.SubIndexName, SubIndexContent = updateFDICircularSubIndexRequest.SubIndexContent, SaveAfterSubIndexId = updateFDICircularSubIndexRequest.SaveAfterSubIndexId, ModifiedBy = Utility.UserId }; int result = iFDICircularSubIndex.UpdateFDICircularSubIndex(fDICircularSubIndex); switch (result) { case 1: responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircularSubIndex updated successfully."; break; case -2: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircularSubIndex already exists."; break; case -3: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircularSubIndex doesn't exist."; break; default: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating FDICircularSubIndex."; break; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating FDICircularSubIndex."; Utility.WriteLog("UpdateFDICircularSubIndex", updateFDICircularSubIndexRequest, "Error while updating FDICircularSubIndex. (FDICircularSubIndexAdminController)", ex.ToString()); } return(Ok(responses)); }
public int DeleteFDICircularSubIndex(FDICircularSubIndex fDICircularSubIndex) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FDICircularSubIndexDelete(fDICircularSubIndex.FDICircularSubIndexId, fDICircularSubIndex.FDICircularIndexId, fDICircularSubIndex.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public int UpdateFDICircularSubIndex(FDICircularSubIndex fDICircularSubIndex) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FDICircularSubIndexUpdate(fDICircularSubIndex.FDICircularSubIndexId, fDICircularSubIndex.FDICircularIndexId, Utility.TrimString(fDICircularSubIndex.SubIndexNo), Utility.TrimString(fDICircularSubIndex.SubIndexName), Utility.TrimString(fDICircularSubIndex.SubIndexContent), fDICircularSubIndex.SaveAfterSubIndexId, fDICircularSubIndex.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public IHttpActionResult AddFDICircularSubIndex(AddFDICircularSubIndexRequest addFDICircularSubIndexRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var fDICircularSubIndex = new FDICircularSubIndex() { FDICircularIndexId = addFDICircularSubIndexRequest.FDICircularIndexId, SubIndexNo = addFDICircularSubIndexRequest.SubIndexNo, SubIndexName = addFDICircularSubIndexRequest.SubIndexName, SubIndexContent = addFDICircularSubIndexRequest.SubIndexContent, SaveAfterSubIndexId = addFDICircularSubIndexRequest.SaveAfterSubIndexId }; int result = iFDICircularSubIndex.AddFDICircularSubIndex(fDICircularSubIndex); if (result > 0) { responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircularSubIndex added successfully."; } else if (result == -2) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircularSubIndex alread exists."; } else { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FDICircularSubIndex."; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FDICircularSubIndex."; Utility.WriteLog("AddFDICircularSubIndex", addFDICircularSubIndexRequest, "Error while adding FDICircularSubIndex. (FDICircularSubIndexAdminController)", ex.ToString()); } return(Ok(responses)); }
public IHttpActionResult GetFDICircularSubIndex([FromUri] GetFDICircularSubIndexRequest getFDICircularSubIndexRequest) { var responses = new Responses(); try { if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } if (getFDICircularSubIndexRequest == null) { getFDICircularSubIndexRequest = new GetFDICircularSubIndexRequest(); } if (getFDICircularSubIndexRequest.PageSize == null) { getFDICircularSubIndexRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]); } var fDICircularSubIndex = new FDICircularSubIndex() { FDICircularSubIndexId = getFDICircularSubIndexRequest.FDICircularSubIndexId, FDICircularIndexId = getFDICircularSubIndexRequest.FDICircularIndexId, SearchText = getFDICircularSubIndexRequest.SearchText, IsActive = getFDICircularSubIndexRequest.IsActive, PageNumber = getFDICircularSubIndexRequest.PageNumber, PageSize = Convert.ToInt32(getFDICircularSubIndexRequest.PageSize), IsPagingRequired = (getFDICircularSubIndexRequest.PageNumber != null) ? true : false, OrderBy = getFDICircularSubIndexRequest.OrderBy, OrderByDirection = getFDICircularSubIndexRequest.OrderByDirection }; var fDICircularSubIndexes = iFDICircularSubIndex.GetFDICircularSubIndex(fDICircularSubIndex); var fDICircularSubIndexList = new List <GetFDICircularSubIndexResponse>(); foreach (var fDICircularSubIndexDetail in fDICircularSubIndexes) { fDICircularSubIndexList.Add(new GetFDICircularSubIndexResponse() { FDICircularSubIndexId = Convert.ToInt32(fDICircularSubIndexDetail.FDICircularSubIndexId), FDICircularIndexId = Convert.ToInt32(fDICircularSubIndexDetail.FDICircularIndexId), SubIndexNo = fDICircularSubIndexDetail.SubIndexNo, SubIndexName = fDICircularSubIndexDetail.SubIndexName, SubIndexContent = fDICircularSubIndexDetail.SubIndexContent, SortId = fDICircularSubIndexDetail.SortId, IsActive = Convert.ToBoolean(fDICircularSubIndexDetail.IsActive), CreatedBy = fDICircularSubIndexDetail.CreatedBy, TotalPageCount = fDICircularSubIndexDetail.TotalPageCount, TotalRecord = fDICircularSubIndexDetail.TotalRecord }); } responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircularSubIndex retrieved successfully"; responses.Response = fDICircularSubIndexList; } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while retrieving FDICircularSubIndex."; Utility.WriteLog("GetFDICircularSubIndex", getFDICircularSubIndexRequest, "Error while retrieving FDICircularSubIndex. (FDICircularSubIndexAdminController)", ex.ToString()); } return(Ok(responses)); }