public void AddProject(ProjectDto t) { var project = new ProjectDb { CreationDate = t.CreationDate, Comment = t.Comment, CreatorId = t.CreatorId, DeptId = t.DeptId, Finish = t.Finish, ManagerId = t.ManagerId, Name = t.Name, Priority = t.Priority, Start = t.Start, State = t.State, UserId = t.UserId }; using (var context = new CamozziEntities()) { context.ProjectDbs.Add(project); context.SaveChanges(); Console.WriteLine("------------------------------------------------------------"); Console.WriteLine(DateTime.Now + " Project Added by " + context.UserDbs.First(x => x.Id == project.CreatorId).Name); } UpdateClients(); }
public void DeleteUser(UserDto t) { using (var context = new CamozziEntities()) { context.UserDbs.Remove(context.UserDbs.Find(t.Id)); context.SaveChanges(); } }
public void AddUser(UserDto t) { var user = new UserDb() { AccountId = t.AccountId, Comment = t.Comment, DeptId = t.DeptId, Mail = t.Mail, Name = t.Name, Password = "******", Phone = t.Phone }; using (var context = new CamozziEntities()) { context.UserDbs.Add(user); context.SaveChanges(); user.QueryId = user.Id; context.SaveChanges(); } }
public void DeleteProject(ProjectDto t) { using (var context = new CamozziEntities()) { Console.WriteLine("------------------------------------------------------------"); Console.WriteLine(DateTime.Now + " Project Deleted by " + context.UserDbs.First(x => x.Id == t.UserId).Name); context.ProjectDbs.Remove(context.ProjectDbs.Find(t.Id)); context.SaveChanges(); } UpdateClients(); }
public void UpdateUser(UserDto t) { using (var context = new CamozziEntities()) { var user = context.UserDbs.Find(t.Id); //context.UserDbs.Attach(Mapper.Map<UserDb>(t)); //var entry = context.Entry(t); user.Mail = t.Mail; user.Comment = t.Comment; //user.Name = t.Name; user.Phone = t.Phone; context.SaveChanges(); } }
public void UpdateProject(ProjectDto t) { using (var context = new CamozziEntities()) { var project = context.ProjectDbs.First(x => x.Id == t.Id); project.CreationDate = t.CreationDate; project.Comment = t.Comment; project.CreatorId = t.CreatorId; project.DeptId = t.DeptId; project.Finish = t.Finish; project.ManagerId = t.ManagerId; project.Name = t.Name; project.Priority = t.Priority; project.Start = t.Start; project.State = t.State; project.UserId = t.UserId; context.SaveChanges(); Console.WriteLine("------------------------------------------------------------"); Console.WriteLine(DateTime.Now + " Project Updated by " + context.UserDbs.First(x => x.Id == project.UserId).Name); } UpdateClients(); }