public async Task UpdateSales(CreateOrEditSaleDto input)
{
var getdata = _nursaryContext.SalesDetails.Where(x => x.Id == input.Id).FirstOrDefault();
getdata.NurseryId = input.NurseryId;
getdata.FarmerId = input.FarmerId;
getdata.ProductName = input.ProductName;
getdata.Cost = input.Cost;
getdata.Quantity = input.Quantity;
getdata.Total = input.Total;
getdata.Advanceamount = input.Advanceamount;
getdata.Date = input.Date;
_nursaryContext.SalesDetails.Update(getdata);
//Commit the transaction
await _nursaryContext.SaveChangesAsync();
}
public async Task <IActionResult> AddSales(CreateOrEditSaleDto input)
{
try
{
var postId = await _salesRepository.AddSales(input);
if (postId > 0)
{
return(Ok(postId));
}
else
{
return(NotFound());
}
}
catch (Exception ex)
{
return(BadRequest());
}
}
public async Task <int> AddSales(CreateOrEditSaleDto input)
{
SalesDetail cd = new SalesDetail();
cd.NurseryId = input.NurseryId;
cd.FarmerId = input.FarmerId;
cd.ProductName = input.ProductName;
cd.Cost = input.Cost;
cd.Advanceamount = input.Advanceamount;
cd.Date = input.Date;
cd.Quantity = input.Quantity;
cd.Total = input.Total;
cd.CreationDate = DateTime.Now;
cd.IsDeleted = false;
cd.GrandTotal = input.GrandTotal;
await _nursaryContext.SalesDetails.AddAsync(cd);
await _nursaryContext.SaveChangesAsync();
return(input.Id);
}
public async Task <IActionResult> UpdateSales(CreateOrEditSaleDto input)
{
if (ModelState.IsValid)
{
try
{
await _salesRepository.UpdateSales(input);
return(Ok());
}
catch (Exception ex)
{
if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException")
{
return(NotFound());
}
return(BadRequest());
}
}
return(BadRequest());
}
