public static bool IsInitialCall(RvPreviousVisitData call)
{
//
using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) {
try {
var qry = from x in db.RvPreviousVisitItems
where x.RvItemId == call.RvItemId
orderby x.Date
select x;
if (qry.Any())
{
if (qry.Count() <= 1)
{
return(true);
}
var c = qry.ToArray().First();
if (c.ItemId == call.ItemId)
{
return(true);
}
}
return(false);
} catch (Exception) {
return(false);
}
}
}
/// <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>
/// 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);
}
}
internal static RvPreviousVisitItem Copy(RvPreviousVisitData call)
{
return(new RvPreviousVisitItem {
RvItemId = call.RvItemId,
Magazines = call.Magazines,
Books = call.Books,
Brochures = call.Brochures,
Tracts = call.Tracts,
Date = call.Date,
Notes = call.Notes
});
}
/// <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.");
}
}
}
public static RvPreviousVisitData[] GetCallsByDate(DateTime @from, DateTime tod)
{
//
using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) {
try { //new DateTime(tod.Year, tod.Month, tod.Day, 0,0,0).AddDays(1)
@from = new DateTime(@from.Year, @from.Month, @from.Day, 0, 0, 0);
tod = new DateTime(tod.Year, tod.Month, tod.Day, 0, 0, 0).AddDays(1);
var calls = from x in db.RvPreviousVisitItems
where x.Date >= @from && x.Date < tod
select x;
if (calls.Any())
{
return(calls.Select(c => RvPreviousVisitData.Copy(c)).ToArray());
}
} catch {
return(null);
}
}
return(null);
}
/// <summary>
/// Gets the previous visits.
/// </summary>
/// <param name="rvItemId">The rv item id.</param>
/// <param name="so">The Sort Order.</param>
/// <returns>RvPreviousVisitData[].</returns>
public static RvPreviousVisitData[] GetPreviousVisits(int rvItemId, SortOrder so)
{
var rvVists = new List <RvPreviousVisitData>();
using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) {
IOrderedQueryable <RvPreviousVisitItem> qry = from x in db.RvPreviousVisitItems
where x.RvItemId == rvItemId
orderby x.Date
select x;
if (qry.Any())
{
IEnumerable <RvPreviousVisitItem> visits = so == SortOrder.DateNewestToOldest ? qry.ToArray().Reverse() : qry.ToArray();
foreach (RvPreviousVisitItem v in visits)
{
rvVists.Add(RvPreviousVisitData.Copy(v));
}
return(rvVists.ToArray());
}
return(new RvPreviousVisitData[0]);
}
}
public static bool IsInitialCall(RvPreviousVisitData call)
{
//
using (var db = new RvPreviousVisitsContext(RvPreviousVisitsContext.DBConnectionString)) {
try {
var qry = from x in db.RvPreviousVisitItems
where x.RvItemId == call.RvItemId
orderby x.Date
select x;
if (qry.Any()) {
if (qry.Count() <= 1) return true;
var c = qry.ToArray().First();
if (c.ItemId == call.ItemId) return true;
}
return false;
} catch (Exception) {
return false;
}
}
}
internal static RvPreviousVisitItem Copy(RvPreviousVisitData call)
{
return new RvPreviousVisitItem {
RvItemId = call.RvItemId,
Magazines = call.Magazines,
Books = call.Books,
Brochures = call.Brochures,
Tracts = call.Tracts,
Date = call.Date,
Notes = call.Notes
};
}
