public int Create(Member member)
{
log.LogStart();
db.Member.InsertOnSubmit(member);
db.SubmitChanges();
return(member.MemberID);
}
public int Update(Location l)
{
log.LogStart();
db.Log = Console.Out;
db.SubmitChanges();
db.Log = null;
return(l.LocationID);
}
public void SetAcceptedDateTime(int runLogId)
{
RunLog l = (from rl in db.RunLog where rl.RunLogID == runLogId select rl).FirstOrDefault();
l.AcceptedDateTime = DateTime.Now;
db.SubmitChanges();
}
public void LogSentSMSMessage(string numbers, string message, int senderUserID)
{
try
{
Message m = new Message();
m.Message1 = message;
m.SenderUserID = senderUserID;
m.Recipient = numbers;
m.MessageTypeID = (int)SERVDataContract.MessageType.SMS;
m.SentDate = DateTime.Now;
m.RecipientMemberID = null;
db.Message.InsertOnSubmit(m);
db.SubmitChanges();
}
catch (Exception e)
{
log.Error(e.Message, e);
}
}
public int CreateCalendarEntry(int calendarID, int memberID, DateTime date, bool adHoc)
{
log.LogStart();
CalendarEntry e = new CalendarEntry()
{
CreateDateTime = DateTime.Now,
CalendarID = calendarID,
EntryDate = date,
MemberID = memberID,
CoverNeeded = 0,
CoverCalendarEntryID = null,
AdHoc = adHoc ? (sbyte)1: (sbyte)0,
ManuallyAdded = adHoc ? (sbyte)1: (sbyte)0,
};
db.CalendarEntry.InsertOnSubmit(e);
db.SubmitChanges();
return(e.CalendarEntryID);
}