public static List <VisitViewModel> GetVisits(int nowServing)
{
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
Client client = opiddailycontext.Clients.Find(nowServing);
string[] msgs = (string.IsNullOrEmpty(client.Msgs) ? new[] { "None:0" } : client.Msgs.Split(','));
DateTime DOB = client.DOB;
string lastName = Extras.StripSuffix(client.LastName.ToUpper());
if (client != null)
{
List <AncientCheck> ancientChecks = opiddailycontext.AncientChecks.Where(ac => ac.DOB == DOB && ac.Name.ToUpper().StartsWith(lastName)).ToList();
List <RCheck> rchecks = opiddailycontext.RChecks.Where(rc => rc.DOB == DOB && rc.Name.ToUpper().StartsWith(lastName)).ToList();
List <VisitViewModel> visits = new List <VisitViewModel>();
foreach (AncientCheck ancientCheck in ancientChecks)
{
visits.Add(AncientCheckToVisitViewModel(ancientCheck, msgs));
}
foreach (RCheck rcheck in rchecks)
{
visits.Add(RCheckToVisitViewModel(rcheck, msgs));
}
// Make sure that visits are listed by ascending date
visits = visits.OrderBy(v => v.Date).ToList();
return(visits);
}
}
return(null);
}
public static List <PocketCheckViewModel> GetPocketChecks()
{
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
List <PocketCheck> pchecks = opiddailycontext.PocketChecks.Where(pc => pc.HH == 0 && pc.IsActive == true).ToList();
List <PocketCheckViewModel> pocketChecks = new List <PocketCheckViewModel>();
foreach (PocketCheck pcheck in pchecks)
{
if (IsPocketCheck(pcheck))
{
Client client = opiddailycontext.Clients.Find(pcheck.ClientId);
if (client != null)
{
pocketChecks.Add(PocketCheckToPocketCheckViewModel(client, pcheck));
}
}
}
// Make sure that pocket checks are listed in alphabetical order
pocketChecks = pocketChecks.OrderBy(pc => pc.Name).ToList();
return(pocketChecks);
}
}
private static bool HavingConversation(int id)
{
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
bool havingConversation = opiddailycontext.TextMsgs.Any(tm => tm.Vid == id);
return(havingConversation);
}
}
public static void EditPocketCheck(PocketCheckViewModel pcvm)
{
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
PocketCheck pcheck = opiddailycontext.PocketChecks.Where(pc => pc.Id == pcvm.Id).SingleOrDefault();
if (pcheck != null)
{
pcheck.Notes = pcvm.Notes;
opiddailycontext.SaveChanges();
}
}
}
public static List <InvitationViewModel> GetUsers()
{
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
List <InvitationViewModel> invitations = new List <InvitationViewModel>();
List <Invitation> invites = opiddailycontext.Invitations.ToList();
foreach (Invitation invite in invites)
{
invitations.Add(InviteToInvitationViewModel(invite));
}
return(invitations);
}
}
public static List <VisitViewModel> GetPocketChecks(int nowServing)
{
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
Client client = opiddailycontext.Clients.Find(nowServing);
List <PocketCheck> pchecks = opiddailycontext.PocketChecks.Where(pc => pc.ClientId == client.Id && pc.IsActive == true).ToList();
List <VisitViewModel> visits = new List <VisitViewModel>();
foreach (PocketCheck pcheck in pchecks)
{
if (pcheck.IsActive)
{
visits.Add(PocketCheckToVisitViewModel(pcheck));
}
}
// Make sure that visits are listed by ascending date
visits = visits.OrderBy(v => v.Date).ToList();
return(visits);
}
}
private static string GetAgencyById(int agencyId)
{
if (agencyId == 0)
{
return("OpID");
}
else
{
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
foreach (Agency agency in opiddailycontext.Agencies)
{
if (agency.AgencyId == agencyId)
{
return(agency.AgencyName);
}
}
return("Unknown agency");
}
}
}
public static void SetDashboardMsgCnt()
{
DateTime today = Extras.DateTimeToday();
int msgCnt = 0;
using (OpidDailyDB opiddailycontext = new DataContexts.OpidDailyDB())
{
List <Client> clients = opiddailycontext.Clients.Where(c => c.HH == 0 && c.ServiceDate != c.Expiry && today <= c.Expiry && c.Active == true).ToList();
foreach (Client client in clients)
{
if (!string.IsNullOrEmpty(client.Msgs) && !client.Msgs.StartsWith("END"))
{
msgCnt += 1;
}
}
// Log.Info(string.Format("MsgCnt = {0}", msgCnt));
SessionHelper.Set("MsgCnt", msgCnt.ToString());
}
}
