public static void DeleteTrucker(int truckerID) { var db = new TruckerProjectDBEntities(); var trucker = db.Truckers.Where(p => p.TruckerID == truckerID).FirstOrDefault(); db.Database.ExecuteSqlCommand("DELETE FROM dbo.LicenseTrucker WHERE TruckerID = {0}", truckerID); db.Truckers.Remove(trucker); db.SaveChanges(); }
public static void CreateTrucker(TruckerDTO truckerDTO) { var db = new TruckerProjectDBEntities(); if (truckerDTO.TruckerID == 0) { truckerDTO.TruckerID = db.Truckers.Count() == 0 ? 1 : db.Truckers.OrderByDescending(p => p.TruckerID).FirstOrDefault().TruckerID + 1; } List <License> dbLicenses = db.Licenses.ToList(); var dbTrucker = convertToDb(truckerDTO, dbLicenses); db.Truckers.Add(dbTrucker); db.SaveChanges(); }