public tblCalisan AddOrUpdate(tblCalisan entity)
{
try
{
_db.Entry(entity).State = entity.ID == 0 ?
EntityState.Added :
EntityState.Modified;
_db.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
return(entity);
}
public ActionResult Edit([Bind(Include = "CalisanID,Ad,Soyad,Telefon,Departman,Yonetici")] tblCalisan tblCalisan)
{
if (ModelState.IsValid)
{
db.Entry(tblCalisan).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Yonetici = new SelectList(db.tblCalisan, "CalisanID", "Ad", tblCalisan.Yonetici);
ViewBag.Departman = new SelectList(db.tblDepartman, "DepartmanID", "DepartmanAd", tblCalisan.Departman);
return(View(tblCalisan));
}
// GET: Calisan/CalisanDetay/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(View());
}
tblCalisan tblCalisan = db.tblCalisan.Find(id);
if (tblCalisan == null)
{
return(HttpNotFound());
}
return(View(tblCalisan));
}
// GET: Calisan/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(View());
}
tblCalisan tblCalisan = db.tblCalisan.Find(id);
if (tblCalisan == null)
{
return(HttpNotFound());
}
ViewBag.Yonetici = new SelectList(db.tblCalisan, "CalisanID", "Ad", tblCalisan.Yonetici);
ViewBag.Departman = new SelectList(db.tblDepartman, "DepartmanID", "DepartmanAd", tblCalisan.Departman);
return(View(tblCalisan));
}
public ActionResult DeleteConfirmed(int id)
{
tblCalisan tblCalisan = db.tblCalisan.Find(id);
var Yonetici = (from m in db.tblCalisan
where m.Yonetici == id
select m).FirstOrDefault();
if (Yonetici == null)
{
db.tblCalisan.Remove(tblCalisan);
db.SaveChanges();
}
else
{
ViewBag.Message = "Çalışan Aynı zamanda bir yönetici ise çalışanı silemezsiniz. İlk önce Çalışanları Başka bir yöneticiye taşıyın.";
return(View());
}
return(RedirectToAction("Index"));
}
public void Update(tblCalisan entity)
{
_db.Entry(entity).State = EntityState.Modified;
_db.SaveChanges();
}
public void Delete(tblCalisan entity)
{
_db.tblCalisan.Remove(entity);
_db.SaveChanges();
}
public void Add(tblCalisan entity)
{
_db.tblCalisan.Add(entity);
_db.SaveChanges();
}