public AgendaController()
{
DateRepository = new DateRepository();
HolidayRepository = new HolidayRepository();
TimeSlotRepository = new TimeSlotRepository();
ContactRepository = new ContactRepository();
}
public RendezVousController()
{
SlotRepository = new TimeSlotRepository();
ContactRepository = new Repository<Contact>();
DateRepository = new DateRepository();
HolidayRepository = new HolidayRepository();
}
public static void LoadDates()
{
DBConnection.DatabaseName = "CANE";
if (DBConnection.IsConnected())
{
string query = "SELECT * FROM Date";
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int dateID = (int)reader["DateID"];
int rosterID = (int)reader["RosterID"];
DateTime day = (DateTime)reader["Day"];
string shopDB = reader["Shop"].ToString();
Shop newShop;
if (shopDB == "kongensgade")
{
newShop = Shop.kongensgade;
}
else
{
newShop = Shop.skibhusvej;
}
Date date = new Date(day, dateID, rosterID, newShop);
DateRepository.AddDate(date);
}
}
DBConnection.Close();
}
}
public static void CreateDates(Roster roster)
{
DBConnection.DatabaseName = "CANE";
string query = "Create_Dates";
int daysDiff = ((TimeSpan)(roster.EndDate.Date - roster.StartDate.Date)).Days;
Shop newShop;
if (roster.Shop.ToString().ToLower() == "kongensgade")
{
newShop = Shop.kongensgade;
}
else
{
newShop = Shop.skibhusvej;
}
for (int i = 0; i <= daysDiff; i++)
{
Date date = new Date(roster.StartDate.AddDays(i), roster.RosterID, newShop);
if (!DateRepository.DateExist(date))
{
if (DBConnection.IsConnected())
{
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@RosterID_IN", roster.RosterID));
cmd.Parameters.Add(new SqlParameter("@Shop_IN", roster.Shop.ToString()));
cmd.Parameters.Add(new SqlParameter("@Day_IN", roster.StartDate.AddDays(i)));
cmd.ExecuteReader();
}
DBConnection.Close();
DateRepository.AddDate(date);
}
}
}
public DateRepositoryTest()
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.development.json", optional: false, reloadOnChange: false);
IConfigurationRoot configuration = builder.Build();
var testTaskOpsBuilder = new DbContextOptionsBuilder <TestTaskContext>();
_testTaskCtx = new TestTaskContext(testTaskOpsBuilder.UseSqlServer(configuration["ConnectionStrings:TestTaskContext"]).Options);
_dateRep = new DateRepository(_testTaskCtx);
}
public GeneratorReport(string pagePath)
{
_pageUrl = pagePath;
RaportName = $"{DateTime.Now.Year}{DateTime.Now.Month}{DateTime.Now.Day}.csv";
_ms = new MemoryStream();
_sw = new StreamWriter(_ms, Encoding.UTF8);
_sw.WriteLine($"\"LINK\";\"NAZWA\";\"DATA SPRAWDZENIA\";\"CENA\";\"DATA SPRAWDZENIE\";\"CENA\";\"PROCENT ZMIANY\"");
_dateRepository = new DateRepository();
_productRepository = new ProductRepository();
}
public UnitOfWork(AppDbContext context)
{
Users = new UserRepository(context);
Airports = new AirportRepository(context);
Airlines = new AirlineRepository(context);
Luggages = new LuggageRepository(context);
Customers = new CustomerRepository(context);
Orders = new OrderRepository(context);
Flights = new FlightRepository(context);
Dates = new DateRepository(context);
DateFlights = new DateFlightRepository(context);
TicketCategories = new TicketCategoryRepository(context);
FlightTicketCategories = new FlightTicketCategoryRepository(context);
Tickets = new TicketRepository(context);
_context = context;
}
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 HolidayController()
{
HolidayRepository = new Repository<Holiday>();
DateRepository = new DateRepository();
}
