public static void LoadDuties()
{
int employeeID;
DateTime startTime;
DateTime endTime;
int dateID;
int dutyID;
DBConnection.DatabaseName = "CANE";
if (DBConnection.IsConnected())
{
string query = "SELECT * FROM Duty";
SqlCommand cmd = new SqlCommand(query, DBConnection.Connection);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
employeeID = (int)reader["EmployeeID"];
dateID = (int)reader["DateID"];
dutyID = (int)reader["DutyID"];
startTime = (DateTime)reader["StartTime"];
endTime = (DateTime)reader["EndTime"];
Duty duty = new Duty(dutyID, employeeID, dateID, startTime, endTime);
DutyRepository.AddDuty(duty);
}
}
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();
}
private void DutyList2_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DutyList2.SelectedIndex != -1)
{
string date = DutyList2.SelectedItem.ToString().Substring(0, 10);
string firstName = DutyList2.SelectedValue.ToString().Substring(16);
string dutyList2selected = DutyList2.SelectedValue.ToString();
Duty duty = DutyRepository.GetDuty(date, firstName);
PopupExchangeDutyWindow popupExchangeDutyWindow = new PopupExchangeDutyWindow(EmployeesProp, dutyList2selected, duty.DutyID, this);
popupExchangeDutyWindow.Show();
}
}
public static void DeleteDuties_EmpID(int employeeID)
{
string query = "Delete_Duties_EmpID";
DBConnection.DatabaseName = "CANE";
if (DBConnection.IsConnected())
{
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EmployeeID_IN", employeeID));
cmd.ExecuteReader();
DBConnection.Close();
}
DutyRepository.Removeduties_EmpID(employeeID);
}
public static void UpdateDuty(int newEmployeeID, int dutyID)
{
DBConnection.DatabaseName = "CANE";
string query = "Update_Duty";
if (DBConnection.IsConnected())
{
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DutyID_IN", dutyID));
cmd.Parameters.Add(new SqlParameter("@EmployeeID_IN", newEmployeeID));
cmd.ExecuteReader();
}
DBConnection.Close();
DutyRepository.UpdateDuty(newEmployeeID, dutyID);
}
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;
}
public ShowMyDutiesWindow(int employeeID)
{
InitializeComponent();
Employee = EmployeeRepository.GetEmployee(employeeID);
List <Duty> duties = DutyRepository.GetDuties(Employee.FirstName);
List <DutyListView> dutyListViews = new List <DutyListView>();
foreach (Duty duty in duties)
{
dutyListViews.Add(new DutyListView
{
Duty = duty,
EmployeeName = EmployeeRepository.GetEmployeeName(duty.EmployeeID)
});
}
DutyListView.ItemsSource = dutyListViews;
this.Closing += WindowClosed;
}
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;
}
}
public void UpdateDutyList()
{
List <Duty> duties = DutyRepository.GetDuties(EmployeeCB.SelectedItem.ToString());
List <string> dutiesS = new List <string>();
if (duties.Count > 0)
{
foreach (Duty duty in duties)
{
string dutyS = DateRepository.GetDate(DutyRepository.GetDuty(duty.DutyID).DateID).Date.ToString().Substring(0, 10) + " <--> " + EmployeeRepository.GetEmployee(duty.EmployeeID).FirstName;
dutiesS.Add(dutyS);
}
DutyList.ItemsSource = dutiesS;
}
else
{
DutyList.ItemsSource = null;
}
}
public void UpdateDutyList()
{
List <Duty> duties = DutyRepository.GetDuties(EmployeeCB.SelectedItem.ToString());
List <DutyListView> dutyListViews = new List <DutyListView>();
foreach (Duty duty in duties)
{
int dateCompare = DateTime.Compare(duty.StartTime, DateTime.Now);
if (dateCompare > 0)
{
dutyListViews.Add(new DutyListView
{
Duty = duty,
EmployeeName = EmployeeRepository.GetEmployeeName(duty.EmployeeID)
});
}
}
DutyListView.ItemsSource = dutyListViews;
DutyListView.SelectedIndex = -1;
}
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();
}
}
}
public static void CreateDuty(Duty duty)
{
string query = "Create_Duty";
DBConnection.DatabaseName = "CANE";
if (!DutyRepository.DutyExist(duty))
{
if (DBConnection.IsConnected())
{
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EmployeeID_IN", duty.EmployeeID));
cmd.Parameters.Add(new SqlParameter("@DateID_IN", duty.DateID));
cmd.Parameters.Add(new SqlParameter("@StartTime_IN", duty.StartTime));
cmd.Parameters.Add(new SqlParameter("@EndTime_IN", duty.EndTime));
cmd.ExecuteReader();
DBConnection.Close();
}
DutyRepository.AddDuty(duty);
}
}
