public IEnumerable <FetersCodeDetail> GetFetersCodeDetail(FetersCodeDetail fetersCodeDetail) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter totalPageCount = new ObjectParameter("TotalPageCount", typeof(int)); ObjectParameter totalRecord = new ObjectParameter("TotalRecord", typeof(int)); var fetersCodeDetails = dataContext.FetersCodeDetailGet(fetersCodeDetail.FetersCodeDetailId, fetersCodeDetail.FetersCodeId, Utility.TrimString(fetersCodeDetail.SearchText), fetersCodeDetail.IsActive, fetersCodeDetail.PageNumber, fetersCodeDetail.PageSize, fetersCodeDetail.IsPagingRequired, Utility.TrimString(fetersCodeDetail.OrderBy), Utility.TrimString(fetersCodeDetail.OrderByDirection), totalPageCount, totalRecord).ToList(); var fetersCodeDetailList = new List <FetersCodeDetail>(); foreach (var fetersCodeDetailDetail in fetersCodeDetails) { fetersCodeDetailList.Add(new FetersCodeDetail() { FetersCodeId = fetersCodeDetailDetail.FetersCodeId, FetersCodeDetailId = fetersCodeDetailDetail.FetersCodeDetailId, GroupNo = fetersCodeDetailDetail.GroupNo, PurposeGroupName = fetersCodeDetailDetail.PurposeGroupName, SerialNo = fetersCodeDetailDetail.SerialNo, LRSItem = fetersCodeDetailDetail.LRSItem, LRSFetersCode = fetersCodeDetailDetail.LRSFetersCode, IsActive = fetersCodeDetailDetail.IsActive, TotalPageCount = Convert.ToInt32(totalPageCount.Value), TotalRecord = Convert.ToInt32(totalRecord.Value) }); } return(fetersCodeDetailList); } }
public IHttpActionResult UpdateFetersCodeDetail(UpdateFetersCodeDetailRequest updateFetersCodeDetailRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } var fetersCodeDetail = new FetersCodeDetail() { FetersCodeDetailId = updateFetersCodeDetailRequest.FetersCodeDetailId, FetersCodeId = updateFetersCodeDetailRequest.FetersCodeId, GroupNo = updateFetersCodeDetailRequest.GroupNo, PurposeGroupName = updateFetersCodeDetailRequest.PurposeGroupName, LRSItem = updateFetersCodeDetailRequest.LRSItem, LRSFetersCode = updateFetersCodeDetailRequest.LRSFetersCode, ModifiedBy = Utility.UserId }; int result = iFetersCodeDetail.UpdateFetersCodeDetail(fetersCodeDetail); switch (result) { case 1: responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FetersCodeDetail updated successfully."; break; case -2: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FetersCodeDetail already exists."; break; case -3: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FetersCodeDetail doesn't exist."; break; default: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating all definition."; break; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while updating FetersCodeDetail."; Utility.WriteLog("UpdateFetersCodeDetail", updateFetersCodeDetailRequest, "Error while updating FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString()); } return(Ok(responses)); }
public int DeleteFetersCodeDetail(FetersCodeDetail fetersCodeDetail) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FetersCodeDetailDelete(fetersCodeDetail.FetersCodeDetailId, fetersCodeDetail.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public int UpdateFetersCodeDetail(FetersCodeDetail fetersCodeDetail) { using (DemsifyEntities dataContext = new DemsifyEntities()) { ObjectParameter result = new ObjectParameter("Result", typeof(int)); dataContext.FetersCodeDetailUpdate(fetersCodeDetail.FetersCodeDetailId, fetersCodeDetail.FetersCodeId, Utility.TrimString(fetersCodeDetail.GroupNo), Utility.TrimString(fetersCodeDetail.PurposeGroupName), Utility.TrimString(fetersCodeDetail.LRSItem), Utility.TrimString(fetersCodeDetail.LRSFetersCode), fetersCodeDetail.ModifiedBy, result); return(Convert.ToInt32(result.Value)); } }
public IHttpActionResult DeleteFetersCodeDetail(DeleteFetersCodeDetailRequest deleteFetersCodeDetailRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } var fetersCodeDetail = new FetersCodeDetail() { FetersCodeDetailId = deleteFetersCodeDetailRequest.FetersCodeDetailId, ModifiedBy = Utility.UserId }; int result = iFetersCodeDetail.DeleteFetersCodeDetail(fetersCodeDetail); switch (result) { case 1: responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FetersCodeDetail deleted successfully."; break; case -2: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FetersCodeDetail doesn't exist."; break; default: responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while deleting FetersCodeDetail."; break; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while deleting FetersCodeDetail."; Utility.WriteLog("DeleteFetersCodeDetail", deleteFetersCodeDetailRequest, "Error while deleting FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString()); } return(Ok(responses)); }
public IHttpActionResult AddFetersCodeDetail(AddFetersCodeDetailRequest addFetersCodeDetailRequest) { var responses = new Responses(); try { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var fetersCodeDetail = new FetersCodeDetail() { FetersCodeId = addFetersCodeDetailRequest.FetersCodeId, GroupNo = addFetersCodeDetailRequest.GroupNo, PurposeGroupName = addFetersCodeDetailRequest.PurposeGroupName, LRSItem = addFetersCodeDetailRequest.LRSItem, LRSFetersCode = addFetersCodeDetailRequest.LRSFetersCode, CreatedBy = Utility.UserId }; int result = iFetersCodeDetail.AddFetersCodeDetail(fetersCodeDetail); if (result > 0) { responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FetersCodeDetail added successfully."; } else if (result == -2) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "FetersCodeDetail alread exists."; } else { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FetersCodeDetail."; } } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while adding FetersCodeDetail."; Utility.WriteLog("AddFetersCodeDetail", addFetersCodeDetailRequest, "Error while adding FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString()); } return(Ok(responses)); }
public IHttpActionResult GetFetersCodeDetail([FromUri] GetFetersCodeDetailRequest getFetersCodeDetailRequest) { var responses = new Responses(); try { if (Utility.UserId < 0) { return(BadRequest(Utility.INVALID_USER)); } if (getFetersCodeDetailRequest == null) { getFetersCodeDetailRequest = new GetFetersCodeDetailRequest(); } if (getFetersCodeDetailRequest.PageSize == null) { getFetersCodeDetailRequest.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]); } var fetersCodeDetail = new FetersCodeDetail() { FetersCodeDetailId = getFetersCodeDetailRequest.FetersCodeDetailId, FetersCodeId = getFetersCodeDetailRequest.FetersCodeId, SearchText = getFetersCodeDetailRequest.SearchText, IsActive = getFetersCodeDetailRequest.IsActive, PageNumber = getFetersCodeDetailRequest.PageNumber, PageSize = Convert.ToInt32(getFetersCodeDetailRequest.PageSize), IsPagingRequired = (getFetersCodeDetailRequest.PageNumber != null) ? true : false, OrderBy = getFetersCodeDetailRequest.OrderBy, OrderByDirection = getFetersCodeDetailRequest.OrderByDirection }; var fetersCodeDetails = iFetersCodeDetail.GetFetersCodeDetail(fetersCodeDetail); var fetersCodeDetailList = new List <GetFetersCodeDetailResponse>(); foreach (var fetersCodeDetailDetail in fetersCodeDetails) { fetersCodeDetailList.Add(new GetFetersCodeDetailResponse() { FetersCodeDetailId = Convert.ToInt32(fetersCodeDetailDetail.FetersCodeDetailId), FetersCodeId = Convert.ToInt32(fetersCodeDetailDetail.FetersCodeId), GroupNo = fetersCodeDetailDetail.GroupNo, PurposeGroupName = fetersCodeDetailDetail.PurposeGroupName, SerialNo = fetersCodeDetailDetail.SerialNo, LRSItem = fetersCodeDetailDetail.LRSItem, LRSFetersCode = fetersCodeDetailDetail.LRSFetersCode, IsActive = Convert.ToBoolean(fetersCodeDetailDetail.IsActive), CreatedBy = fetersCodeDetailDetail.CreatedBy, TotalPageCount = fetersCodeDetailDetail.TotalPageCount, TotalRecord = fetersCodeDetailDetail.TotalRecord }); } responses.Status = Utility.SUCCESS_STATUS_RESPONSE; responses.Description = "FetersCodeDetail retrieved successfully"; responses.Response = fetersCodeDetailList; } catch (Exception ex) { responses.Status = Utility.ERROR_STATUS_RESPONSE; responses.Description = "Error while retrieving FetersCodeDetail."; Utility.WriteLog("GetFetersCodeDetail", getFetersCodeDetailRequest, "Error while retrieving FetersCodeDetail. (FetersCodeDetailAdminController)", ex.ToString()); } return(Ok(responses)); }