public static void AddWishForDayOff(WishForDayOff wishForDayOff)
{
if (!WishForDayOffExist(wishForDayOff))
{
wishForDayOffList.Add(wishForDayOff);
}
}
public static void LoadWishForDayOffs()
{
DateTime day;
int wishForDayOffID;
int employeeID;
DBConnection.DatabaseName = "CANE";
if (DBConnection.IsConnected())
{
string query = "select * from WishForDayOff";
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
wishForDayOffID = (int)reader["WishForDayOffID"];
employeeID = (int)reader["EmployeeID"];
day = (DateTime)reader["Date"];
WishForDayOff newWish = new WishForDayOff(wishForDayOffID, employeeID, day);
WishForDayOffRepository.AddWishForDayOff(newWish);
}
}
DBConnection.Close();
}
}
private void WishForDayOffBtn_Click(object sender, RoutedEventArgs e)
{
MessageBoxButton btn = MessageBoxButton.YesNo;
MessageBoxResult result = MessageBox.Show($"Er du sikker på at {WishForDayOffCB.SelectedItem.ToString()} vil ønske fri på datoen: {WishForDayOffDP.SelectedDate.ToString().Substring(0,10)}?", "ønsk fri", btn);
if (result == MessageBoxResult.Yes)
{
int employeeID = EmployeeRepository.GetEmployeeID(WishForDayOffCB.SelectedItem.ToString());
DateTime date = WishForDayOffDP.SelectedDate.Value;
WishForDayOff newWish = new WishForDayOff(employeeID, date);
DBWishForDayOffController.CreateWishForDayOff(newWish);
this.Close();
}
}
public static bool WishForDayOffExist(WishForDayOff wishForDayOff)
{
bool exist = false;
foreach (WishForDayOff wishForDayOff2 in wishForDayOffList)
{
if (wishForDayOff2.Date == wishForDayOff.Date && wishForDayOff2.EmployeeID == wishForDayOff.EmployeeID)
{
if (wishForDayOff2.WishForDayOffID != wishForDayOff.WishForDayOffID)
{
wishForDayOff2.WishForDayOffID = wishForDayOff.WishForDayOffID;
}
exist = true;
}
}
return(exist);
}
public static void CreateWishForDayOff(WishForDayOff wish)
{
string query = "Create_WishForDayOff";
DBConnection.DatabaseName = "CANE";
if (!WishForDayOffRepository.WishForDayOffExist(wish))
{
if (DBConnection.IsConnected())
{
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EmployeeID_IN", wish.EmployeeID));
cmd.Parameters.Add(new SqlParameter("@Date_IN", wish.Date));
cmd.ExecuteReader();
DBConnection.Close();
}
WishForDayOffRepository.AddWishForDayOff(wish);
}
}
