public ProbehlyTwoCols(KonkretniKrouzek passed)
{
this.InitializeComponent();
this.passed_ = passed;
string cityName = this.passed_.krouzek.skola.adresa.mesto;
if (cityName.Contains('-'))
{
cityName = cityName.Substring(0, cityName.IndexOf('-'));
}
if (cityName.Contains(' '))
{
cityName = cityName.Substring(0, cityName.IndexOf(' '));
}
this.leftLabel.Text = cityName;
this.rightLabel.Text = passed.krouzek.casKonaniOd.ToString("HH:mm");
if (this.passed_.zrusen)
{
this.BackColor = zrusenyColor_;
this.leftLabel.BackColor = zrusenyColor_;
this.rightLabel.BackColor = zrusenyColor_;
}
else
{
this.BackColor = probehlyColor_;
this.leftLabel.BackColor = probehlyColor_;
this.rightLabel.BackColor = probehlyColor_;
}
}
public Tuple <Collection <KonkretniKrouzekPrototype>, Collection <KonkretniKrouzek> > getPlannedAndPassed(
DateTime datumOd, DateTime datumDo, DateTime aktualniDatum)
{
/*
* PROCEDURE PROJEKT.PROC_6_5_ZOBRAZENI_KROUZKU(@P_DATUMOD DATE,
* @P_DATUMDO DATE,
* @P_AKTUALNIDATUM DATE)
*/
Collection <KonkretniKrouzekPrototype> naplanovaneKrouzky = new Collection <KonkretniKrouzekPrototype>();
Collection <KonkretniKrouzek> probehleKrouzky = new Collection <KonkretniKrouzek>();
Tuple <Collection <KonkretniKrouzekPrototype>, Collection <KonkretniKrouzek> > krouzkyTuple =
new Tuple <Collection <KonkretniKrouzekPrototype>, Collection <KonkretniKrouzek> >(naplanovaneKrouzky,
probehleKrouzky);
Console.WriteLine("Funkce 6.5. Zobrazeni naplanovanych a probehlych krouzku.");
Console.WriteLine("\tOd:{0}", datumOd);
Console.WriteLine("\tDo:{0}", datumDo);
Console.WriteLine("\tAktualniDatum:{0}", aktualniDatum);
Database.Database db = this.dao.db;
// 1. create a command object identifying the stored procedure
SqlCommand command = db.CreateCommand("PROJEKT.PROC_6_5_ZOBRAZENI_KROUZKU");
// 2. set the command object so it knows to execute a stored procedure
command.CommandType = CommandType.StoredProcedure;
//3. create input parameters
SqlParameter dbInputObdobiOd = new SqlParameter();
dbInputObdobiOd.ParameterName = "@P_DATUMOD";
dbInputObdobiOd.DbType = DbType.Date;
dbInputObdobiOd.Value = datumOd;
dbInputObdobiOd.Direction = ParameterDirection.Input;
command.Parameters.Add(dbInputObdobiOd);
SqlParameter dbInputObdobiDo = new SqlParameter();
dbInputObdobiDo.ParameterName = "@P_DATUMDO";
dbInputObdobiDo.DbType = DbType.Date;
dbInputObdobiDo.Value = datumDo;
dbInputObdobiDo.Direction = ParameterDirection.Input;
command.Parameters.Add(dbInputObdobiDo);
SqlParameter dbInputAktualniDatum = new SqlParameter();
dbInputAktualniDatum.ParameterName = "@P_AKTUALNIDATUM";
dbInputAktualniDatum.DbType = DbType.Date;
dbInputAktualniDatum.Value = aktualniDatum;
dbInputAktualniDatum.Direction = ParameterDirection.Input;
command.Parameters.Add(dbInputAktualniDatum);
int ret = db.ExecuteNonQuery(command);
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine("Datum: {0} ID: {1} Konkretni ID: {2} Probehly: {3}", rdr["ID"],
rdr["IDKONKRETNIKROUZEK"], rdr["DATUM"], rdr["PROBEHLY"]);
bool probehly = (bool)rdr["PROBEHLY"];
if (probehly)
{
KonkretniKrouzek k = null;
int idKonkretniKrouzek = (int)rdr["IDKONKRETNIKROUZEK"];
//if (!KonkretniKrouzek.instances.ContainsKey(idKonkretniKrouzek))
this.dao.konkretniKrouzekTable.SelectOne(idKonkretniKrouzek, "@idKonkretniKrouzek", out k, db);
//else
//k = KonkretniKrouzek.instances[idKonkretniKrouzek];
if (k != null)
{
krouzkyTuple.Item2.Add(k);
}
}
else
{
int id = (int)rdr["ID"];
DateTime datum = (DateTime)rdr["DATUM"];
krouzkyTuple.Item1.Add(new KonkretniKrouzekPrototype(id, datum));
}
}
return(krouzkyTuple);
}
