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);
}
