public IEnumerable <MasterDirection> GetMasterDirection(MasterDirection masterDirection)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int));
                ObjectParameter totalRecord    = new ObjectParameter("TotalRecord", typeof(int));

                var masterDirections = dataContext.MasterDirectionGet(masterDirection.MasterDirectionId, Utility.TrimString(masterDirection.SearchText), masterDirection.IsActive, masterDirection.PageNumber, masterDirection.PageSize, masterDirection.IsPagingRequired, Utility.TrimString(masterDirection.OrderBy), Utility.TrimString(masterDirection.OrderByDirection), totalPageCount, totalRecord).ToList();

                var masterDirectionList = new List <MasterDirection>();
                foreach (var masterDirectionDetail in masterDirections)
                {
                    masterDirectionList.Add(new MasterDirection()
                    {
                        MasterDirectionId   = masterDirectionDetail.MDID,
                        MasterDirectionName = masterDirectionDetail.MasterDIrectionName,
                        Year           = masterDirectionDetail.Year,
                        PDF            = masterDirectionDetail.PDF,
                        IsActive       = masterDirectionDetail.IsActive,
                        TotalPageCount = Convert.ToInt32(totalPageCount.Value),
                        TotalRecord    = Convert.ToInt32(totalRecord.Value)
                    });
                }
                return(masterDirectionList);
            }
        }
Esempio n. 2
0
        public IHttpActionResult UpdateMasterDirection(UpdateMasterDirectionRequest updateMasterDirectionRequest)
        {
            var responses = new Responses();

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

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

                var masterDirection = new MasterDirection()
                {
                    MasterDirectionId   = updateMasterDirectionRequest.MasterDirectionId,
                    MasterDirectionName = updateMasterDirectionRequest.MasterDirectionName,
                    Year       = updateMasterDirectionRequest.Year,
                    PDF        = updateMasterDirectionRequest.PDF,
                    ModifiedBy = Utility.UserId
                };
                int result = iMasterDirection.UpdateMasterDirection(masterDirection);

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

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

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

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

                Utility.WriteLog("UpdateMasterDirection", updateMasterDirectionRequest, "Error while updating MasterDirection. (MasterDirectionAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }
        public int DeleteMasterDirection(MasterDirection masterDirection)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.MasterDirectionDelete(masterDirection.MasterDirectionId, masterDirection.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
        public int UpdateMasterDirection(MasterDirection masterDirection)
        {
            using (DemsifyEntities dataContext = new DemsifyEntities())
            {
                ObjectParameter result = new ObjectParameter("Result", typeof(int));

                dataContext.MasterDirectionUpdate(masterDirection.MasterDirectionId, Utility.TrimString(masterDirection.MasterDirectionName), Utility.TrimString(masterDirection.Year), Utility.TrimString(masterDirection.PDF), masterDirection.ModifiedBy, result);

                return(Convert.ToInt32(result.Value));
            }
        }
Esempio n. 5
0
        public IHttpActionResult AddMasterDirection(AddMasterDirectionRequest addMasterDirectionRequest)
        {
            var responses = new Responses();

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

                var masterDirection = new MasterDirection()
                {
                    MasterDirectionName = addMasterDirectionRequest.MasterDirectionName,
                    Year      = addMasterDirectionRequest.Year,
                    PDF       = addMasterDirectionRequest.PDF,
                    CreatedBy = Utility.UserId
                };
                int result = iMasterDirection.AddMasterDirection(masterDirection);
                if (result > 0)
                {
                    responses.Status      = Utility.SUCCESS_STATUS_RESPONSE;
                    responses.Description = "MasterDirection added successfully.";
                }
                else if (result == -2)
                {
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "MasterDirection alread exists.";
                }
                else
                {
                    responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                    responses.Description = "Error while adding MasterDirection.";
                }
            }
            catch (Exception ex)
            {
                responses.Status      = Utility.ERROR_STATUS_RESPONSE;
                responses.Description = "Error while adding MasterDirection.";

                Utility.WriteLog("AddMasterDirection", addMasterDirectionRequest, "Error while adding MasterDirection. (MasterDirectionAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }
Esempio n. 6
0
        public IHttpActionResult GetMasterDirection([FromUri] GetMasterDirectionRequest getMasterDirectionRequest)
        {
            var responses = new Responses();

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

                if (getMasterDirectionRequest == null)
                {
                    getMasterDirectionRequest = new GetMasterDirectionRequest();
                }

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

                var masterDirection = new MasterDirection()
                {
                    MasterDirectionId = getMasterDirectionRequest.MasterDirectionId,
                    SearchText        = getMasterDirectionRequest.SearchText,
                    IsActive          = getMasterDirectionRequest.IsActive,
                    PageNumber        = getMasterDirectionRequest.PageNumber,
                    PageSize          = Convert.ToInt32(getMasterDirectionRequest.PageSize),
                    IsPagingRequired  = (getMasterDirectionRequest.PageNumber != null) ? true : false,
                    OrderBy           = getMasterDirectionRequest.OrderBy,
                    OrderByDirection  = getMasterDirectionRequest.OrderByDirection
                };
                var masterDirections = iMasterDirection.GetMasterDirection(masterDirection);

                var masterDirectionList = new List <GetMasterDirectionResponse>();
                foreach (var masterDirectionDetail in masterDirections)
                {
                    masterDirectionList.Add(new GetMasterDirectionResponse()
                    {
                        MasterDirectionId   = Convert.ToInt32(masterDirectionDetail.MasterDirectionId),
                        MasterDirectionName = masterDirectionDetail.MasterDirectionName,
                        Year           = masterDirectionDetail.Year,
                        PDF            = masterDirectionDetail.PDF,
                        IsActive       = Convert.ToBoolean(masterDirectionDetail.IsActive),
                        CreatedBy      = masterDirectionDetail.CreatedBy,
                        TotalPageCount = masterDirectionDetail.TotalPageCount,
                        TotalRecord    = masterDirectionDetail.TotalRecord
                    });
                }

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

                Utility.WriteLog("GetMasterDirection", getMasterDirectionRequest, "Error while retrieving MasterDirection. (MasterDirectionAdminController)", ex.ToString());
            }
            return(Ok(responses));
        }