/// <summary>
/// Saves this instance.
/// </summary>
public void Save()
{
using (var db = new AspNetDatingDataContext())
{
var photoNote = new Model.PhotoNote
{
pn_id = Id,
p_id = PhotoId,
u_username = Username,
pn_notes = Notes,
pn_timestamp = Timestamp,
pn_x = X,
pn_y = Y,
pn_width = Width,
pn_height = Height
};
if (Id == 0)
db.PhotoNotes.InsertOnSubmit(photoNote);
else
{
db.PhotoNotes.Attach(photoNote, true);
}
db.SubmitChanges();
if (Id == 0)
Id = photoNote.pn_id;
}
}
public static void Delete(int id)
{
using (var db = new AspNetDatingDataContext())
{
var pollChoice = db.PollChoices.FirstOrDefault(pc => pc.pc_id == id);
if (pollChoice != null)
{
db.PollChoices.DeleteOnSubmit(pollChoice);
db.SubmitChanges();
}
}
}
public static void RemoveCredentials(string username)
{
using (var db = new AspNetDatingDataContext())
{
var credentials = db.FacebookCredentials.FirstOrDefault(tc => tc.u_username == username);
if (credentials != null)
{
db.FacebookCredentials.DeleteOnSubmit(credentials);
db.SubmitChanges();
}
}
}
public static void SaveCredentials(string username, string token)
{
using (var db = new AspNetDatingDataContext())
{
var credentials = db.FacebookCredentials.FirstOrDefault(tc => tc.u_username == username);
if (credentials == null)
{
credentials = new FacebookCredential { u_username = username };
db.FacebookCredentials.InsertOnSubmit(credentials);
}
credentials.fc_token = token;
db.SubmitChanges();
}
}
public static void AddAnswer(int pollID, string username, int choiceID)
{
using (var db = new AspNetDatingDataContext())
{
var pollAnswer = new Model.PollAnswer
{
p_id = pollID,
pc_id = choiceID,
u_username = username
};
db.PollAnswers.InsertOnSubmit(pollAnswer);
db.SubmitChanges();
}
}
public static void SaveCredentials(string username, string twitterUsername, string twitterPassword)
{
using (var db = new AspNetDatingDataContext())
{
var credentials = db.TwitterCredentials.FirstOrDefault(tc => tc.u_username == username);
if (credentials == null)
{
credentials = new TwitterCredential {u_username = username};
db.TwitterCredentials.InsertOnSubmit(credentials);
}
credentials.tc_username = twitterUsername;
credentials.tc_password = twitterPassword;
db.SubmitChanges();
}
}
private static void Delete(int? id, string fromUsername, string toUsername, bool? accepted)
{
using (var db = new AspNetDatingDataContext())
{
var relationship =
db.Relationships.Where(
r =>
(!id.HasValue || r.r_id == id)
&& (fromUsername == null || r.u_username == fromUsername)
&& (toUsername == null || r.r_username == toUsername)
&& (!accepted.HasValue || r.r_accepted == accepted)).ToArray();
db.Relationships.DeleteAllOnSubmit(relationship);
db.SubmitChanges();
}
}
public void Save()
{
using (var db = new AspNetDatingDataContext())
{
var relationship = new Model.Relationship()
{
r_id = id,
u_username = fromUsername,
r_username = toUsername,
r_type = (int) type,
r_pendingtype = pendingType.HasValue ? (int?) pendingType : null,
r_accepted = accepted,
r_timestamp = timestamp
};
if (id == 0)
{
db.Relationships.InsertOnSubmit(relationship);
}
else
{
db.Relationships.Attach(relationship, true);
}
db.SubmitChanges();
if (id == 0) id = relationship.r_id;
}
}
public static void DeleteByEventID(int id)
{
using (var db = new AspNetDatingDataContext())
{
var comments = db.EventComments.Where(c => c.e_id == id);
db.EventComments.DeleteAllOnSubmit(comments);
db.SubmitChanges();
}
}
public static void Delete(int id)
{
using (var db = new AspNetDatingDataContext())
{
var eventComment = db.EventComments.Single(c => c.ec_id == id);
db.EventComments.DeleteOnSubmit(eventComment);
db.SubmitChanges();
}
}
public void Save()
{
if (comment != null && comment.Length > 2000)
{
Global.Logger.LogWarning(
String.Format("EventComment {0} was not saved because it is more than 2000 chars", id));
return;
}
using (var db = new AspNetDatingDataContext())
{
var eventComment = new Model.EventComment()
{
ec_id = id,
e_id = eventID,
u_username = username,
ec_date = date,
ec_comment = comment
};
if (id == 0)
db.EventComments.InsertOnSubmit(eventComment);
else
{
db.EventComments.Attach(eventComment, true);
}
db.SubmitChanges();
if (id == 0)
id = eventComment.ec_id;
}
}
public void Save()
{
using (var db = new AspNetDatingDataContext())
{
var poll = new Model.Poll
{
p_id = ID,
p_title = Title,
p_startdate = StartDate,
p_enddate = EndDate,
p_showresultsuntil = ShowResultsUntil
};
if (ID == 0)
db.Polls.InsertOnSubmit(poll);
else
{
db.Polls.Attach(poll, true);
}
db.SubmitChanges();
if (ID == 0)
ID = poll.p_id;
}
}
public static void Delete(int id)
{
using (var db = new AspNetDatingDataContext())
{
var bannerCode = db.BannerCodes.Single(c => c.bc_id == id);
db.BannerCodes.DeleteOnSubmit(bannerCode);
db.SubmitChanges();
CacheDependencies.NotifyChanged();
}
}
/// <summary>
/// Deletes this instance.
/// </summary>
public void Delete()
{
using (var db = new AspNetDatingDataContext())
{
var photoNote = db.PhotoNotes.Single(n => n.pn_id == Id);
db.PhotoNotes.DeleteOnSubmit(photoNote);
db.SubmitChanges();
}
}
public static void Delete(int? id, string fromUsername, int? fromGroup, eType? type,
DateTime? date)
{
using (var db = new AspNetDatingDataContext())
{
var events = from e in db.Events
where (!id.HasValue || e.e_id == id)
&& (!type.HasValue || e.e_type == (long?)type)
&& (fromUsername == null || e.e_fromusername == fromUsername)
&& (!fromGroup.HasValue || e.e_fromgroup == fromGroup)
&& (!date.HasValue || e.e_date.Date == date)
select e;
foreach (var ev in events)
{
db.EventComments.DeleteAllOnSubmit(ev.EventComments);
}
db.Events.DeleteAllOnSubmit(events);
db.SubmitChanges();
}
}
public static void Delete(int id)
{
using (var db = new AspNetDatingDataContext())
{
var comments = db.EventComments.Where(c => c.e_id == id);
db.EventComments.DeleteAllOnSubmit(comments);
Model.Event ev = db.Events.Single(e => e.e_id == id);
db.Events.DeleteOnSubmit(ev);
db.SubmitChanges();
}
}
public static void Delete(int id)
{
using (var db = new AspNetDatingDataContext())
{
var pollAnswers = db.PollAnswers.Where(pa => pa.p_id == id);
var pollChoices = db.PollChoices.Where(pc => pc.p_id == id);
var poll = db.Polls.FirstOrDefault(p => p.p_id == id);
if (poll != null)
{
db.PollAnswers.DeleteAllOnSubmit(pollAnswers);
db.PollChoices.DeleteAllOnSubmit(pollChoices);
db.Polls.DeleteOnSubmit(poll);
db.SubmitChanges();
}
}
}
public void Save()
{
using (var db = new AspNetDatingDataContext())
{
var bannerCode = new Model.BannerCode()
{
bc_id = id,
bc_position = (int) position,
bc_priority = priority,
bc_target = target,
bc_code = code
};
if (id == 0)
{
db.BannerCodes.InsertOnSubmit(bannerCode);
}
else
{
db.BannerCodes.Attach(bannerCode, true);
}
db.SubmitChanges();
if (id == 0) id = bannerCode.bc_id;
CacheDependencies.NotifyChanged();
}
}
public void Save()
{
using (var db = new AspNetDatingDataContext())
{
var pollChoice = new Model.PollChoice
{
p_id = PollID,
pc_id = ID,
pc_answer = Answer
};
if (ID == 0)
db.PollChoices.InsertOnSubmit(pollChoice);
else
{
db.PollChoices.Attach(pollChoice, true);
}
db.SubmitChanges();
if (ID == 0)
ID = pollChoice.pc_id;
}
}
