/// <summary>
/// Updates the return visit.
/// </summary>
/// <param name="newRv">The new rv.</param>
public static bool UpdateReturnVisit(ref ReturnVisitData newRv)
{
using (var db = new ReturnVisitDataContext(ReturnVisitDataContext.DBConnectionString)) {
try {
int itemId = newRv.ItemId;
ReturnVisitDataItem rv = db.ReturnVisitItems.Single(s => s.ItemId == itemId);
rv.AddressOne = newRv.AddressOne;
rv.AddressTwo = newRv.AddressTwo;
rv.Age = newRv.Age;
rv.City = newRv.City;
rv.Country = newRv.Country;
rv.FullName = newRv.FullName;
rv.ImageSrc = newRv.ImageSrc;
rv.OtherNotes = newRv.OtherNotes;
rv.PhoneNumber = newRv.PhoneNumber;
rv.PhysicalDescription = newRv.PhysicalDescription;
rv.PostalCode = newRv.PostalCode;
rv.StateProvince = newRv.StateProvince;
rv.Gender = newRv.Gender;
rv.Latitude = newRv.Latitude;
rv.Longitude = newRv.Longitude;
rv.LastVisitDate = newRv.LastVisitDate;
db.SubmitChanges();
return(true);
} catch (InvalidOperationException) {
return(AddNewReturnVisit(ref newRv)); //rv not found, lets create it.
}
}
}
/// <summary>
/// Gets the return visit.
/// </summary>
/// <param name="itemID">The item ID.</param>
/// <returns>ReturnVisitData.</returns>
public static ReturnVisitData GetReturnVisit(int itemID)
{
using (var db = new ReturnVisitDataContext(ReturnVisitDataContext.DBConnectionString)) {
try {
ReturnVisitDataItem r = db.ReturnVisitItems.Single(s => s.ItemId == itemID);
var rr = new ReturnVisitData {
ItemId = r.ItemId,
DateCreated = r.DateCreated,
AddressOne = r.AddressOne,
AddressTwo = r.AddressTwo,
Age = r.Age,
City = r.City,
Country = r.Country,
FullName = r.FullName,
Gender = r.Gender,
OtherNotes = r.OtherNotes,
PhysicalDescription = r.PhysicalDescription,
PostalCode = r.PostalCode,
StateProvince = r.StateProvince,
ImageSrc = r.ImageSrc,
PhoneNumber = r.PhoneNumber,
Latitude = r.Latitude ?? 0,
Longitude = r.Longitude ?? 0,
LastVisitDate = r.LastVisitDate ?? GetLastVisitDate(r)
};
return(rr);
} catch {
return(new ReturnVisitData());
}
}
}
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); }
}
}
internal static ReturnVisitData Copy(ReturnVisitDataItem newRv)
{
return(new ReturnVisitData()
{
ItemId = newRv.ItemId,
AddressOne = newRv.AddressOne,
AddressTwo = newRv.AddressTwo,
Age = newRv.Age,
City = newRv.City,
Country = newRv.Country,
DateCreated = newRv.DateCreated,
FullName = newRv.FullName,
Gender = newRv.Gender,
OtherNotes = newRv.OtherNotes,
PhysicalDescription = newRv.PhysicalDescription,
PostalCode = newRv.PostalCode,
StateProvince = newRv.StateProvince,
ImageSrc = newRv.ImageSrc,
PhoneNumber = newRv.PhoneNumber,
Latitude = newRv.Latitude ?? 0.0,
Longitude = newRv.Longitude ?? 0.0,
LastVisitDate = newRv.LastVisitDate ?? SqlCeConstants.DateTimeMinValue
});
}
