private void lstEvents_ColumnClick(object sender, ColumnClickEventArgs e)
{
eSortColumn sortColumn = (eSortColumn)e.Column;
if (sortColumn == _sortColumn)
{
_sortAscending = !_sortAscending;
}
else
{
_sortColumn = sortColumn;
_sortAscending = true;
}
SortData();
}
private void lstEvents_ColumnClick(object sender, ColumnClickEventArgs e)
{
eSortColumn sortColumn = (eSortColumn)e.Column;
if (sortColumn == _sortColumn)
{
_sortAscending = !_sortAscending;
}
else
{
_sortColumn = sortColumn;
_sortAscending = true;
}
lstEvents.BeginUpdate();
SortData();
lstEvents.VirtualListSize = _debugEvents.Count;
lstEvents.EndUpdate();
}
private static EventComment[] Fetch(int? id, int? eventID, string username, int? numberOfComments, eSortColumn sortColumn)
{
using (var db = new ezFixUpDataContext())
{
var comments = from c in db.EventComments
where (!id.HasValue || c.ec_id == id)
&& (!eventID.HasValue || eventID == c.e_id)
&& (username == null || username == c.u_username)
select new EventComment
{
id = c.ec_id,
eventID = c.e_id,
username = c.u_username,
comment = c.ec_comment,
date = c.ec_date
};
if (sortColumn == eSortColumn.Date)
{
comments = comments.OrderByDescending(c => c.date);
}
else if (sortColumn == eSortColumn.Username)
{
comments = comments.OrderBy(c => c.username);
}
else if (sortColumn == eSortColumn.EventID)
{
comments = comments.OrderBy(c => c.eventID);
}
if (numberOfComments.HasValue)
{
comments = comments.Take(numberOfComments.Value);
}
return comments.ToArray();
}
}
/// <summary>
/// Fetches the by affiliate ID.
/// </summary>
/// <param name="affiliateID">The affiliate ID.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns></returns>
public static AffiliateHistory[] FetchByAffiliateID(int affiliateID, eSortColumn sortColumn)
{
return Fetch(null, affiliateID, null, null, sortColumn);
}
/// <summary>
/// Fetches all content pages from database by specified id or language.
/// </summary>
/// <param name="id">Represents content page id.</param>
/// <param name="languageID">The language ID.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns>Array of content pages.</returns>
public static ContentPage[] FetchContentPages(object id, object languageID, eSortColumn sortColumn)
{
string cacheKey = String.Format("ContentPage_FetchContentPages_{0}_{1}_{2}", id, languageID, sortColumn);
if (HttpContext.Current != null && HttpContext.Current.Cache[cacheKey] != null)
{
return HttpContext.Current.Cache[cacheKey] as ContentPage[];
}
var lPages = new List<ContentPage>(5);
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader =
SqlHelper.ExecuteReader(conn,
"FetchContentPages", id, languageID, sortColumn);
while (reader.Read())
{
var contentPage = new ContentPage();
contentPage.id = (int) reader["ID"];
contentPage.title = (string) reader["Title"];
contentPage.linkText = (string)reader["LinkText"];
contentPage.content = (string) reader["Content"];
contentPage.headerPosition = reader["HeaderPosition"] == DBNull.Value
? null
: (int?) reader["HeaderPosition"];
contentPage.footerPosition = reader["FooterPosition"] == DBNull.Value
? null
: (int?) reader["FooterPosition"];
contentPage.visibleFor = (eVisibility) (int) reader["VisibleFor"];
contentPage.url = reader["URL"] == DBNull.Value ? null : (string) reader["URL"];
contentPage.metaDescription = (string) reader["MetaDescription"];
contentPage.metaKeyword = (string) reader["MetaKeyword"];
contentPage.languageID = (int) reader["LanguageID"];
contentPage.urlRewrite = reader["UrlRewrite"] as string;
lPages.Add(contentPage);
}
}
ContentPage[] pages = lPages.ToArray();
if (HttpContext.Current != null)
{
HttpContext.Current.Cache.Insert(cacheKey, pages, null, DateTime.Now.AddMinutes(30),
Cache.NoSlidingExpiration, CacheItemPriority.NotRemovable, null);
}
return pages;
}
/// <summary>
/// Fetches credits packages by specified arguments.
/// It returns an empty array if there are no credits packages in DB by specified arguments.
/// If these arguments are null it returns all credits packages from DB.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="name">The name.</param>
/// <param name="quantity">The quantity.</param>
/// <param name="price">The price.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns></returns>
private static CreditsPackage[] Fetch(int? id, string name, int? quantity, decimal? price, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = (SqlDataReader)
SqlHelper.GetDB().ExecuteReader( "FetchCreditsPackages", id, name, quantity, price, sortColumn);
List <CreditsPackage> lCreditsPackage = new List<CreditsPackage>();
while (reader.Read())
{
CreditsPackage creditsPackage = new CreditsPackage();
creditsPackage.id = (int) reader["ID"];
creditsPackage.name = (string) reader["Name"];
creditsPackage.quantity = (int) reader["Quantity"];
creditsPackage.price = (decimal) reader["Price"];
lCreditsPackage.Add(creditsPackage);
}
return lCreditsPackage.ToArray();
}
}
/// <summary>
/// Fetches group members from DB by specified group ID, username, type or active status.
/// If all arguments are null it returns all group members from DB.
/// If it cannot find a record in DB by specified arguments it returns an empty array.
/// </summary>
/// <param name="groupID">The group ID.</param>
/// <param name="username">The username.</param>
/// <param name="type">The type.</param>
/// <param name="active">The active.</param>
/// <param name="joinDate">The join date.</param>
/// <param name="invitedBy">The invited by.</param>
/// <param name="numberOfMembers">The number of members.</param>
/// <returns>Group members array or an empty array if no group members are found in DB.</returns>
private static GroupMember[] Fetch(int? groupID, string username, eType? type, bool? active,
DateTime? joinDate, string invitedBy,
int? numberOfMembers, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = (SqlDataReader) SqlHelper.GetDB().ExecuteReader( "FetchGroupMembers",
groupID, username, type, active, joinDate, invitedBy, numberOfMembers, sortColumn);
List<GroupMember> groupMembers = new List<GroupMember>();
while (reader.Read())
{
GroupMember groupMember = new GroupMember();
groupMember.groupID = (int) reader["GroupID"];
groupMember.username = (string) reader["Username"];
groupMember.type = (eType) reader["Type"];
groupMember.active = (bool) reader["Active"];
groupMember.joinDate = (DateTime) reader["JoinDate"];
groupMember.invitedBy = reader["InvitedBy"] != DBNull.Value
? (string) reader["InvitedBy"] : null;
groupMember.joinAnswer = (string) reader["JoinAnswer"];
groupMember.isWarned = (bool) reader["IsWarned"];
groupMember.warnReason = reader["WarnReason"] != DBNull.Value ? (string) reader["WarnReason"] : null;
groupMember.warnExpirationDate = reader["WarnExpirationDate"] != DBNull.Value
? (DateTime?) reader["WarnExpirationDate"]
: null;
groupMembers.Add(groupMember);
}
return groupMembers.ToArray();
}
}
public static GroupMember[] Fetch(int groupID, eType type, eSortColumn sortColumn)
{
return Fetch(groupID, null, type, null, null, null, null, sortColumn);
}
public static GiftCategory[] FetchCategories(eSortColumn sortColumn)
{
GiftCategory[] categories = Fetch(sortColumn);
return categories.Where(category => category._parentID == null /*&& category.IsActive*/)
.Select(category => category).ToArray();
}
public static WinkCategory[] FetchCategoriesByLaguageId(int languageId, eSortColumn sortColumn)
{
WinkCategory[] categories = Fetch(sortColumn);
return categories.Where(category => category._parentID == languageId)
.Select(category => category).ToArray();
}
public static BannerCode[] Fetch(ePosition position, eSortColumn sortColumn)
{
return Fetch(null, position, null, sortColumn);
}
public static EventComment[] Fetch(int eventID, eSortColumn sortColumn)
{
return Fetch(null, eventID, null, null, sortColumn);
}
/// <summary>
/// Fetches group event comments by specified arguments.
/// It returns an empty array if there are no group event comments in DB by specified arguments.
/// If these arguments are null it returns all group event comments from DB.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="groupEventID">The group event ID.</param>
/// <param name="username">The username.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns></returns>
private static GroupEventsComment[] Fetch(int? id, int? groupEventID, string username, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader =
SqlHelper.ExecuteReader(conn, "FetchGroupEventsComments", id, groupEventID, username, sortColumn);
List <GroupEventsComment> lGroupEventsComments = new List<GroupEventsComment>();
while(reader.Read())
{
GroupEventsComment groupEventsComment = new GroupEventsComment();
groupEventsComment.id = (int) reader["ID"];
groupEventsComment.groupEventID = (int) reader["GroupEventID"];
groupEventsComment.username = (string) reader["Username"];
groupEventsComment.comment = (string) reader["Comment"];
groupEventsComment.date = (DateTime) reader["Date"];
lGroupEventsComments.Add(groupEventsComment);
}
return lGroupEventsComments.ToArray();
}
}
/// <summary>
/// Fetches group event comments by specified group event id.
/// If there are no group event comments in DB for the specified group event id it returns an empty array.
/// </summary>
/// <param name="groupEventID">The group event ID.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns></returns>
public static GroupEventsComment[] FetchByGroupEventID(int groupEventID, eSortColumn sortColumn)
{
return Fetch(null, groupEventID, null, sortColumn);
}
public static AdsCategory[] FetchCategories(eSortColumn sortColumn)
{
List<AdsCategory> lAdsCategories = new List<AdsCategory>();
AdsCategory[] categories = Fetch(sortColumn);
foreach (var category in categories)
{
if (category.parentID != null) continue;
lAdsCategories.Add(category);
}
return lAdsCategories.ToArray();
}
private static AdsCategory[] Fetch(int? id, int? parentID, string title, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn, "FetchAdsCategories", id, parentID, title, sortColumn);
List<AdsCategory> categories = new List<AdsCategory>();
while (reader.Read())
{
AdsCategory category = new AdsCategory();
category.id = (int)reader["ID"];
category.parentID = reader["ParentID"] != DBNull.Value ? (int?) reader["ParentID"] : null;
category.title = (string)reader["Title"];
categories.Add(category);
}
return categories.ToArray();
}
}
public static EcardCategory[] FetchSubcategories(int categoryID, eSortColumn sortColumn)
{
return Fetch(null, categoryID, null, sortColumn);
}
private static BannerCode[] Fetch(int? id, ePosition? position, bool? getDefault, eSortColumn sortColumn)
{
string cacheKey = String.Format("BannerCode_Fetch_{0}_{1}_{2}_{3}", id, position, getDefault, sortColumn);
if (HttpContext.Current != null && HttpContext.Current.Cache[cacheKey] != null)
{
return HttpContext.Current.Cache[cacheKey] as BannerCode[];
}
using (var db = new Model.AspNetDatingDataContext())
{
var bannerCodes = from bc in db.BannerCodes
where (!id.HasValue || bc.bc_id == id)
&& (!position.HasValue || bc.bc_position == (int?) position)
&& (!getDefault.HasValue || bc.bc_target == null)
select new BannerCode
{
id = bc.bc_id,
position = (ePosition) bc.bc_position,
priority = bc.bc_priority,
target = bc.bc_target,
code = bc.bc_code
};
switch (sortColumn)
{
case eSortColumn.None :
break;
case eSortColumn.Priority :
bannerCodes = bannerCodes.OrderByDescending(bc => bc.priority);
break;
}
if (HttpContext.Current != null)
{
HttpContext.Current.Cache.Insert(cacheKey, bannerCodes.ToArray(), CacheDependencies.Get(), DateTime.Now.AddMinutes(30),
Cache.NoSlidingExpiration);
}
return bannerCodes.ToArray();
}
}
public static GiftCategory[] Fetch(eSortColumn sortColumn)
{
return Fetch(null, null, null, sortColumn);
}
private static WinkCategory[] Fetch(int? id, int? parentID, string title, eSortColumn sortColumn)
{
//using (var conn = Config.DB.Open())
{
var categories = new List<WinkCategory>();
using (var reader = SqlHelper.GetDB().ExecuteReader(FetchProcedureName,
id, parentID, title, sortColumn))
{
while (reader.Read())
{
var category = new WinkCategory
{
_id = (int) reader["ID"],
_parentID = (int?) reader["LanguageID"],
_title = (string) reader["Title"]
};
categories.Add(category);
}
reader.Close();
}
return categories.ToArray();
}
}
private static GiftCategory[] Fetch(int? id, int? parentID, string title, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn, FetchProcedureName, id, parentID, title, sortColumn);
var categories = new List<GiftCategory>();
while (reader.Read())
{
var category = new GiftCategory
{
_id = (int)reader["ID"],
//_parentID = reader["ParentID"] != DBNull.Value
// ? (int?) reader["ParentID"] : null,
_title = (string)reader["Title"]
};
categories.Add(category);
}
return categories.ToArray();
}
}
private static EcardType[] Fetch(int? id, int? categoryId, string name, eType? type, bool? active, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = (SqlDataReader) SqlHelper.GetDB().ExecuteReader("FetchEcardTypes",
id,
categoryId,
name,
(int?)type,
active,
sortColumn);
var lEcardType = new List<EcardType>();
while (reader.Read())
{
try
{
var ecardType = new EcardType
{
id = (int) reader["ID"],
categoryId = (int) reader["CategoryID"],
name = (string) reader["Name"],
phrase = (string) reader["Phrase"],
type = (eType) reader["Type"],
active = (bool) reader["Active"]
};
lEcardType.Add(ecardType);
}
catch { }
}
return lEcardType.ToArray();
}
}
/// <summary>
/// Fetches active or inactive specified number of members from DB for the specified group and order
/// them by specified sort column.
/// If there are no group members in DB by specified arguments it returns an empty array.
/// </summary>
/// <param name="groupID">The group ID.</param>
/// <param name="active">if set to <c>true</c> [active].</param>
/// <param name="numberOfMembers">The number of members.</param>
/// <returns></returns>
public static GroupMember[] Fetch(int groupID, bool active, int numberOfMembers, eSortColumn sortColumn)
{
return Fetch(groupID, null, null, active, null, null, numberOfMembers, sortColumn);
}
/// <summary>
/// Fetches community photo approval from DB.
/// If there are no community photo approval in DB it returns an empty array.
/// </summary>
/// <returns></returns>
public static CommunityPhotoApproval[] Fetch(eSortColumn sortColumn)
{
return Fetch(null, null, null, null, null, sortColumn);
}
public static CreditsPackage[] Fetch(eSortColumn sortColumn)
{
return Fetch(null, null, null, null, sortColumn);
}
/// <summary>
/// Fetches community photo approval by specified parameters.
/// It returns an empty array if there are no community photo approval in DB by specified arguments.
/// If these arguments are null it returns all community photo approval from DB.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="photoID">The photo ID.</param>
/// <param name="username">The username.</param>
/// <param name="fromDate">From date.</param>
/// <param name="toDate">To date.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns></returns>
private static CommunityPhotoApproval[] Fetch(int? id, int? photoID, string username,
DateTime? fromDate, DateTime? toDate, eSortColumn sortColumn)
{
using (var db = new Model.AspNetDatingDataContext())
{
var photoApprovals = from cpa in db.CommunityPhotoApprovals
where (!id.HasValue || id == cpa.cpa_id)
&& (!photoID.HasValue || photoID == cpa.p_id)
&& (username == null || username == cpa.u_username)
&& (!fromDate.HasValue || cpa.cpa_timestamp >= fromDate)
&& (!toDate.HasValue || cpa.cpa_timestamp <= toDate)
select new CommunityPhotoApproval
{
id = cpa.cpa_id,
username = cpa.u_username,
photoID = cpa.p_id,
approved = cpa.cpa_approved,
date = cpa.cpa_timestamp
};
switch (sortColumn)
{
case eSortColumn.None:
break;
case eSortColumn.Username:
photoApprovals = photoApprovals.OrderBy(pa => pa.username);
break;
case eSortColumn.Date:
photoApprovals = photoApprovals.OrderByDescending(pa => pa.date);
break;
default:
break;
}
return photoApprovals.ToArray();
}
//using (SqlConnection conn = Config.DB.Open())
//{
// SqlDataReader reader = SqlHelper.ExecuteReader(conn, "FetchCommunityPhotoApproval",
// id, photoID, username, fromDate, toDate,
// sortColumn);
// List<CommunityPhotoApproval> lGroupPost = new List<CommunityPhotoApproval>();
// while (reader.Read())
// {
// CommunityPhotoApproval communityPhotoApproval = new CommunityPhotoApproval();
// communityPhotoApproval.id = (int)reader["ID"];
// communityPhotoApproval.photoID = (int)reader["PhotoID"];
// communityPhotoApproval.username = (string)reader["Username"];
// communityPhotoApproval.date = (DateTime)reader["Date"];
// communityPhotoApproval.approved = (bool) reader["Approved"];
// lGroupPost.Add(communityPhotoApproval);
// }
// return lGroupPost.ToArray();
//}
}
/// <summary>
/// Fetches all content pages with the specified language from database
/// and sorts them by specified column.
/// </summary>
/// <returns>Array of content pages.</returns>
public static ContentPage[] FetchContentPages(int languageID, eSortColumn sortColumn)
{
ContentPage[] pages = FetchContentPages(null, languageID, sortColumn);
return pages;
}
private static EcardType[] Fetch(int? id, string name, eType? type, bool? active, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn, "FetchEcardTypes",
id,
name,
type,
active,
sortColumn);
List<EcardType> lEcardType = new List<EcardType>();
while (reader.Read())
{
EcardType ecardType = new EcardType();
ecardType.id = (int)reader["ID"];
ecardType.name = (string) reader["Name"];
ecardType.type = (eType) reader["Type"];
ecardType.active = (bool) reader["Active"];
ecardType.CreditsRequired = reader["CreditsRequired"] as int?;
lEcardType.Add(ecardType);
}
return lEcardType.ToArray();
}
}
/// <summary>
/// Fetches the specified sort column.
/// </summary>
/// <param name="sortColumn">The sort column.</param>
/// <returns></returns>
public static AffiliateHistory[] Fetch(eSortColumn sortColumn)
{
return Fetch(null, null, null, null, sortColumn);
}
private static Ecard[] Fetch(int? id, int? ecardTypeID, string fromUsername, string toUsername,
bool? isOpened, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = (SqlDataReader) SqlHelper.GetDB().ExecuteReader( "FetchEcards",
id,
ecardTypeID,
fromUsername,
toUsername,
isOpened,
sortColumn);
List<Ecard> lEcards = new List<Ecard>();
while (reader.Read())
{
Ecard ecard = new Ecard();
ecard.id = (int)reader["ID"];
ecard.ecardTypeID= (int) reader["EcardTypeID"];
ecard.fromUsername = (string) reader["FromUsername"];
ecard.toUsername = (string) reader["ToUsername"];
ecard.date = (DateTime) reader["Date"];
ecard.message = (string) reader["Message"];
ecard.deletedByFromUser = (bool) reader["DeletedByFromUser"];
ecard.deletedByToUser = (bool) reader["DeletedByToUser"];
ecard.isOpened = (bool) reader["IsOpened"];
lEcards.Add(ecard);
}
return lEcards.ToArray();
}
}
/// <summary>
/// Fetches affiliates history by specified arguments.
/// It returns an empty array if there are no affiliates history in DB by specified arguments.
/// If these arguments are null it returns all affiliates history from DB.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="affiliateID">The affiliate ID.</param>
/// <param name="amount">The amount.</param>
/// <param name="datePayed">The date payed.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns></returns>
private static AffiliateHistory[] Fetch(int? id, int? affiliateID, decimal? amount, DateTime? datePayed, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader =
SqlHelper.ExecuteReader(conn, "FetchAffiliatesHistory", id, affiliateID, amount, datePayed, sortColumn);
List<AffiliateHistory> lAffiliatesHistory = new List<AffiliateHistory>();
while (reader.Read())
{
AffiliateHistory affiliate = new AffiliateHistory();
affiliate.id = (int)reader["ID"];
affiliate.affiliateID = (int)reader["AffiliateID"];
affiliate.amount = (decimal)reader["Amount"];
affiliate.datePaid = (DateTime)reader["DatePaid"];
affiliate.notes = reader["Notes"] == DBNull.Value ? null : (string) reader["Notes"];
affiliate.privateNotes = reader["PrivateNotes"] == DBNull.Value ? null : (string)reader["PrivateNotes"];
lAffiliatesHistory.Add(affiliate);
}
return lAffiliatesHistory.ToArray();
}
}
public static EcardCategory[] FetchCategories(eSortColumn sortColumn)
{
EcardCategory[] categories = Fetch(sortColumn);
return categories.Where(category => category._parentID == null)
.Select(category => category).ToArray();
}
