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