public ActionResult Create(MARKA marka)
{
if (ModelState.IsValid)
{
if (marka.MARKA_ADI != null)
{
db.MARKAs.Add(marka);
}
if (marka.MARKA_REFNO == 0)
{
db.MARKAs.Add(marka);
}
else
{
db.Entry(marka).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
else
{
string hatalar = "";
foreach (var item in ModelState.Values)
{
for (int i = 0; i < item.Errors.Count; i++)
{
hatalar += item.Errors[i].ErrorMessage;
}
}
ViewData["hatalar"] = hatalar;
return(View(marka));
}
return(RedirectToAction("Index"));
}
protected void Button3_Click(object sender, EventArgs e)
{
//kaydet
if (txtMARKA_REFNO.Text != "") //ekranda kayıt varsa
{
int refno = Convert.ToInt32(txtMARKA_REFNO.Text);
MARKA k = db.MARKAs.Find(refno);
k.MARKA_ADI = txtMARKA_ADI.Text;
k.MARKA_REFNO = Convert.ToInt32(txtMARKA_REFNO.Text);
db.SaveChanges();
}
else
{
MARKA k = new MARKA();
k.MARKA_ADI = txtMARKA_ADI.Text;
db.MARKAs.Add(k);//yeni kayıt dbset e ekleniyor.
db.SaveChanges();
}
//degisikliklerin ekrana yansıtılması için
GridView1.DataSource = db.MARKAs.ToList();
GridView1.DataBind();
//kaydet i kapat listeyi ac
pnlMarkaKayit.Visible = false;
pnlMarkaListe.Visible = true;
}
public ActionResult MarkaGuncelle(int?id, MARKA m)
{
var marka = ctx.MARKA.Find(id);
if (ModelState.IsValid)
{
ctx.MARKA.Add(m);
}
return(View(marka));
}
public ActionResult Create(int?id)
{
if (id == null)
{
MARKA m1 = new MARKA();
return(View(m1));
}
MARKA m = db.MARKAs.Find(id);
return(View(m));
}
public ActionResult Delete(int id)
{
MARKA m = db.MARKAs.Find(id);
if (m != null)
{
db.MARKAs.Remove(m);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
//SEÇ
int refno = Convert.ToInt32(GridView1.SelectedDataKey.Value);
MARKA m = db.MARKAs.Find(refno);
txtMARKA_REFNO.Text = Convert.ToString(m.MARKA_REFNO);
txtMARKA_ADI.Text = m.MARKA_ADI;
pnlKAYIT.Visible = true;
pnlLISTE.Visible = false;
}
public ActionResult Create(MARKA m)
{
if (m.MARKA_REFNO == 0)
{
db.MARKAs.Add(m);
}
else
{
db.Entry(m).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
[HttpGet] // link üzerinden geliyor
public ActionResult Create(int?id) // int? id null olabilir demek
{
if (id == null)
{
MARKA m = new MARKA();
return(View(m));
}
else
{
MARKA m = db.MARKAs.Find(id);
return(View(m));
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int refno = Convert.ToInt32(GridView1.SelectedDataKey.Value.ToString());
MARKA m = db.MARKAs.Find(refno);
if (m != null)
{
txtMARKA_ADI.Text = m.MARKA_ADI;
txtMARKA_REFNO.Text = m.MARKA_REFNO.ToString();
}
pnlKayit.Visible = true;
pnlListe.Visible = false;
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int refno = Convert.ToInt32(GridView1.SelectedDataKey.Value);
MARKA k = db.MARKAs.Find(refno);
if (k != null)
{
txtMARKA_ADI.Text = k.MARKA_ADI;
txtMARKA_REFNO.Text = k.MARKA_REFNO.ToString();
}
//kayıt panelini ac liste panelini kapat
pnlMarkaKayit.Visible = true;
pnlMarkaListe.Visible = false;
}
protected void Button5_Click(object sender, EventArgs e)
{
//SİL
if (txtMARKA_REFNO.Text != "")
{
MARKA m = db.MARKAs.Find(Convert.ToInt32(txtMARKA_REFNO.Text));
db.MARKAs.Remove(m);
db.SaveChanges();
GridView1.DataSource = db.MARKAs.Where(marka => marka.MARKA_ADI != "Markasız").ToList();
GridView1.DataBind();
pnlKAYIT.Visible = false;
pnlLISTE.Visible = true;
}
}
protected void Button5_Click(object sender, EventArgs e)
{ // SİL
if (txtMARKA_REFNO.Text != "")
{
int refno = Convert.ToInt32(txtMARKA_REFNO.Text);
MARKA m = db.MARKAs.Find(refno);
db.MARKAs.Remove(m);
db.SaveChanges();
GridView1.DataSource = db.MARKAs.ToList();
GridView1.DataBind();
pnlKayit.Visible = false;
pnlListe.Visible = true;
}
}
protected void Button3_Click(object sender, EventArgs e)
{ // KAYDET
if (txtMARKA_REFNO.Text != "")
{
int refno = Convert.ToInt32(txtMARKA_REFNO.Text);
MARKA m = db.MARKAs.Find(refno);
m.MARKA_ADI = txtMARKA_ADI.Text;
}
else
{
MARKA m = new MARKA();
m.MARKA_ADI = txtMARKA_ADI.Text;
db.MARKAs.Add(m);
db.SaveChanges();
}
GridView1.DataSource = db.MARKAs.ToList();
GridView1.DataBind();
pnlKayit.Visible = false;
pnlListe.Visible = true;
}
protected void Button3_Click(object sender, EventArgs e)
{
// KAYDET
if (txtMARKA_REFNO.Text != "") // güncelle
{
MARKA m = db.MARKAs.Find(Convert.ToInt32(txtMARKA_REFNO.Text));
m.MARKA_ADI = txtMARKA_ADI.Text;
db.SaveChanges();
}
else // yeni kayıt
{
MARKA m = new MARKA();
m.MARKA_ADI = txtMARKA_ADI.Text;
db.MARKAs.Add(m);
db.SaveChanges();
}
GridView1.DataSource = db.MARKAs.Where(m => m.MARKA_ADI != "Markasız").ToList();
GridView1.DataBind();
pnlKAYIT.Visible = false;
pnlLISTE.Visible = true;
}
public bool MarkaEkle(MARKA m)
{
var markaVarmi = ctx.MARKA.FirstOrDefault(x => x.MARKA1 == m.MARKA1);
bool basarili = false;
if (ModelState.IsValid && markaVarmi == null)
{
m.SILINDI = false;
ctx.MARKA.Add(m);
}
else if (ModelState.IsValid)
{
markaVarmi.SILINDI = false;
ctx.Entry(markaVarmi).State = EntityState.Modified;
}
int sonuc = ctx.SaveChanges();
if (sonuc > 0)
{
basarili = true;
}
return(basarili);
}
public ActionResult MarkaGuncelle(MARKA m)
{
bool basarili = false;
try
{
if (ModelState.IsValid)
{
m.SILINDI = false;
ctx.Entry(m).State = EntityState.Modified;
int sonuc = ctx.SaveChanges();
if (sonuc > 0)
{
basarili = true;
}
}
}
catch (DbEntityValidationException ex)
{
Response.Write(ex);
}
return(RedirectToAction("/MarkaTanimKarti"));
}
