public ActionResult Create(HastahaneView hastahaneView)
{
ViewBag.SehirList = new SelectList(GetSehirList(), "Id", "Ad");
if (ModelState.IsValid)
{
var hastahane = new Hastahane();
var aynıHastahane = db.Hastahanes.Where(x => x.Ad == hastahaneView.Ad).Count();
if (aynıHastahane >= 1)
{
ViewBag.AynıAd = "Daha önce böyle bir hastahane kaydı gerçekleştirilmiş.";
}
else
{
hastahane.Ad = hastahaneView.Ad;
hastahane.Adres = hastahaneView.Adres;
hastahane.SehirId = hastahaneView.SehirId;
hastahane.IlceId = hastahaneView.IlceId;
hastahane.Tel = hastahaneView.Tel;
db.Hastahanes.Add(hastahane);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(hastahaneView));
/* ViewBag.IlceId = new SelectList(db.Ilces, "Id", "Ad", hastahane.IlceId);
* ViewBag.SehirId = new SelectList(db.Sehirs, "Id", "Ad", hastahane.SehirId);
* return View(hastahane);*/
}
public ActionResult DeleteConfirmed(int id)
{
Hastahane hastahane = db.Hastahanes.Find(id);
db.Hastahanes.Remove(hastahane);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public Hastahane GetHastaneByID(int hastaneID)
{
Hastahane hastane = _hastaneDAL.GetHospitalById(hastaneID);
if (hastane == null)
{
throw new IDBulunamadi("Hastane");
}
return(hastane);
}
public ActionResult Edit([Bind(Include = "Id,Ad,SehirId,IlceId,Adres,Tel")] Hastahane hastahane)
{
if (ModelState.IsValid)
{
db.Entry(hastahane).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IlceId = new SelectList(db.Ilces, "Id", "Ad", hastahane.IlceId);
ViewBag.SehirId = new SelectList(db.Sehirs, "Id", "Ad", hastahane.SehirId);
return(View(hastahane));
}
// GET: Admin/Hastahane/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Hastahane hastahane = db.Hastahanes.Find(id);
if (hastahane == null)
{
return(HttpNotFound());
}
return(View(hastahane));
}
public Hastahane GetHospitalById(int hastaneID)
{
Hastahane hst = new Hastahane();
query = "SELECT *FROM Hastane WHERE HastaneID=@hastaneID";
SqlParameter id = new SqlParameter("@hastaneID", hastaneID);
helper.AddParameter(id);
DataRow row = helper.FillDataTable(query).Rows[0];
hst.HastaneID = (int)row["HastaneID"];
hst.Ad = row["Ad"].ToString();
hst.Sehir = row["Sehir"].ToString();
return(hst);
}
// GET: Admin/Hastahane/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Hastahane hastahane = db.Hastahanes.Find(id);
if (hastahane == null)
{
return(HttpNotFound());
}
ViewBag.IlceId = new SelectList(db.Ilces, "Id", "Ad", hastahane.IlceId);
ViewBag.SehirId = new SelectList(db.Sehirs, "Id", "Ad", hastahane.SehirId);
return(View(hastahane));
}
public List <Hastahane> GetAllHospitals()
{
List <Hastahane> departmens = new List <Hastahane>();
query = "SELECT *FROM Hastane";
Hastahane hastane = null;
foreach (DataRow item in helper.FillDataTable(query).Rows)
{
hastane = new Hastahane();
hastane.HastaneID = (int)item["HastaneID"];
hastane.Ad = item["Ad"].ToString();
hastane.Sehir = item["Sehir"].ToString();
departmens.Add(hastane);
}
return(departmens);
}
