public ActionResult Create(OgrenciDers ogrenciDers)
{
if (ModelState.IsValid)
{
var liste = (from Ders in db.Derses
join Ogr in db.Ogretmens
on Ders.DersID equals Ogr.DersID
where Ogr.OgretmenID == ogrenciDers.DerID
select new
{
DerOgr = Ders.DersAdi + "-" + Ogr.Adi + " " + Ogr.Soyadi
}).FirstOrDefault();
OgrenciDers ogr = new OgrenciDers();
ogr.DerID = ogrenciDers.DerID;
ogr.OgrenciID = ogrenciDers.OgrenciID;
ogr.DerOgr = liste.DerOgr.ToString();
db.OgrenciDers.Add(ogr);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OgrenciID = new SelectList(db.Ogrencis, "OgrenciID", "Adi", ogrenciDers.OgrenciID);
return(View(ogrenciDers));
}
public ActionResult Create([Bind(Include = "OgrenciId,DersId,Vize,Final,SonNot")] OgrenciDers ogrenciDers)
{
if (ModelState.IsValid)
{
var res = db.OgrenciDers.Find(ogrenciDers.OgrenciId, ogrenciDers.DersId);
if (res == null)
{
ogrenciDers.FindSonNot();
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
string ogrenciAd = db.Ogrenci.Find(ogrenciDers.OgrenciId).Ad + " " + db.Ogrenci.Find(ogrenciDers.OgrenciId).Soyad;
string dersAd = db.Ders.Find(ogrenciDers.DersId).Ad;
ViewBag.Message = ogrenciAd + " isimli ogrencinin " + dersAd + " dersi icin girilmiş notu zaten bulunmaktadır.";
ViewBag.DersId = new SelectList(db.Ders, "Id", "Ad");
ViewBag.OgrenciId = new SelectList(db.Ogrenci, "Id", "Ad");
return(View());
}
}
ViewBag.DersId = new SelectList(db.Ders, "Id", "Ad", ogrenciDers.DersId);
ViewBag.OgrenciId = new SelectList(db.Ogrenci, "Id", "Ad", ogrenciDers.OgrenciId);
return(View(ogrenciDers));
}
// GET: OgrenciDers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OgrenciDers ogrenciDers = db.OgrenciDers.Find(id);
if (ogrenciDers == null)
{
return(HttpNotFound());
}
var liste = (from Ders in db.Derses
join Ogr in db.Ogretmens
on Ders.DersID equals Ogr.DersID
select new
{
DerID = Ogr.OgretmenID,
DerOgr = Ders.DersAdi + "-" + Ogr.Adi + " " + Ogr.Soyadi
}).ToList();
ViewBag.DersListe = new SelectList(liste.ToList(), "DerID", "DerOgr");
ViewBag.OgrenciID = new SelectList(db.Ogrencis, "OgrenciID", "Adi", ogrenciDers.OgrenciID);
return(View(ogrenciDers));
}
public ActionResult Delete(int?id)
{
List <Ogrenci> listOgrenci = db.Ogrenci.ToList();
OgrenciDers ogrenciDers = new OgrenciDers();
List <Ders> listDers = db.Ders.ToList();
foreach (var item in listOgrenci)
{
if (item.SınıfId == id)
{
for (int i = 0; i < listDers.Count(); i++)
{
ogrenciDers = db.OgrenciDers.Find(item.Id, listDers[i].Id);
if (ogrenciDers != null)
{
db.OgrenciDers.Remove(ogrenciDers);
}
}
db.Ogrenci.Remove(item);
}
}
db.Sinif.Remove(db.Sinif.Find(id));
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
OgrenciDers ogrenciDers = db.OgrenciDers.Find(id);
db.OgrenciDers.Remove(ogrenciDers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "OgrenciId,DersId,Vize,Final,SonNot")] OgrenciDers ogrenciDers)
{
if (ModelState.IsValid)
{
ogrenciDers.FindSonNot();
return(RedirectToAction("Index"));
}
ViewBag.DersId = new SelectList(db.Ders, "Id", "Ad", ogrenciDers.DersId);
ViewBag.OgrenciId = new SelectList(db.Ogrenci, "Id", "Ad", ogrenciDers.OgrenciId);
return(View(ogrenciDers));
}
// GET: OgrenciDers/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OgrenciDers ogrenciDers = db.OgrenciDers.Find(id);
if (ogrenciDers == null)
{
return(HttpNotFound());
}
return(View(ogrenciDers));
}
public ActionResult Assignment([Bind(Include = "id,ders_id2,ogrenci_id")] OgrenciDers ogrenciders)
{
if (ModelState.IsValid)
{
OgrenciDers ogrenciDers;
var dersid = 1;
// OgrenciDers ogrenciler = db.OgrenciDers.Where(m => m.ogrenci_id == ogrenciders.ogrenci_id).FirstOrDefault();
OgrenciDers ogrenciler3 = (from y in db.OgrenciDers where y.ogrenci_id == ogrenciders.ogrenci_id select y).FirstOrDefault();
var ogrenciler2 = (from y in db.OgrenciDers where y.ogrenci_id == ogrenciders.ogrenci_id select y).ToList();
if (ogrenciler3 != null)
{
for (var i = 0; i < ogrenciler2.Count(); i++)
{
OgrenciDers ogrenciler = (from y in db.OgrenciDers where y.ogrenci_id == ogrenciders.ogrenci_id select y).FirstOrDefault();
db.OgrenciDers.Remove(ogrenciler);
db.SaveChanges();
}
}
if (ogrenciders.ders_id2 != null)
{
for (var i = 0; i < ogrenciders.ders_id2.Length; i++)
{
dersid = ogrenciders.ders_id2[i];
ogrenciDers = new OgrenciDers()
{
id = ogrenciders.id + i, ders_id = dersid, ogrenci_id = ogrenciders.ogrenci_id
};
db.OgrenciDers.Add(ogrenciDers);
}
db.SaveChanges();
}
else
{
for (var i = 0; i < ogrenciler2.Count(); i++)
{
OgrenciDers ogrenciler = (from y in db.OgrenciDers where y.ogrenci_id == ogrenciders.ogrenci_id select y).FirstOrDefault();
db.OgrenciDers.Remove(ogrenciler);
db.SaveChanges();
}
}
var list4 = db.Ogrenciler.Where(m => m.id == ogrenciders.ogrenci_id).ToList();
TempData["create"] = list4[0].adi + " isimli öğrenciye " + ogrenciders.ders_id2.Count() + " tane ders atandı";
return(RedirectToAction("Index", TempData["create"]));
}
return(View(ogrenciders));
}
public async Task <ActionResult <OgrenciDers> > CreateOgrenciDers(CreateOgrenciDersInput input)
{
try
{
OgrenciDers ogrenciDers = OgrenciDers.Create(input.DersId, input.OgrenciId);
await _context.AddAsync(ogrenciDers);
await _context.SaveChangesAsync();
return(Ok(ogrenciDers));
}
catch (Exception ex)
{
return(NotFound());
}
}
// GET: OgrenciDers/Edit/5
public ActionResult Edit(int?ogrenciId, int?dersId)
{
if (ogrenciId == null && dersId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OgrenciDers ogrenciDers = db.OgrenciDers.Find(ogrenciId, dersId);
if (ogrenciDers == null)
{
Ogrenci ogrenci = db.Ogrenci.Find(ogrenciId);
Ders ders = db.Ders.Find(dersId);
string isim = ogrenci.Ad + " " + ogrenci.Soyad;
string str = isim + " isimli ogrencinin " + ders.Ad + " dersi icin onceden girilmis bir notu bulunmamaktadir.";
TempData["Message"] = str;
//ogrenciDers = new OgrenciDers { OgrenciId = ogrenciId.Value, DersId = dersId.Value };
return(RedirectToAction("Index"));
}
ViewBag.DersId = new SelectList(db.Ders, "Id", "Ad", ogrenciDers.DersId);
ViewBag.OgrenciId = new SelectList(db.Ogrenci, "Id", "Ad", ogrenciDers.OgrenciId);
return(View(ogrenciDers));
}
public ActionResult Edit([Bind(Include = "ID,OgrenciID,DerID")] OgrenciDers ogrenciDers)
{
if (ModelState.IsValid)
{
var liste2 = (from Ders in db.Derses
join Ogr in db.Ogretmens
on Ders.DersID equals Ogr.DersID
where Ogr.OgretmenID == ogrenciDers.DerID
select new
{
DerOgr = Ders.DersAdi + "-" + Ogr.Adi + " " + Ogr.Soyadi
}).FirstOrDefault();
ogrenciDers.DerOgr = liste2.DerOgr.ToString();
OgrenciDers ogr = new OgrenciDers();
ogr.ID = ogrenciDers.ID;
ogr.OgrenciID = ogrenciDers.OgrenciID;
ogr.DerID = ogrenciDers.DerID;
ogr.DerOgr = liste2.DerOgr.ToString();
db.Entry(ogrenciDers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var liste = (from Ders in db.Derses
join Ogr in db.Ogretmens
on Ders.DersID equals Ogr.DersID
select new
{
DerID = Ogr.OgretmenID,
DerOgr = Ders.DersAdi + "-" + Ogr.Adi + " " + Ogr.Soyadi
}).ToList();
ViewBag.DersListe = new SelectList(liste.ToList(), "DerID", "DerOgr");
ViewBag.OgrenciID = new SelectList(db.Ogrencis, "OgrenciID", "Adi", ogrenciDers.OgrenciID);
return(View(ogrenciDers));
}
public ActionResult Index(OgrenciDers ogrenciDers)
{
return(RedirectToAction("Edit", ogrenciDers));
}
