Esempio n. 1
0
        public IEnumerable <FIPBPressReleaseCase> GetFIPBPressReleaseCase(FIPBPressReleaseCase fIPBPressReleaseCase)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
                ObjectParameter totalRecord    = new ObjectParameter("TotalRecord", typeof(int));

                var fIPBPressReleaseCases = dataContext.FIPBPressReleaseCaseGet(fIPBPressReleaseCase.FIPBPressReleaseCaseId, Utility.TrimString(fIPBPressReleaseCase.SearchText), fIPBPressReleaseCase.IsActive, fIPBPressReleaseCase.PageNumber, fIPBPressReleaseCase.PageSize, fIPBPressReleaseCase.IsPagingRequired, Utility.TrimString(fIPBPressReleaseCase.OrderBy), Utility.TrimString(fIPBPressReleaseCase.OrderByDirection), totalPageCount, totalRecord).ToList();

                var fIPBPressReleaseCaseList = new List <FIPBPressReleaseCase>();
                foreach (var fIPBPressReleaseCaseDetail in fIPBPressReleaseCases)
                {
                    fIPBPressReleaseCaseList.Add(new FIPBPressReleaseCase()
                    {
                        FIPBPressReleaseCaseId = fIPBPressReleaseCaseDetail.FIPBPressReleaseCaseId,
                        MinistryName           = fIPBPressReleaseCaseDetail.MinistryName,
                        MeetingNo_Detail       = fIPBPressReleaseCaseDetail.MeetingNo_Detail,
                        PDF            = fIPBPressReleaseCaseDetail.PDF,
                        IsActive       = fIPBPressReleaseCaseDetail.IsActive,
                        TotalPageCount = Convert.ToInt32(totalPageCount.Value),
                        TotalRecord    = Convert.ToInt32(totalRecord.Value)
                    });
                }
                return(fIPBPressReleaseCaseList);
            }
        }
        public IHttpActionResult UpdateFIPBPressReleaseCase(UpdateFIPBPressReleaseCaseRequest updateFIPBPressReleaseCaseRequest)
        {
            var responses = new Responses();

            try
            {
                if (!ModelState.IsValid)
                {
                    return(BadRequest(ModelState));
                }

                if (Utility.UserId < 0)
                {
                    return(BadRequest(Utility.INVALID_USER));
                }

                var fIPBPressReleaseCase = new FIPBPressReleaseCase()
                {
                    FIPBPressReleaseCaseId = updateFIPBPressReleaseCaseRequest.FIPBPressReleaseCaseId,
                    MinistryName           = updateFIPBPressReleaseCaseRequest.MinistryName,
                    MeetingNo_Detail       = updateFIPBPressReleaseCaseRequest.MeetingNo_Detail,
                    PDF        = updateFIPBPressReleaseCaseRequest.PDF,
                    ModifiedBy = Utility.UserId
                };
                int result = iFIPBPressReleaseCase.UpdateFIPBPressReleaseCase(fIPBPressReleaseCase);

                switch (result)
                {
                case 1:
                    responses.Status      = Utility.SUCCESS_STATUS_RESPONSE;
                    responses.Description = "FIPBPressReleaseCase updated successfully.";
                    break;

                case -2:
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "FIPBPressReleaseCase already exists.";
                    break;

                case -3:
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "FIPBPressReleaseCase doesn't exist.";
                    break;

                default:
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "Error while updating fIPBPressReleaseCase.";
                    break;
                }
            }
            catch (Exception ex)
            {
                responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                responses.Description = "Error while updating admin profile.";

                Utility.WriteLog("UpdateFIPBPressReleaseCase", updateFIPBPressReleaseCaseRequest, "Error while updating fIPBPressReleaseCase. (FIPBPressReleaseCaseAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }
Esempio n. 3
0
        public int DeleteFIPBPressReleaseCase(FIPBPressReleaseCase fIPBPressReleaseCase)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FIPBPressReleaseCaseDelete(fIPBPressReleaseCase.FIPBPressReleaseCaseId, fIPBPressReleaseCase.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Esempio n. 4
0
        public int UpdateFIPBPressReleaseCase(FIPBPressReleaseCase fIPBPressReleaseCase)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.FIPBPressReleaseCaseUpdate(fIPBPressReleaseCase.FIPBPressReleaseCaseId, Utility.TrimString(fIPBPressReleaseCase.MinistryName), Utility.TrimString(fIPBPressReleaseCase.MeetingNo_Detail), Utility.TrimString(fIPBPressReleaseCase.PDF), fIPBPressReleaseCase.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public IHttpActionResult DeleteFIPBPressReleaseCase(DeleteFIPBPressReleaseCaseRequest deleteFIPBPressReleaseCaseRequest)
        {
            var responses = new Responses();

            try
            {
                if (!ModelState.IsValid)
                {
                    return(BadRequest(ModelState));
                }

                if (Utility.UserId < 0)
                {
                    return(BadRequest(Utility.INVALID_USER));
                }

                var fIPBPressReleaseCase = new FIPBPressReleaseCase()
                {
                    FIPBPressReleaseCaseId = deleteFIPBPressReleaseCaseRequest.FIPBPressReleaseCaseId,
                    ModifiedBy             = Utility.UserId
                };

                int result = iFIPBPressReleaseCase.DeleteFIPBPressReleaseCase(fIPBPressReleaseCase);
                switch (result)
                {
                case 1:
                    responses.Status      = Utility.SUCCESS_STATUS_RESPONSE;
                    responses.Description = "FIPBPressReleaseCase deleted successfully.";
                    break;

                case -2:
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "FIPBPressReleaseCase doesn't exist.";
                    break;

                default:
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "Error while deleting fIPBPressReleaseCase.";
                    break;
                }
            }
            catch (Exception ex)
            {
                responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                responses.Description = "Error while deleting fIPBPressReleaseCase.";

                Utility.WriteLog("DeleteFIPBPressReleaseCase", deleteFIPBPressReleaseCaseRequest, "Error while deleting fIPBPressReleaseCase. (FIPBPressReleaseCaseAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }
        public IHttpActionResult AddFIPBPressReleaseCase(AddFIPBPressReleaseCaseRequest addFIPBPressReleaseCaseRequest)
        {
            var responses = new Responses();

            try
            {
                if (!ModelState.IsValid)
                {
                    return(BadRequest(ModelState));
                }

                var fIPBPressReleaseCase = new FIPBPressReleaseCase()
                {
                    MinistryName     = addFIPBPressReleaseCaseRequest.MinistryName,
                    MeetingNo_Detail = addFIPBPressReleaseCaseRequest.MeetingNo_Detail,
                    PDF       = addFIPBPressReleaseCaseRequest.PDF,
                    CreatedBy = Utility.UserId
                };
                int result = iFIPBPressReleaseCase.AddFIPBPressReleaseCase(fIPBPressReleaseCase);
                if (result > 0)
                {
                    responses.Status      = Utility.SUCCESS_STATUS_RESPONSE;
                    responses.Description = "FIPBPressReleaseCase added successfully.";
                }
                else if (result == -2)
                {
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "FIPBPressReleaseCase alread exists.";
                }
                else
                {
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "Error while adding fIPBPressReleaseCase.";
                }
            }
            catch (Exception ex)
            {
                responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                responses.Description = "Error while adding fIPBPressReleaseCase.";

                Utility.WriteLog("AddFIPBPressReleaseCase", addFIPBPressReleaseCaseRequest, "Error while adding fIPBPressReleaseCase. (FIPBPressReleaseCaseAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }
Esempio n. 7
0
        public IHttpActionResult GetFIPBPressReleaseCase([FromUri] GetFIPBPressReleaseCaseRequest getFIPBPressReleaseCaseRequest)
        {
            var responses = new Responses();

            try
            {
                if (Utility.UserId < 0)
                {
                    return(BadRequest(Utility.INVALID_USER));
                }

                if (getFIPBPressReleaseCaseRequest == null)
                {
                    getFIPBPressReleaseCaseRequest = new GetFIPBPressReleaseCaseRequest();
                }

                if (getFIPBPressReleaseCaseRequest.PageSize == null)
                {
                    getFIPBPressReleaseCaseRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
                }

                var fIPBPressReleaseCase = new FIPBPressReleaseCase()
                {
                    FIPBPressReleaseCaseId = getFIPBPressReleaseCaseRequest.FIPBPressReleaseCaseId,
                    SearchText             = getFIPBPressReleaseCaseRequest.SearchText,
                    IsActive         = getFIPBPressReleaseCaseRequest.IsActive,
                    PageNumber       = getFIPBPressReleaseCaseRequest.PageNumber,
                    PageSize         = Convert.ToInt32(getFIPBPressReleaseCaseRequest.PageSize),
                    IsPagingRequired = (getFIPBPressReleaseCaseRequest.PageNumber != null) ? true : false,
                    OrderBy          = getFIPBPressReleaseCaseRequest.OrderBy,
                    OrderByDirection = getFIPBPressReleaseCaseRequest.OrderByDirection
                };
                var fIPBPressReleaseCases = iFIPBPressReleaseCase.GetFIPBPressReleaseCase(fIPBPressReleaseCase);

                var fIPBPressReleaseCaseList = new List <GetFIPBPressReleaseCaseResponse>();
                foreach (var fIPBPressReleaseCaseDetail in fIPBPressReleaseCases)
                {
                    fIPBPressReleaseCaseList.Add(new GetFIPBPressReleaseCaseResponse()
                    {
                        FIPBPressReleaseCaseId = Convert.ToInt32(fIPBPressReleaseCaseDetail.FIPBPressReleaseCaseId),
                        MinistryName           = fIPBPressReleaseCaseDetail.MinistryName,
                        MeetingNo_Detail       = fIPBPressReleaseCaseDetail.MeetingNo_Detail,
                        PDF            = fIPBPressReleaseCaseDetail.PDF,
                        IsActive       = Convert.ToBoolean(fIPBPressReleaseCaseDetail.IsActive),
                        CreatedBy      = fIPBPressReleaseCaseDetail.CreatedBy,
                        TotalPageCount = fIPBPressReleaseCaseDetail.TotalPageCount,
                        TotalRecord    = fIPBPressReleaseCaseDetail.TotalRecord
                    });
                }

                responses.Status      = Utility.SUCCESS_STATUS_RESPONSE;
                responses.Description = "FIPBPressReleaseCase retrieved successfully";
                responses.Response    = fIPBPressReleaseCaseList;
            }
            catch (Exception ex)
            {
                responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                responses.Description = "Error while retrieving fIPBPressReleaseCase.";

                Utility.WriteLog("GetFIPBPressReleaseCase", getFIPBPressReleaseCaseRequest, "Error while retrieving fIPBPressReleaseCase. (FIPBPressReleaseCaseUserController)", ex.ToString());
            }
            return(Ok(responses));
        }