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