public static StoryKickCollection FetchByUserID(int userID)
{
StoryKickCollection storyKicks = new StoryKickCollection();
storyKicks.LoadAndCloseReader(StoryKick.FetchByParameter(StoryKick.Columns.UserID, userID));
return(storyKicks);
}
public static void Destroy(int storyID, int userID, int hostID)
{
//NOTE: GJ: there is most likely a much better way of doing this with subsonic
Query query = new Query(StoryKick.Schema).WHERE(StoryKick.Columns.StoryID, storyID).AND(StoryKick.Columns.UserID, userID).AND(StoryKick.Columns.HostID, hostID);
StoryKick storyKick = new StoryKick();
storyKick.LoadAndCloseReader(StoryKick.FetchByQuery(query));
StoryKick.Destroy(storyKick.StoryKickID);
}
public static void Destroy(int storyID, int userID, int hostID)
{
//NOTE: GJ: there is most likely a much better way of doing this with subsonic
Query query = new Query(StoryKick.Schema).WHERE(StoryKick.Columns.StoryID, storyID).AND(StoryKick.Columns.UserID, userID).AND(StoryKick.Columns.HostID, hostID);
StoryKick storyKick = new StoryKick();
storyKick.LoadAndCloseReader(StoryKick.FetchByQuery(query));
StoryKick.Destroy(storyKick.StoryKickID);
}
public static StoryKick AddStoryKick(int storyID, int userID, int hostID, string ipAddress)
{
StoryKick storyKick = new StoryKick();
storyKick.StoryID = storyID;
storyKick.UserID = userID;
storyKick.HostID = hostID;
storyKick.IPAddress = ipAddress;
storyKick.Save();
return storyKick;
}
public void Insert(int StoryID, int UserID, int HostID, DateTime CreatedOn, string IPAddress)
{
StoryKick item = new StoryKick();
item.StoryID = StoryID;
item.UserID = UserID;
item.HostID = HostID;
item.CreatedOn = CreatedOn;
item.IPAddress = IPAddress;
item.Save(UserName);
}
public void Insert(int StoryID,int UserID,int HostID,DateTime CreatedOn,string IPAddress)
{
StoryKick item = new StoryKick();
item.StoryID = StoryID;
item.UserID = UserID;
item.HostID = HostID;
item.CreatedOn = CreatedOn;
item.IPAddress = IPAddress;
item.Save(UserName);
}
public bool Destroy(object StoryKickID)
{
return(StoryKick.Destroy(StoryKickID) == 1);
}
public bool Delete(object StoryKickID)
{
return(StoryKick.Delete(StoryKickID) == 1);
}