private static DateTime GetLastVisitDate(ReturnVisitDataItem r)
{
DateTime lv = SqlCeConstants.DateTimeMinValue;
try {
RvPreviousVisitData[] x = RvPreviousVisitsDataInterface.GetPreviousVisits(r.ItemId, SortOrder.DateNewestToOldest);
if (x.Any())
{
lv = x.First().Date;
}
} catch (Exception) { }
return(lv);
}
/// <summary>
/// Deletes the return visit.
/// </summary>
/// <param name="itemId">The item id.</param>
public static bool DeleteReturnVisit(int itemId, bool deleteCalls)
{
using (var db = new ReturnVisitDataContext(ReturnVisitDataContext.DBConnectionString)) {
try {
ReturnVisitDataItem rv = db.ReturnVisitItems.Single(s => s.ItemId == itemId);
db.ReturnVisitItems.DeleteOnSubmit(rv);
db.SubmitChanges();
if (deleteCalls)
{
return(RvPreviousVisitsDataInterface.DeleteAllCallsFromRv(itemId));
}
return(true);
} catch (InvalidOperationException) { return(false); }
}
}