public Cls_KhachHang_DTA(Cls_KhachHang_DTA KH_Data) { MaKH = KH_Data.MaKH; TenKH = KH_Data.TenKH; TheCard = KH_Data.TheCard; NgaySinh = KH_Data.NgaySinh; Phai = KH_Data.Phai; DienThoai = KH_Data.DienThoai; DiaChi = KH_Data.DiaChi; Email = KH_Data.Email; HinhThucDK = KH_Data.HinhThucDK; MaLoaiKH = KH_Data.MaLoaiKH; }
public void Insert_Update_Delete_KH(Cls_KhachHang_DTA KH_Data,string sThucThi) { sConn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SP_KhachHang"; cmd.Connection = this.sConn; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MaKH", SqlDbType.Char); cmd.Parameters["@MaKH"].Value = KH_Data.MaKH; cmd.Parameters.Add("@TenKH", SqlDbType.NVarChar); cmd.Parameters["@TenKH"].Value = KH_Data.TenKH; cmd.Parameters.Add("@TheCard", SqlDbType.NVarChar); cmd.Parameters["@TheCard"].Value = KH_Data.TheCard; cmd.Parameters.Add("@NgaySinh", SqlDbType.DateTime); cmd.Parameters["@NgaySinh"].Value = KH_Data.NgaySinh; cmd.Parameters.Add("@Phai", SqlDbType.Bit); cmd.Parameters["@Phai"].Value = KH_Data.Phai; cmd.Parameters.Add("@DienThoai", SqlDbType.NVarChar); cmd.Parameters["@DienThoai"].Value = KH_Data.DienThoai; cmd.Parameters.Add("@DiaChi", SqlDbType.NVarChar); cmd.Parameters["@DiaChi"].Value = KH_Data.DiaChi; cmd.Parameters.Add("@Email", SqlDbType.NVarChar); cmd.Parameters["@Email"].Value = KH_Data.Email ; cmd.Parameters.Add("@HinhThucDK", SqlDbType.NVarChar); cmd.Parameters["@HinhThucDK"].Value = KH_Data.HinhThucDK; cmd.Parameters.Add("@MaLoaiKH", SqlDbType.Char); cmd.Parameters["@MaLoaiKH"].Value = KH_Data.MaLoaiKH; cmd.Parameters.Add("@sqlTemp", SqlDbType.NVarChar); if(sThucThi=="Insert"||sThucThi=="Delete"||sThucThi=="Update") cmd.Parameters["@sqlTemp"].Value = sThucThi; cmd.ExecuteNonQuery(); sConn.Close(); }
public void Insert_Update_Delete(Cls_KhachHang_DTA KH_DATA,string sThucThi) { KH_BUS.Insert_Update_Delete_KH(KH_DATA, sThucThi); }