/// <summary>
/// Delete the record.
/// </summary>
/// <param name="idJezdci">jezdec id</param>
/// <returns></returns>
public static int Delete(Jezdec j, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_DELETE_ID);
command.Parameters.AddWithValue("@id", j.cislo_licence);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
/// <summary>
/// Update the record.
/// </summary>
public static int Update(Jezdec jezdec, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, jezdec);
int ret = db.ExecuteNonQuery(command);
if (pDb == null)
{
db.Close();
}
return(ret);
}
/// <summary>
/// Insert the record.
/// </summary>
public static Jezdec Insert(Jezdec jezdec, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
if (SelectOsoba(jezdec.oid, db) == null)
{
SqlCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, jezdec);
db.ExecuteNonQuery(command);
}
jezdec = SelectOsoba(jezdec.oid, db);
if (pDb == null)
{
db.Close();
}
return(jezdec);
}
public static Jezdec SelectOsoba(int oid, Database pDb = null)
{
Database db;
if (pDb == null)
{
db = new Database();
db.Connect();
}
else
{
db = (Database)pDb;
}
SqlCommand command = db.CreateCommand(SQL_SELECT_O);
command.Parameters.AddWithValue("@oid", oid);
SqlDataReader reader = db.Select(command);
Collection <Jezdec> Jezdci = Read(reader);
Jezdec jezdec = null;
if (Jezdci.Count == 1)
{
jezdec = Jezdci[0];
}
reader.Close();
if (pDb == null)
{
db.Close();
}
return(jezdec);
}
public JezdecFormModel(Jezdec jezdec)
{
this.jezdec = jezdec;
this.osoba = OsobaTable.Select(jezdec.oid);
adresa = AdresaTable.getInstance().getByID(osoba.adresa);
zavody = ZavodyTable.SelectFuture(DateTime.Now);
vysledky = VysledekJezdce.GetVysledkyJezdce(jezdec.cislo_licence);
if (jezdec.licence.HasValue && !jezdec.licence.Value)
{
return;
}
kone = KunTable.Select().ToList();
kone = kone.Where(k => k.licence.HasValue && k.licence.Value).ToList();
}
private void button1_Click(object sender, EventArgs e)
{
int id;
if (int.TryParse(textID.Text, out id))
{
Staj staj = StajTable.Select(id);
if (staj.heslo == textHeslo.Text)
{
StajPrihlasen form = new StajPrihlasen(this, staj);
form.Show();
this.Hide();
}
else
{
errorProvider.SetError(textHeslo, "Špatné ID nebo heslo.");
}
}
else if (textID.Text.Equals("Admin") && textHeslo.Text.Equals("AdminHeslo"))
{
AdminForm form = new AdminForm(this);
form.Show();
this.Hide();
}
else
{
Jezdec jezdec = JezdecTable.Select(textID.Text);
if (jezdec == null)
{
errorProvider.SetError(textHeslo, "Špatné ID");
}
if (jezdec.heslo == textHeslo.Text)
{
JezdecPrihlasen form = new JezdecPrihlasen(this, jezdec);
form.Show();
this.Hide();
}
else
{
errorProvider.SetError(textHeslo, "Špatné ID nebo heslo.");
}
}
}
private static Collection <Jezdec> Read(SqlDataReader reader)
{
Collection <Jezdec> jezdci = new Collection <Jezdec>();
while (reader.Read())
{
int i = -1;
Jezdec jezdec = new Jezdec();
jezdec.cislo_licence = reader.GetString(++i);
jezdec.sid = reader.GetInt32(++i);
if (!reader.IsDBNull(++i))
{
if (reader.GetString(i) == "1")
{
jezdec.licence = true;
}
else
{
jezdec.licence = false;
}
}
jezdec.oid = reader.GetInt32(++i);
Osoba osoba = JISdata.DAO.OsobaTable.Select(jezdec.oid);
jezdec.jmeno = osoba.jmeno + " " + osoba.prijmeni;
jezdec.telefon = osoba.telefon.ToString();
if (!reader.IsDBNull(i))
{
jezdec.heslo = reader.GetString(++i);
}
else
{
jezdec.heslo = "11";
}
jezdci.Add(jezdec);
}
return(jezdci);
}
/// <summary>
/// Prepare a command.
/// </summary>
private static void PrepareCommand(SqlCommand command, Jezdec jezdec)
{
command.Parameters.AddWithValue("@cislo_licence", jezdec.cislo_licence);
command.Parameters.AddWithValue("@sid", jezdec.sid);
if (jezdec.licence.HasValue == true)
{
if (jezdec.licence.Value == true)
{
command.Parameters.AddWithValue("@licence", "1");
}
else
{
command.Parameters.AddWithValue("@licence", "0");
}
}
else
{
command.Parameters.AddWithValue("@licence", "0");
}
command.Parameters.AddWithValue("@oid", jezdec.oid);
command.Parameters.AddWithValue("@heslo", jezdec.heslo);
}
public JezdecPrihlasen(Form parent, Jezdec jezdec)
{
this.parent = parent;
model = new JezdecFormModel(jezdec);
InitializeComponent();
}
