public APIResult <DAL.tbl_vehicles> Put(int id, DAL.tbl_vehicles value)
{
try
{
using (var ctx = new MainEntities())
{
var u = APIRequest.User(HttpContext.Current.Request);
var v = ctx.tbl_vehicles.Find(id);
//v.id = id;
v.capacity = value.capacity;
v.color = value.color;
v.model = value.model;
v.license_no = value.license_no;
//ctx.Set<DAL.tbl_vehicles>().Attach(v);
ctx.Entry(v).State = System.Data.Entity.EntityState.Modified;
var result = ctx.SaveChanges();
if (result <= 0)
{
return(APIResult <DAL.tbl_vehicles> .Error(ResponseCode.BackendDatabase, "Error while saving data!"));
}
return(APIResult <DAL.tbl_vehicles> .Success(value, "API_SUCCESS"));
}
}
catch (Exception ex)
{
return(APIResult <DAL.tbl_vehicles> .Error(ResponseCode.BackendDatabase, ex.Message));
}
}
public APIResult <DAL.tbl_vehicles> Post(DAL.tbl_vehicles value)
{
try
{
var u = APIRequest.User(HttpContext.Current.Request);
value.owner_id = u.Entity.id;
value.created_at = DateTime.Now;
value.created_by = u.Entity.id;
using (var ctx = new MainEntities())
{
ctx.Set <DAL.tbl_vehicles>().Add(value);
ctx.Entry(value).State = System.Data.Entity.EntityState.Added;
if (ctx.SaveChanges() <= 0)
{
if (u.hasRole("driver"))
{
ctx.tbl_drivers_vehicles_rel.Add(new tbl_drivers_vehicles_rel()
{
vehicle_id = value.id,
created_at = DateTime.Now,
created_by = u.Entity.id,
driver_id = u.Entity.id,
status = 1
});
ctx.SaveChanges();
}
return(APIResult <DAL.tbl_vehicles> .Error(ResponseCode.BackendDatabase, "Error while saving data!"));
}
return(APIResult <DAL.tbl_vehicles> .Success(value, "API_SUCCESS"));
}
}
catch (Exception ex)
{
return(APIResult <DAL.tbl_vehicles> .Error(ResponseCode.BackendDatabase, ex.Message));
}
}
