public static List <basvuru> GetItems()
{
string commandText = "select * from Table_Basvuru";
SQLiteDataReader rdr = DatabaseOperations.GetItems(commandText);
List <basvuru> basvurus = new List <basvuru>();
int id, bitti, arsiv;
string isim, kayit, son, sonuc, link, baslangic, degisim, hash;
while (rdr.Read())
{
id = Convert.ToInt32(rdr["id"]);
isim = rdr["isim"].ToString();
kayit = rdr["kayit"].ToString();
son = rdr["son"].ToString();
sonuc = rdr["sonuc"].ToString();
link = rdr["link"].ToString();
bitti = Convert.ToInt32(rdr["bitti"]);
baslangic = rdr["baslangic"].ToString();
degisim = rdr["degisim"].ToString();
arsiv = Convert.ToInt32(rdr["arsiv"]);
hash = rdr["hash"].ToString();
basvuru item = new basvuru(id, isim, kayit, son, sonuc, link, bitti, baslangic, degisim, arsiv, hash);
basvurus.Add(item);
}
return(basvurus);
}
public ActionResult DeleteConfirmed(int id)
{
basvuru basvuru = db.basvuru.Find(id);
db.basvuru.Remove(basvuru);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /admin/Register/Delete/5
public ActionResult Delete(int id = 0)
{
basvuru basvuru = db.basvuru.Find(id);
if (basvuru == null)
{
return(HttpNotFound());
}
return(View(basvuru));
}
public ActionResult Edit(basvuru basvuru)
{
if (ModelState.IsValid)
{
db.Entry(basvuru).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(basvuru));
}
public ActionResult Create(basvuru basvuru)
{
if (ModelState.IsValid)
{
db.basvuru.Add(basvuru);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(basvuru));
}
public ActionResult kisi(basvuru model, basvuru kisi)
{
if (ModelState.IsValid)
{
db.basvuru.Add(kisi);
kisi.secilen = "Hayır";
db.SaveChanges();
ViewBag.sonuc = "KAYIT YAPILDI!";
return(View("kisi"));
}
ViewBag.sonuc = "KAYIT YAPILMADI!";
return(View());
}
