public void DeleteBatch(DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "DeleteLoaiCuaHang";
sqlCmd.Parameters.Add("@LoaiCuaHangID", SqlDbType.Int).SourceColumn = "LoaiCuaHangID";
objDataAccess.UpdateBatch(rowUpdate, sqlCmd, dtTblMapping);
}
}
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateCuaHang";
sqlCmd.Parameters.Add("@CuaHangID",SqlDbType.Int).SourceColumn = "CuaHangID";
sqlCmd.Parameters.Add("@TenCuaHang",SqlDbType.NVarChar,100).SourceColumn = "TenCuaHang";
sqlCmd.Parameters.Add("@GioiThieu",SqlDbType.NVarChar,4000).SourceColumn = "GioiThieu";
sqlCmd.Parameters.Add("@NguoiDungID",SqlDbType.Int).SourceColumn = "NguoiDungID";
sqlCmd.Parameters.Add("@Email",SqlDbType.NVarChar,50).SourceColumn = "Email";
sqlCmd.Parameters.Add("@Anh",SqlDbType.NVarChar,100).SourceColumn = "Anh";
sqlCmd.Parameters.Add("@DienThoaiDiDong",SqlDbType.NVarChar,50).SourceColumn = "DienThoaiDiDong";
sqlCmd.Parameters.Add("@DienThoaiCoDinh",SqlDbType.NVarChar,50).SourceColumn = "DienThoaiCoDinh";
sqlCmd.Parameters.Add("@ThongTinLienHe",SqlDbType.NVarChar,4000).SourceColumn = "ThongTinLienHe";
sqlCmd.Parameters.Add("@DiaChi",SqlDbType.NVarChar,200).SourceColumn = "DiaChi";
sqlCmd.Parameters.Add("@Website",SqlDbType.NVarChar,200).SourceColumn = "Website";
sqlCmd.Parameters.Add("@Fax",SqlDbType.NVarChar,50).SourceColumn = "Fax";
sqlCmd.Parameters.Add("@YM",SqlDbType.NVarChar,50).SourceColumn = "YM";
sqlCmd.Parameters.Add("@KichHoat",SqlDbType.Bit).SourceColumn = "KichHoat";
sqlCmd.Parameters.Add("@SapXep",SqlDbType.Int).SourceColumn = "SapXep";
sqlCmd.Parameters.Add("@Bak1",SqlDbType.NVarChar,50).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2",SqlDbType.NVarChar,1000).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3",SqlDbType.Int).SourceColumn = "Bak3";
sqlCmd.Parameters.Add("@Bak4",SqlDbType.Int).SourceColumn = "Bak4";
sqlCmd.Parameters.Add("@Bak5",SqlDbType.Bit).SourceColumn = "Bak5";
sqlCmd.Parameters.Add("@bak6",SqlDbType.NVarChar,50).SourceColumn = "bak6";
sqlCmd.Parameters.Add("@bak7",SqlDbType.NVarChar,1000).SourceColumn = "bak7";
sqlCmd.Parameters.Add("@bak8",SqlDbType.NVarChar,1000).SourceColumn = "bak8";
sqlCmd.Parameters.Add("@Bak9",SqlDbType.Int).SourceColumn = "Bak9";
sqlCmd.Parameters.Add("@BaoDam",SqlDbType.TinyInt).SourceColumn = "BaoDam";
sqlCmd.Parameters.Add("@LoaiCuaHang",SqlDbType.TinyInt).SourceColumn = "LoaiCuaHang";
sqlCmd.Parameters.Add("@LoaiCuaHangID",SqlDbType.Int).SourceColumn = "LoaiCuaHangID";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateLoaiCuaHang";
sqlCmd.Parameters.Add("@LoaiCuaHangID",SqlDbType.Int).SourceColumn = "LoaiCuaHangID";
sqlCmd.Parameters.Add("@TenLoaiCuaHang",SqlDbType.NVarChar,100).SourceColumn = "TenLoaiCuaHang";
sqlCmd.Parameters.Add("@Mota",SqlDbType.NVarChar,200).SourceColumn = "Mota";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}
public void InsertBatch(ref DataRow[] rowInsert)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "InsertLoaiCuaHang_Ref";
sqlCmd.Parameters.Add("@LoaiCuaHangID", SqlDbType.Int ).SourceColumn = "LoaiCuaHangID";
sqlCmd.Parameters["@LoaiCuaHangID"].Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add("@TenLoaiCuaHang",SqlDbType.NVarChar,4).SourceColumn = "TenLoaiCuaHang";
sqlCmd.Parameters.Add("@Mota",SqlDbType.NVarChar,100).SourceColumn = "Mota";
objDataAccess.UpdateBatch(ref rowInsert, sqlCmd, dtTblMapping);
}
}