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();
}
