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