public IEnumerable <FDICircular> GetFDICircular(FDICircular fDICircular) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int)); ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int)); var fDICirculars = dataContext.FDICircularGet(fDICircular.FDICircularId, Utility.TrimString(fDICircular.SearchText), fDICircular.IsActive, fDICircular.PageNumber, fDICircular.PageSize, fDICircular.IsPagingRequired, Utility.TrimString(fDICircular.OrderBy), Utility.TrimString(fDICircular.OrderByDirection), totalPageCount, totalRecord).ToList(); var fDICircularList = new List <FDICircular>(); foreach (var fDICircularDetail in fDICirculars) { fDICircularList.Add(new FDICircular() { FDICircularId = fDICircularDetail.FDICircularId, FDICircularName = fDICircularDetail.FDICircularName, Year = fDICircularDetail.Year, PDF = fDICircularDetail.PDF, IsActive = fDICircularDetail.IsActive, TotalPageCount = Convert.ToInt32(totalPageCount.Value), TotalRecord = Convert.ToInt32(totalRecord.Value) }); } return(fDICircularList); } }
public IHttpActionResult UpdateFDICircular(UpdateFDICircularRequest updateFDICircularRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } var fDICircular = new FDICircular() { FDICircularId = updateFDICircularRequest.FDICircularId, FDICircularName = updateFDICircularRequest.FDICircularName, Year = updateFDICircularRequest.Year, PDF = updateFDICircularRequest.PDF, ModifiedBy = Utility.UserId }; int result = iFDICircular.UpdateFDICircular(fDICircular); switch (result) { case 1: responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircular updated successfully."; break; case -2: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircular already exists."; break; case -3: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircular doesn't exist."; break; default: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating FDICircular."; break; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating FDICircular."; Utility.WriteLog("UpdateFDICircular", updateFDICircularRequest, "Error while updating FDICircular. (FDICircularAdminController)", ex.ToString()); } return(Ok(responses)); }
public int DeleteFDICircular(FDICircular fDICircular) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FDICircularDelete(fDICircular.FDICircularId, fDICircular.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public int UpdateFDICircular(FDICircular fDICircular) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FDICircularUpdate(fDICircular.FDICircularId, Utility.TrimString(fDICircular.FDICircularName), Utility.TrimString(fDICircular.Year), Utility.TrimString(fDICircular.PDF), fDICircular.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public IHttpActionResult AddFDICircular(AddFDICircularRequest addFDICircularRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var fDICircular = new FDICircular() { FDICircularName = addFDICircularRequest.FDICircularName, Year = addFDICircularRequest.Year, PDF = addFDICircularRequest.PDF, CreatedBy = Utility.UserId }; int result = iFDICircular.AddFDICircular(fDICircular); if (result > 0) { responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircular added successfully."; } else if (result == -2) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FDICircular alread exists."; } else { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FDICircular."; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FDICircular."; Utility.WriteLog("AddFDICircular", addFDICircularRequest, "Error while adding FDICircular. (FDICircularAdminController)", ex.ToString()); } return(Ok(responses)); }
public IHttpActionResult GetFDICircular([FromUri] GetFDICircularRequest getFDICircularRequest) { var responses = new Responses(); try { if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } if (getFDICircularRequest == null) { getFDICircularRequest = new GetFDICircularRequest(); } if (getFDICircularRequest.PageSize == null) { getFDICircularRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]); } var fDICircular = new FDICircular() { FDICircularId = getFDICircularRequest.FDICircularId, SearchText = getFDICircularRequest.SearchText, IsActive = getFDICircularRequest.IsActive, PageNumber = getFDICircularRequest.PageNumber, PageSize = Convert.ToInt32(getFDICircularRequest.PageSize), IsPagingRequired = (getFDICircularRequest.PageNumber != null) ? true : false, OrderBy = getFDICircularRequest.OrderBy, OrderByDirection = getFDICircularRequest.OrderByDirection }; var fDICirculars = iFDICircular.GetFDICircular(fDICircular); var fDICircularList = new List <GetFDICircularResponse>(); foreach (var fDICircularDetail in fDICirculars) { fDICircularList.Add(new GetFDICircularResponse() { FDICircularId = Convert.ToInt32(fDICircularDetail.FDICircularId), FDICircularName = fDICircularDetail.FDICircularName, Year = fDICircularDetail.Year, PDF = fDICircularDetail.PDF, IsActive = Convert.ToBoolean(fDICircularDetail.IsActive), CreatedBy = fDICircularDetail.CreatedBy, TotalPageCount = fDICircularDetail.TotalPageCount, TotalRecord = fDICircularDetail.TotalRecord }); } responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FDICircular retrieved successfully"; responses.Response = fDICircularList; } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while retrieving FDICircular."; Utility.WriteLog("GetFDICircular", getFDICircularRequest, "Error while retrieving FDICircular. (FDICircularUserController)", ex.ToString()); } return(Ok(responses)); }