public Boolean insertUser(String pLoginName, String pPassword, String pName, String pMName, String pSurName1, String pSurName2, String pCurrentUser)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_SearchForUsers N'" + pCurrentUser + "', " + 5, 3);
_result = _dbc.ExecuteProcedures("Exec sp_InsertUser N'" + pLoginName + "', " + "N'" + pName + "', " + "N'" + pMName + "', " + "N'" + pSurName1 + "', N' " + pSurName2 + "'," + "N'" + pPassword + "', " + _result[0], 1);
}
catch (Exception ex)
{
_dbc.CloseConnection();
return(false);
}
_dbc.CloseConnection();
if (_result != null)
{
if (((int)_result[0]) == 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public List <object> searchForUsers(String pHint, int pType)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
if (pType == 5)
{
_result = _dbc.ExecuteProcedures("Exec sp_SearchForUsers N'" + pHint + "', " + pType, 2);
}
else
{
_result = _dbc.ExecuteProcedures("Exec sp_SearchForUsers N'" + pHint + "', " + pType, 7);
}
_dbc.CloseConnection();
return(_result);
}
catch (Exception e)
{
_dbc.CloseConnection();
_result = null;
return(_result);
}
}
public Boolean Login(String pPassword, String pUserName)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_Login N'" + pUserName + "', N'" + pPassword + "'", 1);
}
catch (Exception e)
{
_dbc.CloseConnection();
return(false);
}
_dbc.CloseConnection();
if (_result != null)
{
if (((int)_result[0]) == 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public Boolean passwordChange(String pLoginName, String pOldPass, String pNewPass, String pCurrentUser)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_UpdatePassword N'" + pLoginName + "', N'" + pOldPass + "', N'" + pNewPass + "', " + pCurrentUser, 1);
}
catch (Exception e)
{
_dbc.CloseConnection();
return(false);
}
_dbc.CloseConnection();
if (_result != null)
{
if (((int)_result[0]) == 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public Boolean deleteMembership(String pUser, String pGroup)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_DeleteMembership " + pUser + "," + pGroup, 1);
}
catch (Exception ex)
{
_dbc.CloseConnection();
return(false);
}
_dbc.CloseConnection();
if (_result != null)
{
if (((int)_result[0]) == 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public Boolean updateGroup(String pName, String pDescription, int pStatus)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_UpdateUserGroups N'" + pName + "'," + pStatus + ", N'" + pDescription + "'", 1);
}
catch (Exception ex)
{
_dbc.CloseConnection();
return(false);
}
_dbc.CloseConnection();
if (_result != null)
{
if (((int)_result[0]) == 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public Boolean updateUser(String pFirstName, String pSecondName, String pSurName, String pSurName2, String pStatus, String pLoginName, int pActualUser)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_UpdateUser N'" + pFirstName + "', N'" + pSecondName + "', N'" + pSurName + "', N'" + pSurName2 + "', '" + pStatus + "', NULL, NULL, NULL, " + pActualUser + ", N'" + pLoginName + "', NULL, NULL, 0", 1);
}
catch (Exception ex)
{
_dbc.CloseConnection();
return(false);
}
_dbc.CloseConnection();
if (_result != null)
{
if (((int)_result[0]) == 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public Boolean DeleteRights(String pGroup, String pType, String pIdentifier)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
String _query = "";
int plap = String.Compare("Category", "Category");
int plop = String.Compare(pType, "Category");
if (pType == "Section")
{
_query = "Exec sp_DeleteSectionRights ";
}
else if (pType == "Category")
{
_query = "Exec sp_DeleteCategoryRights ";
}
else if (pType == "Page")
{
_query = "Exec sp_DeletePageRights ";
}
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures(_query + pIdentifier + ", " + pGroup, 1);
}
catch (Exception ex)
{
_dbc.CloseConnection();
return(false);
}
_dbc.CloseConnection();
if (_result != null)
{
if (((int)_result[0]) == 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public List <String> getUserRights(String pIdUser, String pType)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _queryResult;
List <String> _result = new List <string>();
String _query = "";
if (pType == "Section")
{
_query = "Exec sp_SelectSectionsByUser ";
}
else if (pType == "Category")
{
_query = "Exec sp_SelectCategoriesByUser ";
}
else if (pType == "Page")
{
_query = "Exec sp_SelectPagesByUser ";
}
try
{
_queryResult = _dbc.ExecuteProcedures(_query + pIdUser, 1);
}
catch (Exception e)
{
_dbc.CloseConnection();
_result = null;
return(_result);
}
_dbc.CloseConnection();
if (_queryResult != null)
{
for (int i = 0; i < _queryResult.Count; i++)
{
_result.Add((String)_queryResult[i]);
}
}
return(_result);
}
public List <object> searchForGroups(String pHint, int ptype)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_SearchForGroups N'" + pHint + "', " + ptype, 4);
_dbc.CloseConnection();
return(_result);
}
catch (Exception e)
{
_dbc.CloseConnection();
_result = null;
return(_result);
}
}
public int searchForGroup(String pHint, int ptype)
{
DataBaseConnection _dbc = new DataBaseConnection();
_dbc.SetConnectionString(_ConnectionString);
_dbc.OpenConnection();
List <object> _result;
try
{
_result = _dbc.ExecuteProcedures("Exec sp_SearchForGroups N'" + pHint + "', " + ptype, 3);
}
catch (Exception e)
{
_dbc.CloseConnection();
return(-1);
}
_dbc.CloseConnection();
if (_result != null)
{
return((int)_result[0]);
}
return(-1);
}