public IActionResult Delete(int id) { try { PBDrawResult singleById = _pbDrawResultRepository.GetById(id); if (singleById == null) { return(NotFound()); } _pbDrawResultRepository.Delete(singleById); int save = _pbDrawResultRepository.Save(); if (save > 0) { return(NoContent()); } return(BadRequest()); } catch (Exception exception) { //Do something with the exception return(StatusCode((int)HttpStatusCode.InternalServerError)); } }
public IActionResult Get(int id) { try { PBDrawResult pbDrawResult = _pbDrawResultRepository.GetById(id); if (pbDrawResult == null) { return(NotFound()); } return(Ok(Mapper.Map <PBDrawResultViewModel>(pbDrawResult))); } catch (Exception exception) { //Do something with the exception return(StatusCode((int)HttpStatusCode.InternalServerError)); } }
public IActionResult Put(int id, [FromBody] PBDrawResultViewModel viewModel) { try { if (viewModel == null) { return(BadRequest()); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } PBDrawResult singleById = _pbDrawResultRepository.GetById(id); if (singleById == null) { return(NotFound()); } singleById.PBNo = viewModel.PBNo; singleById.Draw = viewModel.Draw; singleById.Validity = viewModel.Validity; singleById.LastUpdatedBy = viewModel.LastUpdatedBy; singleById.LastUpdatedDate = DateTime.Now; _pbDrawResultRepository.Update(singleById); int save = _pbDrawResultRepository.Save(); if (save > 0) { return(Ok(Mapper.Map <PBDrawResultViewModel>(singleById))); } return(BadRequest()); } catch (Exception exception) { //Do something with the exception return(StatusCode((int)HttpStatusCode.InternalServerError)); } }
public List <PBDrawResultViewModel> Match(string pbNumbers) { try { List <PBDrawResultViewModel> totalMatchedNumbers = new List <PBDrawResultViewModel>(); if (pbNumbers == null) { return(null); } List <string> pbNoList = pbNumbers.Split(',').Distinct().ToList(); foreach (string pbNo in pbNoList) { if (pbNo.Contains('-')) { var seriesNumbers = pbNo.Split('-').ToArray(); string queryString = string.Format("Select * from PBDrawResults where PBNo between '{0}' and '{1}'", seriesNumbers[0].Trim(), seriesNumbers[1].Trim()); List <PBDrawResult> matchedNumbers = _ctx.PBDrawResults.FromSql(queryString).ToList(); totalMatchedNumbers.AddRange(Mapper.Map <List <PBDrawResultViewModel> >(matchedNumbers)); } else { PBDrawResult number = this.GetAll().FirstOrDefault(oItem => oItem.PBNo.Equals(pbNo.Trim())); if (number != null) { totalMatchedNumbers.Add(Mapper.Map <PBDrawResultViewModel>(number)); } } } return(totalMatchedNumbers); } catch (Exception exception) { throw exception; } }
public IActionResult Post([FromBody] PBDrawResultViewModel viewModel) { try { if (viewModel == null) { return(BadRequest()); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } List <string> pbNoList = viewModel.PBNo.Split(' ').ToList(); foreach (string pbNo in pbNoList) { PBDrawResult item = Mapper.Map <PBDrawResult>(viewModel); item.PBNo = pbNo.Trim(); item.CreationDate = DateTime.Now; item.LastUpdatedDate = DateTime.Now; item.IsActive = true; _pbDrawResultRepository.Add(item); int save = _pbDrawResultRepository.Save(); if (save > 0) { // return CreatedAtRoute("GetById", new { controller = "PBDrawResult", id = item.Id }, item); } } return(StatusCode((int)HttpStatusCode.OK)); } catch (Exception exception) { //Do something with the exception return(StatusCode((int)HttpStatusCode.InternalServerError)); } }
public void Delete(PBDrawResult toDelete) { _ctx.PBDrawResults.Remove(toDelete); }
public PBDrawResult Update(PBDrawResult toUpdate) { _ctx.PBDrawResults.Update(toUpdate); return(toUpdate); }
public PBDrawResult Add(PBDrawResult toAdd) { _ctx.PBDrawResults.Add(toAdd); return(toAdd); }