public void AddProject(ProjectModel p, string s, string c) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { Projects proj = new Projects(); proj.Title = p.Title; proj.Date_Created = DateTime.Now; proj.Date_From = p.Date_From; proj.Date_To = p.Date_To; proj.Cap = Convert.ToDecimal(p.Cap); proj.IsActive = 1; proj.IsDeleted = 0; proj.Client_Id = Convert.ToInt32(s); proj.CreatedBy = Convert.ToInt32(c); proj.TotalStaff = p.TotalStaff; proj.ITsOnProject = p.ITsOnProject; proj.ManualWorkersOnProject = p.ManualWorkersOnProject; proj.EngineersOnProject = p.EngineersOnProject; proj.ArchitectsOnProject = p.ArchitectsOnProject; proj.EstimatedEarnings = p.EstimatedEarnings; proj.RiskFactor = p.RiskFactor; db.Projects.Add(proj); db.SaveChanges(); } }
public void DeleteUser(int id) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { db.Database.ExecuteSqlCommand("Update Users Set IsDeleted = 1 where id =" + id); db.SaveChanges(); } }
public void UpdateProject(ProjectModel pm, string selectClient, string sid, string active) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { db.Entry(convertProjectForDB(pm, selectClient, sid, active)).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateClient(ClientModel c, string sid) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { db.Entry(convertClientForDB(c, sid)).State = EntityState.Modified; db.SaveChanges(); } }
public bool ChangePassword(string old_pass, string new_pass, int id) { if (GetUserPassword(id).Equals(old_pass)) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { db.Users.Find(id).Password = new_pass; db.SaveChanges(); return(true); } } return(false); }
public bool UpdateUser(string name, string address, string phone, string email, int id) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { var user = db.Users.Find(id); user.Address = address; user.Name = name; user.PhoneNumber = phone; user.Email = email; db.SaveChanges(); return(true); } }
public void AddClient(ClientModel p, string maincontact, string sid) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { Clients cli = new Clients(); cli.Name = p.Name; cli.DateAdded = p.DateAdded; cli.MainContact = Convert.ToInt32(maincontact); cli.CreatedBy = Convert.ToInt32(sid); cli.PhoneNumber = p.PhoneNumber; cli.Address = p.Address; cli.IsDeleted = 0; db.Clients.Add(cli); db.SaveChanges(); } }
public void AddUser(UserModel um) { using (ProjectsDBEntities db = new ProjectsDBEntities()) { Users u = new Users(); u.Name = um.Name; u.Address = um.Address; u.imageUrl = "#"; u.Password = um.Password; u.PhoneNumber = um.PhoneNumber; u.Email = um.E_mail; u.Role_Id = 2; u.Username = um.Username; u.Projects = new List <Projects>(); u.Clients = new List <Clients>(); db.Users.Add(u); db.SaveChanges(); } }