public static List <AgencyViewModel> GetAgencies(string sidx, string sord)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <AgencyViewModel> avm = new List <AgencyViewModel>();
List <Agency> agencies = opiddailycontext.Agencies.ToList();
foreach (Agency agency in agencies)
{
avm.Add(AgencyToAgencyViewModel(agency));
}
switch (sidx)
{
case "AgencyName":
if (sord.ToUpper().Equals("DESC"))
{
avm = avm.OrderByDescending(a => a.AgencyName).ToList();
}
else
{
avm = avm.OrderBy(a => a.AgencyName).ToList();
}
break;
default:
break;
}
return(avm);
}
}
public async Task <string> DeleteUser(int id)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Invitation invite = opiddailycontext.Invitations.Where(i => i.Id == id).SingleOrDefault();
if (invite != null)
{
var user = await UserManager.FindByNameAsync(invite.UserName);
if (user != null)
{
UserManager.Delete(user);
opiddailycontext.Invitations.Remove(invite);
opiddailycontext.SaveChanges();
return("Success");
}
else
{
opiddailycontext.Invitations.Remove(invite);
opiddailycontext.SaveChanges();
return("Success");
}
}
return("Failure");
}
}
public static List <PocketCheckViewModel> GetDependentPocketChecks(int id)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
PocketCheck pcheck = opiddailycontext.PocketChecks.Find(id);
if (pcheck != null)
{
Client client = opiddailycontext.Clients.Find(pcheck.ClientId);
if (client != null)
{
List <PocketCheck> dependentPocketChecks = opiddailycontext.PocketChecks.Where(pc => pc.HH == client.Id).ToList();
List <PocketCheckViewModel> pcvms = new List <PocketCheckViewModel>();
foreach (PocketCheck dependentPocketCheck in dependentPocketChecks)
{
PocketCheckViewModel pcvm = PocketCheckToPocketCheckViewModel(client, dependentPocketCheck);
pcvms.Add(pcvm);
}
return(pcvms);
}
return(null);
}
return(null);
}
}
public bool InUse(string userName)
{
using (IdentityDB identitycontext = new IdentityDB())
{
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(identitycontext));
ApplicationUser user = UserManager.FindByName(userName);
if (user != null)
{
return(true);
}
}
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
var user = opiddailycontext.Invitations.Where(i => i.UserName == userName).SingleOrDefault();
if (user != null)
{
return(true);
}
}
return(false);
}
public static void DeletePocketCheck(int nowServing, int id)
{
try
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Client client = opiddailycontext.Clients.Find(nowServing);
if (client != null)
{
PocketCheck pcheck = opiddailycontext.PocketChecks.Where(p => p.ClientId == nowServing).SingleOrDefault();
if (pcheck != null)
{
DeleteVisitNotes(pcheck.Id);
opiddailycontext.PocketChecks.Remove(pcheck);
opiddailycontext.SaveChanges();
}
}
}
}
catch (Exception e)
{
Log.Error(string.Format("Could not delete client with id = {0} Error {1}", nowServing, e.Message));
}
}
public static void DeleteMBVD(MBVDViewModel mbvdvm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
MBVD mbvd = opiddailycontext.MBVDS.Find(mbvdvm.MBVDId);
opiddailycontext.MBVDS.Remove(mbvd);
opiddailycontext.SaveChanges();
}
}
public static void DeleteVisitNotes(int id)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <TextMsg> textmsgs = opiddailycontext.TextMsgs.Where(m => m.Vid == id).ToList();
opiddailycontext.TextMsgs.RemoveRange(textmsgs);
opiddailycontext.SaveChanges();
}
}
public static void AddMBVD(MBVDViewModel mbvdvm)
{
MBVD mbvd = MBVDViewModelToMBVD(mbvdvm);
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
opiddailycontext.MBVDS.Add(mbvd);
opiddailycontext.SaveChanges();
}
}
public static void AddAgency(AgencyViewModel avm)
{
Agency agency = AgencyViewModelToAgency(avm);
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
opiddailycontext.Agencies.Add(agency);
opiddailycontext.SaveChanges();
}
}
public static void DeleteAgency(AgencyViewModel avm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Agency agency = opiddailycontext.Agencies.Find(avm.Id);
opiddailycontext.Agencies.Remove(agency);
opiddailycontext.SaveChanges();
}
}
public static void ExtendInvitation(InvitationViewModel ivm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Invitation invite = InvitationViewModelToInvite(ivm);
opiddailycontext.Invitations.Add(invite);
opiddailycontext.SaveChanges();
}
// SendEmailInvitation(invitation);
}
public static SelectList GetMBVDSelectList()
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <MBVD> mbvds = opiddailycontext.MBVDS.ToList();
mbvds = mbvds.OrderBy(m => m.MBVDId).ToList();
SelectList sl = new SelectList(mbvds, "MBVDId", "MBVDName");
return(sl);
}
}
public static void EditVisitNote(VisitNoteModel vnm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <TextMsg> textmsgs = opiddailycontext.TextMsgs.Where(m => m.Vid == vnm.Id).ToList();
if (textmsgs.Count == 1)
{
TextMsg textmsg = textmsgs[0];
VisitNoteModelToTextMsg(vnm, textmsg);
opiddailycontext.SaveChanges();
}
}
}
public static string GetMBVDName(int mbvdId)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
MBVD mbvd = opiddailycontext.MBVDS.Where(m => m.MBVDId == mbvdId).SingleOrDefault();
if (mbvd != null)
{
return(mbvd.MBVDName);
}
return("unknown mbvd");
}
}
public static void DeleteVisitNote(int id)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <TextMsg> textmsgs = opiddailycontext.TextMsgs.Where(m => m.Vid == id).ToList();
TextMsg textmsg = textmsgs[0];
if (textmsgs.Count == 1)
{
opiddailycontext.TextMsgs.Remove(textmsg);
opiddailycontext.SaveChanges();
}
}
}
public static string GetAgencyName(int agencyId)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Agency agency = opiddailycontext.Agencies.Where(a => a.AgencyId == agencyId).SingleOrDefault();
if (agency != null)
{
return(agency.AgencyName);
}
return("unknown agency");
}
}
public static void EditVisit(int nowServing, VisitViewModel vvm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Client client = opiddailycontext.Clients.Find(nowServing);
if (client != null)
{
AncientCheck ancientCheck = opiddailycontext.AncientChecks.Find(vvm.Id);
if (ancientCheck != null)
{
ancientCheck.Date = vvm.Date;
ancientCheck.Num = Convert.ToInt32(vvm.Check);
ancientCheck.Service = vvm.Item;
ancientCheck.Disposition = vvm.Status;
ancientCheck.Notes = vvm.Notes;
opiddailycontext.SaveChanges();
return;
}
RCheck rcheck = opiddailycontext.RChecks.Find(vvm.Id);
if (rcheck != null)
{
rcheck.Date = vvm.Date;
rcheck.Num = Convert.ToInt32(vvm.Check);
rcheck.Service = vvm.Item;
rcheck.Disposition = vvm.Status;
rcheck.Notes = vvm.Notes;
opiddailycontext.SaveChanges();
return;
}
PocketCheck pcheck = opiddailycontext.PocketChecks.Find(vvm.Id);
if (pcheck != null)
{
pcheck.Date = vvm.Date;
pcheck.Item = vvm.Item;
pcheck.Num = Convert.ToInt32(vvm.Check);
pcheck.Disposition = vvm.Status;
pcheck.Notes = vvm.Notes;
opiddailycontext.SaveChanges();
return;
}
}
}
}
public static void EditMBVD(MBVDViewModel mbvdvm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
MBVD mbvd = opiddailycontext.MBVDS.Find(mbvdvm.Id);
if (mbvd != null)
{
mbvd.MBVDId = mbvdvm.MBVDId;
mbvd.MBVDName = mbvdvm.MBVDName;
mbvd.IsActive = (mbvdvm.IsActive == "Yes" ? true : false);
opiddailycontext.SaveChanges();
}
}
}
public static void AddVisitNote(int nowServing, int vid, string sender, VisitNoteModel vnm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Client client = opiddailycontext.Clients.Find(nowServing);
opiddailycontext.Entry(client).Collection(c => c.TextMsgs).Load();
TextMsg textmsg = VisitNoteModelToTextMsg(vnm, vid);
client.TextMsgs.Add(textmsg);
opiddailycontext.SaveChanges();
}
}
public static List <VisitNoteModel> GetVisitNotes(int nowServing, int vid)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <TextMsg> textmsgs = opiddailycontext.TextMsgs.Where(m => m.Vid == vid).ToList();
List <VisitNoteModel> visitNotes = new List <VisitNoteModel>();
foreach (TextMsg textmsg in textmsgs)
{
visitNotes.Add(TextMsgToVisitNoteModel(textmsg));
}
return(visitNotes);
}
}
public static Invitation AcceptedInvitation(string userName, string email)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Invitation invite = opiddailycontext.Invitations.Where(i => i.UserName == userName).SingleOrDefault();
if (invite != null && invite.Email == email)
{
invite.Accepted = Extras.DateTimeToday();
opiddailycontext.SaveChanges();
return(invite);
}
return(null);
}
}
// Don't know how to move this to the CheckManager where it belongs because of return type issues.
// Just leave it here for now.
public JsonResult GetAncientChecks([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
using (OpidDailyDB opidcontext = new OpidDailyDB())
{
IQueryable <AncientCheck> query = opidcontext.AncientChecks;
var totalCount = query.Count();
// Apply filters for searching
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.Trim();
query = query.Where(p => p.Name.Contains(value) ||
p.sDOB.Contains(value) ||
p.sRecordID.Contains(value) ||
p.sInterviewRecordID.Contains(value) ||
p.sNum.Contains(value) ||
p.sDate.Contains(value) ||
p.Service.Contains(value) ||
p.Disposition.Contains(value)
);
}
var filteredCount = query.Count();
var fqo = query.OrderBy("Id asc"); // Order by the primary key for speed. Ordering by Name times out, because Name is not an indexed field.
// Paging
var fqop = fqo.Skip(requestModel.Start).Take(requestModel.Length);
var data = fqop.Select(ancientCheck => new
{
sRecordID = ancientCheck.sRecordID,
sInterviewRecordID = ancientCheck.sInterviewRecordID,
Name = ancientCheck.Name,
sDOB = ancientCheck.sDOB,
sNum = ancientCheck.sNum,
sDate = ancientCheck.sDate,
Service = ancientCheck.Service,
Disposition = ancientCheck.Disposition
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, filteredCount, totalCount), JsonRequestBehavior.AllowGet));
}
}
public static List <AgencyViewModel> GetAgencies()
{
List <AgencyViewModel> agenciesAVMS = new List <AgencyViewModel>();
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <Agency> agencies = opiddailycontext.Agencies.ToList();
agencies = agencies.OrderBy(a => a.AgencyId).ToList();
foreach (Agency agency in agencies)
{
agenciesAVMS.Add(AgencyEntityToAgencyViewModel(agency));
}
return(agenciesAVMS);
}
}
public static List <MBVDViewModel> GetMBVDS()
{
List <MBVDViewModel> mbvdvms = new List <MBVDViewModel>();
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <MBVD> mbvds = opiddailycontext.MBVDS.ToList();
mbvds = mbvds.OrderBy(m => m.MBVDId).ToList();
foreach (MBVD mbvd in mbvds)
{
mbvdvms.Add(MBVDToMBVDViewModel(mbvd));
}
return(mbvdvms);
}
}
public static string EditUser(InvitationViewModel invite)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Invitation invitation = opiddailycontext.Invitations.Find(invite.Id);
if (invitation != null && invitation.Accepted != (System.DateTime)System.Data.SqlTypes.SqlDateTime.Null)
{
return("Registered");
}
invitation.UserName = invite.UserName;
invitation.Email = invite.Email;
invitation.Role = invite.Role;
opiddailycontext.SaveChanges();
return("Success");
}
}
public static void AddPocketCheck(int nowServing, VisitViewModel vvm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Client client = opiddailycontext.Clients.Find(nowServing);
if (client != null)
{
opiddailycontext.PocketChecks.Add(NewPocketCheck(client, vvm));
// A pocket check must always have a corresponding check in the Research Table,
// because Service Tickets are generated from the visit history in the Research
// table, not by using any pocket checks. So, when we add a new pocket check
// we must also add a new corresponding research check.
opiddailycontext.RChecks.Add(NewRCheck(client, vvm));
opiddailycontext.SaveChanges();
}
}
}
public static SelectList GetAgenciesSelectList(int agencyId)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <Agency> agencies = opiddailycontext.Agencies.ToList();
agencies = agencies.OrderBy(a => a.AgencyId).ToList();
SelectList sl;
if (agencyId == 0) // agencyId == 0 => agency is OPID
{
sl = new SelectList(agencies, "AgencyId", "AgencyName");
}
else
{
sl = new SelectList(agencies, "AgencyId", "AgencyName", agencyId.ToString());
}
return(sl);
}
}
public static void EditUserAgencyId(int oldAgencyId, int newAgencyId)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
List <Invitation> invitations = opiddailycontext.Invitations.Where(i => i.AgencyId == oldAgencyId).ToList();
using (IdentityDB identitycontext = new IdentityDB())
{
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(identitycontext));
foreach (Invitation invite in invitations)
{
// The UserName in the Invitations table is the same as the UserName in table AspNetUsers.
ApplicationUser user = UserManager.FindByName(invite.UserName);
user.AgencyId = newAgencyId;
UserManager.Update(user);
invite.AgencyId = newAgencyId;
}
}
opiddailycontext.SaveChanges();
}
}
public static void EditAgency(AgencyViewModel avm)
{
using (OpidDailyDB opiddailycontext = new OpidDailyDB())
{
Agency agency = opiddailycontext.Agencies.Find(avm.Id);
List <Client> clients = opiddailycontext.Clients.Where(c => c.AgencyId == agency.AgencyId).ToList();
foreach (Client c in clients)
{
c.AgencyId = avm.AgencyId;
}
Users.EditUserAgencyId(agency.AgencyId, avm.AgencyId);
agency.AgencyId = avm.AgencyId;
agency.AgencyName = avm.AgencyName;
agency.ContactPerson = avm.ContactPerson;
agency.Phone = avm.Phone;
agency.Email = avm.Email;
agency.IsActive = (avm.IsActive == "Yes" ? true : false);
opiddailycontext.SaveChanges();
}
}
