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