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"]); */ }