protected void btnyatisyap_Click(object sender, EventArgs e)
{
MongoClient client = new MongoClient();
var database = client.GetDatabase("hastane");
var collection = database.GetCollection <yatanhastalar>("yatanhastalar");
var doktorlist = database.GetCollection <doktortek>("doktorlistesi").Find(x => x._id == ObjectId.Parse(ddlDoktor.SelectedValue)).ToList();
var dr = collection.Find(x => x._id == ObjectId.Parse(ddlDoktor.SelectedValue)).ToList();
if (doktorlist.Count != dr.Count)
{
foreach (var doktor in doktorlist)
{
yatanhastalar cat = new yatanhastalar();
cat._id = doktor._id;
cat.doktor_adi = doktor.doktor_adi;
cat.doktor_soyadi = doktor.doktor_soyadi;
cat.doktor_bölüm = doktor.doktor_bölüm;
collection.InsertOne(cat);
}
}
var srv = collection.Find(x => x._id == ObjectId.Parse(ddlDoktor.SelectedValue)).ToList().SelectMany(x => x.ServisList).Where(x => x._id == ObjectId.Parse(ddlServis.SelectedValue)).ToList();
var servislist = database.GetCollection <servistek>("servislistesi").Find(x => x._id == ObjectId.Parse(ddlServis.SelectedValue)).ToList();
if (srv.Count != servislist.Count)
{
foreach (var item in servislist)
{
servis cat = new servis();
cat._id = item._id;
cat.servis_adi = item.servis_adi;
List <servis> servisliste = collection.Find(x => x._id == ObjectId.Parse(ddlDoktor.SelectedValue)).FirstOrDefault()?.ServisList ?? new List <servis>();
servisliste.Add(cat);
collection.UpdateOne(Builders <yatanhastalar> .Filter.Eq(x => x._id, ObjectId.Parse(ddlDoktor.SelectedValue)),
Builders <yatanhastalar> .Update.Set(b => b.ServisList, servisliste));
}
}
var hst = collection.Find(x => x._id != null).ToList().SelectMany(x => x.ServisList).ToList().SelectMany(x => x.HastaList).Where(x => x._id == ObjectId.Parse(ddlHasta.SelectedValue)).ToList();
var hastalistesi = database.GetCollection <hastatek>("hastalistesi").Find(x => x._id == ObjectId.Parse(ddlHasta.SelectedValue)).ToList();
if (hst.Count != hastalistesi.Count)
{
foreach (var item in hastalistesi)
{
hasta cat = new hasta();
cat._id = item._id;
cat.hasta_adi = item.hasta_adi;
cat.hasta_soyadi = item.hasta_soyadi;
cat.hasta_anneadi = item.hasta_anneadi;
cat.hasta_babaadi = item.hasta_babaadi;
cat.hasta_telefon = item.hasta_telefon;
cat.hasta_adres = item.hasta_adres;
cat.hasta_cinsiyet = item.hasta_cinsiyet;
var servisliste = collection.Find(x => x._id == ObjectId.Parse(ddlDoktor.SelectedValue)).FirstOrDefault()?.ServisList ?? new List <servis>();
List <hasta> hastalist = servisliste.FirstOrDefault(x => x._id == ObjectId.Parse(ddlServis.SelectedValue))?.HastaList ?? new List <hasta>();
hastalist.Add(cat);
collection.UpdateOne(Builders <yatanhastalar> .Filter.Eq(x => x._id, ObjectId.Parse(ddlDoktor.SelectedValue)),
Builders <yatanhastalar> .Update.Set(b => b.ServisList, servisliste));
}
}
}
public ActionResult DeleteConfirmed(int id)
{
servis servis = db.servis.Find(id);
db.servis.Remove(servis);
db.SaveChanges();
TempData["error"] = false;
TempData["message"] = "Uspjesno ste izbrisali servis";
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id_servisa,cijena_servisa,dijelovi,datum_servisa,fk_oprema")] servis servis)
{
if (ModelState.IsValid)
{
db.Entry(servis).State = EntityState.Modified;
db.SaveChanges();
TempData["error"] = false;
TempData["message"] = "Uspjesno ste ažurirali servis";
return(RedirectToAction("Index"));
}
ViewBag.fk_oprema = new SelectList(db.oprema, "id_opreme", "ime_opreme", servis.fk_oprema);
return(View(servis));
}
// GET: servis/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
servis servis = db.servis.Find(id);
if (servis == null)
{
return(HttpNotFound());
}
return(View(servis));
}
// GET: servis/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
servis servis = db.servis.Find(id);
if (servis == null)
{
return(HttpNotFound());
}
ViewBag.fk_oprema = new SelectList(db.oprema, "id_opreme", "ime_opreme", servis.fk_oprema);
return(View(servis));
}