public IEnumerable <APDIRCircularAfter> GetAPDIRCircularAfter(APDIRCircularAfter aPDIRCircularAfter)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
                ObjectParameter totalRecord    = new ObjectParameter("TotalRecord", typeof(int));

                var aPDIRCircularAfters = dataContext.APDIRCircularAfterGet(aPDIRCircularAfter.APDIRCircularAfterId, aPDIRCircularAfter.APDIRCircularParentId, Utility.TrimString(aPDIRCircularAfter.SearchText), aPDIRCircularAfter.IsActive, aPDIRCircularAfter.PageNumber, aPDIRCircularAfter.PageSize, aPDIRCircularAfter.IsPagingRequired, Utility.TrimString(aPDIRCircularAfter.OrderBy), Utility.TrimString(aPDIRCircularAfter.OrderByDirection), totalPageCount, totalRecord).ToList();

                var aPDIRCircularAfterList = new List <APDIRCircularAfter>();
                foreach (var aPDIRCircularAfterDetail in aPDIRCircularAfters)
                {
                    aPDIRCircularAfterList.Add(new APDIRCircularAfter()
                    {
                        APDIRCircularAfterId       = aPDIRCircularAfterDetail.APDIRCircularAfterId,
                        APDIRCircularParentId      = aPDIRCircularAfterDetail.APDIRCircularParentId,
                        APDIRCircularId            = aPDIRCircularAfterDetail.APDIRCircularId,
                        APDIRCircularNo            = aPDIRCircularAfterDetail.APDIRCircularNo,
                        APDIRCircularName          = aPDIRCircularAfterDetail.APDIRCircularName,
                        APDIRCircularDate          = aPDIRCircularAfterDetail.APDIRCircularDate,
                        APDIRCircularEffectiveDate = aPDIRCircularAfterDetail.APDIRCircularEffectiveDate,
                        Year             = aPDIRCircularAfterDetail.Year,
                        APDIRCircularPDF = aPDIRCircularAfterDetail.PDF,
                        IsActive         = aPDIRCircularAfterDetail.IsActive,
                        TotalPageCount   = Convert.ToInt32(totalPageCount.Value),
                        TotalRecord      = Convert.ToInt32(totalRecord.Value)
                    });
                }
                return(aPDIRCircularAfterList);
            }
        }
        public int DeleteAPDIRCircularAfter(APDIRCircularAfter aPDIRCircularAfter)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.APDIRCircularAfterDelete(aPDIRCircularAfter.APDIRCircularAfterId, aPDIRCircularAfter.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int AddAPDIRCircularAfter(APDIRCircularAfter aPDIRCircularAfter)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.APDIRCircularAfterAdd(aPDIRCircularAfter.APDIRCircularParentId, aPDIRCircularAfter.APDIRCircularId, aPDIRCircularAfter.CreatedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Esempio n. 4
0
        public IHttpActionResult DeleteAPDIRCircularAfter(DeleteAPDIRCircularAfterRequest deleteAPDIRCircularAfterRequest)
        {
            var responses = new Responses();

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

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

                var aPDIRCircularAfter = new APDIRCircularAfter()
                {
                    APDIRCircularAfterId = deleteAPDIRCircularAfterRequest.APDIRCircularAfterId,
                    ModifiedBy           = Utility.UserId
                };

                int result = iAPDIRCircularAfter.DeleteAPDIRCircularAfter(aPDIRCircularAfter);
                switch (result)
                {
                case 1:
                    responses.Status      = Utility.SUCCESS_STATUS_RESPONSE;
                    responses.Description = "After AP DIR Circular deleted successfully.";
                    break;

                case -2:
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "After AP DIR Circular doesn't exist.";
                    break;

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

                Utility.WriteLog("DeleteAPDIRCircularAfter", deleteAPDIRCircularAfterRequest, "Error while deleting After AP DIR Circular. (APDIRCircularAfterAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }
Esempio n. 5
0
        public IHttpActionResult AddAPDIRCircularAfter(AddAPDIRCircularAfterRequest addAPDIRCircularAfterRequest)
        {
            var responses = new Responses();

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

                var aPDIRCircularAfter = new APDIRCircularAfter()
                {
                    APDIRCircularParentId = addAPDIRCircularAfterRequest.APDIRCircularParentId,
                    APDIRCircularId       = addAPDIRCircularAfterRequest.APDIRCircularId
                };
                int result = iAPDIRCircularAfter.AddAPDIRCircularAfter(aPDIRCircularAfter);
                if (result > 0)
                {
                    responses.Status      = Utility.SUCCESS_STATUS_RESPONSE;
                    responses.Description = "After AP DIR Circular added successfully.";
                }
                else if (result == -2)
                {
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "After AP DIR Circular alread exists.";
                }
                else if (result == -3)
                {
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "After AP DIR Circular alread exists in Before AP DIR Circular.";
                }
                else
                {
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "Error while adding After AP DIR Circular.";
                }
            }
            catch (Exception ex)
            {
                responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                responses.Description = "Error while adding After AP DIR Circular.";

                Utility.WriteLog("AddAPDIRCircularAfter", addAPDIRCircularAfterRequest, "Error while adding After AP DIR Circular. (APDIRCircularAfterAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }
Esempio n. 6
0
        public IHttpActionResult GetAPDIRCircularAfter([FromUri] GetAPDIRCircularAfterRequest getAPDIRCircularAfterRequest)
        {
            var responses = new Responses();

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

                if (getAPDIRCircularAfterRequest == null)
                {
                    getAPDIRCircularAfterRequest = new GetAPDIRCircularAfterRequest();
                }

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

                var aPDIRCircularAfter = new APDIRCircularAfter()
                {
                    APDIRCircularAfterId  = getAPDIRCircularAfterRequest.APDIRCircularAfterId,
                    APDIRCircularParentId = getAPDIRCircularAfterRequest.APDIRCircularParentId,
                    SearchText            = getAPDIRCircularAfterRequest.SearchText,
                    IsActive         = getAPDIRCircularAfterRequest.IsActive,
                    PageNumber       = getAPDIRCircularAfterRequest.PageNumber,
                    PageSize         = Convert.ToInt32(getAPDIRCircularAfterRequest.PageSize),
                    IsPagingRequired = (getAPDIRCircularAfterRequest.PageNumber != null) ? true : false,
                    OrderBy          = getAPDIRCircularAfterRequest.OrderBy,
                    OrderByDirection = getAPDIRCircularAfterRequest.OrderByDirection
                };
                var aPDIRCircularAfters = iAPDIRCircularAfter.GetAPDIRCircularAfter(aPDIRCircularAfter);

                var aPDIRCircularAfterList = new List <GetAPDIRCircularAfterResponse>();
                foreach (var aPDIRCircularAfterDetail in aPDIRCircularAfters)
                {
                    aPDIRCircularAfterList.Add(new GetAPDIRCircularAfterResponse()
                    {
                        APDIRCircularAfterId       = Convert.ToInt32(aPDIRCircularAfterDetail.APDIRCircularAfterId),
                        APDIRCircularParentId      = aPDIRCircularAfterDetail.APDIRCircularParentId,
                        APDIRCircularId            = aPDIRCircularAfterDetail.APDIRCircularId,
                        APDIRCircularNo            = aPDIRCircularAfterDetail.APDIRCircularNo,
                        APDIRCircularName          = aPDIRCircularAfterDetail.APDIRCircularName,
                        APDIRCircularDate          = aPDIRCircularAfterDetail.APDIRCircularDate,
                        APDIRCircularEffectiveDate = aPDIRCircularAfterDetail.APDIRCircularEffectiveDate,
                        Year = aPDIRCircularAfterDetail.Year,
                        APDIRCircularYearName = Utility.GetAPDIRCircularYear(Convert.ToInt32(aPDIRCircularAfterDetail.Year)).First().APDIRCircularYearName,
                        APDIRCircularPDF      = aPDIRCircularAfterDetail.APDIRCircularPDF,
                        IsActive       = Convert.ToBoolean(aPDIRCircularAfterDetail.IsActive),
                        CreatedBy      = aPDIRCircularAfterDetail.CreatedBy,
                        TotalPageCount = aPDIRCircularAfterDetail.TotalPageCount,
                        TotalRecord    = aPDIRCircularAfterDetail.TotalRecord
                    });
                }

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

                Utility.WriteLog("GetAPDIRCircularAfter", getAPDIRCircularAfterRequest, "Error while retrieving APDIRCircularAfter. (APDIRCircularAfterAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }