// // // // // // //Uplaoding the File into Database // // // // // // private void uploadButton_Click(object sender, EventArgs e) { try { using (var context = new DemoBoxDBContext()) { FileStream fs = new FileStream(fi.FullName, FileMode.Open, FileAccess.Read); BinaryReader rdr = new BinaryReader(fs); byte[] fileData = rdr.ReadBytes((int)fs.Length); rdr.Close(); fs.Close(); file = new DemoBoxThrid.File(); file.FileName = fi.FullName; file.Data = fileData; file.FileExtension = fi.Extension; file.ProjectId = proId; file.EmployeeId = id; context.Files.Add(file); context.SaveChanges(); } } catch { } }
// // // // // // //Project Manager Form Loading // // // // // // private void ProjectManagerUI_Load(object sender, EventArgs e) { //Employee Information Panels Visibility Off currentEIPanel.Visible = false; onLeaveEIPanel.Visible = false; availableEIPanel.Visible = false; //Completed/Pending Project Panels Visibility Off pendingProjectPanel.Visible = false; completedProjectPanel.Visible = false; //Loading Project Manager's Name in ProjectManagerLaber from Database try { using (var context = new DemoBoxDBContext()) { var query = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeName; foreach (var em in query) { projectManagerNameLabel.Text = "" + em; } } } catch { } }
//By Clicking Done Project Manager has added an Project into Project Database private void doneLink_Click(object sender, EventArgs e) { try { var newProject = new Project(); newProject.ProjectName = projectNameTextBox.Text; newProject.ClientName = projectClientTextBox.Text; newProject.ClientEmail = clientEmailTextBox.Text; newProject.ClientContact = clientContactNoTextBox.Text; newProject.ProjectTimeline = projectTimelineTextBox.Text; newProject.ProjectCost = projectCostTextBox.Text; newProject.EstimatedTimeline = estimatedTimeTextBox.Text; newProject.EstimatedCost = estimatedCostTextBox.Text; newProject.DeliveryDate = deliveryDatePicker.Text; newProject.Specification = specificationTextBox.Text; newProject.ProjectStatus = "Active"; using (var context = new DemoBoxDBContext()) { context.Projects.Add(newProject); context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show("" + ex); } }
private void doneLink_Click(object sender, EventArgs e) { if (maleCheckBox.Checked == true && femaleCheckBox.Checked == false) { gender = "Male"; } else if (femaleCheckBox.Checked == true && maleCheckBox.Checked == false) { gender = "FeMale"; } try { var newEmployee = new Employee(); newEmployee.EmployeeName = uNameTextBox.Text; newEmployee.EmployeeEmail = uEmailTextBox.Text; newEmployee.EmployeePassword = uPasswordTextBox.Text; newEmployee.EmployeeGender = gender; newEmployee.EmplyoeePhone = uPhoneNoTextBox.Text; newEmployee.EmployeeBlood = bloodGroupComboBox.Text; newEmployee.EmployeeBirth = dateOfBirthTextBox.Text; using (var context = new DemoBoxDBContext()) { context.Employees.Add(newEmployee); context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show("" + ex); } try { this.Hide(); m.ShowDialog(); this.Close(); } catch { } }
// // // // // // //Loading Assign Project to search and assign Employee. // // // // // // private void AssignProject_Load(object sender, EventArgs e) { string name, time, id; //Visibility Switching at the start of the project.Only search Project Panel is shown. searchProjectPanel.Visible = true; availableEmployeePanel.Visible = false; // // // //Showing Search History on Project Search TextBox. projectNameTextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; projectNameTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource; projectNameTextBox.AutoCompleteCustomSource = autoComplete; // // // try { using (var context = new DemoBoxDBContext()) { IEnumerable <Project> query = from x in context.Projects select x; foreach (var pr in query) { id = pr.ProjectId.ToString(); name = pr.ProjectName; time = pr.ProjectTimeline; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = id; lvi1.SubItems.Add(name); lvi1.SubItems.Add("NILL"); lvi1.SubItems.Add("NILL"); lvi1.SubItems.Add(time); projectListView.Items.Add(lvi1); } } } catch { } }
// // // // // // //Current Employee Checking Button & Setting Visibilitiy // // // // // // private void currentEIButton_Click(object sender, EventArgs e) { //View On or Off if (i == 0) { currentEIPanel.Visible = true; onLeaveEIPanel.Visible = false; availableEIPanel.Visible = false; i = 1; //Showing list on data throug Crruent List view try { string name, role; using (var context = new DemoBoxDBContext()) { IEnumerable <Employee> Emp = from x in context.Employees select x; foreach (var em in Emp) { if (em.EmployeeStatus != "On Leave" || em.EmployeeStatus != "Left") { if (em.EmployeeRole == 2) { name = em.EmployeeName; role = "Team Leader"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); currentEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 3) { name = em.EmployeeName; role = "Analyst"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); currentEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 4) { name = em.EmployeeName; role = "Designer"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); currentEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 5) { name = em.EmployeeName; role = "Programmer"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); currentEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 6) { name = em.EmployeeName; role = "Tester"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); currentEIListView.Items.Add(lvi1); } } } } } catch { } } else { currentEIPanel.Visible = false; onLeaveEIPanel.Visible = false; availableEIPanel.Visible = false; i = 0; currentEIListView.Items.Clear(); } /*EmployeeData ed = new EmployeeData(); * List<Employee> Employees = ed.GetEmployee(); * * foreach () * { * * } */ }
// // // // // // //Available Employee Checking Button & Setting Visibility // // // // // // private void availableEIButton_Click(object sender, EventArgs e) { if (i == 0) { currentEIPanel.Visible = false; onLeaveEIPanel.Visible = false; availableEIPanel.Visible = true; i = 1; try { string name, role; using (var context = new DemoBoxDBContext()) { IEnumerable <Employee> Emp = from x in context.Employees select x; foreach (var em in Emp) { if (em.EmployeeStatus != "On Leave" && em.EmployeeStatus != "Working" && em.EmployeeStatus != "Left") { if (em.EmployeeRole == 2) { name = em.EmployeeName; role = "Team Leader"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); avaiableEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 3) { name = em.EmployeeName; role = "Analyst"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); avaiableEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 4) { name = em.EmployeeName; role = "Designer"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); avaiableEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 5) { name = em.EmployeeName; role = "Programmer"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); avaiableEIListView.Items.Add(lvi1); } else if (em.EmployeeRole == 6) { name = em.EmployeeName; role = "Tester"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(role); avaiableEIListView.Items.Add(lvi1); } } } } } catch { } } else { currentEIPanel.Visible = false; onLeaveEIPanel.Visible = false; availableEIPanel.Visible = false; avaiableEIListView.Items.Clear(); i = 0; } }
private void ProjectHub_FormClosing(object sender, FormClosingEventArgs e) { try { using (var context = new DemoBoxDBContext()) { var query = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeRole; foreach (var s in query) { if (s == 1) { this.Hide(); ProjectManagerUI pm = new ProjectManagerUI(email); pm.ShowDialog(); this.Close(); } else if (s == 2) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 3) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 4) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 5) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 6) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } } } } catch { } }
private void projectNameTextBox_KeyDown(object sender, KeyEventArgs e) { int n = 0; if (e.KeyCode == Keys.Enter) { this.proName = projectNameTextBox.Text; autoComplete.Add(projectNameTextBox.Text); if (n == 0) { try { using (var context = new DemoBoxDBContext()) { var query = from x in context.Projects where x.ProjectName == proName select x; foreach (var em in query) { this.proId = em.ProjectId; } } using (var context = new DemoBoxDBContext()) { IEnumerable <File> query = from x in context.Files join c in context.Projects on x.ProjectId equals c.ProjectId //select new { FileName = x.FileName, x.EmployeeId }; select x; foreach (var em in query) { this.name = em.FileName; this.id = em.EmployeeId; using (var newContext = new DemoBoxDBContext()) { var newQuery = from y in newContext.Employees where y.EmployeeId == id select y; foreach (var es in newQuery) { this.empName = es.EmployeeName; this.role = es.EmployeeRole; } } ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(empName); lvi1.SubItems.Add("" + role); projectDetailsListView.Items.Add(lvi1); } } using (var context = new DemoBoxDBContext()) { var query = from x in context.Projects where x.ProjectId == proId select x; foreach (var em in query) { showStatusLabel.Text = em.ProjectStatus; deliveryDateShowLabel.Text = em.DeliveryDate; clientShowLabel.Text = em.ClientName; DateTime dt1 = Convert.ToDateTime(em.DeliveryDate); DateTime dt2 = DateTime.Today; TimeSpan time = dt1.Subtract(dt2); int t = (int)time.TotalDays; timeRemainingShowLabel.Text = "" + t + " Days"; } } } catch { MessageBox.Show("Nothing Found"); } n = 1; } else if (n == 1) { projectDetailsListView.Items.Clear(); n = 0; } } }
// // // // // // //Loading Information FORM // // // // // // private void Info_Load(object sender, EventArgs e) { updateInfoTile.Visible = false; deleteInfoTile.Visible = false; projectPanel.Visible = false; projectPendingPanel.Visible = false; try { using (var context = new DemoBoxDBContext()) { //Setting Id From Database var query = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeId; foreach (var em in query) { this.id = em; idTextLabel.Text = "" + em; } // // // //Setting Name From Database var query1 = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeName; foreach (var em in query1) { nameTextLabel.Text = em; } // // // //Setting Password From Database var query2 = from x in context.Employees where x.EmployeeEmail == email select x.EmployeePassword; foreach (var em in query2) { passwordTextLabel.Text = em; } // // // //Setting Email From Database var query3 = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeEmail; foreach (var em in query3) { emailTextLabel.Text = em; } // // // //Setting Phone From Database var query4 = from x in context.Employees where x.EmployeeEmail == email select x.EmplyoeePhone; foreach (var em in query4) { phoneNoTextLabel.Text = em; } // // // //Setting Id From Database var query5 = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeBirth; foreach (var em in query5) { dateOfBirthTextLabel.Text = em; } // // // //Setting Id From Database var query6 = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeGender; foreach (var em in query6) { genderTextLabel.Text = em; } // // // //Setting Project Number till now int a = 0; IEnumerable <ProjectEmployee> query7 = from x in context.ProjectEmployees where x.EmployeeId == id select x; foreach (var em in query7) { a++; } projectCompletedTextLabel.Text = "" + a; // // // //Loading Pending Projects } } catch { } }
//New Employee Pending Requests by pressing Button and values in PendingNewListView // // // // // // private void newEmployeeButton_Click(object sender, EventArgs e) { if (i == 0) { if (pendingOldPanel.Visible == true) { pendingOldPanel.Visible = false; } pendingNewPanel.Visible = true; i = 1; try { string id, name, role; using (var context = new DemoBoxDBContext()) { IEnumerable <Employee> Emp = from x in context.Employees select x; foreach (var em in Emp) { if (em.EmployeeRole == 0) { id = em.EmployeeId.ToString(); name = em.EmployeeName; role = "NILL"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = id; lvi1.SubItems.Add(name); lvi1.SubItems.Add(role); pendingNewListView.Items.Add(lvi1); } /*else if (em.EmployeeRole == 2) * { * id = em.EmployeeId.ToString(); * name = em.EmployeeName; * role = "NILL"; * * ListViewItem lvi1 = new ListViewItem(); * * lvi1.Text = id; * lvi1.SubItems.Add(name); * lvi1.SubItems.Add(role); * * pendingNewListView.Items.Add(lvi1); * } * else if (em.EmployeeRole == 4) * { * id = em.EmployeeId.ToString(); * name = em.EmployeeName; * role = "NILL"; * * ListViewItem lvi1 = new ListViewItem(); * * lvi1.Text = id; * lvi1.SubItems.Add(name); * lvi1.SubItems.Add(role); * * pendingNewListView.Items.Add(lvi1); * } * else if (em.EmployeeRole == 5) * { * id = em.EmployeeId.ToString(); * name = em.EmployeeName; * role = "NILL"; * * ListViewItem lvi1 = new ListViewItem(); * * lvi1.Text = id; * lvi1.SubItems.Add(name); * lvi1.SubItems.Add(role); * * pendingNewListView.Items.Add(lvi1); * } * else if (em.EmployeeRole == 6) * { * id = em.EmployeeId.ToString(); * name = em.EmployeeName; * role = "NILL"; * * ListViewItem lvi1 = new ListViewItem(); * * lvi1.Text = id; * lvi1.SubItems.Add(name); * lvi1.SubItems.Add(role); * * pendingNewListView.Items.Add(lvi1); * }*/ } } } catch { } } else if (i == 1) { pendingNewListView.Items.Clear(); pendingNewPanel.Visible = false; pendingOldPanel.Visible = false; i = 0; } }
// // // // // // //Assinging Role and Status to Employee by clicking AssignButton // // // // // // private void assignButton_Click(object sender, EventArgs e) { if (id != 0 && roles != null) { using (var context = new DemoBoxDBContext()) { var query = from x in context.Employees where x.EmployeeId == id select x; foreach (var em in query) { if (roles == "Team Leader") { em.EmployeeRole = 2; } else if (roles == "Analyst") { em.EmployeeRole = 3; } else if (roles == "Designer") { em.EmployeeRole = 4; } else if (roles == "Programmer") { em.EmployeeRole = 5; } else if (roles == "Tester") { em.EmployeeRole = 6; } } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show("" + ex); } } } else if (id != 0 && status != null) { using (var context = new DemoBoxDBContext()) { var query = from x in context.Employees where x.EmployeeId == id select x; foreach (var em in query) { em.EmployeeStatus = status; } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show("" + ex); } } } }
// // // // // // // //Login Completed // // // // // // // private void loginDoneButton_Click(object sender, EventArgs e) { if (loginEmailTextBox.Text == null || loginPasswordTextBox.Text == null) { MessageBox.Show("Enter your Email and Password!!"); } try { string email = loginEmailTextBox.Text; string pass = loginPasswordTextBox.Text; using (var context = new DemoBoxDBContext()) { var query = from x in context.Employees where x.EmployeeEmail == email && x.EmployeePassword == pass select x.EmployeeRole; foreach (var s in query) { if (s == 1) { this.Hide(); ProjectManagerUI pm = new ProjectManagerUI(email); pm.ShowDialog(); this.Close(); } else if (s == 2) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 3) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 4) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 5) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 6) { this.Hide(); EmployeeManagement em = new EmployeeManagement(email, s); em.ShowDialog(); this.Close(); } else if (s == 0) { MetroFramework.MetroMessageBox.Show(this, "Your Account Hasn't Confirmed Yet"); } } } } catch (Exception ex) { MessageBox.Show("" + ex); } }
// // // // // // //Assigning Project to an Employee // // // // // // private void assignButton_Click(object sender, EventArgs e) { if (empId != 0 && proId != 0 && poss != null) { try { var projectEmployee = new ProjectEmployee(); projectEmployee.EmployeeId = empId; projectEmployee.ProjectId = proId; using (var context = new DemoBoxDBContext()) { context.ProjectEmployees.Add(projectEmployee); context.SaveChanges(); } using (var context = new DemoBoxDBContext()) { var query = from x in context.Employees where x.EmployeeId == empId select x; foreach (var em in query) { if (poss == "Team Leader") { em.EmployeeProjectRole = 2; em.EmployeeStatus = "Working"; } else if (poss == "Analyst") { em.EmployeeProjectRole = 3; em.EmployeeStatus = "Working"; } else if (poss == "Designer") { em.EmployeeProjectRole = 4; em.EmployeeStatus = "Working"; } else if (poss == "Programmer") { em.EmployeeProjectRole = 5; em.EmployeeStatus = "Working"; } else if (poss == "Tester") { em.EmployeeProjectRole = 6; em.EmployeeStatus = "Working"; } } try { context.SaveChanges(); } catch { } } } catch { } } }
// // // // // // //Showing Available Employee Panel on One click private void projectListView_MouseClick(object sender, MouseEventArgs e) { availableEmployeePanel.Visible = true; try { string name, role, id; using (var context = new DemoBoxDBContext()) { IEnumerable <Employee> Emp = from x in context.Employees select x; foreach (var em in Emp) { if (em.EmployeeStatus != "On Leave" && em.EmployeeStatus != "Working" && em.EmployeeStatus != "Left") { if (em.EmployeeRole == 2) { id = em.EmployeeId.ToString(); name = em.EmployeeName; role = "Team Leader"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = id; lvi1.SubItems.Add(name); lvi1.SubItems.Add(role); availableEmployeeListView.Items.Add(lvi1); } else if (em.EmployeeRole == 3) { id = em.EmployeeId.ToString(); name = em.EmployeeName; role = "Analyst"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = id; lvi1.SubItems.Add(name); lvi1.SubItems.Add(role); availableEmployeeListView.Items.Add(lvi1); } else if (em.EmployeeRole == 4) { id = em.EmployeeId.ToString(); name = em.EmployeeName; role = "Designer"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = id; lvi1.SubItems.Add(name); lvi1.SubItems.Add(role); availableEmployeeListView.Items.Add(lvi1); } else if (em.EmployeeRole == 5) { id = em.EmployeeId.ToString(); name = em.EmployeeName; role = "Programmer"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = id; lvi1.SubItems.Add(name); lvi1.SubItems.Add(role); availableEmployeeListView.Items.Add(lvi1); } else if (em.EmployeeRole == 6) { id = em.EmployeeId.ToString(); name = em.EmployeeName; role = "Tester"; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = id; lvi1.SubItems.Add(name); lvi1.SubItems.Add(role); availableEmployeeListView.Items.Add(lvi1); } } } } } catch { } }
// // // // // // //Setting EmployeeId,EmployeeName,EmployeeRole, at the top of Form in empNameLabel // // // // // // private void EmployeeManagement_Load(object sender, EventArgs e) { try { using (var context = new DemoBoxDBContext()) { //Setting Employee Name According to Login var query = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeName; foreach (var em in query) { empNameLabel.Text = em; } //Seting Employee ID According to Login var query1 = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeId; foreach (var em in query1) { this.id = em; employeeIdLabel.Text = "" + em; } // //Seting Employee Status Accoding to Login var query2 = from x in context.Employees where x.EmployeeEmail == email select x.EmployeeStatus; foreach (var em in query2) { if (em != null) { empStatusTextLabel.Text = "" + em; } else { empStatusTextLabel.Text = "Nill"; } } //Setting Employee Status According to Login var query3 = from x in context.Employees where x.EmployeeRole == role select x.EmployeeRole; foreach (var em in query3) { if (em == 2) { joinedAsTextLabel.Text = "Team Leader"; } else if (em == 3) { joinedAsTextLabel.Text = "Analyst"; } else if (em == 4) { joinedAsTextLabel.Text = "Designer"; } else if (em == 5) { joinedAsTextLabel.Text = "Programmer"; } else if (em == 6) { joinedAsTextLabel.Text = "Tester"; } } //Setting ProjectId var query4 = from x in context.ProjectEmployees where x.EmployeeId == id select x.ProjectId; foreach (var em in query4) { this.proId = em; } //Loading Project on List View string name, file; var query5 = from p in context.Projects join c in context.Files on p.ProjectId equals c.ProjectId select new { projectName = p.ProjectName, c.FileName }; foreach (var em in query5) { name = em.projectName; file = em.FileName; ListViewItem lvi1 = new ListViewItem(); lvi1.Text = name; lvi1.SubItems.Add(file); projectOnWorkListView.Items.Add(lvi1); } } } catch { } }