/// <summary>
/// Saves the call.
/// </summary>
/// <param name="call">The call.</param>
/// <exception cref="System.ArgumentNullException">rvItemId;Rv Item Id can't be null</exception>
public static bool AddOrUpdateCall(ref RvPreviousVisitData call)
{
if (call.RvItemId < 0)
{
throw new ArgumentNullException("call", "Rv Item Id can't be null");
}
int itemId = call.ItemId;
using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) {
if (itemId > 0 && db.RvPreviousVisitItems.Any(s => s.ItemId == itemId))
{
RvPreviousVisitItem c = db.RvPreviousVisitItems.Single(s => s.ItemId == itemId);
c.RvItemId = call.RvItemId;
c.Magazines = call.Magazines;
c.Books = call.Books;
c.Brochures = call.Brochures;
c.Date = call.Date;
c.Notes = call.Notes;
c.Tracts = call.Tracts;
db.SubmitChanges();
return(c.ItemId > 0 && ReturnVisitsInterface.UpdateLastVisitDate(call.RvItemId, call.Date)); // existing call saved.
}
var cc = RvPreviousVisitData.Copy(call);
db.RvPreviousVisitItems.InsertOnSubmit(cc);
db.SubmitChanges();
call.ItemId = cc.ItemId;
return(call.ItemId >= 0 && ReturnVisitsInterface.UpdateLastVisitDate(call.RvItemId, call.Date));
}
}
/// <summary>
/// Deletes the call.
/// </summary>
/// <param name="callId">The call id.</param>
public static bool DeleteCall(int callId)
{
using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) {
try {
RvPreviousVisitItem call = db.RvPreviousVisitItems.Single(s => s.ItemId == callId);
db.RvPreviousVisitItems.DeleteOnSubmit(call);
db.SubmitChanges();
return(ReturnVisitsInterface.DeleteCallFromRv(call.RvItemId, call.Date));
} catch { return(false); }
}
}
/// <summary>
/// Gets the call.
/// </summary>
/// <param name="callId">The call id.</param>
/// <returns>RvPreviousVisitData.</returns>
/// <exception cref="MyTimeDatabaseLib.RvPreviousVisitNotFoundException">The Call was not found.</exception>
/// <exception cref="RvPreviousVisitNotFoundException">The Call was not found.</exception>
public static RvPreviousVisitData GetCall(int callId)
{
using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) {
try {
RvPreviousVisitItem call = db.RvPreviousVisitItems.Single(s => s.ItemId == callId);
return(RvPreviousVisitData.Copy(call));
} catch {
throw new RvPreviousVisitNotFoundException("The Call was not found.");
}
}
}
internal static RvPreviousVisitData Copy(RvPreviousVisitItem call)
{
return(new RvPreviousVisitData {
ItemId = call.ItemId,
RvItemId = call.RvItemId,
Books = call.Books,
Brochures = call.Brochures,
Tracts = call.Tracts ?? 0,
Date = call.Date,
Magazines = call.Magazines,
Notes = call.Notes
});
}
