public ActionResult Edit([Bind(Include = "id_anketa,prasanje,opis_a,kraen_datum,id_lice,datum_kreiranje,multi_choice")] Anketa anketa)
{
if (ModelState.IsValid)
{
db.Entry(anketa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_lice = new SelectList(db.Lice, "id_lice", "ime", anketa.id_lice);
return(View(anketa));
}
public ActionResult ZapisiKomentar()
{
string sodrzinaKom = Request.Params["sodrzinaKom"];
string anketaId = Request.Params["anketa_id"];
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
var novKom = db.Komentars.Create();
novKom.sodrzina = sodrzinaKom;
db.Komentars.Add(novKom);
var komentarZa = db.Komentar_Za.Create();
komentarZa.id_anketa = Convert.ToInt32(anketaId);
komentarZa.id_kom = novKom.id_kom;
komentarZa.id_lice = (int)Session["id_lice"];
komentarZa.datum = Convert.ToDateTime(datum);
db.Komentar_Za.Add(komentarZa);
db.SaveChanges();
}
//return RedirectToAction("Details", "Anketa", new { id = anketa.id_anketa });
}
//ViewBag.id_lice = new SelectList(db.Lice, "id_lice", "ime", anketa.id_lice);
return(View());
}
public ActionResult ZapisiGlas(Anketa anketa)
{
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
foreach (int i in anketa.GlasoviId)
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
var novGlas = db.Glasas.Create();
novGlas.id_anketa = anketa.id_anketa;
novGlas.id_lice = (int)Session["id_lice"];
novGlas.id_odg = i;
novGlas.datum_glasanje = Convert.ToDateTime(datum);
db.Glasas.Add(novGlas);
}
db.SaveChanges();
}
return(RedirectToAction("Details", "Anketa", new { id = anketa.id_anketa }));
}
//ViewBag.id_lice = new SelectList(db.Lice, "id_lice", "ime", anketa.id_lice);
return(View(anketa));
}
public ActionResult BuyPremium(Premium_Korisnik premiumKorsinik)
{
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
Premium_Korisnik premiumUser = db.Premium_Korisnik.Create();
premiumUser.id_lice = (int)Session["id_lice"];
premiumUser.datum_starts = DateTime.Today;
premiumUser.datum_end = DateTime.Today.AddMonths(12);
db.Premium_Korisnik.Add(premiumUser);
db.SaveChanges();
return RedirectToAction("CheckStatus", "User");
}
}
else
{
return RedirectToAction("Index", "Anketa");
}
return View();
}
public ActionResult BuyPremium(Premium_Korisnik premiumKorsinik)
{
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
Premium_Korisnik premiumUser = db.Premium_Korisnik.Create();
premiumUser.id_lice = (int)Session["id_lice"];
premiumUser.datum_starts = DateTime.Today;
premiumUser.datum_end = DateTime.Today.AddMonths(12);
db.Premium_Korisnik.Add(premiumUser);
db.SaveChanges();
return(RedirectToAction("CheckStatus", "User"));
}
}
else
{
return(RedirectToAction("Index", "Anketa"));
}
return(View());
}
public ActionResult zapisiMultiChoiceGlas()
{
string glasoviIds = Request.Params["odgovoriId"];
string anketaId = Request.Params["anketa_id"];
String[] elements = glasoviIds.Split(',');
if (Session["id_lice"] != null)
{
if (glasoviIds.Length > 0)
{
using (var db = new AnketiEntities5())
{
Anketa anketa = db.Anketas.Find(Convert.ToInt32(anketaId));
for (int i = 0; i < elements.Length; i++)
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
Mozni_Odgovori odgovor = db.Mozni_Odgovori.Find(Convert.ToInt32(elements[i]));
if (anketa.Mozni_Odgovori.Contains(odgovor))
{
var novGlas = db.Glasas.Create();
novGlas.id_anketa = Convert.ToInt32(anketaId);
novGlas.id_lice = (int)Session["id_lice"];
novGlas.id_odg = Convert.ToInt32(elements[i]);
novGlas.datum_glasanje = Convert.ToDateTime(datum);
db.Glasas.Add(novGlas);
}
}
db.SaveChanges();
}
//return RedirectToAction("Details", "Anketa", new { id = anketaId });
}
else
{
//return RedirectToAction("Details", "Anketa", new { id = anketaId });
}
}
return(View());
}
public ActionResult myCreate()
{
var myOdgovori = Request.Params["odgovori"];
string myPrasanje = Request.Params["prasanje"];
string myDesc = Request.Params["description"];
string myDueDate = Request.Params["dueDate"];
string myMultiChoice = Request.Params["multiChoice"];
string myIdKategorii = Request.Params["idKategorii"];
string url_slika = Request.Params["urlSlika"];
String[] elements = myOdgovori.Split(',');
String[] idKategorii = new string[1] {
"kola"
};
bool zname = false;
if (myIdKategorii.Length > 0)
{
idKategorii = myIdKategorii.Split(',');
zname = true;
}
int multiChoice = 0;
if (myMultiChoice.Equals("1"))
{
multiChoice = 1;
}
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
Korisnik korisnik = db.Korisniks.Find((int)Session["id_lice"]);
Premium_Korisnik premiumKorisnik = db.Premium_Korisnik.Find((int)Session["id_lice"]);
bool flag = true;
if (korisnik.br_anketi >= 3)
{
flag = false;
}
if (premiumKorisnik != null)
{
flag = true;
}
if (flag)
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
var novaAnketa = db.Anketas.Create();
novaAnketa.prasanje = myPrasanje;
novaAnketa.opis_a = myDesc;
novaAnketa.kraen_datum = Convert.ToDateTime(myDueDate);
novaAnketa.id_lice = (int)Session["id_lice"];
novaAnketa.datum_kreiranje = Convert.ToDateTime(datum);
novaAnketa.multi_choice = multiChoice;
if (url_slika.Length > 1)
{
novaAnketa.url_slika = url_slika;
}
db.Anketas.Add(novaAnketa);
db.SaveChanges();
Anketa anketa = db.Anketas.Find(novaAnketa.id_anketa);
for (int i = 0; i < elements.Length; i++)
{
string str = elements[i];
str = str.Replace(";;;", ",");
Mozni_Odgovori odg = db.Mozni_Odgovori.Create();
odg.ime_odg = str;
db.Mozni_Odgovori.Add(odg);
db.SaveChanges();
anketa.Mozni_Odgovori.Add(odg);
}
db.SaveChanges();
if (zname)
{
for (int i = 0; i < idKategorii.Length; i++)
{
int id_k = Convert.ToInt32(idKategorii[i]);
Kategorija kategorija = db.Kategorijas.Find(id_k);
anketa.Kategorijas.Add(kategorija);
db.SaveChanges();
}
db.SaveChanges();
}
korisnik.br_anketi = korisnik.br_anketi + 1;
db.SaveChanges();
string strJson = "Your pool has been added. Thanks for your participation!!";
return(Json(strJson));
}
else
{
string strJson = "You have already posted 3 pools. If you want to post more pools You have to upgrade to Premium User!";
return(Json(strJson));
}
}
}
string strJson2 = "You are Not Logged IN!!!";
return(Json(strJson2));
}
public ActionResult Registration(Anketa_Proekt.Models.Louse user)
{
using (var db = new AnketiEntities5())
{
List<SelectListItem> listSelectListItems = new List<SelectListItem>();
foreach (Grad city in db.Grads)
{
SelectListItem selectList = new SelectListItem()
{
Text = city.ime_grad,
Value = city.id_grad.ToString(),
//Selected = false
};
listSelectListItems.Add(selectList);
}
ViewBag.MyGradovi = listSelectListItems;
//return View();
}
if (ModelState.IsValid)
{
using (var db = new AnketiEntities5())
{
var newUser = db.Lice.Create();
newUser.ime = user.ime;
newUser.prezime = user.prezime;
newUser.e_mail = user.e_mail;
newUser.lozinka = user.lozinka;
newUser.tel_broj = user.tel_broj;
newUser.ulica = user.ulica;
newUser.id_grad = user.id_grad;
newUser.datum_r = user.datum_r;
db.Lice.Add(newUser);
db.SaveChanges();
Session["id_lice"] = newUser.id_lice;
var korisnik = db.Korisniks.Create();
korisnik.id_lice = newUser.id_lice;
korisnik.br_anketi = 0;
db.Korisniks.Add(korisnik);
db.SaveChanges();
return RedirectToAction("Index", "Anketa");
}
}
else
{
ModelState.AddModelError("", "The data that you Entered is incorrect!");
}
return View();
}
public ActionResult Registration(Anketa_Proekt.Models.Louse user)
{
using (var db = new AnketiEntities5())
{
List <SelectListItem> listSelectListItems = new List <SelectListItem>();
foreach (Grad city in db.Grads)
{
SelectListItem selectList = new SelectListItem()
{
Text = city.ime_grad,
Value = city.id_grad.ToString(),
//Selected = false
};
listSelectListItems.Add(selectList);
}
ViewBag.MyGradovi = listSelectListItems;
//return View();
}
if (ModelState.IsValid)
{
using (var db = new AnketiEntities5())
{
var newUser = db.Lice.Create();
newUser.ime = user.ime;
newUser.prezime = user.prezime;
newUser.e_mail = user.e_mail;
newUser.lozinka = user.lozinka;
newUser.tel_broj = user.tel_broj;
newUser.ulica = user.ulica;
newUser.id_grad = user.id_grad;
newUser.datum_r = user.datum_r;
db.Lice.Add(newUser);
db.SaveChanges();
Session["id_lice"] = newUser.id_lice;
var korisnik = db.Korisniks.Create();
korisnik.id_lice = newUser.id_lice;
korisnik.br_anketi = 0;
db.Korisniks.Add(korisnik);
db.SaveChanges();
return(RedirectToAction("Index", "Anketa"));
}
}
else
{
ModelState.AddModelError("", "The data that you Entered is incorrect!");
}
return(View());
}
public ActionResult zapisiSingleChoiceGlas()
{
string glasId = Request.Params["odgovoriId"];
string anketaId = Request.Params["anketa_id"];
if (Session["id_lice"] != null)
{
if (glasId.Length > 0)
{
using (var db = new AnketiEntities5())
{
Anketa anketa = db.Anketas.Find(Convert.ToInt32(anketaId));
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
Mozni_Odgovori odgovor = db.Mozni_Odgovori.Find(Convert.ToInt32(glasId));
if (anketa.Mozni_Odgovori.Contains(odgovor))
{
var novGlas = db.Glasas.Create();
novGlas.id_anketa = Convert.ToInt32(anketaId);
novGlas.id_lice = (int)Session["id_lice"];
novGlas.id_odg = Convert.ToInt32(glasId);
novGlas.datum_glasanje = Convert.ToDateTime(datum);
db.Glasas.Add(novGlas);
}
db.SaveChanges();
}
//return RedirectToAction("Details", "Anketa", new { id = anketaId });
}
else
{
//return View();
}
}
return View();
}
public ActionResult ZapisiKomentar()
{
string sodrzinaKom = Request.Params["sodrzinaKom"];
string anketaId = Request.Params["anketa_id"];
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
var novKom = db.Komentars.Create();
novKom.sodrzina = sodrzinaKom;
db.Komentars.Add(novKom);
var komentarZa = db.Komentar_Za.Create();
komentarZa.id_anketa = Convert.ToInt32(anketaId);
komentarZa.id_kom = novKom.id_kom;
komentarZa.id_lice = (int)Session["id_lice"];
komentarZa.datum = Convert.ToDateTime(datum);
db.Komentar_Za.Add(komentarZa);
db.SaveChanges();
}
//return RedirectToAction("Details", "Anketa", new { id = anketa.id_anketa });
}
//ViewBag.id_lice = new SelectList(db.Lice, "id_lice", "ime", anketa.id_lice);
return View();
}
public ActionResult ZapisiGlas(Anketa anketa)
{
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
foreach (int i in anketa.GlasoviId)
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
var novGlas = db.Glasas.Create();
novGlas.id_anketa = anketa.id_anketa;
novGlas.id_lice = (int)Session["id_lice"];
novGlas.id_odg = i;
novGlas.datum_glasanje = Convert.ToDateTime(datum);
db.Glasas.Add(novGlas);
}
db.SaveChanges();
}
return RedirectToAction("Details", "Anketa", new { id = anketa.id_anketa });
}
//ViewBag.id_lice = new SelectList(db.Lice, "id_lice", "ime", anketa.id_lice);
return View(anketa);
}
public ActionResult myCreate()
{
var myOdgovori = Request.Params["odgovori"];
string myPrasanje = Request.Params["prasanje"];
string myDesc = Request.Params["description"];
string myDueDate = Request.Params["dueDate"];
string myMultiChoice = Request.Params["multiChoice"];
string myIdKategorii = Request.Params["idKategorii"];
string url_slika = Request.Params["urlSlika"];
String[] elements = myOdgovori.Split(',');
String[] idKategorii = new string[1] {"kola"};
bool zname = false;
if (myIdKategorii.Length > 0)
{
idKategorii = myIdKategorii.Split(',');
zname = true;
}
int multiChoice = 0;
if (myMultiChoice.Equals("1"))
{
multiChoice = 1;
}
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
Korisnik korisnik = db.Korisniks.Find((int)Session["id_lice"]);
Premium_Korisnik premiumKorisnik = db.Premium_Korisnik.Find((int)Session["id_lice"]);
bool flag = true;
if (korisnik.br_anketi >= 3)
{
flag = false;
}
if (premiumKorisnik != null)
{
flag = true;
}
if (flag)
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
var novaAnketa = db.Anketas.Create();
novaAnketa.prasanje = myPrasanje;
novaAnketa.opis_a = myDesc;
novaAnketa.kraen_datum = Convert.ToDateTime(myDueDate);
novaAnketa.id_lice = (int)Session["id_lice"];
novaAnketa.datum_kreiranje = Convert.ToDateTime(datum);
novaAnketa.multi_choice = multiChoice;
if (url_slika.Length > 1)
{
novaAnketa.url_slika = url_slika;
}
db.Anketas.Add(novaAnketa);
db.SaveChanges();
Anketa anketa = db.Anketas.Find(novaAnketa.id_anketa);
for (int i = 0; i < elements.Length; i++)
{
string str = elements[i];
str = str.Replace(";;;", ",");
Mozni_Odgovori odg = db.Mozni_Odgovori.Create();
odg.ime_odg = str;
db.Mozni_Odgovori.Add(odg);
db.SaveChanges();
anketa.Mozni_Odgovori.Add(odg);
}
db.SaveChanges();
if (zname)
{
for (int i = 0; i < idKategorii.Length; i++)
{
int id_k = Convert.ToInt32(idKategorii[i]);
Kategorija kategorija = db.Kategorijas.Find(id_k);
anketa.Kategorijas.Add(kategorija);
db.SaveChanges();
}
db.SaveChanges();
}
korisnik.br_anketi = korisnik.br_anketi + 1;
db.SaveChanges();
string strJson = "Your pool has been added. Thanks for your participation!!";
return Json(strJson);
}
else
{
string strJson = "You have already posted 3 pools. If you want to post more pools You have to upgrade to Premium User!";
return Json(strJson);
}
}
}
string strJson2 = "You are Not Logged IN!!!";
return Json(strJson2);
}
