public static void LoadDutyExchanges()
{
int dutyExchangeID = 0;
int dutyID = 0;
int employeeID = 0;
DBConnection.DatabaseName = "CANE";
if (DBConnection.IsConnected())
{
string query = "SELECT * FROM DutyExchange";
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
dutyExchangeID = (int)reader["DutyExchangeID"];
dutyID = (int)reader["DutyID"];
employeeID = (int)reader["EmployeeID"];
DutyExchange newDutyExchange = new DutyExchange(dutyExchangeID, dutyID, employeeID);
DutyExchangeRepository.AddDutyExchange(newDutyExchange);
}
}
DBConnection.Close();
}
}
public static void AddDutyExchange(DutyExchange dutyExchange)
{
if (!DutyExchangeExist(dutyExchange))
{
dutyExchanges.Add(dutyExchange);
}
}
public static DutyExchange GetDutyExchange(int dutyID)
{
DutyExchange tempDutyExchange = null;
foreach (DutyExchange dutyExchange in dutyExchanges)
{
if (dutyExchange.DutyID == dutyID)
{
tempDutyExchange = dutyExchange;
}
}
return(tempDutyExchange);
}
public static bool DutyExchangeExist(DutyExchange dutyExchange)
{
bool exist = false;
foreach (DutyExchange dutyExchange2 in dutyExchanges)
{
if (dutyExchange2.DutyID == dutyExchange.DutyID && dutyExchange2.EmployeeID == dutyExchange.EmployeeID)
{
if (dutyExchange2.DutyExchangeID != dutyExchange.DutyExchangeID)
{
dutyExchange2.DutyExchangeID = dutyExchange.DutyExchangeID;
}
exist = true;
}
}
return(exist);
}
public static void CreateDutyExchange(DutyExchange dutyExchange)
{
DBConnection.DatabaseName = "CANE";
string query = "Create_DutyExchange";
if (!DutyExchangeRepository.DutyExchangeExist(dutyExchange))
{
if (DBConnection.IsConnected())
{
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DutyID_IN", dutyExchange.DutyID));
cmd.Parameters.Add(new SqlParameter("@EmployeeID_IN", dutyExchange.EmployeeID));
cmd.ExecuteReader();
}
DBConnection.Close();
}
DutyExchangeRepository.AddDutyExchange(dutyExchange);
}
private void DutyList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string date = null;
if (DutyList.SelectedItem != null)
{
date = DutyList.SelectedItem.ToString().Substring(0, 10);
string employeeName = EmployeeCB.SelectedValue.ToString();
MessageBoxButton btn = MessageBoxButton.YesNo;
MessageBoxImage image = MessageBoxImage.Exclamation;
MessageBoxResult result = MessageBox.Show("Er du sikker på at du vil bytte denne vagt.", "Vagt bytte", btn, image);
if (result == MessageBoxResult.Yes)
{
DutyExchange dutyExchange = new DutyExchange(DutyRepository.GetDuty(date, employeeName).DutyID, EmployeeRepository.GetEmployeeID(employeeName));
DBDutyExchangeController.CreateDutyExchange(dutyExchange);
UpdateDutyList2();
UpdateDutyList();
}
}
}
private void DutyListView_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DutyListView.SelectedIndex != -1)
{
DutyListView dutyListView = (DutyListView)DutyListView.SelectedItem;
MessageBoxButton btn = MessageBoxButton.YesNo;
MessageBoxImage image = MessageBoxImage.Exclamation;
MessageBoxResult result = MessageBox.Show("Er du sikker på at du vil bytte denne vagt.", "Vagt bytte", btn, image);
if (result == MessageBoxResult.Yes)
{
DutyExchange dutyExchange = new DutyExchange(dutyListView.Duty.DutyID, dutyListView.Duty.EmployeeID);
DBDutyExchangeController.CreateDutyExchange(dutyExchange);
UpdateDutyExchangeList();
UpdateDutyList();
}
else if (result == MessageBoxResult.No)
{
DutyListView.SelectedIndex = -1;
}
}
}
