public int DeleteUserById(int UserId)
{
int Retval = -1;
ProductDBEntities tstDb = new ProductDBEntities();
TblUser userProfile = new TblUser();
userProfile.User_ID = UserId;
tstDb.Entry(userProfile).State = EntityState.Deleted;
Retval = tstDb.SaveChanges();
return(Retval);
}
public int UpdateProjectUserInfo(int ProjectID, string project, DateTime startDate, DateTime endDate, int priority, int userID)
{
int Retval = -1;
ProductDBEntities tstDb = new ProductDBEntities();
ProjectInfo tempProd = new ProjectInfo();;
tempProd.Project_ID = ProjectID;
tempProd.Project = project;
tempProd.StartDate = startDate;
tempProd.EndDate = endDate;
tempProd.Project_ID = priority;
TblProject result = tstDb.TblProjects.SingleOrDefault(b => b.Project_ID == ProjectID);
if (result != null)
{
//result.Project_ID = UserId;
result.Project = project;
result.StartDate = startDate;
result.EndDate = endDate;
result.Priority = priority;
tstDb.Entry(result).State = EntityState.Modified;
Retval = tstDb.SaveChanges();
}
//return Retval;
TblUser resultuser = tstDb.TblUsers.SingleOrDefault(b => b.User_ID == userID);
if (resultuser != null)
{
resultuser.User_ID = resultuser.User_ID;
//resultuser.FirstName = resultuser.User_ID;
//resultuser.LastName = LastName;
resultuser.Project_ID = ProjectID;
//resultuser.EmployeeID = Employee_ID;
//resultuser.Task_ID = TaskID;
tstDb.Entry(resultuser).State = EntityState.Modified;
Retval = tstDb.SaveChanges();
}
return(Retval);
}
public int DeleteProjectById(int ProjectId)
{
int Retval = -1;
ProductDBEntities tstDb = new ProductDBEntities();
TblProject projInfo = new TblProject();
projInfo.Project_ID = ProjectId;
tstDb.Entry(projInfo).State = EntityState.Deleted;
Retval = tstDb.SaveChanges();
TblUser resultuser = tstDb.TblUsers.SingleOrDefault(b => b.Project_ID == ProjectId);
if (resultuser != null)
{
resultuser.User_ID = resultuser.User_ID;
resultuser.Project_ID = 0;
tstDb.Entry(resultuser).State = EntityState.Modified;
Retval = tstDb.SaveChanges();
}
return(Retval);
}
