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);
            }
        }
Esempio n. 2
0
        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));
            }
        }
Esempio n. 5
0
        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));
        }
Esempio n. 6
0
        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));
        }