/// <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 }); }