public IEnumerable <IndexAmendment> GetIndexAmendment(IndexAmendment indexAmendment) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int)); ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int)); var indexAmendments = dataContext.IndexAmendmentGet(indexAmendment.IndexAmendmentId, indexAmendment.RegulationId, Utility.TrimString(indexAmendment.SearchText), indexAmendment.IsActive, indexAmendment.PageNumber, indexAmendment.PageSize, indexAmendment.IsPagingRequired, Utility.TrimString(indexAmendment.OrderBy), Utility.TrimString(indexAmendment.OrderByDirection), totalPageCount, totalRecord).ToList(); var indexAmendmentList = new List <IndexAmendment>(); foreach (var indexAmendmentDetail in indexAmendments) { indexAmendmentList.Add(new IndexAmendment() { IndexAmendmentId = indexAmendmentDetail.IndexAmendmentId, RegulationId = indexAmendmentDetail.RegulationId, NotificationIds = indexAmendmentDetail.NotificationIds, Notifications = indexAmendmentDetail.Notifications, RegulationName = indexAmendmentDetail.Regulationname, RegulationNumber = indexAmendmentDetail.Regulationnumber, IndexId = indexAmendmentDetail.IndexId, IndexNo = indexAmendmentDetail.IndexNo, IndexName = indexAmendmentDetail.Indexname, SubIndexId = indexAmendmentDetail.SubIndexId, SubIndexNumber = indexAmendmentDetail.SubIndexNumber, SubIndexName = indexAmendmentDetail.SubIndexName, IndexAmendmentContent = indexAmendmentDetail.IndexAmendmentContent, IsActive = indexAmendmentDetail.IsActive, TotalPageCount = Convert.ToInt32(totalPageCount.Value), TotalRecord = Convert.ToInt32(totalRecord.Value) }); } return(indexAmendmentList); } }
public IHttpActionResult UpdateIndexAmendment(UpdateIndexAmendmentRequest updateIndexAmendmentRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } var indexAmendment = new IndexAmendment() { IndexAmendmentId = updateIndexAmendmentRequest.IndexAmendmentId, RegulationId = updateIndexAmendmentRequest.RegulationId, NotificationIds = updateIndexAmendmentRequest.NotificationIds, IndexId = updateIndexAmendmentRequest.IndexId, SubIndexId = updateIndexAmendmentRequest.SubIndexId, IndexAmendmentContent = updateIndexAmendmentRequest.IndexAmendmentContent, ModifiedBy = Utility.UserId }; int result = iIndexAmendment.UpdateIndexAmendment(indexAmendment); switch (result) { case 1: responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "IndexAmendment updated successfully."; break; case -2: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "IndexAmendment already exists."; break; case -3: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "IndexAmendment doesn't exist."; break; default: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating index amendment."; break; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating index amendment."; Utility.WriteLog("UpdateIndexAmendment", updateIndexAmendmentRequest, "Error while updating index amendment. (IndexAmendmentAdminController)", ex.ToString()); } return(Ok(responses)); }
public int DeleteIndexAmendment(IndexAmendment indexAmendment) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.IndexAmendmentDelete(indexAmendment.IndexAmendmentId, indexAmendment.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public int UpdateIndexAmendment(IndexAmendment indexAmendment) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.IndexAmendmentUpdate(indexAmendment.IndexAmendmentId, indexAmendment.RegulationId, indexAmendment.NotificationIds, indexAmendment.IndexId, indexAmendment.SubIndexId, Utility.TrimString(indexAmendment.IndexAmendmentContent), indexAmendment.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public IHttpActionResult AddIndexAmendment(AddIndexAmendmentRequest addIndexAmendmentRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var indexAmendment = new IndexAmendment() { RegulationId = addIndexAmendmentRequest.RegulationId, NotificationIds = addIndexAmendmentRequest.NotificationIds, IndexId = addIndexAmendmentRequest.IndexId, SubIndexId = addIndexAmendmentRequest.SubIndexId, IndexAmendmentContent = addIndexAmendmentRequest.IndexAmendmentContent }; int result = iIndexAmendment.AddIndexAmendment(indexAmendment); if (result > 0) { responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "IndexAmendment added successfully."; } else if (result == -2) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "IndexAmendment alread exists."; } else { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding index amendment."; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding index amendment."; Utility.WriteLog("AddIndexAmendment", addIndexAmendmentRequest, "Error while adding index amendment. (IndexAmendmentAdminController)", ex.ToString()); } return(Ok(responses)); }
public IHttpActionResult GetIndexAmendment([FromUri] GetIndexAmendmentRequest getIndexAmendmentRequest) { var responses = new Responses(); try { if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } if (getIndexAmendmentRequest == null) { getIndexAmendmentRequest = new GetIndexAmendmentRequest(); } if (getIndexAmendmentRequest.PageSize == null) { getIndexAmendmentRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]); } var indexAmendment = new IndexAmendment() { IndexAmendmentId = getIndexAmendmentRequest.IndexAmendmentId, RegulationId = getIndexAmendmentRequest.RegulationId, SearchText = getIndexAmendmentRequest.SearchText, IsActive = getIndexAmendmentRequest.IsActive, PageNumber = getIndexAmendmentRequest.PageNumber, PageSize = Convert.ToInt32(getIndexAmendmentRequest.PageSize), IsPagingRequired = (getIndexAmendmentRequest.PageNumber != null) ? true : false, OrderBy = getIndexAmendmentRequest.OrderBy, OrderByDirection = getIndexAmendmentRequest.OrderByDirection }; var indexAmendments = iIndexAmendment.GetIndexAmendment(indexAmendment); var indexAmendmentList = new List <GetIndexAmendmentResponse>(); foreach (var indexAmendmentDetail in indexAmendments) { indexAmendmentList.Add(new GetIndexAmendmentResponse() { IndexAmendmentId = indexAmendmentDetail.IndexAmendmentId, RegulationId = indexAmendmentDetail.RegulationId, NotificationIds = indexAmendmentDetail.NotificationIds, Notifications = indexAmendmentDetail.Notifications, RegulationName = indexAmendmentDetail.RegulationName, RegulationNumber = indexAmendmentDetail.RegulationNumber, IndexId = indexAmendmentDetail.IndexId, IndexNo = indexAmendmentDetail.IndexNo, IndexName = indexAmendmentDetail.IndexName, SubIndexId = indexAmendmentDetail.SubIndexId, SubIndexNumber = indexAmendmentDetail.SubIndexNumber, SubIndexName = indexAmendmentDetail.SubIndexName, IndexAmendmentContent = indexAmendmentDetail.IndexAmendmentContent, IsActive = Convert.ToBoolean(indexAmendmentDetail.IsActive), CreatedBy = indexAmendmentDetail.CreatedBy, TotalPageCount = indexAmendmentDetail.TotalPageCount, TotalRecord = indexAmendmentDetail.TotalRecord }); } responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "IndexAmendment retrieved successfully"; responses.Response = indexAmendmentList; } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while retrieving index amendment."; Utility.WriteLog("GetIndexAmendment", getIndexAmendmentRequest, "Error while retrieving index amendment. (FEMASubModuleDetailUserController)", ex.ToString()); } return(Ok(responses)); }