public static List<Permission_Object> SelectAll()
{
string SelectQuery = @"Select * from [Permission]";
List<Permission_Object> result = new List<Permission_Object>();
DataTable tb = commonDatabase.GetSQLDataTable(clsConnectionString.GetConnectionString(), SelectQuery);
foreach (DataRow row in tb.Rows)
{
Permission_Object newObject = new Permission_Object();
newObject.Id = int.Parse(row["Id"].ToString());
newObject.Name = (string)row["Name"];
newObject.Role = row["Role"].ToString();
result.Add(newObject);
}
return result;
}
public static Permission_Object Find(int Id)
{
string SelectQuery = @"Select * from [Permission] where Id=@Id";
List<SqlParameter> sps = new List<SqlParameter>();
sps.Add(new SqlParameter("Id",Id));
Permission_Object result = new Permission_Object();
DataTable tb = commonDatabase.GetSQLDataTable(clsConnectionString.GetConnectionString(), SelectQuery,sps);
if (tb.Rows.Count>0)
{
result.Id = int.Parse(tb.Rows[0]["Id"].ToString());
result.Name = tb.Rows[0]["Name"].ToString();
result.Role = tb.Rows[0]["Role"].ToString();
}
return result;
}