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