public List <FSA> GetFSAList(SponserUser user)
{
List <FSA> retLst = new List <FSA>();
var fsaLst = Entites.sp_GetFSA
(
user.TerritoryCovergae_AB,
user.TerritoryCovergae_BC,
user.TerritoryCovergae_MB,
user.TerritoryCovergae_NB,
user.TerritoryCovergae_NL,
user.TerritoryCovergae_NS,
user.TerritoryCovergae_ON,
user.TerritoryCovergae_PEI,
user.TerritoryCovergae_QC,
user.TerritoryCovergae_SK
).ToList();
foreach (var item in fsaLst)
{
if (!string.IsNullOrEmpty(item.FSA))
{
retLst.Add(
new FSA()
{
Name = item.FSA
}
);
}
}
return(retLst);
}
public void Register(SponserUser user)
{
Entites.sp_RegisterSponser(
user.FirstName,
user.LastName,
user.Company.ID,
user.Role.ID,
user.TerritoryCovergae_All.Value ? 1: 0,
user.TerritoryCovergae_BC.Value ? 1 : 0,
user.TerritoryCovergae_AB.Value ? 1 : 0,
user.TerritoryCovergae_SK.Value ? 1 : 0,
user.TerritoryCovergae_MB.Value ? 1 : 0,
user.TerritoryCovergae_ON.Value ? 1 : 0,
user.TerritoryCovergae_QC.Value ? 1 : 0,
user.TerritoryCovergae_NS.Value ? 1 : 0,
user.TerritoryCovergae_NB.Value ? 1 : 0,
user.TerritoryCovergae_NL.Value ? 1 : 0,
user.TerritoryCovergae_PEI.Value ? 1 : 0,
user.Username,
user.Password
);
}
public List <Payee> GetPayeeList(string idList)
{
List <Payee> lst = new List <Payee>();
foreach (var item in Entites.sp_GetPayeeList(idList))
{
lst.Add(
new Payee()
{
id = item.ID,
PhysicianFirstName = item.PhysicianFirstName,
PhysicianLastName = item.PhysicianLastName,
UserID = item.UserID,
PaymentMethod = item.PaymentMethod,
ChequePayableTo = item.ChequePayableTo,
InternalRefNum = item.InternalRefNum,
MailingAddr1 = item.MailingAddr1,
MailingAddr2 = item.MailingAddr2,
AttentionTo = item.AttentionTo,
City = item.City,
Province = item.Province,
PostalCode = item.PostalCode,
TaxNumber = item.TaxNumber,
AdditionalInstructions = item.AdditionalInstructions
}
);
}
return(lst);
}
public List <BI> Get_BI_List(SponserUser user)
{
List <BI> retLst = new List <BI>();
var biLst = Entites.sp_Get_BI
(
user.TerritoryCovergae_AB,
user.TerritoryCovergae_BC,
user.TerritoryCovergae_MB,
user.TerritoryCovergae_NB,
user.TerritoryCovergae_NL,
user.TerritoryCovergae_NS,
user.TerritoryCovergae_ON,
user.TerritoryCovergae_PEI,
user.TerritoryCovergae_QC,
user.TerritoryCovergae_SK
).ToList();
foreach (var item in biLst)
{
if (item.BI.HasValue)
{
retLst.Add(
new BI()
{
Name = item.BI.Value
}
);
}
}
return(retLst);
}
public string GetPatientAge(int patientID)
{
string retVal = string.Empty;
DateTime today = DateTime.Today;
List <string> result = Entites.sp_GetPatientAge(patientID).ToList();
if (result.Count > 0)
{
string dobStr = result[0].ToString();
//DateTime dob = Domain.Helper.GetCanadianDate(dobStr);
//DateTime dob = DateTime.Parse(DateTime.Parse(dobStr).ToString("dd/MM/yyyy"));
DateTime dob = DateTime.Parse(dobStr);
int age = today.Year - dob.Year;
if (dob > today.AddYears(-age))
{
age--;
}
retVal = age.ToString();
}
return(retVal);
}
/// <summary>
/// Method to get metadata of all resource or specific resource
/// </summary>
/// <param name="options">Enumerable of possible resources</param>
/// <param name="format">Enumerable of possible formats to get data</param>
/// <param name="id">id for get a specific product</param>
/// <returns></returns>
public async Task <string> GetDataAsync(Entites opcoes = Entites.Products, Format formato = Format.json, string id = null)
{
try
{
string url = string.Empty;
if (formato == Format.csv)
{
url = $"https://scihub.copernicus.eu/dhus/odata/v1/{opcoes}({id})?$format=text/csv";
}
else
{
url = $"https://scihub.copernicus.eu/dhus/odata/v1/{opcoes}({id})?$format={formato}";
}
Console.WriteLine($"url: {url}\n");
string teste = await Client.GetStringAsync(url);
var show = JValue.Parse(teste).ToString(Formatting.Indented);
Console.WriteLine(show);
return(teste);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(ex.Message);
}
}
public void AddInvitee(Domain.Invitee inv)
{
Entites.sp_AddPhysician
(
inv.FirstName,
inv.LastName,
inv.PrimaryWorkplace,
inv.Address,
inv.City,
inv.ProvinceID,
inv.PostalCode,
inv.Phone,
inv.Fax,
inv.OptInEmail,
inv.Comments,
inv.RegistrationCode,
inv.IsAdminApproved ? 1 : 0,
inv.PhysicianType == Enums.PhysicianType.PCP ? 1 : 2,
inv.YourFirstName,
inv.YourLastName,
inv.YourEmail,
inv.BITerritoryID,
inv.LillyID
);
}
public List <PCP_ActionItem> GetPCP_ActionItemReport()
{
List <PCP_ActionItem> retVal = new List <PCP_ActionItem>();
foreach (var item in Entites.sp_Get_ActionItems_PCP())
{
retVal.Add
(
new PCP_ActionItem()
{
FirstName = item.FirstName,
LastName = item.LastName,
WorkPlace = item.WorkPlace,
Address = item.Address,
City = item.City,
Province = item.Province,
PostalCode = item.PostalCode,
Phone = item.Phone,
Fax = item.Fax,
UserName = item.UserName,
MOU = item.MOU.HasValue ? item.MOU.Value ? "1" : "0" : "0",
Payee = item.Payee.HasValue ? item.Payee.Value ? "1" : "0" : "0",
NeedsAsssesment = item.NeedsAsssesment.HasValue ? item.NeedsAsssesment.Value ? "1" : "0" : "0",
ePAF1 = item.ePAF1.Value,
eMAf1 = item.eMAf1
}
);
}
return(retVal);
}
public List <Lilly> Get_Lilly_List(SponserUser user)
{
List <Lilly> retLst = new List <Lilly>();
var lillyLst = Entites.sp_Get_Lilly
(
user.TerritoryCovergae_AB,
user.TerritoryCovergae_BC,
user.TerritoryCovergae_MB,
user.TerritoryCovergae_NB,
user.TerritoryCovergae_NL,
user.TerritoryCovergae_NS,
user.TerritoryCovergae_ON,
user.TerritoryCovergae_PEI,
user.TerritoryCovergae_QC,
user.TerritoryCovergae_SK
).ToList();
foreach (var item in lillyLst)
{
if (!string.IsNullOrEmpty(item.Lilly))
{
retLst.Add(
new Lilly()
{
Name = item.Lilly
}
);
}
}
return(retLst);
}
public List <AllianceReport> GetAllianceReport()
{
List <AllianceReport> retVal = new List <AllianceReport>();
foreach (var item in Entites.sp_GetAllianceReport())
{
retVal.Add
(
new AllianceReport()
{
FirstName = item.FirstName,
LastName = item.LastName,
CompanyName = item.CompanyName,
Role = item.Role,
All = item.All.HasValue ? (item.All.Value ? "1" : "0"): "0",
BC = item.BC.HasValue ? (item.BC.Value ? "1" : "0") : "0",
AB = item.AB.HasValue ? (item.AB.Value ? "1" : "0") : "0",
SK = item.SK.HasValue ? (item.SK.Value ? "1" : "0") : "0",
MB = item.MB.HasValue ? (item.MB.Value ? "1" : "0") : "0",
ON = item.ON.HasValue ? (item.ON.Value ? "1" : "0") : "0",
QC = item.QC.HasValue ? (item.QC.Value ? "1" : "0") : "0",
NS = item.NS.HasValue ? (item.NS.Value ? "1" : "0") : "0",
NB = item.NB.HasValue ? (item.NB.Value ? "1" : "0") : "0",
NL = item.NL.HasValue ? (item.NL.Value ? "1" : "0") : "0",
PEI = item.PEI.HasValue ? (item.PEI.Value ? "1" : "0") : "0"
}
);
}
return(retVal);
}
public List <MasterReport> GetNotInvitedReport_Lilly(string biLst, bool isPCP)
{
List <MasterReport> retVal = new List <MasterReport>();
foreach (var item in Entites.sp_GetNotInvitedListReport_Lilly(biLst, isPCP ? 1 : 2))
{
retVal.Add
(
new MasterReport()
{
RegCode = item.RegCode,
FirstName = item.FirstName,
LastName = item.LastName,
FSA = item.FSA,
PostalCode = item.PostalCode,
Status = item.Status,
Clinic = item.Clinic,
Address = item.Address,
City = item.City,
Province = item.Province,
Phone = item.Phone,
Fax = item.Fax,
DocType = item.DocType == 1 ? "PCP" : "CS",
BITerritoryID = item.BITerritoryID.HasValue ? item.BITerritoryID.Value : new int?(),
LillyID = item.LillyID
}
);
}
return(retVal);
}
/// <summary>
/// Method to download and save the metadata into a file.
/// </summary>
/// <param name="path">Destination of downloaded file</param>
/// <param name="options">Resource to download</param>
/// <param name="id">Id of resource</param>
/// <returns></returns>
public async Task <bool> DownloadData(string path, string id, Entites opcoes = Entites.Products)
{
if (string.IsNullOrEmpty(id))
{
throw new Exception("The Id can't be null!");
}
try
{
string json = await GetDataAsync(id : id).ConfigureAwait(false);
var result = json.ExtractJsonId();
string url = result.D.Metadata.MediaSrc;
string fileName = $"{result.D.Name}.zip";
using (var response = await Client.GetAsync(url, HttpCompletionOption.ResponseHeadersRead).ConfigureAwait(false))
using (var streamToReadFrom = await response.Content.ReadAsStreamAsync())
{
string fileToWriteTo = Path.Combine(path, fileName);
using (var streamToWriteTo = File.Open(fileToWriteTo, FileMode.Create))
{
await streamToReadFrom.CopyToAsync(streamToWriteTo);
return(true);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
public void Delete(T t)
{
//throw new NotImplementedException();
//_dbContext.Set<T>().Remove(t);
Entites.Remove(t);
_dbContext.SaveChanges();
}
public List <Domain.EmailReminder> GetPendingNotifications()
{
List <Domain.EmailReminder> lst = new List <Domain.EmailReminder>();
foreach (sp_GetPendingNotifications_Result1 item in Entites.sp_GetPendingNotifications())
{
lst.Add(
new Domain.EmailReminder()
{
ID = item.ID,
PatientID = item.PatientID,
PhysicianID = item.PhysicianID,
VisitID = item.VisitID,
PhysicianEmail = item.PhysicianEmail,
Salutation = item.Salutation,
PhysicianFirstName = item.PhysicianFirstName,
PhysicianLastName = item.PhysicianLastName,
UserEmail = item.UserEmail,
PatientFirstName = item.PatientFirstName,
PatientLastName = item.PatientLastName,
}
);
}
return(lst);
}
public void Update(Entites.Product.Product product)
{
if(product != null)
{
Delete(product.ID);
Add(product);
}
}
public List <PatientVisit> GetPatientsByPhysicians(int physicianID)
{
int itemNum = 0;
List <PatientVisit> retLst = new List <PatientVisit>();
foreach (var item in Entites.sp_GetPatientStatusByPhysican(physicianID).ToList())
{
PatientVisit patVisit = new PatientVisit();
patVisit.PatientID = item.ID.Value;
patVisit.FirstName = Cholestabetes.Encryption.Encryptor.Decrypt(item.FirstName);
patVisit.LastName = Cholestabetes.Encryption.Encryptor.Decrypt(item.LastName);
patVisit.Telephone = Cholestabetes.Encryption.Encryptor.Decrypt(item.Telephone);
patVisit.PhysicianID = item.UserID.Value;
patVisit.VisitStatus1 = item.VisitStatus1.Value;
if (item.VisitDateTime1 != null)
{
patVisit.VisitDateTime1 = item.VisitDateTime1.Value;
}
patVisit.Visit1ScreenID = item.Visit1ScreenID.Value;
patVisit.VisitStatus2 = item.VisitStatus2.Value;
if (item.VisitDateTime2 != null)
{
patVisit.VisitDateTime2 = item.VisitDateTime2.Value;
}
patVisit.Visit2ScreenID = item.Visit2ScreenID.Value;
patVisit.VisitStatus3 = item.VisitStatus3.Value;
if (item.VisitDateTime3 != null)
{
patVisit.VisitDateTime3 = item.VisitDateTime3.Value;
}
patVisit.Visit3ScreenID = item.Visit3ScreenID.Value;
patVisit.Visit1StartDate = item.Visit1StartDate;
patVisit.Visit1EndDate = item.Visit1EndDate;
patVisit.Visit2StartDate = item.Visit2StartDate;
patVisit.Visit2EndDate = item.Visit2EndDate;
patVisit.Visit3StartDate = item.Visit3StartDate;
patVisit.Visit3EndDate = item.Visit3EndDate;
patVisit.PatientName = item.PatientName;
patVisit.AutoNumber = (++itemNum).ToString("D2");
retLst.Add(patVisit);
}
return(retLst);
}
public void Dispose()
{
Entites.ForEach((t) =>
{
t.Entities = null;
});
EntityCreated = null;
ContextModifed = null;
}
public static void Tick()
{
GlobalTicks++;
Entites.ForEach(x => x.Tick());
Entites.Where(x => x.Position == Player.Position).ToList().ForEach(x => x.OnCollide(Player));
if (Exit.Position == Player.Position)
{
Exit.OnCollide(Player);
}
}
public void Update(T t)
{
if (t == null)
{
throw new ArgumentNullException(nameof(T));
}
Entites.Update(t);
_dbContext.SaveChanges();
//throw new NotImplementedException();
}
public string GetPatientName(int patientID)
{
string retStr = string.Empty;
foreach (var item in Entites.sp_GetPatientName(patientID))
{
retStr += item.AnswerValue + " ";
}
return(retStr.TrimEnd(" ".ToCharArray()));
}
public void Set_PS(Remuneration_PS ren)
{
Entites.sp_Set_PS
(
ren.InviteeID,
ren.Date,
ren.Received,
ren.GiftCard
);
}
public bool UpdateAll(Entites.Product.Product[] products)
{
int totalTax = 0;
if(products.Length > 0)
{
List<Product> productList = new List<Product>(products);
totalTax = CalculateTax(products);
return _productRespository.UpdateAll(productList);
}
return true;
}
public void Set_Assesment_Remuneration(Remuneration ren)
{
Entites.sp_Set_Assesment_Remuneration(
ren.Date,
ren.Cheque,
ren.Amount,
ren.Comments,
ren.InviteeID
);
}
public void SaveName(int patientID, string firstName, string lastName, string telephone)
{
//Entites.sp_SavePatientName(patientID, firstName, lastName, telephone);
Entites.sp_SavePatientName(
patientID,
Cholestabetes.Encryption.Encryptor.Encrypt(firstName),
Cholestabetes.Encryption.Encryptor.Encrypt(lastName),
Cholestabetes.Encryption.Encryptor.Encrypt(telephone)
);
}
public Page4Values GetPage4Values(int patientID)
{
var result = Entites.sp_GetPage4Values(patientID).Single();
return(new Page4Values
{
AddColesevelam = result.AddColesevelam == 1,
AddEzetimibe = result.AddEzetimibe == 1,
AddFibrate = result.AddFibrate == 1,
AddNiacin = result.AddNiacin == 1
});
}
internal Context InitailizeRows(EntitiesContext mctx, Dictionary <string, Func <object, object> > ini)
{
Entites.ForEach((e) =>
{
e.Entities = ini[e.Name](mctx).CastToType <IEnumerable <Entity> >();
IEntityCollection collection = e.Entities as IEntityCollection;
if (collection.IsNotNull())
{
collection.Context = this;
}
});
return(this);
}
public void Save(List <AnsweredQuestion> lst)
{
foreach (AnsweredQuestion item in lst)
{
Entites.sp_SaveAnswer
(
item.UserID,
item.QID,
item.AID,
item.Answer
);
}
}
public string GetSponserPassword(string userName)
{
string retVal = string.Empty;
var row = Entites.sp_GetSponserDetails_UserName(userName).SingleOrDefault();
if (row != null)
{
retVal = row.Password.ToString();
}
return(retVal);
}
public List <Domain.Invitee> GetAllInviteesByProvincePending(int provinceID, bool?isPCP)
{
List <Domain.Invitee> retLst = new List <Domain.Invitee>();
foreach (var item in Entites.sp_GetAllInviteesPending(provinceID, isPCP.HasValue ? (isPCP.Value ? 1 : 2) : 0))
{
Domain.Invitee newInvitee = new Domain.Invitee();
newInvitee.PhysicianID = item.ID;
newInvitee.Speciality = item.Specialty;
newInvitee.OneKeyID = item.OneKeyID;
newInvitee.RegistrationCode = item.RegCode;
newInvitee.FirstName = item.FirstName;
newInvitee.LastName = item.LastName;
newInvitee.PrimaryWorkplace = item.PrimaryWorkplace;
newInvitee.Address = item.Address;
newInvitee.City = item.City;
newInvitee.ProvinceID = item.ProvinceID.HasValue ? item.ProvinceID.Value : 0;
newInvitee.Invited = item.Invited.HasValue ? item.Invited.Value : false;
newInvitee.Status = item.RegistrationStatusID;
newInvitee.PostalCode = item.PostalCode;
newInvitee.Phone = item.Phone;
newInvitee.Fax = item.Fax;
newInvitee.OptInEmail = item.OptInEmail;
newInvitee.YourFirstName = item.AdderFirstName;
newInvitee.YourLastName = item.AdderLastName;
newInvitee.YourEmail = item.AdderEmail;
newInvitee.Province = new Domain.Province()
{
ID = item.ProvinceID, Name = item.Province
};
newInvitee.ReStatus = new RegistrationStatus()
{
ID = item.RegistrationStatusID, Name = item.Status
};
newInvitee.FSA = item.FSA;
newInvitee.InvitationSentDate = item.InvitationSentDate;
newInvitee.InvitationSentDateFrench = item.InvitationSentDateFrench;
newInvitee.PhysicianType = item.TypeID.Value == 1 ? VistaDM.Domain.Enums.PhysicianType.PCP : VistaDM.Domain.Enums.PhysicianType.CS;
retLst.Add(newInvitee);
}
return(retLst);
}
public List <Cholestabetes.Domain.Question> GetQuestionList(int screenID)
{
int lastQID = -1;
bool addQuestion = false;
List <Cholestabetes.Domain.Question> questionLst = new List <Domain.Question>();
foreach (sp_GetQuestionsAnswersByScreen_Result item in Entites.sp_GetQuestionsAnswersByScreen(screenID).ToList())
{
Domain.Question question = null;
if (lastQID != item.QuestionID)
{
question = new Domain.Question();
question.ID = item.QuestionID;
question.Required = item.QuestionRequired;
question.Sequence = item.QuestionSequence;
question.Text = item.QuestionText;
question.Type = item.QuestionType;
question.Screen = item.Screen.Value;
addQuestion = true;
}
else
{
question = questionLst[questionLst.Count - 1] as Domain.Question;
addQuestion = false;
}
//getting answers
Domain.Answer ans = new Domain.Answer();
ans.ID = item.AnswerID;
ans.QID = item.AnswerQuestionID;
ans.Text = item.AnswerText;
question.Answers.Add(ans);
if (addQuestion)
{
questionLst.Add(question);
}
lastQID = item.QuestionID;
}
return(questionLst);
}
public DateTime GetVisit1DateOfConsent(int patientID)
{
DateTime retVal = DateTime.MinValue;
DateTime dummy;
List <string> lst = Entites.sp_GetVisit1DateOfConsent(patientID).ToList();
if (lst.Count > 0)
{
string resultStr = lst[0].ToString();
retVal = Domain.Helper.GetCanadianDate(resultStr);
}
return(retVal);
}
public Page4ValuesSec GetPage4ValuesSec(int patientID)
{
var result = Entites.sp_GetPage4ValuesSec(patientID).Single();
return(new Page4ValuesSec
{
AddGlucosidase = result.AddGlucosidase == 1,
AddDPP4 = result.AddDPP4 == 1,
AddGLP1 = result.AddGLP1 == 1,
AddInsulin = result.AddInsulin == 1,
AddMeglitinide = result.AddMeglitinide == 1,
AddSGLT2 = result.AddSGLT2 == 1,
AddSulfonylurear = result.AddSulfonylurear == 1,
AddThiazolidinedione = result.AddThiazolidinedione == 1
});
}
public void Add(Entites.Product.Product product)
{
_productService.Add(product);
}
public bool UpdateAll(Entites.Product.Product[] products)
{
return _productService.UpdateAll(products);
}
public void Add(Entites.Product.Product product)
{
productList.Add(product);
}
public int CalculateTotal(Entites.Product.Product[] products)
{
return _productService.CalculateTax(products);
}
