private void btnSil_Click(object sender, EventArgs e) { if (lstRaf.SelectedItems.Count > 0) { int silinecekShelfID = (int)lstRaf.SelectedValue; DialogResult result = MessageBox.Show("Silmek istediğinize emin misiniz ?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { EShelf shelf = new EShelf(); shelf.ID = silinecekShelfID; if (BLLShelf.Delete(shelf)) { MessageBox.Show("Silme işleminiz başarıyla tamamlanmıştır."); lstRaf.DataSource = BLLShelf.GetAll(); } else { MessageBox.Show("Bir hata oluştu!"); } } } else { MessageBox.Show("Lütfen silmek istediğiniz rafı seçiniz!"); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (Request.QueryString["ID"] != null) { EShelf shelf = new EShelf(); shelf.ID = int.Parse(Request.QueryString["ID"]); bool sonuc = BLLShelf.Delete(shelf); if (sonuc) { Response.Write("<script>alert('Harika! Silindi!')</script>"); } else { Response.Write("<script>alert('Hay Aksi! Silinemedi!')</script>"); } } rptRaflar.DataSource = BLLShelf.GetAll(); rptRaflar.DataBind(); if (Request.QueryString["scs"] != null) { int scsID = Convert.ToInt32(Request.QueryString["scs"].ToString()); if (scsID == 1) { Response.Write("<script>alert('Harika! Güncellendi!');</script>"); } } }
protected void btnGuncelle_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtRafNo.Text)) { EShelf guncellenecek = new EShelf(); guncellenecek.Category = new ECategories(); guncellenecek.ID = int.Parse(Request.QueryString["shelfID"]); guncellenecek.ShelfNo = txtRafNo.Text; guncellenecek.Category.ID = Convert.ToInt32(cmbRafTuru.SelectedValue); bool sonuc = BLLShelf.Update(guncellenecek); if (sonuc) { Response.Write("<script>alert('Harika! Güncellendi!');</script>"); Response.Redirect("Raflar.aspx?scs=1"); } else { Response.Write("<script>alert('Hay Aksi! Hata Oluştu!')</script>"); } } else { Response.Write("<script>alert('Raf numarası boş geçilemez.')</script>"); } }
public static void Delete(EShelf shelf) { SqlCommand cmd = new SqlCommand("spShelf_Delete", Baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("shelfID", shelf.ID); Baglanti.conn.Open(); cmd.ExecuteNonQuery(); Baglanti.conn.Close(); }
public static void InsertNewShelf(EShelf shelf) { SqlCommand cmd = new SqlCommand("spShelf_Insert", Baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ShelfNo", shelf.ShelfNo); cmd.Parameters.AddWithValue("@CategoryID", shelf.Category.ID); Baglanti.conn.Open(); cmd.ExecuteNonQuery(); Baglanti.conn.Close(); }
public static bool InsertNewShelf(EShelf shelf) { if (shelf.ShelfNo == "" || shelf.Category.ID < 1) { return(false); } else { DALShelf.InsertNewShelf(shelf); return(true); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { cmbRafTuru.DataSource = BLLCategories.GetAll(); cmbRafTuru.DataTextField = "Name"; cmbRafTuru.DataValueField = "ID"; cmbRafTuru.DataBind(); int shelfID = Convert.ToInt32(Request.QueryString["shelfID"].ToString()); EShelf shelf = new EShelf(); shelf.Category = new ECategories(); shelf = BLLShelf.GetIdOnly(shelfID);; txtRafNo.Text = shelf.ShelfNo; cmbRafTuru.SelectedValue = shelf.Category.ID.ToString(); } }
public static EShelf GetIdOnly(int shelfID) { SqlCommand cmd = new SqlCommand("spShelf_GetIdOnly", Baglanti.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ShelfID", shelfID); Baglanti.conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); EShelf shelf = new EShelf(); shelf.Category = new ECategories(); while (dr.Read()) { shelf.ID = Convert.ToInt32(dr["ID"]); shelf.ShelfNo = dr["ShelfNo"].ToString(); shelf.Category.Name = dr["Name"].ToString(); } dr.Close(); Baglanti.conn.Close(); return(shelf); }
public static List <EShelf> GetAll() { SqlCommand cmd = new SqlCommand("spShelf_GetAll", Baglanti.conn); Baglanti.conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); List <EShelf> sliste = new List <EShelf>(); while (dr.Read()) { EShelf e = new EShelf(); e.Category = new ECategories(); e.ID = Convert.ToInt32(dr["ID"]); e.ShelfNo = dr["ShelfNo"].ToString(); e.Category.Name = dr["Name"].ToString(); sliste.Add(e); } dr.Close(); Baglanti.conn.Close(); return(sliste); }
private void btnEkle_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtRafNo.Text)) { List <EShelf> shelfList = BLLShelf.GetAll(); shelfList = (from l in shelfList where l.ShelfNo.Trim().ToLower().Equals(txtRafNo.Text.Trim().ToLower()) select l).ToList(); if (shelfList.Count == 0) { EShelf shelf = new EShelf(); shelf.Category = new ECategories(); shelf.ShelfNo = txtRafNo.Text; shelf.Category.ID = Convert.ToInt32(cmbRafTuru.SelectedValue); if (BLLShelf.InsertNewShelf(shelf)) { MessageBox.Show("Yeni raf kayıt işlemi başarıyla tamamlanmıştır!"); lstRaf.DataSource = BLLShelf.GetAll(); txtRafNo.Clear(); txtRafNo.Focus(); } else { MessageBox.Show("Bir hata oluştu!"); } } else { MessageBox.Show("Kaydetmek istediğiniz raf zaten kayıtlı!"); } } else { MessageBox.Show("Raf numarası boş geçilemez!"); } }
protected void btnKaydet_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtRafNo.Text)) { List <EShelf> shelfList = BLLShelf.GetAll(); shelfList = (from l in shelfList where l.ShelfNo.Trim().ToLower().Equals(txtRafNo.Text.Trim().ToLower()) select l).ToList(); if (shelfList.Count == 0) { EShelf shelf = new EShelf(); shelf.Category = new ECategories(); shelf.ShelfNo = txtRafNo.Text; shelf.Category.ID = Convert.ToInt32(cmbRafTuru.SelectedValue); if (BLLShelf.InsertNewShelf(shelf)) { Response.Write("<script>alert('Raf kayıt işleminiz başarıyla gerçekleşmiştir.')</script>"); } else { Response.Write("<script>alert('Hata Oluştu!')</script>"); } } else { Response.Write("<script>alert('Kaydetmek istediğiniz raf zaten kayıtlı!')</script>"); } txtRafNo.Text = String.Empty; cmbRafTuru.ClearSelection(); txtRafNo.Focus(); } else { Response.Write("<script>alert('Raf numarası boş geçilemez!')</script>"); } }
public static bool Delete(EShelf shelf) { DALShelf.Delete(shelf); return(true); }
public static bool Update(EShelf shelf) { DALShelf.Update(shelf); return(true); }