private void FillTeams()
{
using (var context = new RedSeaEntities())
{
var teams = context.tblTeams.ToList();
teamLookUpEdit.Properties.DataSource = teams;
}
}
private void FillPositions()
{
using (var context = new RedSeaEntities())
{
var positions = context.tblDesignations.ToList();
positionLookUpEdit.Properties.DataSource = positions;
}
}
private void FillSystems()
{
using (var context = new RedSeaEntities())
{
var systems = context.tblSystems.ToList();
foreach (var record in systems)
{
programsCheckedComboBoxEdit.Properties.Items.Add(record.Id, record.SystemName);
}
}
}
private void FillSkills()
{
using (var context = new RedSeaEntities())
{
var skills = context.tblSkills.ToList();
foreach (var record in skills)
{
skillsCheckedComboBoxEdit.Properties.Items.Add(record.Id, record.SkillName);
}
}
}
private void FillLanguages()
{
using (var context = new RedSeaEntities())
{
var languages = context.tblLanguages.ToList();
foreach (var record in languages)
{
languagesCheckedComboBoxEdit.Properties.Items.Add(record.Id, record.LanguageName);
}
}
}
public int Add()
{
using (var context = new RedSeaEntities())
{
var designation = new tblDesignation()
{
Designation = this.designation
};
context.tblDesignations.Add(designation);
context.SaveChanges();
this.id = designation.Id;
}
return(this.id);
}
public bool Delete()
{
bool result = false;
using (var context = new RedSeaEntities())
{
var designation = context.tblDesignations.SingleOrDefault(i => i.Id == this.id);
if (designation != null)
{
context.tblDesignations.Remove(designation);
context.SaveChanges();
result = true;
}
}
return(result);
}
private void RecallEmployee()
{
if (this.employeeId == 0)
{
return;
}
using (var context = new RedSeaEntities())
{
var fte = context.tblFTEs
.Where(b => b.Id == this.employeeId)
.FirstOrDefault();
fullNameLabelControl.Text = fte.FirstName + " " + fte.LastName;
firstNameTextEdit.EditValue = fte.FirstName;
lastNameTextEdit.EditValue = fte.LastName;
usernameTextEdit.EditValue = fte.Username;
positionLookUpEdit.EditValue = fte.Designation;
teamLookUpEdit.EditValue = fte.Team;
hireDateDateEdit.EditValue = fte.HireDate;
statusComboBoxEdit.SelectedIndex = (fte.Active) ? 0 : 1;
emailTextEdit.EditValue = fte.Email;
codeTextEdit.Text = fte.Code;
fingerprintTextEdit.EditValue = fte.FingerPrint;
directReportLookUpEdit.EditValue = fte.DirectReport;
phoneTextEdit.EditValue = fte.Phone;
ciscoTextEdit.EditValue = fte.Cisco;
pcLookUpEdit.EditValue = fte.PC;
authorityLookUpEdit.EditValue = fte.Authority;
notesMemoEdit.EditValue = fte.Notes;
Image employeeImage = RedSea24.Classes.Logic.ByteArrayToImage(fte.Photo);
if (employeeImage != null)
{
photoPictureEdit.Image = employeeImage;
}
else
{
photoPictureEdit.Image = Resources.images__1_;
}
CheckLanguages();
CheckSkills();
CheckPrograms();
}
}
private void SaveNew()
{
// check validation first
if (!dxValidationProvider1.Validate())
{
return;
}
using (var context = new RedSeaEntities())
{
tblFTE currentFte = new tblFTE();
currentFte.FirstName = Classes.Logic.CleanString(firstNameTextEdit.Text, 1);
currentFte.LastName = Classes.Logic.CleanString(lastNameTextEdit.Text, 1);
currentFte.Username = usernameTextEdit.Text;
currentFte.Designation = Convert.ToInt32(positionLookUpEdit.EditValue);
currentFte.Team = Convert.ToInt32(teamLookUpEdit.EditValue);
currentFte.HireDate = Convert.ToDateTime(hireDateDateEdit.EditValue);
currentFte.Active = (statusComboBoxEdit.SelectedIndex == 0) ? true : false;
currentFte.Email = emailTextEdit.Text;
currentFte.Code = codeTextEdit.Text;
currentFte.FingerPrint = fingerprintTextEdit.Text;
currentFte.DirectReport = Convert.ToInt64(directReportLookUpEdit.EditValue);
currentFte.Phone = phoneTextEdit.Text;
currentFte.Cisco = ciscoTextEdit.Text;
currentFte.PC = Convert.ToInt32(pcLookUpEdit.EditValue);
currentFte.Authority = Convert.ToString(authorityLookUpEdit.EditValue);
currentFte.Notes = notesMemoEdit.Text;
currentFte.PassKey = "12345";
if (photoPictureEdit.Image != Resources.images__1_)
{
currentFte.Photo = RedSea24.Classes.Logic.ImageToByteArray(photoPictureEdit.Image);
}
context.tblFTEs.Add(currentFte);
context.SaveChanges();
this.employeeId = currentFte.Id;
SaveLanguages();
SaveSkills();
SavePrograms();
this.employeeCollectionView.GetDataSource();
this.parent.ShowMessage("Saved", "New employee has been added successfully!");
}
}
private void CheckPrograms()
{
using (var context = new RedSeaEntities())
{
var query = context.tblLinkSystems
.Where(b => b.FTE == this.employeeId);
foreach (var record in query)
{
for (var i = 0; i < programsCheckedComboBoxEdit.Properties.Items.Count; i++)
{
if (programsCheckedComboBoxEdit.Properties.Items[i].Value.ToString() == record.cSystem.ToString())
{
programsCheckedComboBoxEdit.Properties.Items[i].CheckState = CheckState.Checked;
}
}
}
}
}
private void FillDirectReport()
{
using (var context = new RedSeaEntities())
{
var query =
from directReports in context.tblFTEs
select new
{
id = directReports.Id,
directReprt = directReports.FirstName + " " + directReports.LastName
};
DataTable dt = new DataTable();
dt.Columns.Add("Id");
dt.Columns.Add("DirectReport");
foreach (var record in query)
{
dt.Rows.Add(record.id, record.directReprt);
}
directReportLookUpEdit.Properties.DataSource = dt;
}
}
private void FillPcs()
{
using (var context = new RedSeaEntities())
{
var query =
from pcs in context.tblPCs
select new
{
Id = pcs.Id,
PCName = pcs.PCName
};
DataTable dt = new DataTable();
dt.Columns.Add("Id");
dt.Columns.Add("PCName");
foreach (var record in query)
{
dt.Rows.Add(record.Id, record.PCName);
}
pcLookUpEdit.Properties.DataSource = dt;
}
}
private void SavePrograms()
{
using (var context = new RedSeaEntities())
{
// delete old rows
var oldPrograms = context.tblLinkSystems
.Where(b => b.FTE == this.employeeId);
context.tblLinkSystems.RemoveRange(oldPrograms);
// add new rows
for (var i = 0; i < programsCheckedComboBoxEdit.Properties.Items.Count; i++)
{
if (programsCheckedComboBoxEdit.Properties.Items[i].CheckState == CheckState.Checked)
{
tblLinkSystem newProgram = new tblLinkSystem();
newProgram.FTE = this.employeeId;
newProgram.cSystem = Convert.ToInt32(programsCheckedComboBoxEdit.Properties.Items[i].Value);
context.tblLinkSystems.Add(newProgram);
}
}
context.SaveChanges();
}
}
private void SaveSkills()
{
using (var context = new RedSeaEntities())
{
// delete old rows
var oldSkills = context.tblLinkSkills
.Where(b => b.FTE == this.employeeId);
context.tblLinkSkills.RemoveRange(oldSkills);
// add new rows
for (var i = 0; i < skillsCheckedComboBoxEdit.Properties.Items.Count; i++)
{
if (skillsCheckedComboBoxEdit.Properties.Items[i].CheckState == CheckState.Checked)
{
tblLinkSkill newSkill = new tblLinkSkill();
newSkill.FTE = this.employeeId;
newSkill.Skill = Convert.ToInt32(skillsCheckedComboBoxEdit.Properties.Items[i].Value);
context.tblLinkSkills.Add(newSkill);
}
}
context.SaveChanges();
}
}
private void SaveLanguages()
{
using (var context = new RedSeaEntities())
{
// delete old rows
var oldLanguages = context.tblLinkLanguages
.Where(b => b.FTE == this.employeeId);
context.tblLinkLanguages.RemoveRange(oldLanguages);
// add new rows
for (var i = 0; i < languagesCheckedComboBoxEdit.Properties.Items.Count; i++)
{
if (languagesCheckedComboBoxEdit.Properties.Items[i].CheckState == CheckState.Checked)
{
tblLinkLanguage newLanguage = new tblLinkLanguage();
newLanguage.FTE = this.employeeId;
newLanguage.cLanguage = Convert.ToInt32(languagesCheckedComboBoxEdit.Properties.Items[i].Value);
context.tblLinkLanguages.Add(newLanguage);
}
}
context.SaveChanges();
}
}
