public int Insert(AirPortModel.Models.AirPort obj) { try { int id = _db.AirPorts.OrderByDescending(x => x.DateCreate).Count() + 1; obj.Id = id; obj.DateCreate = DateTime.Now; obj.LastUpdate = DateTime.Now; obj.IsDelete = false; _db.AirPorts.Add(obj); _db.Database.OpenConnection(); _db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Tbl_AirPort ON"); _db.SaveChanges(); _db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Tbl_AirPort OFF"); return(obj.Id); } catch (Exception ex) { string ms = ex.Message; return(0); } finally { _db.Database.CloseConnection(); } }
public ProgressStatus Update(AirPortModel.Models.AirPort obj) { try { obj.LastUpdate = DateTime.Now.Date; _db.AirPorts.Update(obj); _db.SaveChanges(); var result = new ProgressStatus { Number = 1, Title = "Delete Successful", Message = "AirPort Has been Update" }; return(result); } catch (Exception ex) { var result = new ProgressStatus { Number = 0, Title = "Delete Error", Message = "AirPort can't be Update" }; return(result); } }