public ViewProjects(string s1) { loggedInName = s1; InitializeComponent(); SetGridView(); var con = new PmtContext(); projectBindingSource.DataSource = con.Projects.ToList().Where(t => t.ProjectManager == loggedInName); cboxSelectProject.DataSource = projectBindingSource; }
public AddOrUpdateTask() { var con = new PmtContext(); InitializeComponent(); projectBindingSource.DataSource = con.Projects.ToList(); userBindingSource.DataSource = con.Users.ToList(); //cboxSelectProject.DataSource = projectBindingSource.DataSource; //cboxSelectResourcePerson.DataSource = userBindingSource.DataSource; }
public static void AddResource_Person(string s1, string s2, string s3) { var context = new PmtContext(); context.ResourcePersons.Add(new ResourcePerson() { ResourcePersonName = s1, ResourcePersonProjectName = s2, ResourcePersonDesignation = s3 }); context.SaveChanges(); }
public ProjectDetails(string s1) { MessageBox.Show(s1); var con = new PmtContext(); InitializeComponent(); projectBindingSource.DataSource = con.Projects.ToList().Where(t => t.ProjectName == s1); taskBindingSource.DataSource = con.Tasks.ToList().Where(t => t.TasksProjectName == s1); projectName = s1; SetGridView(); }
public static void AddUser(string s1, string s2, string s3, bool s4, string s5) { var context = new PmtContext(); context.Users.Add(new User() { UserName = s1, UserEmail = s2, UserPassword = s3, UserStatus = s4, UserDesignation = s5 }); context.SaveChanges(); }
public static void AddTask(string s1, string s2, string s3, DateTime s4, string s5) { var context = new PmtContext(); context.Tasks.Add(new EntityClasses.Task() { TasksName = s3, TasksProjectName = s1, TasksAssignedUser = s2, dueDate = s4, priority = s5 }); context.SaveChanges(); }
public static void AddProject(string s1, string s2, string s3, string s4, string s5, DateTime s6, DateTime s7, int s8, string s9, string s10) { var context = new PmtContext(); context.Projects.Add(new Project() { ProjectName = s1, ProjectShortName = s2, ProjectDescription = s3, ProjectManager = s4, ProjectFilePath = s5, ProjectPsd = s6, ProjectPed = s7, ProjectDuration = s8, ProjectPriority = s9, ProjectStatus = s10 }); context.SaveChanges(); }
private void btnLogin_Click(object sender, EventArgs e) { var con = new PmtContext(); var userLogin = con.Users.SingleOrDefault(t => t.UserName == txtUserName.Text) as User; if (txtUserName.Text == "it" && txtPassword.Text == "it123") { MessageBox.Show("IT Admin logged In Successfully"); Hide(); AddOrUpdateUser a1 = new AddOrUpdateUser(); a1.Show(); } else if (userLogin != null && userLogin.UserPassword == txtPassword.Text) { string deg = userLogin.UserDesignation; if (deg == "Project Manager") { Hide(); ProjectManager p1 = new ProjectManager(userLogin.UserName); p1.Show(); } else { Hide(); ViewProjects v1 = new ViewProjects(userLogin.UserName); v1.Show(); } MessageBox.Show(deg + " logged In Successfully"); } else { MessageBox.Show("Invalid User"); } }
private void SetGridView() { var con = new PmtContext(); dataGridView1.DataSource = con.Projects.ToList(); }