public DataTable selectAll(Model.ML_UserAccessType uat) { MySqlParameter[] para = new MySqlParameter[1]; para[0] = new MySqlParameter("@AccessTypeName", uat.AccessTypeName); return(MySQLHelper.ExecuteDataTable(DBConnection.connectionString, CommandType.Text, "SELECT `Key`, AccessTypeName, UserKey, UpdatedDate, Deleted FROM useraccesstype WHERE AccessTypeName = COALESCE(@AccessTypeName, AccessTypeName)", para)); }
public System.Data.DataTable selectAll(Model.ML_UserAccessType uat) { return(new OBALog.Data.DL_UserAccessType().selectAll(uat)); }