public override void Update(BOBase u)
{
BO.Comment Comment = u as BO.Comment;
List<SqlParameter> param = fillParams(u);
param.Add(DAL.CommonMethods.parameter("w_CommentID", u.ID));
int error = 0;
DAL.CommonMethods.UpdateDataTable("usp_update_Comment", out error, param.ToArray());
}
public override void Update(BOBase u)
{
BO.Feed feed = u as BO.Feed;
List<SqlParameter> userparam = fillParams(u);
userparam.Add(DAL.CommonMethods.parameter("w_FeedID", u.ID));
int error = 0;
DAL.CommonMethods.UpdateDataTable("usp_update_Feed", out error, DAL.CommonMethods.parameter("p_ID", u.ID));
}
public override void Create(BOBase u)
{
BO.FeedItemStatus FeedItemStatus = u as BO.FeedItemStatus;
int error = 0;
int identity = 0;
DAL.CommonMethods.UpdateDataTable("usp_insert_FeedItemStatus", out error, out identity, fillParams(u).ToArray());
u.ID = identity;
}
public override void Create(BOBase u)
{
BO.Comment Comment = u as BO.Comment;
int error = 0;
int identity = 0;
DAL.CommonMethods.UpdateDataTable("usp_insert_Comment", out error, out identity, fillParams(u).ToArray());
u.ID = identity;
}
public override void Update(BOBase u)
{
BO.Subscription Subscription = u as BO.Subscription;
List<SqlParameter> param = fillParams(u);
param.Add(DAL.CommonMethods.parameter("w_SubscriptionID", u.ID));
int error = 0;
DAL.CommonMethods.UpdateDataTable("usp_update_Subscription", out error, param.ToArray());
}
public override void Update(BOBase u)
{
BO.FeedItemStatus FeedItemStatus = u as BO.FeedItemStatus;
List<SqlParameter> param = fillParams(u);
param.Add(DAL.CommonMethods.parameter("w_FeedItemStatusID", u.ID));
int error = 0;
DAL.CommonMethods.UpdateDataTable("usp_update_FeedItemStatus", out error, param.ToArray());
}
public override List<SqlParameter> fillParams(BOBase u)
{
BO.Subscription Subscription = u as BO.Subscription;
return new List<SqlParameter>
{
DAL.CommonMethods.parameter("p_FeedID", Subscription.FeedID),
DAL.CommonMethods.parameter("p_UserID", Subscription.UserID)
};
}
public override List<SqlParameter> fillParams(BOBase u)
{
BO.User user = u as BO.User;
return new List<SqlParameter>
{
DAL.CommonMethods.parameter("p_UserName", user.UserName),
DAL.CommonMethods.parameter("p_Mail", user.Mail)
};
}
public override List<SqlParameter> fillParams(BOBase u)
{
BO.Filter Filter = u as BO.Filter;
return new List<SqlParameter>
{
DAL.CommonMethods.parameter("p_FeedID", Filter.FeedID),
DAL.CommonMethods.parameter("p_FilterString", Filter.FilterString),
DAL.CommonMethods.parameter("p_UserID", Filter.UserID)
};
}
public override List<SqlParameter> fillParams(BOBase u)
{
BO.Feed feed = u as BO.Feed;
return new List<SqlParameter>
{
DAL.CommonMethods.parameter("p_LastPublishDate", feed.LastPublishDate),
DAL.CommonMethods.parameter("p_HomePage", feed.HomePage),
DAL.CommonMethods.parameter("p_FeedUrl", feed.FeedUrl)
};
}
public override List<SqlParameter> fillParams(BOBase u)
{
BO.Comment Comment = u as BO.Comment;
return new List<SqlParameter>
{
DAL.CommonMethods.parameter("p_FeedItemID", Comment.FeedItemID),
DAL.CommonMethods.parameter("p_Comment", Comment.Value),
DAL.CommonMethods.parameter("p_UserID", Comment.UserID)
};
}
public override List<SqlParameter> fillParams(BOBase u)
{
BO.FeedItemStatus FeedItemStatus = u as BO.FeedItemStatus;
return new List<SqlParameter>
{
//convert to bit
DAL.CommonMethods.parameter("p_FeedItemID", FeedItemStatus.FeedItemID),
DAL.CommonMethods.parameter("p_UserID", FeedItemStatus.UserID),
DAL.CommonMethods.parameter("p_Read", FeedItemStatus.Read),
DAL.CommonMethods.parameter("p_ReadLater", FeedItemStatus.ReadLater),
DAL.CommonMethods.parameter("p_Favourite", FeedItemStatus.Favourite)
};
}
public override List<SqlParameter> fillParams(BOBase u)
{
BO.FeedItem FeedItem = u as BO.FeedItem;
return new List<SqlParameter>
{
DAL.CommonMethods.parameter("p_Title", FeedItem.Title)
,DAL.CommonMethods.parameter("p_PublishDate", FeedItem.PublishDate)
,DAL.CommonMethods.parameter("p_Summary", FeedItem.Summary)
,DAL.CommonMethods.parameter("p_ArticleLink", FeedItem.ArticleLink)
,DAL.CommonMethods.parameter("p_FeedID", FeedItem.FeedID)
,DAL.CommonMethods.parameter("p_Authors", FeedItem.Authors)
,DAL.CommonMethods.parameter("p_Contributors", FeedItem.Contributors)
,DAL.CommonMethods.parameter("p_Links", FeedItem.Links)
,DAL.CommonMethods.parameter("p_SourceFeed", FeedItem.SourceFeed)
,DAL.CommonMethods.parameter("p_Copyright", FeedItem.CopyRight)
,DAL.CommonMethods.parameter("p_Content", FeedItem.Content)
};
}
public override void Delete(BOBase u)
{
BO.Subscription Subscription = u as BO.Subscription;
DAL.CommonMethods.UpdateDataTable("usp_delete_Subscription", DAL.CommonMethods.parameter("p_ID", u.ID));
}
public override void Delete(BOBase u)
{
BO.FeedItemStatus FeedItemStatus = u as BO.FeedItemStatus;
DAL.CommonMethods.UpdateDataTable("usp_delete_FeedItemStatus", DAL.CommonMethods.parameter("p_ID", u.ID));
}
public override void Delete(BOBase u)
{
BO.Filter Filter = u as BO.Filter;
DAL.CommonMethods.UpdateDataTable("usp_delete_Filter", DAL.CommonMethods.parameter("p_ID", u.ID));
}
public override void Delete(BOBase u)
{
BO.Comment Comment = u as BO.Comment;
DAL.CommonMethods.UpdateDataTable("usp_delete_Comment", DAL.CommonMethods.parameter("p_ID", u.ID));
}