public ActionResult Edit(int id, district district)
{
try
{
if (ModelState.IsValid)
{
int flag = DistrictsControllerManager.updateDistrict(id, district);
if (flag == 1)
{
HttpContext.Cache.Remove("results");
return(RedirectToAction("Index"));
}
}
return(View());
}
catch (Exception)
{
return(RedirectToAction("Error", "Home", new { error = "POST/Districts/Edit/int" }));
}
}
//delete method
public int deleteDistrictDB(int id, district district)
{
try
{
int flag = 0;
var result = db.districts.Where(d => d.district_id == id && d.district_status == 1).FirstOrDefault();
if (result != null)
{
db.Entry(result).State = EntityState.Detached;
db.Entry(district).State = EntityState.Modified;
db.SaveChanges();
flag = 1;
}
return(flag);
}
catch (Exception)
{
throw;
}
}
//update method
public int updateDistrictDB(int id, district district)
{
try
{
int flag = 0;
district.district_code = district.district_code.ToUpper(); //search funtion in views only accept captal for District code
var result = db.districts.Where(d => d.district_id == id && d.district_status == 1).FirstOrDefault();
if (result != null)
{
db.Entry(result).State = EntityState.Detached;
db.Entry(district).State = EntityState.Modified;
db.SaveChanges();
flag = 1;
}
return(flag);
}
catch (Exception)
{
throw;
}
}
public async Task <IActionResult> Edit(district data)
{
try
{
if (ModelState.IsValid)
{
_context.districts.Update(data);
await _context.SaveChangesAsync(_session.Id);
return(MessageBox.Show(MessageType.Success));
}
else
{
return(MessageBox.Show(MessageType.NotValid));
}
}
catch (Exception e)
{
return(MessageBox.Show(MessageType.Error));
}
}
public ActionResult Create(district district)
{
try
{
if (ModelState.IsValid)
{
int flag = DistrictsControllerManager.saveDistrict(district);
if (flag == 1)
{
HttpContext.Cache.Remove("results");
return(RedirectToAction("Index"));
}
else
{
TempData["district_code"] = "This District is already taken";
}
}
return(View());
}
catch (Exception)
{
return(RedirectToAction("Error", "Home", new { error = "POST/Districts/Create" }));
}
}
private void btnKEKaydet_Click(object sender, EventArgs e)
{
if (_plant.speciesid == null)
{
ShowMessage.Error("Tür boş bırakılamaz");
return;
}
if (_plantBLL.entities.plant.FirstOrDefault(x => x.herbno == txtKod.Text.Trim() && x.id != _plant.id) != null)
{
ShowMessage.Error(txtKod.Text + " herbaryum numarası daha önce kullanılmış değiştirin");
return;
}
_plant.localname = txtLocalName.Text;
_plant.subsp = txtSubsp.Text;
_plant.variety = txtVaryete.Text;
_plant.endemism = rdbYes.Checked;
_plant.typeexample = txtTypeExample.Text;
_plant.localite = txtlocalite.Text;
_plant.date = dtPicker.Value;
_plant.minimum = Convert.ToDouble(nmMin.Value);
_plant.maximum = Convert.ToDouble(nmMaks.Value);
_plant.diagnose = txtDiagnose.Text;
_plant.collector = txtCollector.Text;
_plant.explanation = rchDetails.Text;
_plant.herbno = txtKod.Text.Trim();
_plant.coordinates = txtCoord.Text;
//_plantBLL.addGrids(_plant, txtGrids.Text);
_plant.habitat = _plantBLL.getHabitatId(txtHabitat.Text);
city city = entities.city.FirstOrDefault(x => x.name == cmbIl.Text);
if (city != null)
{
district district = entities.district.FirstOrDefault(x => x.name == cmbIlce.Text && x.cityid == city.id);
district = district is null?entities.district.FirstOrDefault(x => x.cityid == city.id) : district;
_plant.districtid = district.id;
}
// if (_plantBLL.Location!=null && _plantBLL.Location.Valid)
// {
// _plant.latitude = Convert.ToDouble(_plantBLL.Location.DecLatitude);
// _plant.longitude = Convert.ToDouble(_plantBLL.Location.DecLongitude);
// }
if (!isUpdate)
{
_plantBLL.AddPlant(_plant);
var satir = Tablo.NewRow();
satir = SatiriDoldur(satir);
Tablo.Rows.InsertAt(satir, 0);
lblDurum.Text = _plant.herbno + " başarıyla eklendi!";
Log.Debug("[Yeni Bitki]: " + _plant.herbno, $"{_plant.herbno} kodlu {DateTime.Now.ToString()} tarihinde {UserBLL.ActiveUser.name} tarafından {cmbSpecies.Text} eklendi.\nEklenen bitkinin detayları:\n" + Log.PlantRowToJson(satir));
StartInitialize();
this._plant = new plant();
var count = entities.plant.Count();
if (count > 0)
{
var list = entities.plant.OrderBy(x => x.id).ToList();
int sayi = Convert.ToInt32(entities.plant.OrderBy(x => x.id).ToList()[0].herbno.Substring(4)) + 1;
txtKod.Text = "KNYA" + string.Format("{0:D7}", sayi);
}
else
{
txtKod.Text = "KNYA" + string.Format("{0:D7}", 28001);
}
YeniBitki();
Temizle();
timer1.Start();
pnlBildirim.Visible = true;
}
else
{
_plantBLL.UpdatePlant(_plant);
DataRow satir = GetRowOfPlant();
SatiriDoldur(satir);
satir.AcceptChanges();
Log.Debug("[Güncellenen Bitki]: " + _plant.herbno, $"{_plant.herbno} kodlu {DateTime.Now.ToString()} tarihinde {UserBLL.ActiveUser.name} tarafından {cmbSpecies.Text} güncellendi.\nDeğişiklikler:\n" + Log.DiffBetweenTwoDict(Log.PlantRowToDict(satir), oldRow) + "\nGüncelleme sonrası:\n" + Log.PlantRowToJson(satir) + "\nGüncelleme öncesi:\n" + Log.DictToJson(oldRow));
timer1.Start();
pnlBildirim.Visible = true;
lblDurum.Text = _plant.herbno + " başarıyla güncellendi!";
}
}
public static void Main(string[] args)
{
district[] districts = new district[58];
}
