public static void UpdateCountry(int cID, string newname, string newcurrency, int newsub) { using (var context = new scrumprojectEntities()) { try { var c = context.Countries .FirstOrDefault(x => x.CID == cID); c.Name = newname; c.Currency = newcurrency; c.Subsistence = newsub; context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
//Uppdatera användare public static void UpdateUser(int userid, string newusername, string newfirstname, string newlastname, string newpassword, string newssn, string newemail, int newboss) { using (var context = new scrumprojectEntities()) { try { var u = context.Users .FirstOrDefault(x => x.UID == userid); u.PW = newpassword; u.Username = newusername; u.FirstName = newfirstname; u.LastName = newlastname; u.Email = newemail; u.SSN = newssn; u.BID = newboss; context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
//Uppdatera status på användare som innebär att användaren blir inaktiverad. public static void UpdateStatus(string username) { using (var context = new scrumprojectEntities()) { try { var u = context.Users .FirstOrDefault(x => x.Username == username); u.Status = false; context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public void addCountry(Country C) { using (var context = new scrumprojectEntities()) { try { context.Countries.Add(C); context.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }