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