示例#1
0
        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));
        }
示例#3
0
        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));
            }
        }
示例#4
0
        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));
        }