public void SearchOne_Full()
{
using (TestMqServiceClient mq = new TestMqServiceClient())
{
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
//Регистрируем один случай. Статус направления "Зарегистрировано в РЕГИЗ.УО"
Referral referral = (new SetData()).FullRegister();
var result = mq.Register(cr, referral);
//Задаём Options по зарегистрированному направлению и ищем его
Coding cod = new Coding {
Code = "1", System = Dictionary.REFERRAL_STATUS, Version = "1"
};
Options opt = (new SetData()).GetRefferalReturnOptions_SearchOne(referral, referral.Patient.Privileges, result.IdMq, result.MqReferralStatus);
var res2 = mq.SearchOne(cr, opt);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void FullHealthCareStart()
{
using (MqServiceClient mq = new MqServiceClient())
{
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
Referral referral = (new SetData()).MinRegister();
var result = mq.Register(cr, referral);
//"Выдано пациенту"
referral = (new SetData()).MinPatientDocumentIssue(result.IdMq);
var res2 = mq.PatientDocumentIssue(cr, referral);
//"Выделена единица ресурса, целевой МО назначена дата приема"
referral = (new SetData()).MinChangePlannedResource(result.IdMq);
var res3 = mq.ChangePlannedResource(cr, referral);
referral = (new SetData()).FullHealthCareStart(result.IdMq);
var res4 = mq.HealthCareStart(cr, referral);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void StatusPatientDocumentIssue_curStat1()
{
using (TestMqServiceClient mq = new TestMqServiceClient())
{
//Задаём статус направления "Зарегистрировано в РЕГИЗ.УО"
Referral referral = (new SetData()).MinRegister();
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
var result = mq.Register(cr, referral);
//Задаём статус "Выдано пациенту"
referral = (new SetData()).SetStatus_PatientDocumentIssue(result.IdMq);
var res2 = mq.UpdateFromSourcedMo(cr, referral);
if (res2.MqReferralStatus.Code != "3")
{
Global.errors1.Add("Неверный статус:" + res2.MqReferralStatus.Code + "");
}
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void FullChangePlannedResource()
{
using (MqServiceClient mq = new MqServiceClient())
{
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
Referral referral = (new SetData()).MinRegister();
var result = mq.Register(cr, referral);
//"Выдано пациенту"
referral = (new SetData()).MinPatientDocumentIssue(result.IdMq);
var res2 = mq.PatientDocumentIssue(cr, referral);
referral = (new SetData()).FullChangePlannedResource(result.IdMq);
var res3 = mq.ChangePlannedResource(cr, referral);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void StatusCancellation_CurStat2()
{
using (TestMqServiceClient mq = new TestMqServiceClient())
{
//Задаём статус направления "Зарегистрировано в РЕГИЗ.УО"
Referral referral = (new SetData()).MinRegister();
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
var result = mq.Register(cr, referral);
//Задаём статус "Согласовано в направляющей МО"
referral = (new SetData()).SetStatus_AgreedInSourcedMO(result.IdMq);
var res2 = mq.UpdateFromSourcedMo(cr, referral);
//Задаём статус "Аннулировано"
referral = (new SetData()).MinCancellation(result.IdMq);
var res3 = mq.Cancellation(cr, referral);
if (res3.MqReferralStatus.Code != "0")
{
Global.errors1.Add("Неверный статус:" + res3.MqReferralStatus.Code + "");
}
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void SearchOne_CheckRelevance()
{
using (TestMqServiceClient mq = new TestMqServiceClient())
{
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
//Регистрируем один случай. Статус направления "Зарегистрировано в РЕГИЗ.УО"
Referral referral = (new SetData()).FullRegister();
var result = mq.Register(cr, referral);
referral = (new SetData()).FullUpdateFromSourcedMo(result.IdMq);
var res2 = mq.UpdateFromSourcedMo(cr, referral);
//Задаём Options по зарегистрированному направлению и ищем его
Options opt = (new SetData()).GetRefferalReturnOptions_SearchOne(referral, referral.Patient.Privileges, result.IdMq, res2.MqReferralStatus);
var res3 = mq.SearchOne(cr, opt);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
private void butSlip_Click(object sender, EventArgs e)
{
int idx = gridMain.GetSelectedIndex();
if (idx == -1)
{
MsgBox.Show(this, "Please select a referral first");
return;
}
Referral referral = ReferralL.GetReferral(((RefAttach)gridMain.Rows[idx].Tag).ReferralNum);
if (referral == null)
{
return;
}
SheetDef sheetDef;
if (referral.Slip == 0)
{
sheetDef = SheetsInternal.GetSheetDef(SheetInternalType.ReferralSlip);
}
else
{
sheetDef = SheetDefs.GetSheetDef(referral.Slip);
}
Sheet sheet = SheetUtil.CreateSheet(sheetDef, PatNum);
SheetParameter.SetParameter(sheet, "PatNum", PatNum);
SheetParameter.SetParameter(sheet, "ReferralNum", referral.ReferralNum);
SheetFiller.FillFields(sheet);
SheetUtil.CalculateHeights(sheet);
FormSheetFillEdit.ShowForm(sheet);
}
public MqResult Cancellation(Credentials cr, Referral r)
{
try
{
TestReferral tr = TestReferral.BuildReferralFromDataBaseData(r.ReferralInfo.IdMq);
tr.evInfo.cancellation = new TestCancellation(r.EventsInfo.Cancellation);
MqResult x = client.Cancellation(cr, r);
if (tr != TestReferral.BuildReferralFromDataBaseData(x.IdMq))
{
Global.errors1.Add("Несовпадение");
Global.errors1.AddRange(Global.errors2);
}
return x;
}
catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault[]> e)
{
getErrors(e.Detail);
return null;
}
catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault> e)
{
Global.errors1.Add(e.Detail.PropertyName + " - " + e.Detail.Message);
return null;
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<Referral> TableToList(DataTable table){
List<Referral> retVal=new List<Referral>();
Referral referral;
for(int i=0;i<table.Rows.Count;i++) {
referral=new Referral();
referral.ReferralNum = PIn.Long (table.Rows[i]["ReferralNum"].ToString());
referral.LName = PIn.String(table.Rows[i]["LName"].ToString());
referral.FName = PIn.String(table.Rows[i]["FName"].ToString());
referral.MName = PIn.String(table.Rows[i]["MName"].ToString());
referral.SSN = PIn.String(table.Rows[i]["SSN"].ToString());
referral.UsingTIN = PIn.Bool (table.Rows[i]["UsingTIN"].ToString());
referral.Specialty = (OpenDentBusiness.DentalSpecialty)PIn.Int(table.Rows[i]["Specialty"].ToString());
referral.ST = PIn.String(table.Rows[i]["ST"].ToString());
referral.Telephone = PIn.String(table.Rows[i]["Telephone"].ToString());
referral.Address = PIn.String(table.Rows[i]["Address"].ToString());
referral.Address2 = PIn.String(table.Rows[i]["Address2"].ToString());
referral.City = PIn.String(table.Rows[i]["City"].ToString());
referral.Zip = PIn.String(table.Rows[i]["Zip"].ToString());
referral.Note = PIn.String(table.Rows[i]["Note"].ToString());
referral.Phone2 = PIn.String(table.Rows[i]["Phone2"].ToString());
referral.IsHidden = PIn.Bool (table.Rows[i]["IsHidden"].ToString());
referral.NotPerson = PIn.Bool (table.Rows[i]["NotPerson"].ToString());
referral.Title = PIn.String(table.Rows[i]["Title"].ToString());
referral.EMail = PIn.String(table.Rows[i]["EMail"].ToString());
referral.PatNum = PIn.Long (table.Rows[i]["PatNum"].ToString());
referral.NationalProvID = PIn.String(table.Rows[i]["NationalProvID"].ToString());
referral.Slip = PIn.Long (table.Rows[i]["Slip"].ToString());
referral.IsDoctor = PIn.Bool (table.Rows[i]["IsDoctor"].ToString());
referral.IsTrustedDirect= PIn.Bool (table.Rows[i]["IsTrustedDirect"].ToString());
retVal.Add(referral);
}
return retVal;
}
public Referral FullRegister()
{
Referral referral = ReferralData.referral;
//если передаётся Survey, то ReferralType должен быть 3, согласно правилам валидации
referral.ReferralInfo.ReferralType = new Coding {
Code = "3", System = Dictionary.REFERRAL_TYPE, Version = "1"
};
referral.Target = new ReferralTarget
{
IdCaseMis = ReferralData.referralTarget.IdCaseMis,
Lpu = ReferralData.referralTarget.Lpu
};
referral.EventsInfo = new EventsInfo
{
Source = ReferralData.eventsInfo.Source,
Target = new EventTarget
{
IsReferralReviwed = ReferralData.eventsInfo.Target.IsReferralReviwed,
ReferralReviewDate = ReferralData.eventsInfo.Target.ReferralReviewDate,
ReceptionAppointComment = ReferralData.eventsInfo.Target.ReceptionAppointComment,
ReceptionAppointDate = ReferralData.eventsInfo.Target.ReceptionAppointDate,
ReceptionAppointTime = ReferralData.eventsInfo.Target.ReceptionAppointTime
}
};
return(referral);
}
//document = либо DocumentData.SingleOMS, либо DocumentData.OldOMS
public Referral SetStatus_HealthCareStart(string idMq, DocumentDto document)
{
Referral referral = (new SetData()).MinUpdateFromTargetMO(idMq);
referral.Patient = new Patient
{
Documents = new DocumentDto[]
{
new DocumentDto
{
ProviderName = document.ProviderName,
DocumentType = document.DocumentType
}
}
};
referral.EventsInfo = new EventsInfo
{
Target = new EventTarget
{
CaseOpenDate = ReferralData.eventsInfo.Target.CaseOpenDate,
CaseAidForm = ReferralData.eventsInfo.Target.CaseAidForm,
CaseAidPlace = ReferralData.eventsInfo.Target.CaseAidPlace,
CaseAidType = ReferralData.eventsInfo.Target.CaseAidType
}
};
return(referral);
}
public Referral FullPatientDocumentIssue(string idMq)
{
Referral referral = MinPatientDocumentIssue(idMq);
referral.EventsInfo.Source.PlannedDate = ReferralData.eventsInfo.Source.PlannedDate;
return(referral);
}
public Referral FullChangePlannedResource(string idMq)
{
Referral referral = MinChangePlannedResource(idMq);
referral.EventsInfo.Target.ReceptionAppointComment = ReferralData.eventsInfo.Target.ReceptionAppointComment;
return(referral);
}
private void BtAddReferral_Click(object sender, RoutedEventArgs e)
{
int nbOfDays;
bool success;
if (CbPatient.SelectedItem != null && TbDiagnosis.Text != "" && TbIcd10.Text != "" && DpDateReferral.SelectedDate != null)
{
success = int.TryParse(TbNbOfDays.Text, out nbOfDays);
if (success)
{
MessageBoxResult result = MessageBox.Show("Czy zapisać skierowanie dla pacjenta " + ((Patient)CbPatient.SelectedItem).Name + " " + ((Patient)CbPatient.SelectedItem).Surname + "?", "Zapis", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
Referral.AddReferral(TbDiagnosis.Text, TbIcd10.Text, TbTreatments.Text, TbDoctor.Text, nbOfDays, DpDateReferral.SelectedDate.Value, CbPatient.SelectedItem as Patient, dbcontext);
TbDiagnosis.Clear(); TbIcd10.Clear(); DpDateReferral.SelectedDate = null; TbNbOfDays.Clear(); CbPatient.SelectedItem = null; TbTreatments.Clear(); TbDoctor.Clear();
}
}
else
{
MessageBox.Show("Podaj poprawną liczbę wizyt!");
}
}
else
{
MessageBox.Show("Uzupełnij wszystkie dane!");
}
referralDataGrid.Items.Refresh();
}
/// <summary>
/// Removes all referrals attached to student
/// </summary>
/// <param name="studentid">ID of student to delete referrals for</param>
public async Task DeleteStudentsReferrals(int studentid)
{
var studentReferrals = (from referrals in _context.Referrals
select new
{
referrals.ReferralId,
referrals.StudentId
}).Where(r => r.StudentId == studentid);
List <Referral> studentReferralsList = new List <Referral>();
foreach (var r in studentReferrals)
{
Referral newReferral = new Referral()
{
ReferralId = r.ReferralId,
StudentId = r.StudentId
};
studentReferralsList.Add(newReferral);
}
_context.Referrals.RemoveRange(studentReferralsList);
await _context.SaveChangesAsync();
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Referral> TableToList(DataTable table)
{
List <Referral> retVal = new List <Referral>();
Referral referral;
for (int i = 0; i < table.Rows.Count; i++)
{
referral = new Referral();
referral.ReferralNum = PIn.Long(table.Rows[i]["ReferralNum"].ToString());
referral.LName = PIn.String(table.Rows[i]["LName"].ToString());
referral.FName = PIn.String(table.Rows[i]["FName"].ToString());
referral.MName = PIn.String(table.Rows[i]["MName"].ToString());
referral.SSN = PIn.String(table.Rows[i]["SSN"].ToString());
referral.UsingTIN = PIn.Bool(table.Rows[i]["UsingTIN"].ToString());
referral.Specialty = (DentalSpecialty)PIn.Int(table.Rows[i]["Specialty"].ToString());
referral.ST = PIn.String(table.Rows[i]["ST"].ToString());
referral.Telephone = PIn.String(table.Rows[i]["Telephone"].ToString());
referral.Address = PIn.String(table.Rows[i]["Address"].ToString());
referral.Address2 = PIn.String(table.Rows[i]["Address2"].ToString());
referral.City = PIn.String(table.Rows[i]["City"].ToString());
referral.Zip = PIn.String(table.Rows[i]["Zip"].ToString());
referral.Note = PIn.String(table.Rows[i]["Note"].ToString());
referral.Phone2 = PIn.String(table.Rows[i]["Phone2"].ToString());
referral.IsHidden = PIn.Bool(table.Rows[i]["IsHidden"].ToString());
referral.NotPerson = PIn.Bool(table.Rows[i]["NotPerson"].ToString());
referral.Title = PIn.String(table.Rows[i]["Title"].ToString());
referral.EMail = PIn.String(table.Rows[i]["EMail"].ToString());
referral.PatNum = PIn.Long(table.Rows[i]["PatNum"].ToString());
referral.NationalProvID = PIn.String(table.Rows[i]["NationalProvID"].ToString());
referral.Slip = PIn.Long(table.Rows[i]["Slip"].ToString());
referral.IsDoctor = PIn.Bool(table.Rows[i]["IsDoctor"].ToString());
retVal.Add(referral);
}
return(retVal);
}
private static IAppointmentRepository CreateAppointmentStubRepository()
{
var stubRepository = new Mock <IAppointmentRepository>();
var appointments = new List <DoctorAppointment>();
Referral referral1 = new Referral(1, "Medicine", "Take medicine until", 3, "classify", "comment", 1);
Referral referral2 = new Referral(2, "Medicine2", "Take medicine until", 3, "Appointment", "comment", 1);
var referrals = new List <Referral>();
referrals.Add(referral1);
referrals.Add(referral1);
DoctorAppointment appointment1 = new DoctorAppointment(1, new TimeSpan(), "22/04/2020", new PatientUser(), new DoctorUser(1, "DoctorName", "DoctorSurname", "1234", "2/2/2020", "123", "email", "pass", "Grad",
200.0, false, "Specialty", new List <DoctorNotification>(), "Ordination 1"), new List <Referral>(), "1");
DoctorAppointment appointment2 = new DoctorAppointment(2, new TimeSpan(), "22/08/2020", new PatientUser(), new DoctorUser(1, "Pera", "Jovanovic", "1234", "2/2/2020", "123", "email", "pass", "Grad",
200.0, false, "Specialty", new List <DoctorNotification>(), "Ordination 1"), new List <Referral>(), "1");
appointments.Add(appointment1);
appointments.Add(appointment2);
stubRepository.Setup(m => m.GetAppointmentsForPatient(2)).Returns(appointments);
return(stubRepository.Object);
}
public void FullUpdateFromSourcedMo()
{
using (MqServiceClient mq = new MqServiceClient())
{
Referral referral = (new SetData()).MinRegister();
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
var result = mq.Register(cr, referral);
//обновляем данные
referral = (new SetData()).FullUpdateFromSourcedMo(result.IdMq);
try
{
var updateResult = mq.UpdateFromSourcedMo(cr, referral);
}
catch (FaultException <MqTests.WebReference.MqFault> e)
{
string s = e.Detail.MqFaults[0].Message;
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
}
///<summary>Updates one Referral in the database.</summary>
public static void Update(Referral referral)
{
string command = "UPDATE referral SET "
+ "LName = '" + POut.String(referral.LName) + "', "
+ "FName = '" + POut.String(referral.FName) + "', "
+ "MName = '" + POut.String(referral.MName) + "', "
+ "SSN = '" + POut.String(referral.SSN) + "', "
+ "UsingTIN = " + POut.Bool(referral.UsingTIN) + ", "
+ "Specialty = " + POut.Int((int)referral.Specialty) + ", "
+ "ST = '" + POut.String(referral.ST) + "', "
+ "Telephone = '" + POut.String(referral.Telephone) + "', "
+ "Address = '" + POut.String(referral.Address) + "', "
+ "Address2 = '" + POut.String(referral.Address2) + "', "
+ "City = '" + POut.String(referral.City) + "', "
+ "Zip = '" + POut.String(referral.Zip) + "', "
+ "Note = '" + POut.String(referral.Note) + "', "
+ "Phone2 = '" + POut.String(referral.Phone2) + "', "
+ "IsHidden = " + POut.Bool(referral.IsHidden) + ", "
+ "NotPerson = " + POut.Bool(referral.NotPerson) + ", "
+ "Title = '" + POut.String(referral.Title) + "', "
+ "EMail = '" + POut.String(referral.EMail) + "', "
+ "PatNum = " + POut.Long(referral.PatNum) + ", "
+ "NationalProvID= '" + POut.String(referral.NationalProvID) + "', "
+ "Slip = " + POut.Long(referral.Slip) + ", "
+ "IsDoctor = " + POut.Bool(referral.IsDoctor) + " "
+ "WHERE ReferralNum = " + POut.Long(referral.ReferralNum);
Db.NonQ(command);
}
public static List <Referral> SampleReferralData()
{
List <Referral> returnedRefs = new List <Referral>();
Referral testRef1 = new Referral()
{
ApplicationId = 1,
Application = null,
ReferralId = 0,
Name = "Jane Doe",
Email = "*****@*****.**",
Position = "HR Manager",
Company = "Google",
Phone = "555-123-5555"
};
returnedRefs.Add(testRef1);
Referral testRef2 = new Referral()
{
ApplicationId = 1,
Application = null,
ReferralId = 1,
Name = "Dua Lipa",
Email = "*****@*****.**",
Position = "Pop Icon",
Company = "Billboard",
Phone = "555-123-1234"
};
returnedRefs.Add(testRef2);
return(returnedRefs);
}
public IHttpActionResult PostReferral(Referral referral)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Referrals.Add(referral);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (ReferralExists(referral.CMHCNO))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = referral.CMHCNO }, referral));
}
public IHttpActionResult PutReferral(int id, Referral referral)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != referral.CMHCNO)
{
return(BadRequest());
}
db.Entry(referral).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ReferralExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
///<summary>Inserts one Referral into the database. Returns the new priKey.</summary>
public static long Insert(Referral referral)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
referral.ReferralNum = DbHelper.GetNextOracleKey("referral", "ReferralNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(referral, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
referral.ReferralNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(referral, false));
}
}
public TestReferral(Referral r, string idLpu = "")
{
referral = r;
attachment = new TestAttachment(r.Attachment);
doctor = new TestDoctor(r.Author, idLpu);
departmentHead = new TestDoctor(r.DepartmentHead, idLpu);
}
///<summary>Inserts one Referral into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(Referral referral, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO referral (";
if (!useExistingPK && isRandomKeys)
{
referral.ReferralNum = ReplicationServers.GetKeyNoCache("referral", "ReferralNum");
}
if (isRandomKeys || useExistingPK)
{
command += "ReferralNum,";
}
command += "LName,FName,MName,SSN,UsingTIN,Specialty,ST,Telephone,Address,Address2,City,Zip,Note,Phone2,IsHidden,NotPerson,Title,EMail,PatNum,NationalProvID,Slip,IsDoctor,IsTrustedDirect,IsPreferred) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(referral.ReferralNum) + ",";
}
command +=
"'" + POut.String(referral.LName) + "',"
+ "'" + POut.String(referral.FName) + "',"
+ "'" + POut.String(referral.MName) + "',"
+ "'" + POut.String(referral.SSN) + "',"
+ POut.Bool(referral.UsingTIN) + ","
+ POut.Long(referral.Specialty) + ","
+ "'" + POut.String(referral.ST) + "',"
+ "'" + POut.String(referral.Telephone) + "',"
+ "'" + POut.String(referral.Address) + "',"
+ "'" + POut.String(referral.Address2) + "',"
+ "'" + POut.String(referral.City) + "',"
+ "'" + POut.String(referral.Zip) + "',"
+ DbHelper.ParamChar + "paramNote,"
+ "'" + POut.String(referral.Phone2) + "',"
+ POut.Bool(referral.IsHidden) + ","
+ POut.Bool(referral.NotPerson) + ","
+ "'" + POut.String(referral.Title) + "',"
+ "'" + POut.String(referral.EMail) + "',"
+ POut.Long(referral.PatNum) + ","
+ "'" + POut.String(referral.NationalProvID) + "',"
+ POut.Long(referral.Slip) + ","
+ POut.Bool(referral.IsDoctor) + ","
+ POut.Bool(referral.IsTrustedDirect) + ","
//DateTStamp can only be set by MySQL
+ POut.Bool(referral.IsPreferred) + ")";
if (referral.Note == null)
{
referral.Note = "";
}
OdSqlParameter paramNote = new OdSqlParameter("paramNote", OdDbType.Text, POut.StringParam(referral.Note));
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramNote);
}
else
{
referral.ReferralNum = Db.NonQ(command, true, "ReferralNum", "referral", paramNote);
}
return(referral.ReferralNum);
}
private void butSlip_Click(object sender, EventArgs e)
{
int idx = gridMain.GetSelectedIndex();
if (idx == -1)
{
MsgBox.Show(this, "Please select a referral first");
return;
}
Referral referral = Referrals.GetReferral(RefAttachList[idx].ReferralNum);
SheetDef sheetDef;
if (referral.Slip == 0)
{
sheetDef = SheetsInternal.GetSheetDef(SheetInternalType.ReferralSlip);
}
else
{
sheetDef = SheetDefs.GetSheetDef(referral.Slip);
}
Sheet sheet = SheetUtil.CreateSheet(sheetDef, PatNum);
SheetParameter.SetParameter(sheet, "PatNum", PatNum);
SheetParameter.SetParameter(sheet, "ReferralNum", referral.ReferralNum);
SheetFiller.FillFields(sheet);
SheetUtil.CalculateHeights(sheet, this.CreateGraphics());
FormSheetFillEdit FormS = new FormSheetFillEdit(sheet);
FormS.ShowDialog();
//grid will not be refilled, so no need to reselect.
}
public void MinUpdateFromTargetMO()
{
using (TestMqServiceClient mq = new TestMqServiceClient())
{
Credentials cr = new Credentials {
Organization = idLpu, Token = guid
};
Referral referral = (new SetData()).MinRegister();
var result = mq.Register(cr, referral);
//"Выдано пациенту"
referral = (new SetData()).MinPatientDocumentIssue(result.IdMq);
var res2 = mq.PatientDocumentIssue(cr, referral);
referral = (new SetData()).MinUpdateFromTargetMO(result.IdMq);
var res3 = mq.UpdateFromTargetMo(cr, referral);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public async Task <Referral> addReferral(int personId, int fromFacilityId, int serviceAreaId, int referredTo, int referralReason, int userId, DateTime dateToBeEnrolled)
{
try
{
var referral = new Referral
{
PersonId = personId,
ReferralDate = DateTime.Now,
FromFacility = fromFacilityId,
FromServicePoint = serviceAreaId,
ToServicePoint = serviceAreaId,
ToFacility = referredTo,
ReferralReason = referralReason,
ReferredBy = userId,
CreatedBy = userId,
ExpectedDate = dateToBeEnrolled,
CreateDate = DateTime.Now,
DeleteFlag = false
};
await _htsunitOfWork.Repository <Referral>().AddAsync(referral);
await _htsunitOfWork.SaveAsync();
return(referral);
}
catch (Exception e)
{
throw e;
}
}
public void Map_ReceiptWithLineItem_CorrectDynamicsType()
{
var referenceNumber = "ref";
var receipt = new Referral
{
ReferralNumber = "ref1",
InvoiceNumber = "inv1",
TotalAmount = 10m,
TotalGST = 5m
};
var lineItem = new LineItem
{
Amount = 10m,
Description = "desc",
GST = 5m,
ReceiptNumber = null,
ReferralNumber = receipt.ReferralNumber,
SupportProvided = "support"
};
var mappedLineItems = new[] { lineItem }.MapLineItems(referenceNumber, receipt);
var mappedLineItem = Assert.Single(mappedLineItems);
var typeProperty = TypeDescriptor.GetProperties(mappedLineItem).Find("type", true);
Assert.True(typeProperty.Attributes.Contains(new JsonPropertyAttribute("@odata.type")));
Assert.Equal("Microsoft.Dynamics.CRM.era_supportlineitem", typeProperty.GetValue(mappedLineItem));
}
public void MarkAsSeen(int referralId)
{
Referral r = GetReferral(referralId);
r.SeenByReferredDoctor = true;
_dataContext.SaveChanges();
}
/// <summary>
/// Deletes all referrals attached to teacherid.
/// </summary>
/// <param name="teacherid">ID of teacher to delete referrals of.</param>
public async Task DeleteTeacherReferrals(int teacherid)
{
var referralsQuery = (from referrals in _context.Referrals
select new
{
referrals.TeacherId,
referrals.ReferralId
}).Where(r => r.TeacherId == teacherid);
List <Referral> referralsToDelete = new List <Referral>();
foreach (var r in referralsQuery)
{
Referral referral = new Referral()
{
TeacherId = r.TeacherId,
ReferralId = r.ReferralId
};
referralsToDelete.Add(referral);
}
_context.Referrals.AttachRange(referralsToDelete);
_context.Referrals.RemoveRange(referralsToDelete);
await _context.SaveChangesAsync();
}
///<summary>Inserts one Referral into the database. Returns the new priKey.</summary>
internal static long Insert(Referral referral)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
referral.ReferralNum=DbHelper.GetNextOracleKey("referral","ReferralNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(referral,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
referral.ReferralNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(referral,false);
}
}
public Referral FullUpdateFromSourcedMo(string idMq)
{
Referral referral = new Referral();
referral.ReferralInfo = ReferralData.referralInfo;
referral.ReferralInfo.ReferralType = new Coding
{
Code = "4", // ??
System = Dictionary.REFERRAL_TYPE,
Version = "1"
};
referral.ReferralInfo.IdMq = idMq;
referral.ReferralSurvey = ReferralData.survey;
referral.Source = ReferralData.referralSource;
referral.Target = new ReferralTarget
{
Lpu = ReferralData.referralTarget.Lpu
};
referral.Patient = PersonData.patient;
referral.EventsInfo = new EventsInfo
{
Source = ReferralData.eventsInfo.Source
};
return(referral);
}
public static IEnumerable <Referral> GetReferrals(string fileName)
{
using (var rdr = new StreamReader(fileName))
{
var next = new Referrer();
int state = 0;
string line;
while ((line = rdr.ReadLine()) != null)
{
switch (state)
{
case 0:
next.ReferrerText = line;
state = 1;
break;
case 1:
next.ReferrerDescription = line;
state = 2;
break;
case 2:
next.ReferringId = int.Parse(line);
yield return(next);
next = new Referral();
state = 0;
break;
}
}
}
}
public AddResponse(
LDAPResult_resultCode resultCode,
LDAPDN matchedDN,
LDAPString errorMessage,
Referral referral)
: base(resultCode, matchedDN, errorMessage, referral)
{
}
public ReferralRemaining(int referral_remaining_id, int referral_id, int field_id, int num_services_remaining, int deleted_by, DateTime date_deleted)
{
this.referral_remaining_id = referral_remaining_id;
this.referral = new Referral(referral_id);
this.field = new IDandDescr(field_id);
this.num_services_remaining = num_services_remaining;
this.deleted_by = deleted_by;
this.date_deleted = date_deleted;
}
public TestReferral(Referral r, string idLpu = "")
{
evInfo = new TestEventsInfo(r.EventsInfo);
patient = new TestPatient(r.Patient);
refInfo = new TestReferralInfo(r.ReferralInfo);
refSurvey = new TestReferralSurvey(r.ReferralSurvey);
refSourse = new TestReferralSource(r.Source);
refTarget = new TestReferralTarget(r.Target);
}
public SearchResultDone(
LDAPResult_resultCode resultCode,
LDAPDN matchedDN,
LDAPString errorMessage,
Referral referral)
{
this.resultCode = resultCode;
this.matchedDN = matchedDN;
this.errorMessage = errorMessage;
this.referral = referral;
}
public ExtendedResponse(
LDAPResult_resultCode resultCode,
LDAPDN matchedDN,
LDAPString errorMessage,
Referral referral)
{
this.resultCode = resultCode;
this.matchedDN = matchedDN;
this.errorMessage = errorMessage;
this.referral = referral;
this.responseName = null;
this.response = null;
}
public BindResponse(
LDAPResult_resultCode resultCode,
LDAPDN matchedDN,
LDAPString errorMessage,
Referral referral,
Asn1OctetString serverSaslCreds)
{
this.resultCode = resultCode;
this.matchedDN = matchedDN;
this.errorMessage = errorMessage;
this.referral = referral;
this.serverSaslCreds = serverSaslCreds;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
loadCountries();
setStartingCountry();
}
finally
{
try
{
btn_redeem_submit.Enabled = true;
lblErrorMessage.Controls.Clear();
try
{
referralid = int.Parse(Server.UrlDecode(Cryptography.DecryptData(Request["ReferralId"])));
badReferralId = false;
}
catch (Exception ex)
{
logService.LogAppEvent("", @"HarperNET", "Referral", "Unable to decrypt referral id, using default referrer instead. (referralid in url): " + Request["ReferralId"], ex.Message, ex.StackTrace, "", "Page_Load");
badReferralId = true;
}
if (!badReferralId)
{
Referral referral = new Referral(referralid);
if (referral.id <= 0)
{
throw new Exception(string.Format("Cannot redeem referral - referral id {0} does not exist", referralid));
}
if (referral.dateredeemed != null)
{
throw new Exception(string.Format("Referral id {0} has already been redeemed", referralid));
}
if (!Page.IsPostBack)
{
email_address.Text = referral.friendemail;
}
}
}
catch (Exception ex)
{
logService.LogAppEvent("", @"HarperNET", "Referral", "Error in Page_Load Referralid in url): " + Request["ReferralId"], ex.Message, ex.StackTrace, "", "Page_Load");
LiteralControl err = new LiteralControl();
err.Text = "<p class=\"error-message\">An error has occurred. Please contact the membership department at <a href=\"mailto:[email protected]\">[email protected]</a></p>";
lblErrorMessage.Controls.Add(err);
lblErrorMessage.Visible = true;
btn_redeem_submit.Enabled = false;
}
}
}
public ExtendedResponse(
LDAPResult_resultCode resultCode,
LDAPDN matchedDN,
LDAPString errorMessage,
Referral referral,
LDAPOID responseName,
Asn1OctetString response)
{
this.resultCode = resultCode;
this.matchedDN = matchedDN;
this.errorMessage = errorMessage;
this.referral = referral;
this.responseName = responseName;
this.response = response;
}
///<summary>Inserts one Referral into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Referral referral,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
referral.ReferralNum=ReplicationServers.GetKey("referral","ReferralNum");
}
string command="INSERT INTO referral (";
if(useExistingPK || PrefC.RandomKeys) {
command+="ReferralNum,";
}
command+="LName,FName,MName,SSN,UsingTIN,Specialty,ST,Telephone,Address,Address2,City,Zip,Note,Phone2,IsHidden,NotPerson,Title,EMail,PatNum,NationalProvID,Slip,IsDoctor) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(referral.ReferralNum)+",";
}
command+=
"'"+POut.String(referral.LName)+"',"
+"'"+POut.String(referral.FName)+"',"
+"'"+POut.String(referral.MName)+"',"
+"'"+POut.String(referral.SSN)+"',"
+ POut.Bool (referral.UsingTIN)+","
+ POut.Int ((int)referral.Specialty)+","
+"'"+POut.String(referral.ST)+"',"
+"'"+POut.String(referral.Telephone)+"',"
+"'"+POut.String(referral.Address)+"',"
+"'"+POut.String(referral.Address2)+"',"
+"'"+POut.String(referral.City)+"',"
+"'"+POut.String(referral.Zip)+"',"
+"'"+POut.String(referral.Note)+"',"
+"'"+POut.String(referral.Phone2)+"',"
+ POut.Bool (referral.IsHidden)+","
+ POut.Bool (referral.NotPerson)+","
+"'"+POut.String(referral.Title)+"',"
+"'"+POut.String(referral.EMail)+"',"
+ POut.Long (referral.PatNum)+","
+"'"+POut.String(referral.NationalProvID)+"',"
+ POut.Long (referral.Slip)+","
+ POut.Bool (referral.IsDoctor)+")";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
referral.ReferralNum=Db.NonQ(command,true);
}
return referral.ReferralNum;
}
public MqResult Cancellation(Credentials cr, Referral r)
{
try
{
TestReferral br = TestReferral.BuildReferralFromDataBaseData(r.ReferralInfo.IdMq);
MqResult x = client.Cancellation(cr, r);
br.UpdateTestReferral(r, cr.Organization);
if (br != TestReferral.BuildReferralFromDataBaseData(x.IdMq))
{
Global.errors1.Add("Несовпадение");
Global.errors1.AddRange(Global.errors2);
}
return x;
}
catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault> e)
{
getErrors(e.Detail);
Global.errors1.Add("ЭКСЕПШН");
return null;
}
}
public MqResult HealthCareEnd(Credentials cr, Referral r)
{
try
{
MqResult x = client.HealthCareEnd(cr, r);
if (new TestReferral(r, cr.Organization) != TestReferral.BuildReferralFromDataBaseData(x.IdMq))
{
Global.errors1.Add("Несовпадение");
Global.errors1.AddRange(Global.errors2);
}
return x;
}
catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault[]> e)
{
getErrors(e.Detail);
return null;
}
catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault> e)
{
Global.errors1.Add(e.Detail.PropertyName + " - " + e.Detail.Message);
return null;
}
}
/// <summary>
/// По заданному Referral'у строит Options для SeacrhOne.
///
/// Может можно сделать лучше?(проверки на null)
///
/// </summary>
public Options GetRefferalReturnOptions_SearchOne(Referral referral, Privilege[] privileges, string idMq, Coding mqReferralStatus)
{
Options opt = new Options();
opt.IdMq = idMq;
if (referral.ReferralInfo != null)
{
opt.ReferralInfo = new ReferralInfo
{
ProfileMedService = referral.ReferralInfo.ProfileMedService,
ReferralType = referral.ReferralInfo.ReferralType,
MqReferralStatus = mqReferralStatus
};
}
if (referral.Target != null)
{ opt.Target = new ReferralTarget { Lpu = referral.Target.Lpu }; }
if (referral.Source != null)
{ opt.Source = new ReferralSource { Lpu = referral.Source.Lpu }; }
if (referral.ReferralSurvey != null)
{
opt.Survey = new Survey
{
SurveyType = referral.ReferralSurvey.SurveyType,
SurveyOrgan = referral.ReferralSurvey.SurveyOrgan
};
}
if (referral.Patient != null)
{
opt.Patient.Person = new Person
{
BirthDate = referral.Patient.Person.BirthDate,
IdPatientMis = referral.Patient.Person.IdPatientMis
};
if (referral.Patient.Person.HumanName != null)
{
opt.Patient.Person.HumanName = new HumanName
{
FamilyName = referral.Patient.Person.HumanName.FamilyName,
GivenName = referral.Patient.Person.HumanName.GivenName,
MiddleName = referral.Patient.Person.HumanName.MiddleName
};
}
}
if (privileges != null)
{ opt.Patient.Privileges = (Privilege[])privileges.Clone(); }
if (referral.EventsInfo != null && referral.EventsInfo.Target != null)
{
opt.EventsInfo.Target = new EventTarget
{
IsReferralReviwed = referral.EventsInfo.Target.IsReferralReviwed,
ReceptionAppointDate = referral.EventsInfo.Target.ReceptionAppointDate
};
}
OptionData.options = opt;
return opt;
}
/// <summary>
/// По заданному Referral'у строит Options для SeacrhMany.
/// </summary>
public Options GetRefferalReturnOptions_SearchMany(Referral referral, Privilege[] privileges, Coding mqReferralStatus)
{
Options opt = GetRefferalReturnOptions_SearchOne(referral, privileges, null, mqReferralStatus);
if (referral.EventsInfo != null && referral.EventsInfo.Source != null)
{
opt.EventsInfo.Source = new EventSource
{
PlannedDate = referral.EventsInfo.Source.PlannedDate
};
}
OptionData.options = opt;
return opt;
}
public Referral FullUpdateFromSourcedMo(string idMq)
{
Referral referral = new Referral();
referral.ReferralInfo = ReferralData.referralInfo;
referral.ReferralInfo.ReferralType = new Coding
{
Code = "4", // ??
System = Dictionary.REFERRAL_TYPE,
Version = "1"
};
referral.ReferralInfo.IdMq = idMq;
referral.ReferralSurvey = ReferralData.survey;
referral.Source = ReferralData.referralSource;
referral.Target = new ReferralTarget
{
Lpu = ReferralData.referralTarget.Lpu
};
referral.Patient = PersonData.patient;
referral.EventsInfo = new EventsInfo
{
Source = ReferralData.eventsInfo.Source
};
return referral;
}
public MqResult Register(Credentials cr, Referral r)
{
try
{
MqResult x = client.Register(cr, r);
r.ReferralInfo.IdMq = x.IdMq;
if (!new TestReferral(r, cr.Organization).Equals(TestReferral.BuildReferralFromDataBaseData(x.IdMq)))
{
Global.errors1.Add("Несовпадение");
Global.errors1.AddRange(Global.errors2);
}
return x;
}
catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault> e)
{
getErrors(e.Detail);
return null;
}
//catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault> e)
//{
// Global.errors1.Add(e.Detail.PropertyName + " - " + e.Detail.Message);
// return null;
//}
}
public override int BerDecode(IAsn1DecodingBuffer buffer, bool explicitTag = true)
{
int headLen = 0;
Asn1Tag seqTag;
headLen += TagBerDecode(buffer, out seqTag);
int valueLen;
headLen += LengthBerDecode(buffer, out valueLen);
int valueLenDecode = 0;
resultCode = new LDAPResult_resultCode();
valueLenDecode += resultCode.BerDecode(buffer);
matchedDN = new LDAPDN();
valueLenDecode += matchedDN.BerDecode(buffer);
errorMessage = new LDAPString();
valueLenDecode += errorMessage.BerDecode(buffer);
if (valueLenDecode == valueLen)
{
referral = null;
serverSaslCreds = null;
}
else
{
Asn1Tag contextTag;
valueLenDecode += TagBerDecode(buffer, out contextTag);
if (contextTag.TagValue == 3)
{
//referral
referral = new Referral();
valueLenDecode += referral.BerDecodeWithoutUnisersalTag(buffer);
if (valueLenDecode < valueLen)
{
valueLenDecode += TagBerDecode(buffer, out contextTag);
}
}
if (contextTag.TagValue == 7)
{
//serverSaslCreds
serverSaslCreds = new Asn1OctetString();
valueLenDecode += serverSaslCreds.BerDecodeWithoutUnisersalTag(buffer);
}
}
if (valueLen != valueLenDecode)
{
throw new Asn1DecodingUnexpectedData(ExceptionMessages.DecodingUnexpectedData + " BindResponse.");
}
return headLen + valueLen;
}
//public TestReferral(ReferralDto r)
//{
// referral = new Referral
// {
// ReferralInfo = new ReferralInfo
// {
// IdReferralType = Convert.ToByte(r.IdReferralType),
// IdReferralMis = r.IdReferralMis,
// IssuedDateTime = r.IssuedDateTime,
// //r.IdUrgencyType;
// MkbCode = r.MkbCode,
// Reason = r.Reason
// },
// IdSourceLpu = r.IdSourceLpu,
// IdTargetLpu = r.IdTargetLpu,
// //r.IdLPU;
// };
// attachment = new TestAttachment(new MedDocument.DocumentAttachment());
// doctor = TestDoctor.BuildTestDoctorFromDataBase(r.IdDoctorRef);
// departmentHead = TestDoctor.BuildTestDoctorFromDataBase(r.IdRefDepartmentHead);
//}
public static List<TestReferral> BuildReferralFromDataBaseData(string idStep)
{
List<TestReferral> trl = new List<TestReferral>();
if (idStep != "")
{
List<TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idReferral);
if (lta != null)
foreach (TestAttachment i in lta)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findR = "SELECT * FROM Referral WHERE IdMedDocument = '" + i.idMedDocument + "'";
SqlCommand Rcommand = new SqlCommand(findR, connection);
using (SqlDataReader RReader = Rcommand.ExecuteReader())
{
while (RReader.Read())
{
Referral r = new Referral();
r.ReferralInfo = new ReferralInfo();
if (RReader["MkbCode"].ToString() != "")
r.ReferralInfo.MkbCode = Convert.ToString(RReader["MkbCode"]);
if (RReader["IdSourceLpu"].ToString() != "")
r.IdSourceLpu = Global.GetIdIdLpu(Convert.ToString(RReader["IdSourceLpu"]));
if (RReader["IdTargetLpu"].ToString() != "")
r.IdTargetLpu = Global.GetIdIdLpu(Convert.ToString(RReader["IdTargetLpu"]));
if (RReader["Reason"].ToString() != "")
r.ReferralInfo.Reason = Convert.ToString(RReader["Reason"]);
if (RReader["IdReferralMIS"].ToString() != "")
r.ReferralInfo.IdReferralMis = Convert.ToString(RReader["IdReferralMIS"]);
if (RReader["IdReferralType"].ToString() != "")
r.ReferralInfo.IdReferralType = Convert.ToByte(RReader["IdReferralType"]);
if (RReader["IssuedDateTime"].ToString() != "")
r.ReferralInfo.IssuedDateTime = Convert.ToDateTime(RReader["IssuedDateTime"]);
if (RReader["IdHospitalizationOrder"].ToString() != "")
r.ReferralInfo.HospitalizationOrder = Convert.ToByte(RReader["IdHospitalizationOrder"]);
if (RReader["ReferralId"].ToString() != "")
r.ReferralID = Convert.ToString(RReader["ReferralId"]);
if (RReader["RelatedId"].ToString() != "")
r.RelatedID = Convert.ToString(RReader["RelatedId"]);
r.CreationDate = i.CreationDate;
r.Header = i.DocHead;
//Тут нет ReferalId и referedId
TestReferral tr = new TestReferral(r);
tr.attachment = i;
if (RReader["IdRefDepartmentHead"].ToString() != "")
tr.departmentHead = TestDoctor.BuildTestDoctorFromDataBase((RReader["IdRefDepartmentHead"]).ToString());
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
trl.Add(tr);
}
}
}
}
}
if (trl.Count != 0)
return trl;
else
return null;
}
///<summary>Updates one Referral in the database.</summary>
public static void Update(Referral referral){
string command="UPDATE referral SET "
+"LName = '"+POut.String(referral.LName)+"', "
+"FName = '"+POut.String(referral.FName)+"', "
+"MName = '"+POut.String(referral.MName)+"', "
+"SSN = '"+POut.String(referral.SSN)+"', "
+"UsingTIN = "+POut.Bool (referral.UsingTIN)+", "
+"Specialty = "+POut.Int ((int)referral.Specialty)+", "
+"ST = '"+POut.String(referral.ST)+"', "
+"Telephone = '"+POut.String(referral.Telephone)+"', "
+"Address = '"+POut.String(referral.Address)+"', "
+"Address2 = '"+POut.String(referral.Address2)+"', "
+"City = '"+POut.String(referral.City)+"', "
+"Zip = '"+POut.String(referral.Zip)+"', "
+"Note = '"+POut.String(referral.Note)+"', "
+"Phone2 = '"+POut.String(referral.Phone2)+"', "
+"IsHidden = "+POut.Bool (referral.IsHidden)+", "
+"NotPerson = "+POut.Bool (referral.NotPerson)+", "
+"Title = '"+POut.String(referral.Title)+"', "
+"EMail = '"+POut.String(referral.EMail)+"', "
+"PatNum = "+POut.Long (referral.PatNum)+", "
+"NationalProvID = '"+POut.String(referral.NationalProvID)+"', "
+"Slip = "+POut.Long (referral.Slip)+", "
+"IsDoctor = "+POut.Bool (referral.IsDoctor)+", "
+"IsTrustedDirect= "+POut.Bool (referral.IsTrustedDirect)+" "
+"WHERE ReferralNum = "+POut.Long(referral.ReferralNum);
Db.NonQ(command);
}
///<summary>Updates one Referral in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(Referral referral,Referral oldReferral){
string command="";
if(referral.LName != oldReferral.LName) {
if(command!=""){ command+=",";}
command+="LName = '"+POut.String(referral.LName)+"'";
}
if(referral.FName != oldReferral.FName) {
if(command!=""){ command+=",";}
command+="FName = '"+POut.String(referral.FName)+"'";
}
if(referral.MName != oldReferral.MName) {
if(command!=""){ command+=",";}
command+="MName = '"+POut.String(referral.MName)+"'";
}
if(referral.SSN != oldReferral.SSN) {
if(command!=""){ command+=",";}
command+="SSN = '"+POut.String(referral.SSN)+"'";
}
if(referral.UsingTIN != oldReferral.UsingTIN) {
if(command!=""){ command+=",";}
command+="UsingTIN = "+POut.Bool(referral.UsingTIN)+"";
}
if(referral.Specialty != oldReferral.Specialty) {
if(command!=""){ command+=",";}
command+="Specialty = "+POut.Int ((int)referral.Specialty)+"";
}
if(referral.ST != oldReferral.ST) {
if(command!=""){ command+=",";}
command+="ST = '"+POut.String(referral.ST)+"'";
}
if(referral.Telephone != oldReferral.Telephone) {
if(command!=""){ command+=",";}
command+="Telephone = '"+POut.String(referral.Telephone)+"'";
}
if(referral.Address != oldReferral.Address) {
if(command!=""){ command+=",";}
command+="Address = '"+POut.String(referral.Address)+"'";
}
if(referral.Address2 != oldReferral.Address2) {
if(command!=""){ command+=",";}
command+="Address2 = '"+POut.String(referral.Address2)+"'";
}
if(referral.City != oldReferral.City) {
if(command!=""){ command+=",";}
command+="City = '"+POut.String(referral.City)+"'";
}
if(referral.Zip != oldReferral.Zip) {
if(command!=""){ command+=",";}
command+="Zip = '"+POut.String(referral.Zip)+"'";
}
if(referral.Note != oldReferral.Note) {
if(command!=""){ command+=",";}
command+="Note = '"+POut.String(referral.Note)+"'";
}
if(referral.Phone2 != oldReferral.Phone2) {
if(command!=""){ command+=",";}
command+="Phone2 = '"+POut.String(referral.Phone2)+"'";
}
if(referral.IsHidden != oldReferral.IsHidden) {
if(command!=""){ command+=",";}
command+="IsHidden = "+POut.Bool(referral.IsHidden)+"";
}
if(referral.NotPerson != oldReferral.NotPerson) {
if(command!=""){ command+=",";}
command+="NotPerson = "+POut.Bool(referral.NotPerson)+"";
}
if(referral.Title != oldReferral.Title) {
if(command!=""){ command+=",";}
command+="Title = '"+POut.String(referral.Title)+"'";
}
if(referral.EMail != oldReferral.EMail) {
if(command!=""){ command+=",";}
command+="EMail = '"+POut.String(referral.EMail)+"'";
}
if(referral.PatNum != oldReferral.PatNum) {
if(command!=""){ command+=",";}
command+="PatNum = "+POut.Long(referral.PatNum)+"";
}
if(referral.NationalProvID != oldReferral.NationalProvID) {
if(command!=""){ command+=",";}
command+="NationalProvID = '"+POut.String(referral.NationalProvID)+"'";
}
if(referral.Slip != oldReferral.Slip) {
if(command!=""){ command+=",";}
command+="Slip = "+POut.Long(referral.Slip)+"";
}
if(referral.IsDoctor != oldReferral.IsDoctor) {
if(command!=""){ command+=",";}
command+="IsDoctor = "+POut.Bool(referral.IsDoctor)+"";
}
if(referral.IsTrustedDirect != oldReferral.IsTrustedDirect) {
if(command!=""){ command+=",";}
command+="IsTrustedDirect = "+POut.Bool(referral.IsTrustedDirect)+"";
}
if(command==""){
return false;
}
command="UPDATE referral SET "+command
+" WHERE ReferralNum = "+POut.Long(referral.ReferralNum);
Db.NonQ(command);
return true;
}
public Referral MinRefferal()
{
Referral r = new Referral
{
CreationDate = MedRecordData.referral.CreationDate,
Header = MedRecordData.referral.Header,
IdSourceLpu = MedRecordData.referral.IdSourceLpu,
IdTargetLpu = MedRecordData.referral.IdTargetLpu,
Author = MinDoctorSet(),
ReferralInfo = new ReferralInfo
{
Reason = MedRecordData.referral.ReferralInfo.Reason,
IdReferralMis = MedRecordData.referral.ReferralInfo.IdReferralMis,
IdReferralType = MedRecordData.referral.ReferralInfo.IdReferralType,
HospitalizationOrder = MedRecordData.referral.ReferralInfo.HospitalizationOrder,
IssuedDateTime = MedRecordData.referral.ReferralInfo.IssuedDateTime,
MkbCode = MedRecordData.referral.ReferralInfo.MkbCode
},
DepartmentHead = MinDoctorSet()
};
return r;
}
public Referral MinAgreedFromSourcedMo(string idMq)
{
Referral referral = new Referral();
referral.ReferralInfo = new ReferralInfo { IdMq = idMq };
referral.Source = new ReferralSource
{
Doctors = new Doctor[]
{
new Doctor
{
Lpu = PersonData.doctor.Lpu,
Speciality = PersonData.doctor.Speciality,
Position = PersonData.doctor.Position,
Person = new Person
{
IdPersonMis = PersonData.doctor.Person.IdPersonMis,
HumanName = new HumanName
{
FamilyName = PersonData.doctor.Person.HumanName.FamilyName,
GivenName = PersonData.doctor.Person.HumanName.GivenName
}
},
ContactDtos = new ContactDto[]
{
new ContactDto
{
ContactType = SetCoding(PersonData.contact.ContactType),
ContactValue = PersonData.contact.ContactValue
}
}
}
}
};
referral.EventsInfo = new EventsInfo
{
Source = new EventSource
{
ReferralCreateDate = ReferralData.eventsInfo.Source.ReferralCreateDate,
IsReferralReviewed = ReferralData.eventsInfo.Source.IsReferralReviewed,
ReferralReviewDate = ReferralData.eventsInfo.Source.ReferralReviewDate
}
};
return referral;
}
public static Referral[] GetAll(bool inc_deleted = false, int patient_id = -1)
{
DataTable tbl = GetDataTable(inc_deleted, patient_id);
Referral[] list = new Referral[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
list[i] = LoadAll(tbl.Rows[i]);
return list;
}
public Referral MinRegister()
{
Referral referral = new Referral();
referral.ReferralInfo = new ReferralInfo
{
ReferralType = SetCoding(ReferralData.referralInfo.ReferralType),
ProfileMedService = SetCoding(ReferralData.referralInfo.ProfileMedService),
};
referral.Source = new ReferralSource
{
IdReferralMis = ReferralData.referralSource.IdReferralMis,
Lpu = SetCoding(ReferralData.referralSource.Lpu),
Doctors = new Doctor[]
{
new Doctor
{
Role = SetCoding(PersonData.doctor.Role),
Lpu = SetCoding(PersonData.doctor.Lpu),
Speciality = SetCoding(PersonData.doctor.Speciality),
Position = SetCoding(PersonData.doctor.Position),
Person = new Person
{
Sex = SetCoding(PersonData.doctor.Person.Sex),
IdPersonMis = PersonData.doctor.Person.IdPersonMis,
HumanName = new HumanName
{
FamilyName = PersonData.doctor.Person.HumanName.FamilyName,
GivenName = PersonData.doctor.Person.HumanName.GivenName
}
}
}
}
};
referral.Patient = new Patient
{
Person = new Person
{
BirthDate = PersonData.patient.Person.BirthDate,
Sex = SetCoding(PersonData.patient.Person.Sex),
HumanName = new HumanName
{
FamilyName = PersonData.patient.Person.HumanName.FamilyName,
GivenName = PersonData.patient.Person.HumanName.GivenName
}
}
};
return referral;
}
internal override int ReadDataWireFormat(byte[] buffer, int bufferIndex, int len)
{
int start = bufferIndex;
PathConsumed = ReadInt2(buffer, bufferIndex);
bufferIndex += 2;
if ((Flags2 & SmbConstants.Flags2Unicode) != 0)
{
PathConsumed /= 2;
}
NumReferrals = ReadInt2(buffer, bufferIndex);
bufferIndex += 2;
flags = ReadInt2(buffer, bufferIndex);
bufferIndex += 4;
Referrals = new Referral[NumReferrals];
for (int ri = 0; ri < NumReferrals; ri++)
{
Referrals[ri] = new Referral(this);
bufferIndex += Referrals[ri].ReadWireFormat(buffer, bufferIndex, len);
}
return bufferIndex - start;
}
/// <summary>
/// Creates a Referral object from a list of reference URLs.
/// </summary>
/// <param name="referrals">Reference URLs.</param>
/// <returns>The referral object. If the refUrls is null, return null.</returns>
private Referral CreateReferral(string[] refUrls)
{
if (refUrls == null)
{
return null;
}
int length = refUrls.Length;
LDAPURL[] ldapUrls = new LDAPURL[length];
for (int i = 0; i < length; i++)
{
ldapUrls[i] = new LDAPURL(refUrls[i]);
}
Referral referral = new Referral(ldapUrls);
return referral;
}
protected void btnSumbit_click(object sender, EventArgs e)
{
try
{
#region Unable to decode referral id, try finding original referral based on email address
if (badReferralId)
{
try
{
Referral badRef = new Referral(email_address.Text);
if (badRef.id > 0)
{
referralid = badRef.id;
}
else
{
throw new Exception();
}
}
catch (Exception ex)
{
logService.LogAppEvent("", @"HarperNET", "Referral", "Unable to link email to referral id (id could not be decoded and email not on file). Using default referrer. Referral id in url: " + Request["ReferralId"] + ", email address entered: " + email_address.Text, ex.Message, ex.StackTrace, "", "Page_Load");
Referral defaultReferral = new Referral();
defaultReferral.keycode = "POTRIAL";
defaultReferral.pubcode = "PO";
ReferralOffer offer = new ReferralOffer(defaultReferral.keycode, defaultReferral.pubcode);
defaultReferral.ccmember = false;
defaultReferral.datecreated = DateTime.Now;
defaultReferral.dateexpires = defaultReferral.datecreated.AddMonths(offer.offerexpiresmonths);
defaultReferral.friendemail = email_address.Text;
defaultReferral.friendname = first_name.Text + " " + last_name.Text;
HarperLINQ.tbl_Customer defaultReferrer = new tbl_Customer(ConfigurationManager.AppSettings["default_referrer_username"], true);
defaultReferral.memberid = defaultReferrer.cusID;
defaultReferral.subscriptionlength = offer.triallengthinmonths;
defaultReferral.Save();
referralid = defaultReferral.id;
}
}
#endregion
HarperMembershipService.BaseResponse response = new HarperMembershipService.BaseResponse();
HarperMembershipService.MembershipService webservice = new HarperMembershipService.MembershipService();
#region Get selected region
country = ddlCountries.SelectedValue;
ISO3166 iso = new ISO3166(country, IdentifierType.Country_Code_Alpha2);
string sfgcountrycode = iso.SFGCode;
if (txtRegion.Text != "" && txtRegion.Text != null)
{
region = txtRegion.Text;
}
else if (txtRegionNotListed.Text != "" && txtRegionNotListed.Text != null)
{
region = txtRegionNotListed.Text;
}
else
{
region = ddlRegion.SelectedValue;
}
#endregion
string erefid = Cryptography.EncryptData(referralid.ToString());
string epwd = Cryptography.EncryptData(txtPassword.Text);
#region Redeem the referral
response = webservice.RedeemReferral(erefid, first_name.Text, last_name.Text, email_address.Text,
sfgcountrycode, address_line_1.Text, address_line_2.Text, city.Text, region, postal.Text, true,
txtUserName.Text, epwd);
#endregion
#region Check for errors
if (response == null)
{
throw new Exception(string.Format("Error redeeming referral id {0}, response from SFG was null.", referralid));
}
if (response.Messages != null && response.Messages.Count() > 0)
{
throw new Exception(response.Messages[0].AhMessage);
}
#endregion
Response.Redirect("~/Referral/RedemptionConfirmation.aspx", false);
}
catch (Exception ex)
{
logService.LogAppEvent("", @"HarperNET", "Referral", "Error in btnSumbit_click", ex.Message, ex.StackTrace, "", "btnSubmit_click");
LiteralControl err = new LiteralControl();
err.Text = "<p class=\"error-message\">An error has occurred. Please contact the membership department at <a href=\"mailto:[email protected]\">[email protected]</a></p>";
lblErrorMessage.Controls.Add(err);
lblErrorMessage.Visible = true;
}
}
