public void Delete(int LoaiCuaHangID)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "DeleteLoaiCuaHang";
sqlCmd.Parameters.Add("@LoaiCuaHangID", SqlDbType.Int).Value = LoaiCuaHangID;
objDataAccess.ExecuteQuery(sqlCmd, "LoaiCuaHang");
}
}
public DataSet SelectByNguoiDungID(int NguoiDungID)
{
DataAccess objDataAccess = new DataAccess();
DataSet dsResult = new DataSet(); dsResult.Locale = CultureInfo.CurrentCulture;
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "GetCuaHangByNguoiDungID";
sqlCmd.Parameters.Add("@NguoiDungID", SqlDbType.Int ).Value = NguoiDungID;
dsResult = objDataAccess.ExecuteQuery(sqlCmd, "CuaHang");
return dsResult;
}
}
public DataSet SelectByField(string FieldName, string value, string type)
{
DataAccess objDataAccess = new DataAccess();
DataSet dsResult = new DataSet();
dsResult.Locale = CultureInfo.CurrentCulture;
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SelectCuaHangByField";
sqlCmd.Parameters.Add("@FieldName", SqlDbType.NVarChar).Value = FieldName;
sqlCmd.Parameters.Add("@Value", SqlDbType.NVarChar).Value = value;
sqlCmd.Parameters.Add("@type", SqlDbType.NVarChar).Value = type;
dsResult = objDataAccess.ExecuteQuery(sqlCmd, "CuaHang");
return dsResult;
}
}
public DataSet SelectAll()
{
DataAccess objDataAccess = new DataAccess();
DataSet dsResult = new DataSet();
dsResult.Locale = CultureInfo.CurrentCulture;
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "GetCuaHang";
dsResult = objDataAccess.ExecuteQuery(sqlCmd, "CuaHang");
return dsResult;
}
}
//Check User belong Units
public DataSet UnitsPermissionCheck(int USER_ID)
{
//GetPermissionUserForUnits
DataAccess objDataAccess = new DataAccess();
DataSet dsResult = new DataSet();
dsResult.Locale = CultureInfo.CurrentCulture;
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "GetPermissionUserForUnits";
sqlCmd.Parameters.Add("@USER_ID", SqlDbType.BigInt).Value = USER_ID;
dsResult = objDataAccess.ExecuteQuery(sqlCmd, "PermissionUserForUnits");
return dsResult;
}
}
