public List <Country> GetAllCountries()
{
using (var context = new scrumprojectEntities())
{
return(context.Countries.OrderBy(x => x.Name).ToList());
}
}
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);
}
}
}
}
}
public Country GetSpecificsFromCountry(string country)
{
using (var context = new scrumprojectEntities())
{
return(context.Countries.FirstOrDefault(x => x.Name.Equals(country)));
}
}
//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);
}
}
}
}
}
public List <Report> GetAllReports()
{
using (var context = new scrumprojectEntities())
{
return(context.Reports.ToList());
}
}
//Skapar en lista med alla användare
public static List <User> GetAll()
{
using (var context = new scrumprojectEntities())
{
return(context.Users.OrderBy(x => x.FirstName).ToList());
}
}
//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);
}
}
}
}
}
//Skapa list med användarnamn
public static List <User> GetMatchingUsers(string name)
{
using (var context = new scrumprojectEntities())
{
return(context.Users.Where(x => x.Username.Contains(name)).ToList());
}
}
public void AddPrepaymentRequest(Prepayment prepayment)
{
using (var context = new scrumprojectEntities())
{
context.Prepayments.Add(prepayment);
}
}
public List <Boss> GetAllBosses()
{
using (var context = new scrumprojectEntities())
{
return(context.Bosses.ToList());
}
}
public List <User> GetAllUsers()
{
using (var context = new scrumprojectEntities())
{
return(context.Users.ToList());
}
}
public Boss LoginBoss(string username, string password)
{
using (var context = new scrumprojectEntities())
{
return(context.Bosses.FirstOrDefault(x =>
x.Username.Equals(username) &&
x.PW.Equals(password)));
}
}
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);
}
}
}
}
}
