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