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