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