//tự động tăng ID nhân viên khi insert
public string tangIDNV()
{
DAL.SQLConnect conn = new DAL.SQLConnect();
conn.OpenConnect();
string sql = "select * from tbEmployees";
SqlCommand cmd = new SqlCommand(sql, conn.Connection);//sqlconnection
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
string id = "";
if (dt.Rows.Count <= 0)
{
id = "NV01";
}
else
{
int k = 0;
id = "NV";
k = Convert.ToInt32(dt.Rows[dt.Rows.Count - 1][0].ToString().Substring(2, 2));
k += 1;
if (k < 10)
{
id += "0";
}
id += k.ToString();
}
return(id);
}
private void btnDeleteMenu_Click(object sender, EventArgs e)
{
DAL.SQLConnect conn = new DAL.SQLConnect();
conn.OpenConnect();
string sqlDelete = "delete from tbDish where ID_dish=@ID_dish";
SqlCommand cmd = new SqlCommand(sqlDelete, conn.Connection);//sqlconnection
cmd.Parameters.AddWithValue("ID_dish", txtIDDish.Text);
cmd.Parameters.AddWithValue("Name_dish", txtNameDish.Text);
cmd.Parameters.AddWithValue("Unit_price", txtUnitPrice.Text);
cmd.ExecuteNonQuery();
showListMenu();
}
private void btnAddMenu_Click(object sender, EventArgs e)
{
DAL.SQLConnect conn = new DAL.SQLConnect();
conn.OpenConnect();
string sqlAdd = "insert into tbDish values(@ID_dish,@Name_dish,@Unit_price)";
SqlCommand cmd = new SqlCommand(sqlAdd, conn.Connection);//sqlconnection
cmd.Parameters.AddWithValue("ID_dish", txtIDDish.Text);
cmd.Parameters.AddWithValue("Name_dish", txtNameDish.Text);
cmd.Parameters.AddWithValue("Unit_price", txtUnitPrice.Text);
cmd.ExecuteNonQuery();
showListMenu();
}
public void showListNhanVien()
{
//DAL.SQLConnect conn = new DAL.SQLConnect();
//dataGridViewNV.DataSource = conn.getDataTable("tbEmployees");
clearLsvNhanVien();
DAL.SQLConnect conn = new DAL.SQLConnect();
SqlDataReader dr = conn.getDataTableNV("tbEmployees");
while (dr.Read())
{
addlist(dr);
}
}
public void LoadComboBox2()
{
try
{
DAL.SQLConnect provider = new DAL.SQLConnect();
string query = ("select Name_employees,ID_employees from tbEmployees");
cbbNameEmployees.DataSource = provider.ExecuteQuery(query);
cbbNameEmployees.DisplayMember = "Name_employees";
cbbNameEmployees.ValueMember = "Name_employees";
}
catch (Exception ex)
{
new Exception("Error " + ex.ToString());
}
}
//phạm ngọc đạt
#region tabPage BanHang
public void LoadComboBox()
{
try
{
DAL.SQLConnect provider = new DAL.SQLConnect();
string query = "select Name_dish,Unit_price from tbDish";
cbbNameEat.DataSource = provider.ExecuteQuery(query);
cbbNameEat.DisplayMember = "Name_dish";
cbbNameEat.ValueMember = "Name_dish";
}
catch (Exception ex)
{
throw new Exception("Error " + ex.ToString());
}
}
private void btnSearchDish_Click(object sender, EventArgs e)
{
DAL.SQLConnect conn = new DAL.SQLConnect();
conn.OpenConnect();
string sqlSearchID = "select* from tbDish where ID_dish=@ID_dish";
SqlCommand cmd = new SqlCommand(sqlSearchID, conn.Connection);//sqlconnection
cmd.Parameters.AddWithValue("ID_dish", txtSearchDish.Text);
cmd.ExecuteNonQuery();
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dGvMenu.DataSource = dt;
}
//Trần Phương Thảo
#region tabPage Menu
public void showListMenu()
{
DAL.SQLConnect conn = new DAL.SQLConnect();
dGvMenu.DataSource = conn.getDataTable("tbDish");
}