public ActionResult Kaydet(Departman dep)
{
if (!ModelState.IsValid)
{
return(View("DepartmanForm"));
}
MesajViewModel model = new MesajViewModel();
if (dep.id == 0)
{
db.Departman.Add(dep);
model.Mesaj = dep.ad + " eklendi";
}
else
{
var kayit = db.Departman.Find(dep.id);
if (kayit == null)
{
return(HttpNotFound());
}
kayit.ad = dep.ad;
model.Mesaj = dep.ad + " güncellendi";
}
db.SaveChanges();
model.Status = true;
model.LinkText = "Departman Listesi";
model.Url = "/Departman";
return(View("_Mesaj", model));
}
public void DepartmanDoldur()
{
Departman dep = new Departman();
DepartmanService deps = new DepartmanService();
dep.DepoBirimleri.Add(DepoBirimiDoldur(1));
deps.AddDepartmanService(dep);
Departman dep11 = new Departman();
DepartmanService deps11 = new DepartmanService();
dep11.LojistikBirimleri.Add(LojistikBirimiDoldur(1));
deps11.AddDepartmanService(dep);
Departman dep22 = new Departman();
DepartmanService deps22 = new DepartmanService();
dep22.SantiyeBirimleri.Add(SantiyeBirimiDoldur(1));
deps22.AddDepartmanService(dep);
Departman dep33 = new Departman();
DepartmanService deps33 = new DepartmanService();
dep33.SatinAlmaBirimleri.Add(SatinAlmaBirimiDoldur(1));
deps33.AddDepartmanService(dep);
Departman dep44 = new Departman();
DepartmanService deps44 = new DepartmanService();
dep44.TeklifBirimleri.Add(TeklifBirimiDoldur(1));
deps44.AddDepartmanService(dep);
}
public void DeleteEntity(int Id)
{
Departman temp = (from tablo in _db.DbDepartman where tablo.Id == Id select tablo).First();
temp.AktifMi = false;
SaveEntity();
}
public ActionResult Create(Departman departman)
{
context.Departmans.Add(departman);
context.SaveChanges();
return(RedirectToAction("Index"));
}
private async void btnDepartmanİnsert_Click(object sender, RoutedEventArgs e)
{
using (Context db = new Context())
{
Departman departman = grdGorevler.DataContext as Departman;
if (string.IsNullOrEmpty(departman.DepartmanName))
{
await this.ShowMessageAsync("Uyarı", "Departman adı boş bırakılamaz.");
return;
}
if (flyoutDerpartman.Header == "Yeni")
{
db.Departmans.Add(departman);
db.SaveChanges();
await this.ShowMessageAsync("Bilgi", "Kayıt ekleme başarı ile tamamlanmıştır.");
flyoutDerpartman.IsOpen = !flyoutDerpartman.IsOpen;
DepartmanList();
}
else if (flyoutDerpartman.Header == "Güncelle")
{
Departman updateDepartman = db.Departmans.SingleOrDefault(x => x.Id == departman.Id);
updateDepartman.DepartmanName = departman.DepartmanName;
db.SaveChanges();
await this.ShowMessageAsync("Bilgi", "Güncelleme işlemi başarı ile tamamlanmıştır.");
flyoutDerpartman.IsOpen = !flyoutDerpartman.IsOpen;
DepartmanList();
}
}
}
[ValidateAntiForgeryToken] //bunu ekleyerek, dışardıdan gelenecek olan isteklere karşı koruma sağlar.
public ActionResult Kaydet(Departman departman)
{
if (!ModelState.IsValid)
{
return(View("DepartmanForm"));
}
MesajViewModel m = new MesajViewModel();
if (departman.Id == 0)
{
db.Departman.Add(departman);
m.Mesaj = departman.Ad + " başarıyla eklendi!";
}
else
{
var guncellenecekDep = db.Departman.Find(departman.Id);
if (guncellenecekDep == null)
{
return(HttpNotFound());
}
guncellenecekDep.Ad = departman.Ad;
m.Mesaj = departman.Ad + " başarıyla güncellendi!";
}
db.SaveChanges();
m.Status = true;
m.LinkText = "Departman Listesi";
m.Url = "/Departman";
//return RedirectToAction("Index", "Departman");
return(View("_Mesaj", m));
}
} //Yanlislikla 2 kez tiklama sonucu olusmus bir fonksiyon
private void button_EKLEME_Click(object sender, EventArgs e)
{
try
{
label_Message.Text = "";
//connection.Open();
ad = textBox_ad.Text.Trim();
hastaneID = int.Parse(textBox_HastaneID.Text.Trim());
yoneticiID = int.Parse(textBox_YoneticiID.Text.Trim());
if (string.IsNullOrWhiteSpace(ad))
{
textBox_ad.Focus(); throw new Exception("Departman adı boş bırakılamaz.");
}
Departman obj = new Departman(ad, hastaneID, yoneticiID);
int result = obj.DepartmanEkle();
if (result > 0)
{
label_Message.Text = "Kayıt başarıyla gerçekleşti."; label_Message.ForeColor = Color.Green;
}
}
catch (Exception ex)
{
label_Message.Text = ex.Message;
label_Message.ForeColor = Color.Red;
}
//connection.Close();
}
public ActionResult DepartmanEkle(Departman d)
{
tablolar.Departmans.Add(d);
tablolar.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Kaydet(Departman departman)
{
if (!ModelState.IsValid)
{
return(View("DepartmanForm"));
}
if (departman.ID == 0)
{
db.Departman.Add(departman);
}
else
{
var güncellenecekDepartman = db.Departman.Find(departman.ID);
if (güncellenecekDepartman == null)
{
return(HttpNotFound());
}
else
{
güncellenecekDepartman.DepartmanIsmi = departman.DepartmanIsmi;
}
}
db.SaveChanges();
return(RedirectToAction("DepartmanList", "Departman"));
}
public JsonResult SaveDepartmanDatabase(FormCollection form)
{
int depid = Convert.ToInt16(form["departman.Id"].ToString());
string depad = form["departman.DepartmanAdi"].ToString();
var result = false;
try
{
if (depid > 0)
{
Departman dep = db.Departman.SingleOrDefault(x => x.Id == depid);
dep.DepartmanAdi = depad;
db.SaveChanges();
result = true;
}
else
{
Departman dep = new Departman();
dep.DepartmanAdi = depad;
db.Departman.Add(dep);
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Kaydet(Departman departman)
{
/* using (var transaction = db.Database.BeginTransaction())
* {
* db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Departman] ON");
*
*
* db.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Departman] OFF");
* transaction.Commit();
* } */
if (departman.Id == 0)
{
db.Departman.Add(departman);
}
else
{
var guncelDep = db.Departman.Find(departman.Id);
if (guncelDep == null)
{
return(HttpNotFound());
}
guncelDep.Ad = departman.Ad;
}
db.SaveChanges();
return(RedirectToAction("Index", "Departman"));
}
public ActionResult DepartmanEkle(Departman d)
{ //d paramatre olarak view e gönderilecek değerlerdir
d.Durum = true;
c.Departmans.Add(d); //k ismindeki nesne view'den gönderilen yeni departman adını tutacak
c.SaveChanges(); //değişiklikleri kaydet
return(RedirectToAction("Index")); //iş bitince index'e yönlendirme
}
[HttpPost] //form methodunda belirlenen post işlemi için
public ActionResult Kaydet(Departman departman)
{
if (!ModelState.IsValid)
{
return(View("DepartmanForm"));
}
if (departman.Id == 0)
{
db.Departman.Add(departman);
}
else
{
var guncelleDepartman = db.Departman.Find(departman.Id);
if (guncelleDepartman == null)
{
return(HttpNotFound());
}
else
{
guncelleDepartman.Ad = departman.Ad;
}
}
db.SaveChanges();
//kayıt tamamlandıktan sonra Index sayfasına yönlendirdi
return(RedirectToAction("Index", "Departman"));
}
public ActionResult Detail(int id = 5)
{
var departman = new Departman()
{
Id = id, Ad = "Bilgi İşlem"
};
var personeller = new List <Personel>()
{
new Personel()
{
Ad = "personel1"
},
new Personel()
{
Ad = "personel2"
},
new Personel()
{
Ad = "personel3"
}
};
var model = new DepartmanDetayViewModel()
{
Departman = departman,
Personeller = personeller
};
return(View(model));
}
public ActionResult DepartmanEkle(Departman departman)
{
departman.Durum = true;
context.Departmans.Add(departman);
context.SaveChanges();
return(RedirectToAction("Index"));
}
private async void btnİnsert_Click(object sender, RoutedEventArgs e)
{
using (Context db = new Context())
{
if (FormTuru == "Yeni")
{
Departman departman = grdGorevler.DataContext as Departman;
db.Departmans.Add(departman);
db.SaveChanges();
await this.ShowMessageAsync("Bilgi", "Departman Güncelleme Başarılı");
this.Close();
}
else if (FormTuru == "Güncelle")
{
Departman departman = grdGorevler.DataContext as Departman;
Departman updateDepartman = db.Departmans.SingleOrDefault(x => x.Id == departman.Id);
updateDepartman.DepartmanName = departman.DepartmanName;
db.SaveChanges();
await this.ShowMessageAsync("Bilgi", "Departman Güncelleme Başarılı");
this.Close();
}
}
}
public ActionResult DepartmanEkle(Departman dep)
{
dep.Durum = true;
C.Departmans.Add(dep);
C.SaveChanges();
return(RedirectToAction("Index"));
}
private async void btnDepartmanDelete_Click(object sender, RoutedEventArgs e)
{
using (Context db = new Context())
{
Departman select = dtgDepartmans.SelectedItem as Departman;
if (select != null)
{
Departman selectDelete = db.Departmans.Single(x => x.Id == select.Id);
var dialogResult = MessageBox.Show("Silmek istediğizden emin misiniz?", "Uyarı", MessageBoxButton.YesNo, MessageBoxImage.Information);
if (dialogResult == MessageBoxResult.Yes)
{
db.Departmans.Remove(selectDelete);
db.SaveChanges();
await this.ShowMessageAsync("Bilgi", "Departman silme işleme başarı ile tamamlanmıştır.");
DepartmanList();
}
else
{
await this.ShowMessageAsync("Uyarı", "Silme işlemi iptal edildi.");
}
}
else
{
await this.ShowMessageAsync("Uyarı", "Silme işlemi için departman seçiniz.");
}
}
}
/*
*
* BU İKİ YÖNTEMİ MECBUR KALMAYINCA KULLANMA
*
* public ActionResult Detay(int id)
* {
* var departman = new Departman() { Id = id, Ad = "Bilgi İşlem" };
* ViewData["departman"] = departman;
* return View();
* }
*
*
* public ActionResult Detay(int id)
* {
* var departman = new Departman() { Id = id, Ad = "Bilgi İşlem" };
* ViewBag.Departman = departman;
* return View();
* }
*
*
*/
public ActionResult Detay()
{
var departman = new Departman()
{
Id = 1, Ad = "Bilgi İşlem"
};
var personeller = new List <Personel>()
{
new Personel()
{
Ad = "FURKAN YILDIZ"
},
new Personel()
{
Ad = "OĞUZHAN DEMİR"
},
new Personel()
{
Ad = "ZAHİDE ÖZKAN"
}
};
var model = new DepartmanDetayViewModel()
{
Departman = departman,
Personeller = personeller
};
return(View(model));
}
public string AjaxDeleteDepartman()
{
// 0 - silme işlemi başarısız oldu
// 1 - Silme işlemi başarılı oldu
string donenkod = "0";
int ID = Convert.ToInt32(Request.Form["id"]);
Departman d = DepartmanRepository.Find(ID);
if (d.Calisans.Count > 0)
{
return(donenkod);
}
else
{
try
{
DepartmanRepository.Delete(ID);
DepartmanRepository.Save();
donenkod = "1";
}
catch (Exception ex)
{
}
return(donenkod);
}
}
// Belirli bir Calisan'a, görev alacagi bir departman ekler.
public async Task <CalisanGetirDto> EkleCalisanDepartmanı(CalisanDepartmaniEkleDto yeniCalisanDept)
{
Calisan calisan = await _context.Calisanlar
.Include(c => c.Firma)
.Include(c => c.CalisanDepartmanlari).ThenInclude(cd => cd.Departman)
.FirstOrDefaultAsync(c => c.Id == yeniCalisanDept.CalisanId);
Departman departman = await _context.Departmanlar.FirstOrDefaultAsync(d => d.Id == yeniCalisanDept.DepartmanId);
CalisanDepartman calisanDepartman = new CalisanDepartman
{
Calisan = calisan,
Departman = departman
};
await _context.CalisanDepartmanlar.AddAsync(calisanDepartman);
await _context.SaveChangesAsync();
Calisan guncelCalisan = await _context.Calisanlar
.Where(c => c.Id == calisan.Id)
.Include(c => c.Firma)
.Include(c => c.CalisanDepartmanlari).ThenInclude(cd => cd.Departman)
.FirstOrDefaultAsync();
return(_mapper.Map <CalisanGetirDto>(guncelCalisan));
}
public int AddItem(Departman item)
{
_db.Departman.Add(item);
try
{
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
//_etkilenenEntity=_db.ChangeTracker.Entries().ToList().Count;
//for (int i = 0; i < _etkilenenEntity; i++)
//{
_etkilenenSatir += _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(_etkilenenSatir);
}
public HttpResponseMessage GetDepartmani()
{
List <Departman> result = new List <Departman>();
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("select * from Departman.Departman", connection)
{
CommandType = CommandType.Text
};
try
{
connection.Open();
using (var dataReader = sqlCmd.ExecuteReader())
{
while (dataReader.Read())
{
var Departman = new Departman
{
DepartmanID = Convert.ToInt32(dataReader["DepartmanID"]),
NazivDepartmana = Convert.ToString(dataReader["NazivDepartmana"]),
FakultetID = Convert.ToInt32(dataReader["FakultetID"])
};
result.Add(Departman);
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error retrieving data"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public ActionResult Kaydet(Departman dep)
{
if (!ModelState.IsValid)
{
return(View("DepartmanForm"));
}
MesajViewModel model = new MesajViewModel();
if (dep.Id == 0)
{
db.Departman.Add(dep);
model.Mesaj = dep.Ad + " başarıyla eklendi";
}
else
{
var guncellenecekdepartman = db.Departman.Find(dep.Id);
if (guncellenecekdepartman == null)
{
return(HttpNotFound());
}
guncellenecekdepartman.Ad = dep.Ad;
model.Mesaj = dep.Ad + " başarıyla güncellendi";
}
db.SaveChanges();
model.Status = true;
model.Url = "/Departman";
model.LinkText = "Departman Listesi";
return(View("_Mesaj", model));
}
public HttpResponseMessage UpdatePredmet([FromBody] Departman Departman)
{
using (var connection = new SqlConnection(ConnectionString))
{
try
{
using (var sqlCmd = new SqlCommand("UPDATE Departman.Departman SET NazivDepartmana=@NazivDepartmana, FakultetID=@FakultetID WHERE Departman.DepartmanID=@DepartmanID"))
{
connection.Open();
sqlCmd.Connection = connection;
sqlCmd.Parameters.AddWithValue("NazivDepartmana", Departman.NazivDepartmana);
sqlCmd.Parameters.AddWithValue("DepartmanID", Departman.DepartmanID);
sqlCmd.Parameters.AddWithValue("FakultetID", Departman.FakultetID);
int rowAffected = sqlCmd.ExecuteNonQuery();
if (rowAffected == 0)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 BadRequest"));
}
}
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 400 Bad Request"));
}
}
return(Request.CreateResponse(HttpStatusCode.OK, "Updated Successfully"));
}
public HttpResponseMessage CreateDepartman([FromBody] Departman Departman)
{
using (var connection = new SqlConnection(ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand("INSERT INTO Departman.Departman VALUES(@NazivDepartmana, @FakultetID)", connection);
sqlCmd.Parameters.AddWithValue("NazivDepartmana", Departman.NazivDepartmana);
sqlCmd.Parameters.AddWithValue("FakultetID", Departman.FakultetID);
try
{
connection.Open();
int i = sqlCmd.ExecuteNonQuery();
SqlCommand sqlDepartman = new SqlCommand("SELECT TOP 1 * FROM Departman.Departman ORDER BY DepartmanID DESC", connection);
Departman last = new Departman();
using (var DepartmanRead = sqlDepartman.ExecuteReader())
{
while (DepartmanRead.Read())
{
last.DepartmanID = Convert.ToInt32(DepartmanRead["DepartmanID"]);
last.NazivDepartmana = Convert.ToString(DepartmanRead["NazivDepartmana"]);
last.FakultetID = Convert.ToInt32(DepartmanRead["FakultetID"]);
}
}
var response = Request.CreateResponse(HttpStatusCode.Created, last);
response.Headers.Location = new Uri(Request.RequestUri + "/" + last.DepartmanID);
return(response);
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Error 404 Bad request"));
}
}
}
public ActionResult Kaydet(Departman departman)
{
if (!ModelState.IsValid)
{
return(View("DepartmanForm"));
}
if (departman.Id == 0)
{
db.Departman.Add(departman);
}
else
{
var guncellenecekDepartman = db.Departman.Find(departman.Id);
if (guncellenecekDepartman == null)
{
return(HttpNotFound());
}
guncellenecekDepartman.Ad = departman.Ad;
}
db.SaveChanges();
return(RedirectToAction("Index", "Departman"));
}
public ActionResult DepartmanGuncelle(Departman d)
{
var deger = c.Departmans.Find(d.Departmanid);
deger.DepartmanAd = d.DepartmanAd;
c.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DepartmanGuncelle(Departman p)
{
var dept = c.Departmen.Find(p.DepartmanID);
dept.DepartmanAd = p.DepartmanAd;
c.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DepartmanGuncelle(Departman dpr)
{
var dpt = db.Departmans.Find(dpr.DepartmanID);
dpt.DepartmanAd = dpr.DepartmanAd;
db.SaveChanges();
return(RedirectToAction("Index"));
}
