/// <summary>
/// Is User Group Exists
/// </summary>
/// <param name="ObjConn">SqlConnection</param>
/// <param name="ObjSqlCommmand">SqlCommand</param>
/// <param name="GroupID">GroupID</param>
/// <param name="UserID">UserID</param>
/// <returns></returns>
public bool IsUserGroupExists(Conn ObjConn, SqlCommand ObjSqlCommmand, int GroupID, int UserID)
{
int i = ObjConn.executeselectcountquery(ObjSqlCommmand, "select count(1) from [GroupsToUsers] where [GroupID] = " + GroupID.ToString() + " and [UserID] = " + UserID.ToString());
if (i > 0)
return true;
else
return false;
}
/// <summary>
/// Is Group Exists
/// </summary>
/// <param name="ObjConn">SqlConnection</param>
/// <param name="ObjSqlCommmand">SqlCommand</param>
/// <param name="GroupName">GroupName</param>
/// <returns></returns>
public bool IsGroupExists(Conn ObjConn, SqlCommand ObjSqlCommmand, string GroupName)
{
int i = ObjConn.executeselectcountquery(ObjSqlCommmand, "select count(1) from [User] where GroupName = '" + GroupName + "'");
if (i > 0)
return true;
else
return false;
}
/// <summary>
/// Is User Exists
/// </summary>
/// <param name="ObjConn">SqlConnection</param>
/// <param name="ObjSqlCommmand">SqlCommand</param>
/// <param name="Login">Login</param>
/// <returns>True/False</returns>
public bool IsUserExists(Conn ObjConn, SqlCommand ObjSqlCommmand,string Login)
{
int i = ObjConn.executeselectcountquery(ObjSqlCommmand, "select COUNT(1) from [User] where [Login] = '" + Login + "'");
if (i > 0)
return true;
else
return false;
}
