protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["id"]))
{
AddEdit = Convert.ToInt32(Request.QueryString["id"]);
}
else
{
AddEdit = 0;
}
if (!Page.IsPostBack)
{
if (AddEdit != 0)
{
btnKaydet.Text = "Düzenle";
MUSTERI mst = MUSTERICRUD.IdyeGoreMUSTERIGetir(AddEdit);
tbK_Ad.Text = mst.K_AD;
tbAd.Text = mst.AD;
tbCep.Text = mst.CEP_TEL;
tbTel.Text = mst.TEL;
tbAdres.Text = mst.ADRES;
}
MUSGetir();
}
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
try
{
MUSTERI mn = new MUSTERI();
mn.K_AD = tbK_Ad.Text;
mn.AD = tbAd.Text;
mn.CEP_TEL = tbCep.Text;
mn.TEL = tbTel.Text;
mn.ADRES = tbAdres.Text;
string sonuc = String.Empty;
if (AddEdit == 0)
{
MUSTERICRUD.Kaydet(mn);
sonuc = "Kaydetme";
Temizle();
}
else
{
mn.ID = AddEdit;
MUSTERICRUD.Guncelle(mn);
sonuc = "Güncelleme";
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "bilgi", "$.jGrowl('" + sonuc + " Başarılı" + "', { header: 'Sonuç' });", true);
MUSGetir();
}
catch
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "bilgi", "$.jGrowl('" + "İşleminizde Hata Oluştu Lütfen Kontrol Ediniz!" + "', { header: 'Sonuç' });", true);
}
}
public bool Update(MusteriDetayDTO entity)
{
MUSTERI musteri = new MUSTERI();
musteri.ID = entity.ID;
musteri.MusterAd = entity.MusteriAd;
return(dao.Update(musteri));
}
public ActionResult DeleteConfirmed(decimal id)
{
MUSTERI musteri = db.MUSTERI.Find(id);
db.MUSTERI.Remove(musteri);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool Insert(MusteriDetayDTO entity)
{
MUSTERI musteri = new MUSTERI();
musteri.MusterAd = entity.MusteriAd;
musteri.isDeleted = false;
return(dao.Insert(musteri));
}
public ActionResult Details(decimal id = 0)
{
MUSTERI musteri = db.MUSTERI.Find(id);
if (musteri == null)
{
return(HttpNotFound());
}
return(View(musteri));
}
public ActionResult Edit(MUSTERI musteri)
{
if (ModelState.IsValid)
{
db.Entry(musteri).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ILID = new SelectList(db.IL, "ID", "ILADI", musteri.ILID);
return(View(musteri));
}
public ActionResult Edit(decimal id = 0)
{
MUSTERI musteri = db.MUSTERI.Find(id);
if (musteri == null)
{
return(HttpNotFound());
}
ViewBag.ILID = new SelectList(db.IL, "ID", "ILADI", musteri.ILID);
return(View(musteri));
}
public ActionResult Create(MUSTERI musteri)
{
if (ModelState.IsValid)
{
db.MUSTERI.Add(musteri);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ILID = new SelectList(db.IL, "ID", "ILADI", musteri.ILID);
return(View(musteri));
}
public bool Delete(MusteriDetayDTO entity)
{
MUSTERI musteri = new MUSTERI();
musteri.ID = entity.ID;
dao.Delete(musteri);
SATIM satis = new SATIM();
satis.MusteriID = entity.ID;
satisdao.Delete(satis);
return(true);
}
public static void Guncelle(MUSTERI p)
{
SQLiteCommand cm = DBCon.KomutOlustur("update MUSTERI set K_AD=@K_AD,AD=@AD,ADRES=@ADRES,CEP_TEL=@CEP_TEL,TEL=@TEL where ID=@ID");
cm.Parameters.AddWithValue("@K_AD", p.K_AD);
cm.Parameters.AddWithValue("@AD", p.AD);
cm.Parameters.AddWithValue("@ADRES", p.ADRES);
cm.Parameters.AddWithValue("@CEP_TEL", p.CEP_TEL);
cm.Parameters.AddWithValue("@TEL", p.TEL);
cm.Parameters.AddWithValue("@ID", p.ID);
cm.Connection.Open();
cm.ExecuteNonQuery();
cm.Connection.Close();
}
public static void Kaydet(MUSTERI p)
{
SQLiteCommand cm = DBCon.KomutOlustur("insert into MUSTERI(ID,K_AD,AD,ADRES,CEP_TEL,TEL)values (@ID,@K_AD,@AD,@ADRES,@CEP_TEL,@TEL)");
cm.Parameters.AddWithValue("@ID", null);
cm.Parameters.AddWithValue("@K_AD", p.K_AD);
cm.Parameters.AddWithValue("@AD", p.AD);
cm.Parameters.AddWithValue("@ADRES", p.ADRES);
cm.Parameters.AddWithValue("@CEP_TEL", p.CEP_TEL);
cm.Parameters.AddWithValue("@TEL", p.TEL);
cm.Connection.Open();
cm.ExecuteNonQuery();
cm.Connection.Close();
}
public static MUSTERI IdyeGoreMUSTERIGetir(int ID)
{
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from MUSTERI where ID=@ID", DBCon.BaglantiYap());
da.SelectCommand.Parameters.AddWithValue("@ID", ID);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count != 0)
{
MUSTERI m = new MUSTERI();
m.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
m.K_AD = Convert.ToString(dt.Rows[0]["K_AD"]);
m.AD = Convert.ToString(dt.Rows[0]["AD"]);
m.ADRES = Convert.ToString(dt.Rows[0]["ADRES"]);
m.CEP_TEL = Convert.ToString(dt.Rows[0]["CEP_TEL"]);
m.TEL = Convert.ToString(dt.Rows[0]["TEL"]);
return(m);
}
else
{
return(null);
}
}
