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); } }