public Response Post(Product item)
{
Response resp = new Response();
try
{
using (_context = new DemoAPIContext())
{
item.CreatedOn = DateTime.Now;
item.LastUpdatedOn = DateTime.Now;
item.IsDeleted = false;
_context.Products.Add(item);
_context.SaveChanges();
resp.httpCode = HttpStatusCode.OK;
resp.message = "Request Posted Successfully";
}
}
catch (Exception ex)
{
resp.httpCode = HttpStatusCode.BadRequest;
resp.message = "Something went wrong";
resp.json = JsonConvert.SerializeObject(new { Error = ex.Message });
return(resp);
}
return(resp);
}
public Response GetById(int id)
{
Response resp = new Response();
try
{
using (_context = new DemoAPIContext())
{
var record = _context.Products.Where(a => a.Id == id).FirstOrDefault();
if (!ReferenceEquals(record, null))
{
resp.httpCode = HttpStatusCode.OK;
resp.message = "Record found";
resp.json = JsonConvert.SerializeObject(record);
}
else
{
resp.httpCode = HttpStatusCode.BadRequest;
resp.message = "No record found";
}
}
}
catch (Exception ex)
{
resp.httpCode = HttpStatusCode.BadRequest;
resp.message = "Something went wrong";
resp.json = JsonConvert.SerializeObject(new { Error = ex.Message });
}
return(resp);
}
public Response Get()
{
Response resp = new Response();
try
{
using (_context = new DemoAPIContext())
{
var record = _context.Products.ToList();
if (record.Count > 0)
{
resp.httpCode = HttpStatusCode.OK;
resp.message = "Record found";
resp.json = JsonConvert.SerializeObject(record);
}
else
{
resp.httpCode = HttpStatusCode.BadRequest;
resp.message = "No record found";
}
}
}
catch (Exception ex)
{
resp.httpCode = HttpStatusCode.BadRequest;
resp.message = "Something went wrong";
resp.json = JsonConvert.SerializeObject(new { Error = ex.Message });
}
return(resp);
}
public Response Put(Product item)
{
Response resp = new Response();
try
{
using (_context = new DemoAPIContext())
{
Product record = _context.Products.Where(a => a.Id == item.Id).FirstOrDefault();
if (!ReferenceEquals(record, null))
{
record.Title = item.Title;
record.ProductTypeId = item.ProductTypeId;
record.ContactPersonId = item.ContactPersonId;
record.Description = item.Description;
record.LastUpdatedOn = DateTime.Now;
// _context.Entry(item).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
resp.httpCode = HttpStatusCode.OK;
resp.message = "Record Updated Successfully";
}
else
{
resp.httpCode = HttpStatusCode.BadRequest;
resp.message = "No record found";
}
}
}
catch (Exception ex)
{
resp.httpCode = HttpStatusCode.BadRequest;
resp.message = "Something went wrong";
resp.json = JsonConvert.SerializeObject(new { Error = ex.Message });
return(resp);
}
return(resp);
}
public CategoriesController(DemoAPIContext context)
{
_context = context;
}
public ProductsController(DemoAPIContext context)
{
_context = context;
}
public UserRepository(DemoAPIContext demoContext, IConfiguration configuration)
{
_context = demoContext;
_config = configuration;
}
