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