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