//Insert the gender into the db, and generate a new Id for it. public int Insert() { try { using (MusicEntities dc = new MusicEntities()) { //Create a new Id this.Id = Guid.NewGuid(); //Set the properties tblGender gender = new tblGender { Id = this.Id, Description = this.Description }; //Add it to the table and save changes dc.tblGenders.Add(gender); return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public EditWorkerViewModel(EditWorker editWorkerOpen, vwWorker workerEdit) { _editWorker = editWorkerOpen; _worker = workerEdit; _location = new vwLocation(); _gender = new tblGender(); _sector = new tblSector(); _manager = new vwManager(); LocationList = _dbService.GetAllLocations(); WorkerList = _dbService.GetAllWorkerRecords(); GenderList = _dbService.GetAllGenders(); SectorList = _dbService.GetAllSectors(); ManagerList = new List <vwManager>(); foreach (var item in _dbService.GetAllManagers()) { if (item.WorkerID != _worker.WorkerID) { ManagerList.Add(item); } } FirstNameBeforeEdit = _worker.FirstName; LastNameBeforeEdit = _worker.LastName; JMBGBeforeEdit = _worker.JMBG; actionEventObject = new ActionEvent(); actionEventObject.ActionPerformed += ActionPerformed; }
public IHttpActionResult PuttblGender(decimal id, tblGender tblGender) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblGender.typeCode) { return(BadRequest()); } db.Entry(tblGender).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblGenderExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IActionResult> Edit(int id, [Bind("GenderId,Name")] tblGender tblGender) { if (id != tblGender.GenderId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblGender); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tblGenderExists(tblGender.GenderId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(tblGender)); }
public IHttpActionResult PosttblGender(tblGender tblGender) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblGender.Add(tblGender); try { db.SaveChanges(); } catch (DbUpdateException) { if (tblGenderExists(tblGender.typeCode)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = tblGender.typeCode }, tblGender)); }
public AddEmployeViewModel(AddEmploye addEmployeOpen) { addEmploye = addEmployeOpen; LocationList = GetLocations(); GenderList = GetGenders(); Location = new tblLOCATION(); Gender = new tblGender(); Employe = new tblEmploye(); Sector = new tblSector(); }
public async Task <IActionResult> Create([Bind("GenderId,Name")] tblGender tblGender) { if (ModelState.IsValid) { _context.Add(tblGender); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tblGender)); }
public IHttpActionResult GettblGender(decimal id) { tblGender tblGender = db.tblGender.Find(id); if (tblGender == null) { return(NotFound()); } return(Ok(tblGender)); }
public IHttpActionResult PosttblGender(tblGender tblGender) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblGenders.Add(tblGender); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tblGender.Id }, tblGender)); }
public IHttpActionResult DeletetblGender(decimal id) { tblGender tblGender = db.tblGender.Find(id); if (tblGender == null) { return(NotFound()); } db.tblGender.Remove(tblGender); db.SaveChanges(); return(Ok(tblGender)); }
public OwnerViewModel(Owner openOwner) { owner = openOwner; newEmployee = new tblUser(); newManager = new tblManager(); newStaff = new tblStaff(); qualification = new tblProfessionalQualification(); engagement = new tblEngagement(); gender = new tblGender(); engagementList = Service.Service.GetEngagementList(); qualificationList = Service.Service.GetQualificationList(); genderList = Service.Service.GetGenderList(); }
public RegistrationAdministratorViewModel(RegistrationAdministrator reg) { registrationAdministrator = reg; newUser = new tblUser(); newAdministrator = new tblAdministrator(); //gender genderList = Service.Service.GetGenderList(); selectedGender = new tblGender(); //marriage maritalList = Service.Service.GetMaritalStatusList(); selectedMarital = new tblMarriageStatu(); //type selectedType = new tblAdminType(); typeList = Service.Service.GetTypeAdminList(); }
public bool Delete(GenderEntity gender) { try { TIMSDBEntities entity = new TIMSDBEntities(); tblGender Gender = entity.tblGenders.Where(x => x.ID == gender.ID).FirstOrDefault(); entity.tblGenders.Remove(Gender); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public GenderEntity GetSingle(int ID) { try { TIMSDBEntities entity = new TIMSDBEntities(); tblGender Gender = entity.tblGenders.Where(x => x.ID == ID).FirstOrDefault(); GenderEntity gender = new GenderEntity(); gender.ID = Gender.ID; gender.Title = Gender.Title; return(gender); } catch (Exception ex) { return(null); } }
//Retrieve the gender from the database with this Id public void LoadById() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve from the db tblGender gender = dc.tblGenders.FirstOrDefault(g => g.Id == this.Id); //Set this gender's properties this.Description = gender.Description; } } catch (Exception ex) { throw ex; } }
public bool Save(GenderEntity gender) { try { tblGender Gender = new tblGender(); Gender.ID = gender.ID; Gender.Title = gender.Title; TIMSDBEntities entity = new TIMSDBEntities(); entity.tblGenders.Add(Gender); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public bool Update(GenderEntity gender) { try { tblGender newGender = new tblGender(); newGender.ID = gender.ID; newGender.Title = gender.Title; TIMSDBEntities entity = new TIMSDBEntities(); tblGender oldGender = entity.tblGenders.Where(x => x.ID == gender.ID).FirstOrDefault(); entity.Entry(oldGender).CurrentValues.SetValues(newGender); entity.SaveChanges(); return(true); } catch (Exception) { throw; } }
public tblGender GetGenderByName(string gender) { try { using (EmployeeDBEntities context = new EmployeeDBEntities()) { tblGender genderFromDB = (from g in context.tblGenders where g.Gender.Equals(gender) select g).First(); return(genderFromDB); //FileLoging fileLog = FileLoging.Instance(); //fileLog.LogDeleteUserToFile(userToDelete); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public int Update() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve the record from the DB tblGender gender = dc.tblGenders.FirstOrDefault(g => g.Id == this.Id); //Update the properties gender.Description = this.Description; //Save the changes return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public int Delete() { try { using (MusicEntities dc = new MusicEntities()) { //Retrieve it from the DB tblGender gender = dc.tblGenders.FirstOrDefault(g => g.Id == this.Id); //Remove the gender dc.tblGenders.Remove(gender); //Save the changes return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public RegistrationViewModel(Registration open) { registration = open; newUser = new tblUser(); newManager = new tblManager(); newEmployee = new tblEmployee(); //gender selectedGender = new tblGender(); genderList = Service.Service.GetGenderList(); //sector selectedSector = new tblSector(); sectorList = Service.Service.GetSectorList(); //marital status selectedMarital = new tblMarriageStatu(); maritalList = Service.Service.GetMaritalStatusList(); //position selectedPosition = new tblPosition(); positionList = Service.Service.GetPositionList(); //qualification selectedQualification = new tblProfessionalQualification(); qualificationList = Service.Service.GetQualificationList(); }
private void SaveExecute() { try { if (!ValidationClass.JMBGisValid(employee.JMBG)) { MessageBox.Show("JMBG is not valid."); return; } if (!ValidationClass.JMBGIsUniqueForEditWindow(employee.JMBG, employee)) { MessageBox.Show("JMBG already exists in database"); return; } if (!ValidationClass.RegisterNumberIsValid(employee.RegistrationNumber)) { MessageBox.Show("Registration number is not valid"); return; } if (!ValidationClass.RegNumberIsUniqueForEdit(employee.RegistrationNumber, employee)) { MessageBox.Show("Registration number already exists in database"); return; } if (!ValidationClass.TelfonNumberValid(employee.TelefonNumber)) { MessageBox.Show("Telefon number is not valid. It must have 9 numbers"); return; } employee.LocationID = SelctedLocation.LocationID; employee.DateOfBirth = StartDate; if (String.IsNullOrEmpty(selectedMenager.Menager)) { vwMenager menagerDB = employeeService.GetMenagerByName(" "); employee.MenagerID = menagerDB.EmployeeID; } else { employee.MenagerID = selectedMenager.EmployeeID; } string genderForDB; if (Gender.Equals("male")) { genderForDB = "M"; } else if (Gender.Equals("female")) { genderForDB = "F"; } else { genderForDB = "O"; } tblGender gender = genderService.GetGenderByName(genderForDB); tblSector sectorDB = sectorService.GetSectorByName(Sector); if (sectorDB == null) { sectorDB = new tblSector(); sectorDB.SectorName = Sector; sectorDB = sectorService.AddSector(sectorDB); employee.SectorID = sectorDB.SectorID; } else { employee.SectorID = sectorDB.SectorID; } employee.GenderID = gender.GenderID; isUpdateUser = true; string textForFile = String.Format("Updated user {0} {1} JMBG {2} to {3} {4} JMBG {5}", oldEmployee.FirstName, oldEmployee.LastName, oldEmployee.JMBG, employee.FirstName, employee.LastName, employee.JMBG); eventObject.OnActionPerformed(textForFile); employeeService.EditEmployee(employee); editEmployee.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }