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