public ActionResult UpdateIlce(Ilce model)
{
Ilce ilce = dbContext.Ilceler.Where(x => x.Id == model.Id).FirstOrDefault();
modell.sehir = dbContext.Sehirler.ToList();
if (ilce != null)
{
ilce.Ad = model.Ad;
ilce.Id = model.Id;
ilce.SehirId = model.SehirId; //Burası önemli buradaki ID durumunu çöz
int sonuc = dbContext.SaveChanges();
if (sonuc > 0)
{
ViewBag.Result = "Güncelleme işlemi başarılı.";
ViewBag.Status = "success";
}
else
{
ViewBag.Result = "Güncelleme işlemi başarısız.";
ViewBag.Status = "danger";
}
}
return(View(ilce));
}
public ActionResult Detay(int id, IlceModel model)
{
Ilce ilce = manager2.Bul(id);
model.Ilce = ilce;
return(View(model));
}
public ActionResult InsertIlce(Ilce ilce)
{
dbContext.Ilceler.Add(ilce);
dbContext.SaveChanges();
return(View());
}
public async Task <IActionResult> Edit(int id, [Bind("id,adi,telefonKodu,sehirId")] Ilce ilce)
{
if (id != ilce.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(ilce);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IlceExists(ilce.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["sehirId"] = new SelectList(_context.Sehir, "id", "adi", ilce.sehirId);
return(View(ilce));
}
private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
secilceid = (int)dataGridView1.CurrentRow.Cells[0].Value;
secilce = repılc.bul(secilceid);
txtboxılcead.Text = secilce.IlceAd;
cmbboxıl.SelectedValue = secilce.IlId;
}
public async Task <IActionResult> Edit(int?id, Ilce Ilce)
{
if (ModelState.IsValid)
{
try
{
if (id == null || id == 0)
{
await _IlceServis.AddAsync(Ilce, _loginHelper.UserHelper);
}
else
{
if (id != Ilce.Id)
{
return(NotFound());
}
await _IlceServis.UpdateAsync(Ilce, _loginHelper.UserHelper);
}
}
catch (DbUpdateConcurrencyException)
{
if (!await IlceExistsAsync(Ilce.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index) + "/" + Ilce.IlId));
}
return(View(Ilce));
}
//Update
private void button3_Click(object sender, EventArgs e)
{
try {
if (selectCombobox.SelectedIndex == 0)
{
BLL bll = new BLL();
Sehir newSehir = new Sehir(Convert.ToInt16(sehirControl.id.Text), sehirControl.ad.Text);
bll.Update <Sehir>(newSehir);
dataGridView.DataSource = bll.Get("Sehir");
}
else if (selectCombobox.SelectedItem.ToString() == "Kisi")
{
BLL bll = new BLL();
Kisi newKisi = new Kisi(Convert.ToInt16(kisiControl.id.Text), kisiControl.ad.Text, kisiControl.soyad.Text, Convert.ToInt16(kisiControl.yas.Text), kisiControl.adres.Text, kisiControl.sehir.Text, kisiControl.ilce.Text);
bll.Update <Kisi>(newKisi);
dataGridView.DataSource = bll.Get("Kisi");
}
else if (selectCombobox.SelectedItem.ToString() == "Ilce")
{
BLL bll = new BLL();
Ilce newIlce = new Ilce(Convert.ToInt16(ilceControl.id.Text), ilceControl.ad.Text, Convert.ToInt16(ilceControl.sehirId.Text));
bll.Update <Ilce>(newIlce);
dataGridView.DataSource = bll.Get("Ilce");
}
} catch {
MessageBox.Show("Error occured during update.");
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,IlceAd")] Ilce ilce)
{
if (id != ilce.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(ilce);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IlceExists(ilce.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(ilce));
}
//Insert
private void button2_Click(object sender, EventArgs e)
{
try {
BLL BLL = new BLL(); //BLL Business Logic Layer
if (selectCombobox.SelectedItem.ToString() == "Sehir")
{
Sehir newSehir = new Sehir(Convert.ToInt16(sehirControl.id.Text), sehirControl.ad.Text);
BLL.Insert <Sehir>(newSehir);
dataGridView.DataSource = BLL.Get("Sehir");
}
else if (selectCombobox.SelectedItem.ToString() == "Kisi")
{
Kisi newKisi = new Kisi(Convert.ToInt16(kisiControl.id.Text), kisiControl.ad.Text, kisiControl.soyad.Text, Convert.ToInt16(kisiControl.yas.Text), kisiControl.adres.Text, kisiControl.sehir.Text, kisiControl.ilce.Text);
BLL.Insert <Kisi>(newKisi);
dataGridView.DataSource = BLL.Get("Kisi");
}
else if (selectCombobox.SelectedItem.ToString() == "Ilce")
{
Ilce newIlce = new Ilce(Convert.ToInt16(ilceControl.id.Text), ilceControl.ad.Text, Convert.ToInt16(ilceControl.sehirId.Text));
BLL.Insert <Ilce>(newIlce);
dataGridView.DataSource = BLL.Get("Ilce");
}
} catch {
MessageBox.Show("An error occured during insert");
}
}
public bool ilce_Update(Ilce usr)
{
using (SobelediyeEntities sb = new SobelediyeEntities())
{
}
return(true);
}
public ActionResult Sil(int id, IlceModel model)
{
Ilce ilce = manager.Bul(id);
manager.Sil(ilce);
manager.Save();
return(RedirectToAction("Ilce"));
}
public IlceDTO Map(Ilce ent)
{
var ilce = new IlceDTO();
ilce.ilceAdi = ent.ilceAdi;
ilce.ilceID = ent.ilceID;
ilce.ilID = ent.ilID;
return(ilce);
}
public ActionResult Guncelle(int id, IlceModel model)
{
Ilce ilce = manager.Bul(id);
ilce.Ad = model.ilce.Ad;
ilce.IlId = model.ilce.IlId;
manager.Guncelle(ilce);
manager.Save();
return(RedirectToAction("Ilce"));
}
public ActionResult Edit([Bind(Include = "Id,Adi,SehirId")] Ilce ilce)
{
if (ModelState.IsValid)
{
_ilceService.Update(ilce);
return(RedirectToAction("Index"));
}
ViewBag.SehirId = new SelectList(_sehirService.GetList(), "Id", "Adi", ilce.SehirId);
return(View(ilce));
}
public ActionResult UpdateIlce(int?id)
{
Ilce ilce = null;
if (id != null)
{
ilce = dbContext.Ilceler.Where(x => x.Id == id).FirstOrDefault();
}
return(View(ilce));
}
private void btnekle_Click(object sender, EventArgs e)
{
Ilce i = new Ilce();
i.IlceAd = txtboxılcead.Text;
i.IlId = (int)cmbboxıl.SelectedValue;
repılc.ekle(i);
repılc.kaydet();
frmılce_Load(null, null);
}
public void IlceSil(Ilce ilce)
{
if (ilce == null)
{
throw new ArgumentNullException("ilce");
}
_ilceDepo.Sil(ilce);
_olayYayınlayıcı.OlaySilindi(ilce);
}
public void IlceGüncelle(Ilce ilce)
{
if (ilce == null)
{
throw new ArgumentNullException("ilce");
}
_ilceDepo.Güncelle(ilce);
_olayYayınlayıcı.OlayGüncellendi(ilce);
}
public ActionResult Ekle(IlceModel model)
{
Ilce ilce = new Ilce();
ilce.Ad = model.ilce.Ad;
ilce.IlId = model.ilce.IlId;
manager.Ekle(ilce);
manager.Save();
return(RedirectToAction("Ilce"));
}
private void dgwVeriler_CellClick(object sender, DataGridViewCellEventArgs e)
{
//DataGridView'den seçilen ID'yi alalım.
IlcesecilenID = Convert.ToInt32(dgwVeriler.CurrentRow.Cells[0].Value); //Veya .Cells["BirimID"] (birimkodu)
Ilce xIlce = db.Ilceler.Find(IlcesecilenID);
txtIlceAdi.Text = xIlce.IlceAdi;
cbIl.SelectedValue = xIlce.IlID;
}
public async Task <JsonResult> Sil([FromBody] IlceDTO ilceDTO)
{
Ilce ilce = new Ilce();
ilce = map.Map(ilceDTO, ilce);
ilceRep.Delete(ilce);
await ilceRep.Commit();
return(Json(ilceDTO));
}
public async Task <IActionResult> Create([Bind("Id,IlceAd")] Ilce ilce)
{
if (ModelState.IsValid)
{
_context.Add(ilce);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(ilce));
}
public async Task <Ilce> Update(Ilce entity)
{
using (var _DefaultDbContext = new DefaultDbContext())
{
_DefaultDbContext.tblIlce.Update(entity);
entity.AktifMi = true;
await _DefaultDbContext.SaveChangesAsync();
return(entity);
}
}
public ActionResult Ekle(Ilce ilce)
{
if (!ModelState.IsValid)
{
ModelState.AddModelError("", @"İlçe eklenemedi");
return(RedirectToAction("Index"));
}
ilce.CreatedDate = DateTime.Now;
_ilceRepository.Insert(ilce);
return(RedirectToAction("Index"));
}
public async Task <JsonResult> Ekle([FromBody] IlceDTO ilceDTO)
{
Ilce ilce = new Ilce();
ilce = map.Map(ilceDTO, ilce);
ilce.Id = 0;
ilceRep.Add(ilce);
await ilceRep.Commit();
return(Json(ilceDTO));
}
public async Task <IActionResult> Add(Ilce entity)
{
try
{
if (ModelState.IsValid)
{
var eklenenIlce = await _ilce.Add(entity);
await _log.Add(new Log()
{
DurumId = 1,
IslemTipId = 3,
Aciklama = entity.Ad + " İlçesi Eklendi",
KullaniciId = Convert.ToInt32(Request.Headers["current-user-id"]),
KullaniciAdi = Request.Headers["current-user-name"],
Tarih = DateTime.Now,
IP = Request.Headers["ip-address"]
});
return(CreatedAtAction("GetById", new { id = eklenenIlce.Id }, eklenenIlce));
}
else
{
await _log.Add(new Log()
{
DurumId = 2,
IslemTipId = 3,
Aciklama = entity.Ad + " İlçesi Eklenemedi",
KullaniciId = Convert.ToInt32(Request.Headers["current-user-id"]),
KullaniciAdi = Request.Headers["current-user-name"],
Tarih = DateTime.Now,
IP = Request.Headers["ip-address"]
});
return(BadRequest(ModelState));
}
}
catch (System.Exception)
{
await _log.Add(new Log()
{
DurumId = 2,
IslemTipId = 3,
Aciklama = "İlçe Servisinde Ekleme Hatası Oluştu!",
KullaniciId = Convert.ToInt32(Request.Headers["current-user-id"]),
KullaniciAdi = Request.Headers["current-user-name"],
Tarih = DateTime.Now,
IP = Request.Headers["ip-address"]
});
return(BadRequest(ModelState));
}
}
protected override void GuncelNesneOlustur()
{
CurrentEntity = new Ilce
{
Id = Id,
Kod = txtKod.Text,
IlceAdi = txtIlceAdi.Text,
IlId = _ilId,
Aciklama = txtAciklama.Text,
Durum = tglDurum.IsOn
};
}
public ActionResult DeleteMahallee(int?id)
{
if (id != null)
{
Ilce ilce = dbContext.Ilceler.Where(x => x.Id == id).FirstOrDefault();
dbContext.Ilceler.Remove(ilce);
dbContext.SaveChanges();
}
return(RedirectToAction("ListMahalle", "MahalleController"));
}
public async Task <IActionResult> Create([Bind("id,adi,telefonKodu,sehirId")] Ilce ilce)
{
if (ModelState.IsValid)
{
_context.Add(ilce);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["sehirId"] = new SelectList(_context.Sehir, "id", "adi", ilce.sehirId);
return(View(ilce));
}
public bool ilce_Delete(Ilce usr)
{
using (SobelediyeEntities sb = new SobelediyeEntities())
{
Ilce ilcec = new Ilce();
ilcec.Ilce_ID = usr.Ilce_ID;
ilcec.Ilce1 = usr.Ilce1;
sb.Ilce.Remove(ilcec);
sb.SaveChanges();
}
return(true);
}
