public Employee(string firstName, string lastName, Gender gender, int age
, decimal salary, TypeOfEmployee typeOfEmployee, string emailAddress)
{
FirstName = firstName;
LastName = lastName;
Gender = gender;
SetAge(age);
Salary = salary;
TypeOfEmployee = typeOfEmployee;
SetEmailAddress(emailAddress);
}
public void Raise(string Name, TypeOfEmployee EmployeeType = TypeOfEmployee.Hourly)
{
for (int EmployeeIndex = 0; EmployeeIndex < CompanyEmployeesList.Count; EmployeeIndex++)
{
if (CompanyEmployeesList[EmployeeIndex].EmployeeType == EmployeeType && CompanyEmployeesList[EmployeeIndex].Name == Name)
{
CompanyEmployeesList[EmployeeIndex] = CompanyEmployeesList[EmployeeIndex].Raise();
return;
}
}
Console.WriteLine("No Employee was found matching those characteristics");
}
public void Fire(string Name, TypeOfEmployee EmployeeType = TypeOfEmployee.Hourly)
{
foreach (Employee WorkingEmployee in CompanyEmployeesList)
{
if (WorkingEmployee.EmployeeType == EmployeeType && WorkingEmployee.Name == Name)
{
Console.WriteLine($"{Name}, who was a {EmployeeType}, got fired");
CompanyEmployeesList.Remove(WorkingEmployee);
return;
}
}
Console.WriteLine("No Employee was found matching those characteristics");
}
internal Manager(string EmployeeName, double MonthlyIncome, double RaiseOfManager = 1.1, TypeOfEmployee NewEmployeeType = TypeOfEmployee.Manager)
: base(EmployeeName, MonthlyIncome * RaiseOfManager, NewEmployeeType)
{
}
internal SalariedEmployee(string EmployeeName, double MonthlyIncome, TypeOfEmployee NewEmployeeType = TypeOfEmployee.Salaried)
: base(EmployeeName, MonthlyIncome, NewEmployeeType)
{
}
private void CreatePosition()
{
Positions = new ObservableCollection <TypeOfEmployee>();
DataTable dTable = new DataTable();
String sqlQuery;
SQLiteFactory factory = (SQLiteFactory)System.Data.Common.DbProviderFactories.GetFactory("System.Data.SQLite");
using (SQLiteConnection connection = (SQLiteConnection)factory.CreateConnection())
{
connection.ConnectionString = "Data Source = " + dbFileName;
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(connection))
{
if (connection.State != ConnectionState.Open)
{
MessageBox.Show("Open connection with database");
return;
}
try
{
sqlQuery = "SELECT * FROM TypeOfEmployee";
SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlQuery, connection);
adapter.Fill(dTable);
if (dTable.Rows.Count > 0)
{
for (int i = 0; i < dTable.Rows.Count; i++)
{
var row = dTable.Rows[i].ItemArray;
var te = new TypeOfEmployee
{
TypeOfEmployeeId = Convert.ToInt32(row[0]),
NameOfEmployee = Convert.ToString(row[1]),
SalaryParameters = SalaryParameters.Where(sp => sp.SalaryParametersId == Convert.ToInt32(row[2])).FirstOrDefault()
};
Positions.Add(te);
}
}
else
{
MessageBox.Show("Database is empty");
}
}
catch (SQLiteException ex)
{
MessageBox.Show("Error: " + ex.Message);
}
}
}
//Positions.Add(new TypeOfEmployee { TypeOfEmployeeId = 2, NameOfEmployee = "Менеджер" });
//Positions.Add(new TypeOfEmployee { TypeOfEmployeeId = 1, NameOfEmployee = "Работник" });
//Positions.Add(new TypeOfEmployee { TypeOfEmployeeId = 3, NameOfEmployee = "Продавец" });
/* Выборка данных
* string sql = "SELECT Id, Name FROM Table1";
* command = new SQLiteCommand(sql, conn);
* SQLiteDataReader reader = command.ExecuteReader();
* while (reader.Read())
* MessageBox.Show("Id: " + reader["Id"] + " Name: " + reader["Name"]);
*/
}
