public static List <Zapisnik> Zapisnik_Get_All()
{
var lista = new List <Zapisnik>();
SQLiteCommand com = DB_connection.conn.CreateCommand();
com.CommandText = String.Format(@"SELECT * FROM ZAPISNIK");
SQLiteDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Zapisnik z = new Zapisnik();
z.Id = Convert.ToInt32(reader["ID"]);
if (DateTime.FromFileTime(reader.GetInt64(1)).GetType() != typeof(DBNull))
{
z.Datum = DateTime.FromFileTime(reader.GetInt64(1));
}
if (reader["Ekipa_ID"].GetType() != typeof(DBNull))
{
z.Ekipa_id = Convert.ToInt32(reader["Ekipa_ID"]);
}
z.Ekipa_gost = (string)reader["Ekipa_G"];
z.Rez_dom = Convert.ToInt32(reader["Rez_d"]);
z.Rez_gost = Convert.ToInt32(reader["Rez_g"]);
lista.Add(z);
}
com.Dispose();
return(lista);
}
public static void Zapisnik_Put(Zapisnik za)
{
SQLiteCommand com = DB_connection.conn.CreateCommand();
com.CommandText = String.Format(@"INSERT INTO ZAPISNIK (Datum, Ekipa_ID, Ekipa_G, Rez_d, Rez_g)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')",
za.Datum.ToFileTime(), za.Ekipa_id, za.Ekipa_gost, za.Rez_dom, za.Rez_gost);
com.ExecuteNonQuery();
com.Dispose();
}
public async Task <IActionResult> Create(ZapisnikViewModel model)
{
if (ModelState.IsValid)
{
Zapisnik z = new Zapisnik();
z.ZapisnikId = model.ZapisnikId;
z.IdPovjerenstva = model.IdPovjerenstva;
z.PonudaId = model.IdPonude;
z.NazivZapisnik = model.NazivZapisnik;
z.IdPrethZapisnika = model.IdPrethZapisnika;
z.IspravnostZapisnik = model.ispravnostZapisnik;
foreach (var stavka in model.StavkeZapisnika)
{
StavkaZapisnik novaStavka = new StavkaZapisnik();
novaStavka.idOdredba = stavka.idOdredba;
novaStavka.cijenaKršenja = stavka.cijenaKršenjaOdluke;
novaStavka.ispravnostStavka = stavka.ispravnostStavka;
z.StavkaZapisniks.Add(novaStavka);
}
try
{
ctx.Add(z);
await ctx.SaveChangesAsync();
TempData[Constants.Message] = $"Zapisnik uspješno dodan. Id={z.ZapisnikId}";
TempData[Constants.ErrorOccurred] = false;
return(RedirectToAction(nameof(Edit), new { id = z.ZapisnikId }));
}
catch (Exception exc)
{
ModelState.AddModelError(string.Empty, exc.CompleteExceptionMessage());
return(View(model));
}
}
else
{
return(View(model));
}
}
private void btnZapisnik02_Click(object sender, EventArgs e)
{
var zap = new Zapisnik();
zap.Datum = (DateTime)calendarZapisnik.SelectionRange.Start;
zap.Ekipa_id = ek.Id;
zap.Ekipa_gost = txtbZapisnik01.Text;
zap.Rez_dom = Int32.Parse(txtbZapisnik02.Text);
zap.Rez_gost = Int32.Parse(txtbZapisnik03.Text);
try
{
DB_connection.OpenConn();
DB_PUT.Zapisnik_Put(zap);
DB_connection.CloseConn();
this.Close();
}
catch (ArgumentException err)
{
lblZapisnikResult.ForeColor = Color.Red;
Change_label(err.ToString());
}
}
