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();
}
}
private void Confirm_Click(object sender, RoutedEventArgs e)
{
int newEmployeeID = EmployeeRepository.GetEmployeeID(EmployeeCB.SelectedValue.ToString());
int oldEmployeeID = EmployeeRepository.GetEmployeeID(DutyLabel.Content.ToString().Substring(16));
int dutyID = DutyRepository.GetDuty(DutyLabel.Content.ToString().Substring(0, 10), DutyLabel.Content.ToString().Substring(16)).DutyID;
DBDutyController.UpdateDuty(newEmployeeID, DutyID);
DBDutyExchangeController.DeleteDutyExchange(dutyID, oldEmployeeID);
DutyExchangeRepository.RemoveDutyExchange(dutyID, oldEmployeeID);
ExchangeDutyWindow.Close();
this.Close();
}
public void UpdateDutyExchangeList()
{
List <DutyExchange> dutyExchanges = DutyExchangeRepository.GetDutyExchanges();
List <DutyListView> dutyExchangeListViews = new List <DutyListView>();
foreach (DutyExchange dutyExchange in dutyExchanges)
{
dutyExchangeListViews.Add(new DutyListView
{
Duty = DutyRepository.GetDuty(dutyExchange.DutyID),
EmployeeName = EmployeeRepository.GetEmployeeName(dutyExchange.EmployeeID)
});
}
DutyExchangeListView.ItemsSource = dutyExchangeListViews;
DutyExchangeListView.SelectedIndex = -1;
}
private void Confirm_Click(object sender, RoutedEventArgs e)
{
int newEmployeeID = EmployeeRepository.GetEmployeeID(EmployeeCB.SelectedValue.ToString());
int oldEmployeeID = EmployeeRepository.GetEmployeeID(EmployeeRepository.GetEmployeeName(DutyExchangeListView.Duty.EmployeeID));
try
{
DBDutyController.UpdateDuty(newEmployeeID, DutyExchangeListView.Duty.DutyID);
}
catch (Exception t)
{
MessageBox.Show(t.Message);
}
DBDutyExchangeController.DeleteDutyExchange(DutyExchangeListView.Duty.DutyID);
DutyExchangeRepository.RemoveDutyExchange(DutyExchangeListView.Duty.DutyID);
this.Close();
}
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);
}
public void UpdateDutyList2()
{
List <DutyExchange> dutyExchanges = DutyExchangeRepository.GetDutyExchanges();
List <string> newDutyExchanges = new List <string>();
if (dutyExchanges.Count > 0)
{
foreach (DutyExchange dutyExchange in dutyExchanges)
{
string newDutyExchange = DateRepository.GetDate(DutyRepository.GetDuty(dutyExchange.DutyID).DateID).Date.ToString().Substring(0, 10) + " <--> " + EmployeeRepository.GetEmployee(dutyExchange.EmployeeID).FirstName;
newDutyExchanges.Add(newDutyExchange);
}
DutyList2.ItemsSource = newDutyExchanges;
}
else
{
DutyList2.ItemsSource = null;
}
}
