/// <summary>
/// method for saving data to the database
/// </summary>
private void SaveExecute()
{
try
{
using (CompanyDBEntities context = new CompanyDBEntities())
{
tblPosition newPosition = new tblPosition();
newPosition.PositionName = position.PositionName;
newPosition.PositionDescription = position.PositionDescription;
newPosition.PositionID = position.PositionID;
// saving data
context.tblPositions.Add(newPosition);
context.SaveChanges();
MessageBox.Show("The position created successfully.");
// logging the action
FileActions.FileActions.Instance.Adding(FileActions.FileActions.path, FileActions.FileActions.actions, "position", newPosition.PositionName);
}
addPosition.Close();
}
catch (Exception)
{
MessageBox.Show("Wrong inputs. Please try again.");
}
}
public AddPositionViewModel(AddPosition addPosition)
{
view = addPosition;
positionService = new PositionService();
Position = new tblPosition();
}
public PositionsForManagerViewModel(PositionsForManager positions)
{
view = positions;
positionService = new PositionService();
Position = new tblPosition();
PositionList = positionService.GetPositions();
}
public tblPosition Addpos(int depid, int joblevel, string position, decimal basicpay, decimal Incometax, string exp)
{
var pos = new tblPosition()
{
DepartmentId = depid,
JobLevel = joblevel,
Position = position,
BasicPay = basicpay,
IncomeTax = Incometax,
Experience = exp + " Years",
};
return(pos);
}
public tblPosition GetPositionByName(string positionName)
{
try
{
using (MyCompanyDBEntities context = new MyCompanyDBEntities())
{
tblPosition user = (from x in context.tblPositions
where x.PositionName.Equals(positionName)
select x).First();
return(user);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public void DeletePosition(int positionId)
{
try
{
using (MyCompanyDBEntities context = new MyCompanyDBEntities())
{
tblPosition positionToDelete = (from u in context.tblPositions
where u.PositionID == positionId
select u).First();
context.tblPositions.Remove(positionToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public tblPosition AddPosition(tblPosition position)
{
try
{
using (MyCompanyDBEntities context = new MyCompanyDBEntities())
{
tblPosition newPositon = new tblPosition();
newPositon.PositionName = position.PositionName;
newPositon.PositionDescription = position.PositionDescription;
context.tblPositions.Add(newPositon);
context.SaveChanges();
return(newPositon);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
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(object parameter)
{
try
{
tblPosition positionInDb = positionService.GetPositionByName(Position.PositionName);
if (positionInDb != null)
{
string str1 = string.Format("Position with this name exists\n" +
"Enter another position name");
MessageBox.Show(str1);
return;
}
positionService.AddPosition(Position);
string str = string.Format("You added new position");
MessageBox.Show(str);
view.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// Adds new account to tblAccount and adds an employee with the acount AccountID to database.
/// </summary>
/// <param name="account"></param>
/// <param name="sector"></param>
/// <param name="position"></param>
/// <param name="experience"></param>
/// <param name="qualification"></param>
internal void AddEmployee(tblEmployee employee, tblAccount account, tblSector sector, tblPosition position, int experience)
{
int id = RandomManager();
if (id != 0)
{
using (CompanyEntities context = new CompanyEntities())
{
tblAccount newAccount = new tblAccount();
newAccount.FirstName = account.FirstName;
newAccount.LastName = account.LastName;
newAccount.JMBG = account.JMBG;
newAccount.Gender = account.Gender.ToUpper();
newAccount.City = account.City;
newAccount.MarrigeStatusID = account.MarrigeStatusID;
newAccount.UserName = account.UserName;
newAccount.Pass = account.Pass;
context.tblAccounts.Add(newAccount);
context.SaveChanges();
tblEmployee newEmployee = new tblEmployee();
newEmployee.AccountID = newAccount.AccountID;
newEmployee.ManagerID = id;
newEmployee.SectorID = sector.SectorID;
newEmployee.PositionID = position.PositionID;
newEmployee.EmploymentDate = DateTime.Now.AddYears(-experience);
newEmployee.QualificationsLevel = employee.QualificationsLevel;
context.tblEmployees.Add(newEmployee);
context.SaveChanges();
MessageBox.Show("Employee saved.");
}
}
else
{
MessageBox.Show("You can not register any employees until there is no registered managers first.");
}
}
public AddPositionViewModel(AddPosition open)
{
addPosition = open;
position = new tblPosition();
}
public void Add(tblPosition obj)
{
context.tblPositions.Add(obj);
}