/// <summary>
/// updates the specified RolePermissions
/// </summary>
/// <param name="obj">RolePermissions</param>
/// <returns></returns>
public void Update(RolePermissions obj)
{
SqlHelper.ExecuteNonQuery(Data.ConnectionString, CommandType.StoredProcedure, "sproc_RolePermissions_Update"
, Data.CreateParameter("RolePermissionID", obj.RolePermissionID)
, Data.CreateParameter("RoleName", obj.RoleName)
, Data.CreateParameter("PageName", obj.PageName)
, Data.CreateParameter("Accessable", obj.Accessable)
);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public RolePermissions Populate(IDataReader myReader)
{
RolePermissions obj = new RolePermissions();
obj.RolePermissionID = (int)myReader["RolePermissionID"];
obj.RoleName = (string)myReader["RoleName"];
obj.PageName = (string)myReader["PageName"];
obj.Accessable = (bool)myReader["Accessable"];
return(obj);
}
/// <summary>
/// Add a new RolePermissions within RolePermissions database table
/// </summary>
/// <param name="obj">RolePermissions</param>
/// <returns>key of table</returns>
public int Add(RolePermissions obj)
{
DbParameter parameterItemID = Data.CreateParameter("RolePermissionID", obj.RolePermissionID);
parameterItemID.Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(Data.ConnectionString, CommandType.StoredProcedure, "sproc_RolePermissions_Add"
, parameterItemID
, Data.CreateParameter("RoleName", obj.RoleName)
, Data.CreateParameter("PageName", obj.PageName)
, Data.CreateParameter("Accessable", obj.Accessable)
);
return((int)parameterItemID.Value);
}
