public bool KhachHang_Insert(Entity.KhachHang Data)
{
try
{
using (SqlCommand dbCmd = new SqlCommand("sp_KhachHang_Insert", GetConnection()))
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@tenKH", Data.TenKH));
dbCmd.Parameters.Add(new SqlParameter("@GioiTinh", Data.GioiTinh));
dbCmd.Parameters.Add(new SqlParameter("@NgaySinh", Data.NgaySinh));
dbCmd.Parameters.Add(new SqlParameter("@TaiKhoan", Data.TaiKhoan));
dbCmd.Parameters.Add(new SqlParameter("@MatKhau", Data.MatKhau));
dbCmd.Parameters.Add(new SqlParameter("@Email", Data.Email));
dbCmd.Parameters.Add(new SqlParameter("@SDT", Data.SDT));
dbCmd.Parameters.Add(new SqlParameter("@Tinh", Data.Tinh));
dbCmd.Parameters.Add(new SqlParameter("@Quan", Data.Quan));
dbCmd.Parameters.Add(new SqlParameter("@DiaChi", Data.DiaChi));
dbCmd.Parameters.Add(new SqlParameter("@Link_Fb", Data.Link_Fb));
//dbCmd.Parameters.Add(new SqlParameter("@HinhThucThanhToan", Data.HinhThucThanhToan));
dbCmd.ExecuteNonQuery();
}
//Clear cache
System.Web.HttpContext.Current.Cache.Remove("KhachHang");
return(true);
}
catch
{
return(false);
}
}
public List <KhachHang> KhachHang_GetByTop(string Top, string Where, string Order)
{
List <Entity.KhachHang> list = new List <Entity.KhachHang>();
using (SqlCommand dbCmd = new SqlCommand("sp_KhachHang_GetByTop", GetConnection()))
{
Entity.KhachHang obj = new Entity.KhachHang();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
dr.Close();
dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.KhachHangIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
public void Update(KhachHang info)
{
string sqlQuery = "update KhachHang" +
" set TenKH=N'" + info.TenKH + "'," +
"DiaChiKH=N'" + info.DiaChiKH + "'," +
"SoDienThoai='"+info.SoDienThoai+"',"+
"Email='"+info.Email+"'"+
"where MaKH='" + info.MaKH + "'";
ExecuteNonQuery(sqlQuery);
}
public void Insert(KhachHang info)
{
string sqlQuery = "insert into KhachHang values ('" +
info.MaKH + "',N'" +
info.TenKH + "',N'" +
info.DiaChiKH + "','" +
info.SoDienThoai + "','" +
info.Email + "')";
ExecuteNonQuery(sqlQuery);
}
private void btThem_Click(object sender, RoutedEventArgs e)
{
KhachHang khachHang = new KhachHang() { MaKH = (++id).ToString(), TenKH = tbTenKhachHang.Text, DiaChiKH = tbDiaChi.Text, SoDienThoai = tbSoDienThoai.Text, Email = tbEmail.Text };
KhachHangBUS bus = new KhachHangBUS();
try
{
bus.Insert(khachHang);
MessageBox.Show("Thêm thành công !");
}
catch (Exception)
{
MessageBox.Show("Thêm thất bại !");
}
LoadData();
}
public List<KhachHang> GetList()
{
List<KhachHang> list = new List<KhachHang>();
string sqlQuery = "select * from KhachHang";
reader = ExecuteReader(sqlQuery);
while (reader.Read())
{
KhachHang khachHang = new KhachHang();
khachHang.MaKH = reader["MaKH"].ToString();
khachHang.TenKH = reader["TenKH"].ToString();
khachHang.DiaChiKH = reader["DiaChiKH"].ToString();
khachHang.SoDienThoai = reader["SoDienThoai"].ToString();
khachHang.Email = reader["Email"].ToString();
list.Add(khachHang);
}
return list;
}
private void btSua_Click(object sender, RoutedEventArgs e)
{
KhachHang khachHang = new KhachHang() { MaKH = tbMaKhachHang.Text, TenKH = tbTenKhachHang.Text, DiaChiKH = tbDiaChi.Text, SoDienThoai = tbSoDienThoai.Text, Email = tbEmail.Text };
KhachHangBUS bus = new KhachHangBUS();
try
{
bus.Update(khachHang);
MessageBox.Show("Sửa thành công !");
}
catch (Exception)
{
MessageBox.Show("Sửa thất bại !");
}
LoadData();
}
private void btThem_Click(object sender, RoutedEventArgs e)
{
// them thong tin khach hang
int idKhachHang = int.Parse(dsKhachHang[dsKhachHang.Count - 1].MaKH);
KhachHang kh = new KhachHang()
{ MaKH = (idKhachHang++).ToString(), DiaChiKH = tbDiaChi.Text, Email = tbEmail.Text, SoDienThoai = tbSoTienThu.Text, TenKH = tbHoTenKhachHang.Text };
busKhachHang.Insert(kh);
// them thong tin phieu thu tien
PhieuThuTien ptt = new PhieuThuTien()
{ };
}
public void Update(KhachHang info)
{
data.Update(info);
}
public void Insert(KhachHang info)
{
data.Insert(info);
}
