public IActionResult Polecany(string dzien)
{
int userid = int.Parse(User.Identity.GetUserId());
var user = _context.uzytkownicy.Single(e => e.Id == userid);
var polecay_id = PolecanyTrening(DateTime.Now.Date);
Trening polecany = _context.treningi.First();
if (polecay_id != -1)
{
polecany = _context.treningi.Single(e => e.id_treningu == polecay_id);
}
PlanowanieTreningow planowany = new PlanowanieTreningow();
planowany.data = DateTime.Now;
planowany.dzien = dzien;
planowany.trening = polecany;
planowany.uzytkownik = user;
planowany.id_treningu = polecany.id_treningu;
planowany.id_uzytkownika = user.Id;
_context.Add(planowany);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
//return View();
}
///
/// <param name="vezbacId"></param>
/// <param name="service"></param>
/// <param name="trening"></param>
public string AddTreningVezbac(int vezbacId, IDBService service, Trening trening){
string message = "";
undoRedo.InsertInUnDoRedoForAdd(vezbacId, 1, service, trening, out message);
return message;
//return service.AddTreningVezbac(vezbacId, trening);
}
private void Create()
{
Error = null;
Trening trening = new Trening();
trening.Termin = DateTime.Now;
trening.Trener = SelektovaniTrener;
if (InternalData.Data.ulogovanaOsova.Role == 0)
{
Error = InternalData.Data.service.AddTreningAdmin(InternalData.Data.ulogovanaOsova.ID, trening);
}
else
{
Error = InternalData.Data.service.AddTreningVezbac(InternalData.Data.ulogovanaOsova.ID, trening);
}
if (Error != null)
{
MessageBox.Show(Error);
}
if (Treninzi == null)
{
Treninzi = new ObservableCollection <Trening>();
}
Treninzi.Add(trening);
}
public async Task <IActionResult> UrediTrening(Guid id, [Bind("Id,Naziv,Vjezbe")] Trening trening)
{
if (id != trening.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
trening.Vjezbe = trening.Vjezbe.Where(v => v != null).ToList();
_context.Update(trening);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TreningExists(trening.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(trening));
}
public async Task <IActionResult> PrijavaTreninga(int id)
{
DbKorisnik k = context.Korisnik.Where(o => o.DbKorisnikID.Equals(id)).First();
DbClan c = context.Clan.Where(o => o.DbClanID.Equals(id)).First();
prijavljeniClan = new Clan(k, c);
ViewData["clan"] = c;
Dictionary <Trening, Trener> treninzi = new Dictionary <Trening, Trener>();
List <DbTrening> treninziZaIteriranje = context.Trening.ToList();
foreach (DbTrening t in treninziZaIteriranje)
{
if (t.DatumOdrzavanja > new DateTime())
{
System.Diagnostics.Debug.WriteLine("DB" + t.DbTreningID);
Trening treningNovi = new Trening(t);
System.Diagnostics.Debug.WriteLine("NEDB" + treningNovi.ID);
treninzi.Add(treningNovi, new Trener(context.Korisnik.Where(tr => tr.DbKorisnikID == t.DbTrenerID).FirstOrDefault()));
//treninzi.Add(new Trening(t));
}
}
System.Diagnostics.Debug.WriteLine(treninzi.Count);
ViewData["treninzi"] = treninzi;
ViewData["username"] = prijavljeniClan.Ime;
return(View(prijavljeniClan));
}
public Trening_dashboard(Trening tr, List <Igraci> igr, List <Vjezbe> vj)
{
trening_now = tr;
igraci_now = igr;
vjezbe_now = vj;
InitializeComponent();
lblDashboard01.Text = tr.Naziv.ToString() + " - " + String.Format("{0:MM/dd/yy}", (DateTime)tr.Datum);
//GRIDVIEW
//punjenje gridview-a sa igracima
BindingSource datasource;
dgvDashboardIgraci.AutoGenerateColumns = false;
dgvDashboardIgraci.ColumnCount = 2;
var collection = new ObservableCollection <Igraci>(igraci_now);
datasource = new BindingSource(collection, null);
dgvDashboardIgraci.Columns[0].HeaderText = "Ime";
dgvDashboardIgraci.Columns[0].DataPropertyName = "Ime";
dgvDashboardIgraci.Columns[1].HeaderText = "Prezime";
dgvDashboardIgraci.Columns[1].DataPropertyName = "Prezime";
dgvDashboardIgraci.DataSource = datasource;
dgvDashboardIgraci.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvDashboardIgraci.AutoResizeColumns();
dgvDashboardIgraci.AllowUserToAddRows = false;
dgvDashboardIgraci.CellClick += (s, e) =>
{
Check_Kosevi_List();
igrac_odabran = (Igraci)this.igraci_now[e.RowIndex];
};
}
public TreningForma(Form1 form, ISession s, Trening t)
{
InitializeComponent();
this.form = form;
session = s;
trening = t;
}
///
/// <param name="adminId"></param>
/// <param name="service"></param>
/// <param name="trening"></param>
public string AddTreningAdmin(int adminId, IDBService service, Trening trening){
string message = "";
undoRedo.InsertInUnDoRedoForAdd(adminId, 0, service, trening, out message);
return message;
//return service.AddTreningAdmin(adminId, trening);
}
public IActionResult Polecany()
{
var polecay_id = PolecanyTrening(DateTime.Now.Date);
Trening polecany = _context.treningi.Include(t => t.obrazy).First();
if (polecay_id != -1)
{
polecany = _context.treningi.Include(t => t.obrazy).Single(e => e.id_treningu == polecay_id);
}
ViewBag.trainingDetails = _context.treningSzczegoly.Where(k => k.id_treningu == polecany.id_treningu)
.Include(k => k.cwiczenie)
.ToList();
var link = TreningController.generateYoutubeEmbededLink(polecany.youtube_link);
ViewBag.youtube = link == "" || link == null ? null : link;
if (polecany.obrazy.Count <= 0)
{
ViewBag.image = null;
}
else
{
ViewBag.image = polecany.obrazy
.Last()
.GetImageDataUrl();
}
ViewBag.polecany = polecany;
isAdmin();
return(View());
}
private void dodajToolStripMenuItem_Click(object sender, EventArgs e)
{
Trening t = new Trening();
TreningForma trening = new TreningForma(this, session, t);
trening.Show();
}
internal static void PronadjiTreninge(ComboBox cmbVrsta, DataGridView dataGridView1)
{
VrstaTreninga v = cmbVrsta.SelectedItem as VrstaTreninga;
trening = new Trening();
if (v != null)
{
trening.Uslov = " VrstaTreningaID=" + v.VrstaTreningaID + "";
}
else
{
trening.Uslov = "Datum is not null";
}
List <Trening> lista = (List <Trening>)komunikacija.PretraziTreninge(trening);
dataGridView1.DataSource = lista;
if (lista == null)
{
MessageBox.Show("Sistem ne može da nađe treninge po zadatim vrednostima!");
return;
}
if (lista.Count == 0)
{
MessageBox.Show("Ne postoje treninzi za odabrani kriterijum!");
}
else
{
MessageBox.Show("Sistem je uspešno pronašao treninge!");
}
}
public static Trening Trening_Get_Last_Add()
{
var lista = new Trening();
SQLiteCommand com = DB_connection.conn.CreateCommand();
com.CommandText = String.Format(@"SELECT * FROM TRENING ORDER BY ID DESC LIMIT 1");//get the last added record
SQLiteDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Trening t = new Trening();
t.Id = Convert.ToInt32(reader["ID"]);
t.Datum = DateTime.FromFileTime(reader.GetInt64(1));
if (reader["Naziv"].GetType() != typeof(DBNull))
{
t.Naziv = (string)reader["Naziv"];
}
if (reader["Br_vjezbi"].GetType() != typeof(DBNull))
{
t.Br_Vjezbi = Convert.ToInt32(reader["Br_vjezbi"]);
}
lista = t;
}
com.Dispose();
return(lista);
}
public static List <Trening> Trening_Get_All()
{
var lista = new List <Trening>();
SQLiteCommand com = DB_connection.conn.CreateCommand();
com.CommandText = String.Format(@"SELECT * FROM TRENING");
SQLiteDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Trening t = new Trening();
t.Id = Convert.ToInt32(reader["ID"]);
t.Datum = DateTime.FromFileTime(reader.GetInt64(1));
if (reader["Naziv"].GetType() != typeof(DBNull))
{
t.Naziv = (string)reader["Naziv"];
}
if (reader["Br_vjezbi"].GetType() != typeof(DBNull))
{
t.Br_Vjezbi = Convert.ToInt32(reader["Br_vjezbi"]);
}
lista.Add(t);
}
com.Dispose();
return(lista);
}
///
/// <param name="osoba"></param>
/// <param name="trening"></param>
/// <param name="service"></param>
public string DeleteTrening(Osoba osoba, Trening trening, IDBService service){
string message = "";
undoRedo.InsertInUnDoRedoForDelete(osoba, service, trening, out message);
return message;
//return service.DeleteTrening(osoba, trening);
}
public ActionResult Index(TreningDTO trening)
{
var minute = Int32.Parse(Request.Params["Minute1"]);
var sekunde = Int32.Parse(Request.Params["Sekunde1"]);
var stotinke = Int32.Parse(Request.Params["Stotinke1"]);
trening.Dionica1 = new TimeSpan(0, 0, minute, sekunde, stotinke * 10);
minute = Int32.Parse(Request.Params["Minute2"]);
sekunde = Int32.Parse(Request.Params["Sekunde2"]);
stotinke = Int32.Parse(Request.Params["Stotinke2"]);
trening.Dionica2 = new TimeSpan(0, 0, minute, sekunde, stotinke * 10);
if (trening.IdTipTreninga > 2)
{
minute = Int32.Parse(Request.Params["Minute3"]);
sekunde = Int32.Parse(Request.Params["Sekunde3"]);
stotinke = Int32.Parse(Request.Params["Stotinke3"]);
trening.Dionica3 = new TimeSpan(0, 0, minute, sekunde, stotinke * 10);
}
var treningServis = new Trening();
treningServis.StvoriTrening(trening);
var veslacRepozitorij = new VeslacRepozitorij();
var veslaci = veslacRepozitorij.DohvatiVeslace();
return(View(veslaci));
}
public async Task <IActionResult> Edit(int id, [Bind("id_treningu,nazwa,id_kategorii")] Trening trening)
{
if (id != trening.id_treningu)
{
return(NotFound());
}
if (trening.id_uzytkownika != int.Parse(User.Identity.GetUserId()))
{
return(RedirectToAction("Details", new { id = trening.id_treningu }));
}
if (ModelState.IsValid)
{
try
{
_context.Update(trening);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TreningExists(trening.id_treningu))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["id_kategorii"] = new SelectList(_context.kategoriaTreningu, "id_kategorii", "nazwa", trening.id_kategorii);
return(View(trening));
}
private void btnTreningKreiraj01_Click(object sender, EventArgs e)
{
List <Igraci> igrac = new List <Igraci>();
List <Prisutnost> pris = new List <Prisutnost>();
List <Vjezbe> tren = new List <Vjezbe>();
foreach (DataGridViewRow row in dgvTreningKreiraj01.Rows)
{
if (Convert.ToBoolean(row.Cells["Koristi"].Value) == true)
{
tren.Add(row.DataBoundItem as Vjezbe);
}
}
Trening tr = new Trening(txtbTreningKreiraj01.Text, (int)tren.Count);
Trening tr_id = new Trening();
//Spremanje i dohvacanje spremljenog treninga
try
{
DB_connection.OpenConn();
DB_PUT.Trening_Put(tr);
tr_id = DB_GET.Trening_Get_Last_Add();
DB_connection.CloseConn();
tr.Id = tr_id.Id;
}
catch (ArgumentException err)
{
lblTreningKreirajResult.ForeColor = Color.Red;
Change_label("Greška kod spremanja treninga" + err.ToString());
}
foreach (DataGridViewRow row in gv.Rows)
{
Prisutnost p = new Prisutnost();
p.Igrac_id = Convert.ToInt32(row.Cells[0].Value);
p.Trening_id = tr.Id;
p.Prisutan = Convert.ToBoolean(row.Cells["Prisutan"].Value);
if (Convert.ToBoolean(row.Cells["Prisutan"].Value) == true)
{
igrac.Add(row.DataBoundItem as Igraci);
}
pris.Add(p);
}
//Spremanje prisutnosti
try
{
DB_connection.OpenConn();
DB_PUT.Prisutnost_Put_List(pris);
DB_connection.CloseConn();
new Trening_dashboard(tr, igrac, tren).Show();
this.Close();
}
catch (ArgumentException err)
{
lblTreningKreirajResult.ForeColor = Color.Red;
Change_label("Greška kod spremanja prisutnosti: " + err.ToString());
}
}
public override object IzvrsiKonkretnuSistemskuOperaciju(OpstiDomenskiObjekat odo)
{
Trening t = new Trening();
t.TreningID = Broker.DajSesiju().VratiSifru(t);
Broker.DajSesiju().Sacuvaj(t);
return(t);
}
//
// Spustenie automatizovaneho treningu
//
private void TreningDoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker worker = sender as BackgroundWorker;
_trening = new Trening(_biosandboxHome, _textbox);
e.Result = _trening.DoTrening();
}
public TreningForma(Form1 form, ISession s, Trening t, ListaTreninga lt)
{
InitializeComponent();
this.form = form;
session = s;
trening = t;
listaTreninga = lt;
dodajInformacije();
}
public static void Trening_Put(Trening tr)
{
SQLiteCommand com = DB_connection.conn.CreateCommand();
com.CommandText = String.Format(@"INSERT INTO TRENING (Datum, Naziv, Br_vjezbi)
VALUES ('{0}', '{1}', '{2}')",
tr.Datum.ToFileTime(), tr.Naziv, tr.Br_Vjezbi);
com.ExecuteNonQuery();
com.Dispose();
}
public static Trening Procitaj(ObjectId id)
{
MongoCollection <Trening> treninziCollection = Connection <Trening> .getCollection("treninzi");
Trening trening = (from t in treninziCollection.AsQueryable <Trening>()
where t.Id == id
select t).FirstOrDefault();
return(trening);
}
public Object UcitajTrening(Trening t)
{
TransferKlasa transfer = new TransferKlasa();
transfer.Operacija = Operacije.UcitajTreninge;
transfer.TransferObjekat = t;
formater.Serialize(tok, transfer);
return(((TransferKlasa)formater.Deserialize(tok)).Rezultat);
}
public void DodajNoviTrening(Trening trening)
{
using (ISession session = FluentNHibernate.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
trening.IgraciNaTreningu = trening.IgraciNaTreningu;
session.Save(trening);
transaction.Commit();
}
}
}
public async Task <IActionResult> Create([Bind("id_treningu,nazwa,id_kategorii")] Trening trening)
{
trening.id_uzytkownika = int.Parse(User.Identity.GetUserId());
if (ModelState.IsValid)
{
_context.Add(trening);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["id_kategorii"] = new SelectList(_context.kategoriaTreningu, "id_kategorii", "nazwa", trening.id_kategorii);
return(View(trening));
}
public static void Dodaj(Trening Item)
{
try
{
var collection = Connection <Trening> .getCollection("treninzi");
collection.Insert(Item);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
private void btnOdaberiTrening_Click(object sender, EventArgs e)
{
Trening odabraniTrening = dgvOdrzaniTreninzi.CurrentRow.DataBoundItem as Trening;
if (odabraniTrening != null)
{
FrmPregledPrisustva forma = new FrmPregledPrisustva(odabraniTrening);
forma.ShowDialog();
PrikaziTreninge();
PrikaziClanarine();
ObojiClanarine();
}
}
public async Task <IActionResult> TreningDetalji(int id, int treningID)
{
DbKorisnik k = context.Korisnik.Where(o => o.DbKorisnikID.Equals(id)).First();
DbClan c = context.Clan.Where(o => o.DbClanID.Equals(id)).First();
System.Diagnostics.Debug.WriteLine("primljeni id" + treningID);
Trening trening = new Trening(context.Trening.Where(x => x.DbTreningID == treningID).FirstOrDefault());
prijavljeniClan = new Clan(k, c);
ViewData["clan"] = c;
ViewData["trening"] = trening;
ViewData["username"] = prijavljeniClan.Ime;
return(View(prijavljeniClan));
}
public void DodajNoviTrening(IDodavanjeTreninga inForm)
{
if (inForm.ShowForm())
{
DateTime Datum = inForm.Datum;
GrupaTreninga Grupa = inForm.Grupa;
List <Igrac> Igraci = inForm.Igraci;
Trening trening = new Trening(Datum, Grupa.NazivGrupe, Igraci);
tr.DodajNoviTrening(trening);
notifyObservers();
}
}
public void Dodaj_Trening(string Data, string GodzRozp, string GodzZak, int IdKlient, int IdTrener)
{
Trening trening = new Trening();
BazaDAO baza = new BazaDAO();
string query = "Insert into Trening(IdTrener,IdKlient,DataGodzRozp,DataGodzZak,CzyZakonczony, Kwota) values(@idtrener,@idklient,@datagodzrozp,@datagodzzak,@czyzakonczony,@kwota)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(new SqlParameter("@idtrener", trening.IdTrener));
cmd.Parameters.Add(new SqlParameter("@idklient", trening.IdKlient));
cmd.Parameters.Add(new SqlParameter("@datagodzrozp", trening.DataGodzRozp));
cmd.Parameters.Add(new SqlParameter("@datagodzzak", trening.DataGodzZak));
cmd.Parameters.Add(new SqlParameter("@czyzakonczony", trening.CzyZakonczono));
cmd.Parameters.Add(new SqlParameter("@kwota", trening.Kwota));
con.Close();
}
