public static bool CheckNetworkEmailUnique(Mysql db, string eMail)
{
DataTable networkMemberTable = db.Query(string.Format("SELECT user_id, member_email FROM network_members WHERE LCASE(member_email) = '{0}';",
Mysql.Escape(eMail.ToLower())));
if (networkMemberTable.Rows.Count > 0)
{
//lastEmailId = (long)networkMemberTable.Rows[0]["user_id"];
return false;
}
return true;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="userName"></param>
/// <param name="eMail"></param>
/// <returns></returns>
public static bool CheckUserNameUnique(Mysql db, string userName)
{
if (db.Query(string.Format("SELECT user_name FROM user_keys WHERE user_name_lower = '{0}';",
Mysql.Escape(userName.ToLower()))).Rows.Count > 0)
{
return false;
}
return true;
}
/// <summary>
/// Checks a given gallery slug to ensure uniqueness
/// </summary>
/// <param name="db">Database</param>
/// <param name="owner">Gallery owner</param>
/// <param name="parentFullPath">Parent path</param>
/// <param name="slug">Slug to check for uniqueness</param>
/// <returns>True if slug is unique given owner and parent</returns>
public static bool CheckGallerySlugUnique(Mysql db, Primitive owner, string parentFullPath, string slug)
{
DataTable galleryGalleryTable = db.Query(string.Format("SELECT gallery_path FROM user_galleries WHERE gallery_item_id = {0} AND gallery_item_type_id = {1} AND gallery_parent_path = '{2}' AND gallery_path = '{3}';",
owner.Id, owner.TypeId, Mysql.Escape(parentFullPath), Mysql.Escape(slug)));
if (galleryGalleryTable.Rows.Count > 0)
{
return false;
}
else
{
return true;
}
}
