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