protected void SupplierGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { SupplierGridView.DataSource = SupplierBizLogic.ListSupplier(); SupplierGridView.PageIndex = e.NewPageIndex; SupplierGridView.DataBind(); BindGrid(); }
protected void loadSuppliers() { var conn = new MySqlConnection(strcon); conn.Open(); string getdata = "SELECT * FROM Supplier INNER JOIN Contact ON Supplier.SupId = Contact.SupId WHERE Supplier.SupId = '" + supplierTB.Text + "' AND Main = '1'"; var cmd = new MySqlCommand(getdata, conn); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); int count = ds.Tables[0].Rows.Count; if (ds.Tables[0].Rows.Count > 0) { SupplierGridView.DataSource = ds; SupplierGridView.DataBind(); } else { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); SupplierGridView.DataSource = ds; SupplierGridView.DataBind(); int columncount = SupplierGridView.Rows[0].Cells.Count; lblmsg.Text = " No data found !!!"; } }
void addSupplier() { try { SqlConnection con = new SqlConnection(connection); if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("INSERT INTO supplier (supplier_id, supplier_name) VALUES(@id, @name )", con); cmd.Parameters.AddWithValue("@id", txtSupId.Text.Trim()); cmd.Parameters.AddWithValue("@name", txtSupName.Text.Trim()); cmd.ExecuteNonQuery(); con.Close(); Response.Write("<script>alert('Supplier added successfully');</script>"); txtSupId.Text = ""; txtSupName.Text = ""; SupplierGridView.DataBind(); } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } }
void deletesupplier() //deleting supplier { try { SqlConnection con = new SqlConnection(connection); if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("DELETE FROM supplier WHERE supplier_id=@id", con); cmd.Parameters.AddWithValue("@id", txtSupId.Text.Trim()); cmd.ExecuteNonQuery(); con.Close(); Response.Write("<script>alert('Supplier Delete Successful.');</script>"); txtSupId.Text = ""; txtSupName.Text = ""; SupplierGridView.DataBind(); } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); } }
private void SupplierGridView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { try { if (SupplierGridView.GetFocusedRow() is Suppliers item) { if (MessageBox.Show("Do you want to submit this?", "Submit", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } UnitOfWork unitOfWork = new UnitOfWork(); if (item.Id == 0) { unitOfWork.SuppliersRepo.Insert(item); } else { unitOfWork.SuppliersRepo.Update(item); } unitOfWork.Save(); } } catch (Exception exception) { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var controller = new SupplierController(); SupplierGridView.DataSource = controller.ListSuppliers(); SupplierGridView.DataBind(); } }
private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { try { if (SupplierGridView.GetFocusedRow() is Suppliers item) { if (MessageBox.Show("Do you want to submit this?", "Submit", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } UnitOfWork unitOfWork = new UnitOfWork(); unitOfWork.SuppliersRepo.Delete(item); unitOfWork.Save(); Init(); } } catch (Exception exception) { } }
private void BindGrid() { SupplierGridView.DataSource = SupplierBizLogic.ListSupplier(); SupplierGridView.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SupplierGridView.DataBind(); }