public async Task <ActionResult <ViewVisitTable> > GetVisitTable(decimal id)
{
var data = await _context.VisitTable.FindAsync(id);
if (data == null)
{
return(NotFound());
}
ViewVisitTable mapData = new ViewVisitTable(data);
return(mapData);
}
public async Task <ActionResult <IEnumerable <ViewVisitTable> > > GetVisitTable()
{
List <VisitTable> data = await _context.VisitTable.ToListAsync();
List <ViewVisitTable> mapDataList = new List <ViewVisitTable>();
if (data == null)
{
return(NotFound());
}
foreach (var item in data)
{
ViewVisitTable mapData = new ViewVisitTable(item);
mapDataList.Add(mapData);
}
return(mapDataList);
}
public async Task <ActionResult <VisitTable> > PostVisitTable(ViewVisitTable visitTable)
{
VisitTable v = new VisitTable();
v.CustName = visitTable.CustName;
v.ContactNo = visitTable.ContactNo;
v.ContactPerson = visitTable.ContactPerson;
v.Description = visitTable.Description;
v.EmpId = visitTable.EmpId;
v.VisitDatetime = DateTime.Now;
v.InterestProduct = visitTable.InterestProduct;
v.IsDeleted = false;
v.IsDisabled = false;
_context.VisitTable.Add(v);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetVisitTable", new { id = visitTable.VisitId }, visitTable));
}
public async Task <IActionResult> PutVisitTable(decimal id, ViewVisitTable visitTable)
{
if (id != visitTable.VisitId)
{
return(BadRequest());
}
var visitFromDb = await _context.VisitTable.FirstOrDefaultAsync(r => r.VisitId == visitTable.VisitId);
if (visitFromDb == null)
{
return(NotFound("No data Found"));
}
visitFromDb.CustName = visitTable.CustName;
visitFromDb.Description = visitTable.Description;
visitFromDb.InterestProduct = visitTable.InterestProduct;
visitFromDb.IsDisabled = visitTable.IsDisabled;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VisitTableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
