private void button9_Click(object sender, EventArgs e)
{
if (txt_idloaihang.TextLength == 0)
{
MessageBox.Show("Chưa nhập ID loại hàng");
}
else if (txt_tenloaihang.TextLength == 0)
{
MessageBox.Show("Chưa nhập tên loại hàng");
}
else if (txt_mota.TextLength == 0)
{
MessageBox.Show("Chưa nhập mô tả");
}
else
{
DTO_LoaiHang dto_loaihang = new DTO_LoaiHang();
dto_loaihang.idloaihang = txt_idloaihang.Text;
dto_loaihang.tenloaihang = txt_tenloaihang.Text;
dto_loaihang.mota = txt_mota.Text;
BUS_LoaiHang bus_loaihang = new BUS_LoaiHang();
bus_loaihang.insert_loaihang(dto_loaihang);
Quan_Ly_Load(sender, e);
reset_loaihang();
}
}
public bool ThemLoaiHang(DTO_LoaiHang dl)
{
string query = string.Empty;
query += "INSERT INTO [tblnhomhang] ([ten]) ";
query += "VALUES (@tennh)";
using (SqlConnection con = new SqlConnection(connectionString)) {
using (SqlCommand cmd = new SqlCommand()) {
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@tennh", dl.TenLoaiHang);
try {
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
con.Close();
con.Dispose();
return(true);
}
else
{
con.Close();
return(false);
}
} catch {
con.Close();
return(false);
}
}
}
}
public int delete_loaihang(DTO_LoaiHang dto_loaihang)
{
int parameter = 1;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@idloaihang";
values[0] = dto_loaihang.idloaihang;
string sql = "delete_loaihang";
return(ketnoi.Execute(sql, name, values, parameter));
}
private void button7_Click(object sender, EventArgs e)
{
DTO_LoaiHang dto_loaihang = new DTO_LoaiHang();
dto_loaihang.idloaihang = txt_idloaihang.Text;
BUS_LoaiHang bus_loaihang = new BUS_LoaiHang();
bus_loaihang.delete_loaihang(dto_loaihang);
Quan_Ly_Load(sender, e);
reset_loaihang();
}
private void button6_Click(object sender, EventArgs e)
{
DTO_LoaiHang dto_loaihang = new DTO_LoaiHang();
dto_loaihang.idloaihang = txt_idloaihang.Text;
dto_loaihang.tenloaihang = txt_tenloaihang.Text;
dto_loaihang.mota = txt_mota.Text;
BUS_LoaiHang bus_loaihang = new BUS_LoaiHang();
bus_loaihang.update_loaihang(dto_loaihang);
Quan_Ly_Load(sender, e);
reset_loaihang();
}
public int update_loaihang(DTO_LoaiHang dto_loaihang)
{
int parameter = 3;
string[] name = new string[parameter];
object[] values = new object[parameter];
name[0] = "@idloaihang";
name[1] = "@tenloaihang";
name[2] = "@mota";
values[0] = dto_loaihang.idloaihang;
values[1] = dto_loaihang.tenloaihang;
values[2] = dto_loaihang.mota;
string sql = "update_loaihang";
return(ketnoi.Execute(sql, name, values, parameter));
}
public bool SuaLoaiHang(DTO_LoaiHang dl)
{
string query = string.Empty;
query = "UPDATE [tblnhomhang] " +
"SET [ten] = @tendl " +
"WHERE [id] = @id";
//query = "SuaDaiLy";
using (SqlConnection con = new SqlConnection(connectionString)) {
using (SqlCommand cmd = new SqlCommand()) {
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@tendl", dl.TenLoaiHang);
cmd.Parameters.AddWithValue("@id", dl.Id);
//try
{
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
con.Close();
con.Dispose();
return(true);
}
else
{
con.Close();
return(false);
}
}
//catch
{
con.Close();
return(false);
}
}
}
}
public List <DTO_LoaiHang> TimKiemLoaiHang(string tukhoa)
{
List <DTO_LoaiHang> ds = new List <DTO_LoaiHang>();
string query = string.Empty;
query += "SELECT * FROM [tblnhomhang]";
query += "WHERE [ten] like '%' + @tukhoa + '%' ";
using (SqlConnection con = new SqlConnection(connectionString)) {
using (SqlCommand cmd = new SqlCommand()) {
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@tukhoa", tukhoa);
try {
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
DTO_LoaiHang dl = new DTO_LoaiHang();
dl.Id = long.Parse(reader["id"].ToString());
dl.TenLoaiHang = reader.GetString(1);
ds.Add(dl);
}
}
con.Close();
con.Dispose();
} catch {
con.Close();
return(null);
}
}
}
return(ds);
}
public List <DTO_LoaiHang> LayDanhSachLoaiHang()
{
List <DTO_LoaiHang> ds = new List <DTO_LoaiHang>();
string query = string.Empty;
query = "SELECT * FROM tblnhomhang";
using (SqlConnection con = new SqlConnection(connectionString)) {
using (SqlCommand cmd = new SqlCommand()) {
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try {
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
DTO_LoaiHang dl = new DTO_LoaiHang();
dl.Id = long.Parse(reader["id"].ToString());
dl.TenLoaiHang = reader.GetString(1);
ds.Add(dl);
}
}
con.Close();
con.Dispose();
} catch {
con.Close();
return(null);
}
}
}
return(ds);
}
public int delete_loaihang(DTO_LoaiHang dto_loaihang)
{
return(dal_loaihang.delete_loaihang(dto_loaihang));
}
public int update_loaihang(DTO_LoaiHang dto_loaihang)
{
return(dal_loaihang.update_loaihang(dto_loaihang));
}
public int insert_loaihang(DTO_LoaiHang dto_loaihang)
{
return(dal_loaihang.insert_loaihang(dto_loaihang));
}
public int check_dangky(DTO_LoaiHang dto_loaihang)
{
string sql = "select count(*) from loaihang where idloaihang='" + dto_loaihang.idloaihang + "'";
return(ketnoi.ReturnInteger(sql));
}
public bool SuaLoaiHang(DTO_LoaiHang dl)
{
return(loaihang.SuaLoaiHang(dl));
}
public bool ThemLoaiHang(DTO_LoaiHang dl)
{
return(loaihang.ThemLoaiHang(dl));
}
