public void Destroy(ProjectViewModel db)
{
var entity = new Project_Table();
entity.ProjectID = db.ProjectID;
entities.Project_Table.Attach(entity);
entities.Project_Table.Remove(entity);
entities.SaveChanges();
}
public bool AddProject(ProjectModel project)
{
//using (ProjectManagerEntities dbContext = new ProjectManagerEntities())
//{
try
{
if (project.Project_ID == 0)
{
Project_Table projectData = new Project_Table()
{
Project = project.Project,
Start_Date = project.Start_Date == DateTime.MinValue ? null : project.Start_Date,
End_Time = project.End_Time == DateTime.MinValue ? null : project.End_Time,
Priority = project.Priority
};
Project_Table projectCreated = dbContext.Project_Table.Add(projectData);
dbContext.SaveChanges();
var userData = dbContext.Users_Table.Where(c => c.User_ID == project.User_ID).First();
if (userData != null)
{
userData.Project_ID = projectCreated.Project_ID;
}
dbContext.SaveChanges();
}
else
{
var projectData = dbContext.Project_Table.Where(c => c.Project_ID == project.Project_ID).First();
if (projectData != null)
{
projectData.Project = project.Project;
projectData.Start_Date = project.Start_Date == DateTime.MinValue ? null : project.Start_Date;
projectData.End_Time = project.End_Time == DateTime.MinValue ? null : project.End_Time;
projectData.Priority = project.Priority;
dbContext.SaveChanges();
}
var userData = dbContext.Users_Table.Where(c => c.User_ID == project.User_ID).First();
if (userData != null)
{
userData.Project_ID = project.Project_ID;
}
dbContext.SaveChanges();
}
}
catch (Exception e)
{
return(false);
}
return(true);
//}
}
public void Update(ProjectViewModel db)
{
var entity = new Project_Table();
entity.ProjectID = db.ProjectID;
entity.ProjectName = db.ProjectName;
entity.StartData = (DateTime)db.StartData.Date;
entity.EndDate = (DateTime)db.EndDate.Date;
entity.Status = db.Status;
entities.Project_Table.Attach(entity);
entities.Entry(entity).State = EntityState.Modified;
entities.SaveChanges();
}
public void Create(ProjectViewModel db)
{
var entity = new Project_Table();
entity.ProjectName = db.ProjectName;
entity.StartData = (DateTime)db.StartData.Date;
entity.EndDate = (DateTime)db.EndDate.Date;
entity.Status = db.Status;
entities.Project_Table.Add(entity);
entities.SaveChanges();
db.ProjectID = entity.ProjectID;
}
public bool DeleteProject(ProjectModel project)
{
try
{
var userData = dbContext.Users_Table.Where(c => c.User_ID == project.User_ID).First();
userData.Project_ID = null;
dbContext.SaveChanges();
var projectData = new Project_Table {
Project_ID = project.Project_ID
};
dbContext.Entry(projectData).State = EntityState.Deleted;
dbContext.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
