public static List <RasporedModel> GetRaspored(int tID)
{
List <RasporedModel> rasporedi = new List <RasporedModel>();
using (var db = new ggwpDBEntities())
{
List <Raspored> lista = new List <Raspored>();
if (tID == -1)
{
lista = db.Raspored.ToList();
}
else
{
lista = db.Raspored.Where(x => x.tim1_id == tID || x.tim2_id == tID).ToList();
}
foreach (Raspored r in lista)
{
rasporedi.Add(new RasporedModel(r));
}
}
return(rasporedi);
}
public static ResultModel CreateUser(UserModel user)
{
ResultModel result = new ResultModel();
//create new user
PWSHasher pwHasher = new PWSHasher();
byte[] saltBytes = Encoding.ASCII.GetBytes("ggwp");
HashWithSaltResult hashResult = pwHasher.HashWithGivenSalt(user.password, 64, saltBytes);
user.password = hashResult.Digest;
using (var db = new ggwpDBEntities())
{
Korisnik newKorisnik = new Korisnik();
newKorisnik.username = user.username;
newKorisnik.password = user.password;
newKorisnik.email = user.email;
newKorisnik.ime = user.ime;
newKorisnik.dob = user.dob;
db.Korisnik.Add(newKorisnik);
db.SaveChanges();
user.id = newKorisnik.id;
result.SetResults(user, true);
}
return(result);
}
public static Korisnik LoginUser(LoginModel user)
{
ResultModel result = new ResultModel();
Korisnik kor = null;
//login user
using (var db = new ggwpDBEntities())
{
string dbSalt = "ggwp";
PWSHasher pwHasher = new PWSHasher();
byte[] saltBytes = Encoding.ASCII.GetBytes(dbSalt);
HashWithSaltResult hashResult = pwHasher.HashWithGivenSalt(user.password, 64, saltBytes);
try
{
kor = db.Korisnik.Where(x => x.username.Equals(user.username)).SingleOrDefault();
}
catch (InvalidOperationException ex)
{
return(null);
}
if (hashResult.Digest.Equals(kor.password) && user.username.Equals(kor.username))
{
result.SetResults(KorisnikToModel(kor), true);
}
else
{
kor = null;
}
}
return(kor);
}
public string GetIgre(int temp)
{
List <Igra> igre = new List <Igra>();
using (var db = new ggwpDBEntities())
{
igre = db.Igra.ToList();
}
return(JsonConvert.SerializeObject(igre));
}
public static Igra GetIgra(int igraID)
{
Igra i = null;
using (var db = new ggwpDBEntities())
{
i = db.Igra.Find(igraID);
}
return(i);
}
public ActionResult Index()
{
List <Vijesti> vijesti = new List <Vijesti>();
using (var db = new ggwpDBEntities())
{
vijesti = db.Vijesti.Where(x => x.status != -1).ToList();
}
return(View(vijesti));
}
public ActionResult OglasnaPloca()
{
List <Tim> model = new List <Tim>();
using (var db = new ggwpDBEntities())
{
model = db.Tim.Where(x => x.otvoren == 1).ToList();
}
return(View(model));
}
public static UserModel GetKorisnikData(int uID)
{
UserModel um = null;
using (var db = new ggwpDBEntities())
{
um = KorisnikToModel(db.Korisnik.Find(uID));
}
return(um);
}
public static Tim GetTim(int tID)
{
Tim t = null;
using (var db = new ggwpDBEntities())
{
t = db.Tim.Find(tID);
t.Igra = db.Igra.Find(t.igra_id);
}
return(t);
}
public static List <TimskiRaspored> GetTimskiRaspored(int uID)
{
List <TimskiRaspored> rasporedi = new List <TimskiRaspored>();
using (var db = new ggwpDBEntities())
{
List <Tim> lista = GetKorisnikoviTimovi(uID);
foreach (Tim t in lista)
{
rasporedi.Add(new TimskiRaspored(t));
}
}
return(rasporedi);
}
public static List <Tim> GetKorisnikoviTimovi(int uID)
{
List <Tim> lista = new List <Tim>();
using (var db = new ggwpDBEntities())
{
List <KorisnikTim> ktlist = db.KorisnikTim.Where(x => x.korisnik_id == uID).ToList();
foreach (KorisnikTim kt in ktlist)
{
lista.Add(db.Tim.Find(kt.tim_id));
}
}
return(lista);
}
public static List <Tim> GetTimovi(bool onlyOpen)
{
List <Tim> lista = new List <Tim>();
using (var db = new ggwpDBEntities())
{
if (onlyOpen)
{
lista = db.Tim.Where(x => x.otvoren == 1).ToList();
}
else
{
lista = db.Tim.Where(x => x.otvoren == 0).ToList();
}
}
return(lista);
}
public string GetAllRaspored()
{
ApiResponse response = new ApiResponse();
using (var db = new ggwpDBEntities())
{
List <RasporedModel> model = TimManager.GetRaspored(-1);
if (model.Count > 0)
{
response.code = "200";
response.payload = model;
}
else
{
response.code = "404";
response.payload = null;
}
}
return(JsonConvert.SerializeObject(response));
}
public static List <Clan> GetTimClanovi(int tID)
{
List <Clan> result = new List <Clan>();
using (var db = new ggwpDBEntities())
{
List <KorisnikTim> ktlist = db.KorisnikTim.Where(x => x.tim_id == tID && x.tip == 1).ToList();
foreach (KorisnikTim kt in ktlist)
{
Korisnik k = db.Korisnik.Find(kt.korisnik_id);
if (k != null)
{
Clan c = new Clan(k.username, ""); //dodati opis
result.Add(c);
}
}
}
return(result);
}
public string GetAllVijesti()
{
ApiResponse response = new ApiResponse();
using (var db = new ggwpDBEntities())
{
List <Vijesti> vlist = db.Vijesti.Where(x => x.status != -1).ToList();
if (vlist.Count > 0)
{
response.code = "200";
response.payload = vlist;
}
else
{
response.code = "404";
response.payload = null;
}
}
return(JsonConvert.SerializeObject(response));
}
public string GetProfil(int uid)
{
ApiResponse response = new ApiResponse();
using (var db = new ggwpDBEntities())
{
ProfilModel model = new ProfilModel(uid);
if (model != null)
{
response.code = "200";
response.payload = model;
}
else
{
response.code = "404";
response.payload = null;
}
}
return(JsonConvert.SerializeObject(response));
}
public string GetVijest(int vid)
{
ApiResponse response = new ApiResponse();
using (var db = new ggwpDBEntities())
{
Vijesti v = db.Vijesti.Find(vid);
if (v != null)
{
v.datum = v.datum.Date;
response.code = "200";
response.payload = v;
}
else
{
response.code = "404";
response.payload = null;
}
}
return(JsonConvert.SerializeObject(response));
}
