public void addProject(Projekt newProject, int customerID)
{
testDashboardContext database = new testDashboardContext();
Projekt newProjekt = new Projekt()
{
KundID = customerID,
Name = newProject.Name,
Status = newProject.Status,
TotalTid = newProject.TotalTid,
Deadline = newProject.Deadline,
T = newProject.T,
UTF = newProject.UTF
};
database.Projekts.Add(newProjekt);
try
{
database.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 addProjectItem(ProjektItem newItem)
{
testDashboardContext database = new testDashboardContext();
ProjektItem item = new ProjektItem()
{
ProjektID = newItem.ProjektID,
Name = newItem.Name,
UserID = newItem.UserID,
UtveckladeTimmar = newItem.UtveckladeTimmar,
TotalTid = newItem.TotalTid,
Deadline = newItem.Deadline
};
database.ProjektItems.Add(item);
try
{
database.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 <Projekt> getProjectItem(int id)
{
testDashboardContext database = new testDashboardContext();
List <Projekt> projectItem = new List <Projekt>();
projectItem = database.Projekts.Where(x => x.ID == id).ToList();
return(projectItem);
}
public KundProjectModel getProjects()
{
KundProjectModel model = new KundProjectModel();
testDashboardContext database = new testDashboardContext();
model.Kunders = database.Kunders.ToList();
model.Projekts = database.Projekts.ToList();
return(model);
}
public bool checkMe(SystemUser model)
{
testDashboardContext database = new testDashboardContext();
IQueryable <SystemUser> checkUserQuery =
from Username in database.SystemUsers
where Username.Username == model.Username
select Username;
foreach (var user in checkUserQuery)
{
if (user.Username == model.Username)
{
return(true);
}
}
return(false);
}
public void registerMe(SystemUser model)
{
testDashboardContext database = new testDashboardContext();
SystemUser newUser = new SystemUser()
{
Username = model.Username, SaltedPassword = "******", Email = model.Email, IsAdmin = model.IsAdmin
};
database.SystemUsers.Add(newUser);
try
{
database.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
throw new Exception(ex.ToString());
}
}
public void addHours(Kommentarer newComment)
{
testDashboardContext database = new testDashboardContext();
Kommentarer newKommentar = new Kommentarer()
{
ItemID = newComment.ItemID, UserID = newComment.UserID,
AntalTimmar = newComment.AntalTimmar, Kommentar = newComment.Kommentar,
DateCreated = newComment.DateCreated
};
database.Kommentarers.Add(newKommentar);
try
{
database.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
throw new Exception(ex.ToString());
}
}
