protected void customerGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
Global_Connection gc = new Global_Connection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
string index = Convert.ToString(e.CommandArgument);
string strData = "Select * From customer Where mid='" + index + "'";
SqlDataAdapter da = new SqlDataAdapter(strData, gc.cn);
DataSet ds = new DataSet();
da.Fill(ds, "tbl_customer1");
DataTable dt = ds.Tables[0];
//.Text = dt.Rows[0]["mid"].ToString();
txtCustomerName.Text = dt.Rows[0]["name"].ToString();
txtCustomerAddress.Text = dt.Rows[0]["address"].ToString();
txtPhone.Text = dt.Rows[0]["phone"].ToString();
txtEmail.Text = dt.Rows[0]["email"].ToString();
cmboMember.Text = dt.Rows[0]["memberType"].ToString();
lblId.Text = dt.Rows[0]["mid"].ToString();
btnAdd.Visible = false;
btnDelete.Visible = true;
btnUpdate.Visible = true;
}
protected void itemGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
Global_Connection gc = new Global_Connection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
string index = Convert.ToString(e.CommandArgument);
string strData = "Select * From item Where itemId='" + index + "'";
SqlDataAdapter da = new SqlDataAdapter(strData, gc.cn);
DataSet ds = new DataSet();
da.Fill(ds, "item");
DataTable dt = ds.Tables[0];
//.Text = dt.Rows[0]["mid"].ToString();
txtItemName.Text = dt.Rows[0]["name"].ToString();
txtDescription.Text = dt.Rows[0]["description"].ToString();
txtItemPrice.Text = dt.Rows[0]["price"].ToString();
txtItemQty.Text = dt.Rows[0]["quantity"].ToString();
txtPurchaseDate.Text = dt.Rows[0]["purchaseDate"].ToString();
cmboCategory.SelectedValue = dt.Rows[0]["category"].ToString();
cmboSupplier.SelectedValue = dt.Rows[0]["supplier"].ToString();
lblId.Text = dt.Rows[0]["itemId"].ToString();
btnAdd.Visible = false;
btnUpdate.Visible = true;
}
protected void categoryGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
Global_Connection gc = new Global_Connection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
string index = Convert.ToString(e.CommandArgument);
string strData = "Select * From category Where categoryId='" + index + "'";
SqlDataAdapter da = new SqlDataAdapter(strData, gc.cn);
DataSet ds = new DataSet();
da.Fill(ds, "category");
DataTable dt = ds.Tables[0];
//.Text = dt.Rows[0]["mid"].ToString();
txtCategoryName.Text = dt.Rows[0]["categoryName"].ToString();
lblId.Text = dt.Rows[0]["categoryId"].ToString();
}
protected void supplierGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
Global_Connection gc = new Global_Connection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
string index = Convert.ToString(e.CommandArgument);
string strData = "Select * From supplier Where supplierId='" + index + "'";
SqlDataAdapter da = new SqlDataAdapter(strData, gc.cn);
DataSet ds = new DataSet();
da.Fill(ds, "supplier");
DataTable dt = ds.Tables[0];
//.Text = dt.Rows[0]["mid"].ToString();
txtSupplierName.Text = dt.Rows[0]["supplierName"].ToString();
txtAddress.Text = dt.Rows[0]["address"].ToString();
txtPhoneNumber.Text = dt.Rows[0]["phone"].ToString();
txtSupplierEmail.Text = dt.Rows[0]["email"].ToString();
lblId.Text = dt.Rows[0]["supplierId"].ToString();
}
protected void userGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
Global_Connection gc = new Global_Connection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = gc.cn;
string index = Convert.ToString(e.CommandArgument);
string strData = "Select * From credential Where id='" + index + "'";
SqlDataAdapter da = new SqlDataAdapter(strData, gc.cn);
DataSet ds = new DataSet();
da.Fill(ds, "credential");
DataTable dt = ds.Tables[0];
//.Text = dt.Rows[0]["mid"].ToString();
txtUsername.Text = dt.Rows[0]["username"].ToString();
txtEmail.Text = dt.Rows[0]["email"].ToString();
txtPassword.Text = dt.Rows[0]["password"].ToString();
checkIsAdmin.Checked = bool.Parse(dt.Rows[0]["isAdmin"].ToString());
lblId.Text = dt.Rows[0]["id"].ToString();
btnAddUser.Visible = false;
btnUpdate.Visible = true;
}
public String AddSale(double totalAmount, int customerId, int staffId, int itemId, int quantity)
{
try
{
DateTime date = DateTime.Today;
Global_Connection gc = new Global_Connection();
SqlCommand cmd = new SqlCommand("Insert into sales(totalAmount, dateTime, customerId, staffId, itemId, quantity) values(@totalAmount, @dateTime, @customerId, @staffId, @itemId, @quantity)", gc.cn);
// cmd.Parameters.AddWithValue("@category", Category);
cmd.Parameters.AddWithValue("@totalAmount", totalAmount);
cmd.Parameters.AddWithValue("@dateTime", date);
cmd.Parameters.AddWithValue("@customerId", customerId);
cmd.Parameters.AddWithValue("@staffId", staffId);
cmd.Parameters.AddWithValue("@itemId", itemId);
cmd.Parameters.AddWithValue("@quantity", quantity);
cmd.ExecuteNonQuery();
gc.cn.Close();
return(ChangeQuantity(itemId, quantity));
}
catch (Exception ex)
{
return(ex.Message);
}
}