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