// Delete existing Role
public int deleteRole(int RoleID)
{
DataManipulation dm = new DataManipulation();
SqlParameter[] paras = new SqlParameter[1];
paras[0] = new SqlParameter("@RoleID", SqlDbType.Int);
paras[0].Value = RoleID;
return dm.manipulateData("prcRole_Delete", paras);
}
// Insert new Role
public int insertRole(String Name, String Description)
{
DataManipulation dm = new DataManipulation();
SqlParameter[] paras = new SqlParameter[2];
paras[0] = new SqlParameter("@Name", SqlDbType.VarChar);
paras[0].Value = Name;
paras[1] = new SqlParameter("@Des", SqlDbType.VarChar);
paras[1].Value = Description;
return dm.manipulateData("prcRole_Insert", paras);
}