public List <insurance> _getInsurance_doc1(dynamic con_ins)
{ // temporary for table DOCTOR1
try
{
SV_db1Entities dbEntity = new SV_db1Entities();
List <insurance> ins = new List <insurance>();
// var con_ins = dbEntity.con_DOCTOR1_ref_insurance.Where(a => a.rel_DOCTOR_id == doctor_id);
foreach (var n in con_ins)
{
//ins.Add(new insurance
//{
// id = n.rel_ref_insurance_provider_id.Value,
// provider = n.ref_insurance_provider.PayerName.Split('|')[0]
//});
ins.Add(new insurance
{
id = n.ins_id,
provider = n.ins_provider.Split('|')[0]
});
}
return(ins);
}
catch (Exception ex)
{
return(null);
}
}
public IHttpActionResult Get1()
{
SV_db1Entities db = new SV_db1Entities();
string insurance_id = "";
var ref_ins = from a in db.ref_insurance_provider
where a.PayerID.Contains(insurance_id)
select a;
ref_ins = ref_ins.OrderBy(a => a.PayerName);
List <insurance> ins = new List <insurance>();
foreach (var i in ref_ins)
{
ins.Add(
new insurance
{
id = i.id, //i.PayerID.Split(',')[0],
provider = i.PayerName.Split('|')[0].Trim()
});
}
var ret1 = JsonConvert.SerializeObject(ins);
var json1 = Newtonsoft.Json.Linq.JArray.Parse(ret1);
return(Json(new { data = json1, message = "", success = true }));
}
// created: 01/11/2018
public List <doc_specialty_01112018> getSpecialty(long spec_id)
{
SV_db1Entities db = new SV_db1Entities();
var n = db.ref_specialty1.Find(spec_id);
List <doc_specialty_01112018> spec = new List <doc_specialty_01112018>();
if (n != null)
{
//string[] con = n.conditions.Split('|');
List <string> condition = new List <string>();
foreach (var c in n.ref_condition)
{
condition.Add(c.dname);
}
spec.Add(new doc_specialty_01112018
{
id = n.id,
provider_type = n.ref_specialty_provider.name,// s.provider_type,
classification_code = n.level2_classification_code,
classification = n.level2_classification,
specialization_code = n.level2_classification_code == null ? "" : n.level2_classification_code,
specialization = n.level3_specialization == null ? "" : n.level3_specialization, // s.specialization,
conditions = condition
});
}
return(spec);
}
public List <doc_language> _getLanguage_doc1(dynamic con_lang)
{
// temporary for table DOCTOR1
try
{
SV_db1Entities dbEntity = new SV_db1Entities();
List <doc_language> doc_lang = new List <doc_language>();
//var con_lang = dbEntity.con_DOCTOR1_ref_language.Where(a => a.rel_DOCTOR_id == doctor_id);
//string[] split_val = value.Split(',');
foreach (var a in con_lang)
{
// var ref_lang = dbEntity.ref_languages.Find(a.rel_ref_language_id);
//doc_lang.Add(new doc_language
//{
// id = a.ref_languages.id,
// name = a.ref_languages.name
//});
doc_lang.Add(new doc_language
{
id = a.lang_id,
name = a.lang_name
});
}
return(doc_lang);
}
catch (Exception ex) { return(null); }
}
private long xvalidateZip(string city, string state, string zip)
{
SV_db1Entities db = new SV_db1Entities();
int nzip = 0;
bool isvalid = int.TryParse(zip, out nzip);
if (!isvalid)
{
return(-1);
}
var ref_zip = db.ref_zip.Where(a => a.zip == zip);
if (ref_zip.Count() > 0)
{
if (ref_zip.FirstOrDefault().city_name.ToLower() != city.ToLower())
{
//return Json(new { data = new string[] { }, message = "Invalid city name.", success = false });
return(0);
}
if (ref_zip.FirstOrDefault().city_state.ToLower() != state.ToLower()
& ref_zip.FirstOrDefault().city_state_long.ToLower() != state.ToLower())
{
//return Json(new { data = new string[] { }, message = "Invalid state name.", success = false });
return(0);
}
}
//return Json(new { data = new string[] { }, message = "Match found.", success = true });
return(ref_zip.FirstOrDefault().id);
}
// validate zip in PharmacyController
public long validateZip(post_pharmacy pha)
{
SV_db1Entities db = new SV_db1Entities();
int nzip = 0;
bool isvalid = int.TryParse(pha.zip, out nzip);
if (!isvalid)
{
return(1);
}
var ref_zip = db.ref_zip.Where(a => a.zip == pha.zip);
if (ref_zip.Count() > 0)
{
if (ref_zip.FirstOrDefault().city_name.ToLower() != pha.city.ToLower())
{
//return Json(new { data = new string[] { }, message = "Invalid city name.", success = false });
return(2);
}
if (ref_zip.FirstOrDefault().city_state.ToLower() != pha.state.ToLower()
& ref_zip.FirstOrDefault().city_state_long.ToLower() != pha.state.ToLower())
{
//return Json(new { data = new string[] { }, message = "Invalid state name.", success = false });
return(3);
}
}
pha.zip_id = ref_zip.FirstOrDefault().id;
//return Json(new { data = new string[] { }, message = "Match found.", success = true });
return(0);
}
public static bool Login(string username, string password)
{
using (SV_db1Entities auth = new SV_db1Entities())
{
return(auth.app_authentication.Any(user => username.Equals(username, StringComparison.OrdinalIgnoreCase) &&
user.password == password
));
}
}
public List <doc_specialty_01112018> _getDoctor_specialty_doc1(dynamic con_spec)
{
try
{
SV_db1Entities dbEntity = new SV_db1Entities();
//01/11/2018 List<doc_specialty2> spec = new List<doc_specialty2>();
List <doc_specialty_01112018> spec = new List <doc_specialty_01112018>();
//var con_spec = dbEntity.con_DOCTOR1_ref_specialty.Where(a => a.rel_DOCTOR_id == doctor_id);
foreach (var i in con_spec)
{
// 01/11/2018
List <string> condition = new List <string>();
foreach (var c in i.spec_condition)
{
//string[] con = i.spec_condition.Split('|');
//foreach (var c in con)
//{
if (!string.IsNullOrEmpty(c))
{
condition.Add(c);
}
//}
}
// 01/11/2018
spec.Add(new doc_specialty_01112018
{
// id = n.ref_specialty.id,
// description = n.ref_specialty.description,
// name = n.ref_specialty.name,
// actor = n.ref_specialty.actor == null ? "" : n.ref_specialty.actor
id = i.spec_id,
provider_type = i.spec_provider_type,// s.provider_type,
classification_code = i.spec_classification_code,
classification = i.spec_classification,
specialization_code = i.spec_specialization_code == null? "" : i.spec_specialization_code,
specialization = i.spec_specialization == null?"" : i.spec_specialization, // s.specialization,
conditions = condition
});
}
return(spec);
}
catch (Exception ex)
{
return(null);
}
}
// created: 01/11/2018
public List <doc_specialty_01112018> getSpecialty(string code)
{
SV_db1Entities db = new SV_db1Entities();
// 01/17/2018 var spec1 = db.ref_specialty1.Where(b => b.level2_classification_code == code || b.level3_specialization_code == code);
var spec1 = from a in db.ref_specialty1
select new {
a.id,
specialty_provider = a.ref_specialty_provider.name,
a.level2_classification,
a.level2_classification_code,
a.level3_specialization,
a.level3_specialization_code,
condition = from b in a.ref_condition
select b.dname,
};
List <doc_specialty_01112018> spec = new List <doc_specialty_01112018>();
foreach (var n in spec1)
{
//string[] con = n.conditions.Split('|');
List <string> condition = new List <string>();
foreach (var c in n.condition)
{
condition.Add(c);
}
spec.Add(new doc_specialty_01112018
{
// id = n.ref_specialty.id,
// description = n.ref_specialty.description,
// name = n.ref_specialty.name,
// actor = n.ref_specialty.actor == null ? "" : n.ref_specialty.actor
id = n.id,
provider_type = n.specialty_provider,// s.provider_type,
classification_code = n.level2_classification_code,
classification = n.level2_classification,
specialization_code = n.level3_specialization_code == null ? "" : n.level3_specialization_code,
specialization = n.level3_specialization == null ? "" : n.level3_specialization, // s.specialization,
conditions = condition
});
}
return(spec);
}
public getDoctor_rating _get_averagerating_doc1(long doctor_id)
{
try
{
//balkon rating = dr.average_rating,
//balkon favorite = dr.fave,
//balkon patient_review = dr.review,
SV_db1Entities dbEntity = new SV_db1Entities();
// var appt = dbEntity.APPOINTMENTs.Where(a => a.doctor_id == doctor_id);
var appt = from ap in dbEntity.APPOINTMENTs
where ap.doctor_id == doctor_id
select ap;
// having Where clause slows down the response.
// we shud consider the status of the Appointment, only those that were Closed not canceled
getDoctor_rating ave = new getDoctor_rating();
List <p_ratings_review> rating_review = new List <p_ratings_review>();
foreach (var a in appt)
{
// long id = a.doctor_id.Value;
// ave.average_rating= a.doctor_rating.Value;
// review = a.doctor_review;
double rating = a.doctor_rating == null ? 0 : a.doctor_rating.Value;
string review = a.doctor_review;
rating_review.Add(new p_ratings_review {
rating = rating, remark = review
});
// ave.review.Add{ rating_review};
}
ave.review = rating_review;
return(ave);
}
catch (Exception ex)
{
return(null);
}
}
// resultsTextBox.Text += "Working . . . . . . .\r\n";
//}
public IHttpActionResult Getinsurance(long insurance_id = 0)
{
System.Web.HttpContext httpCOn = System.Web.HttpContext.Current;
string a_pass = httpCOn.Request.Headers["Authorization"];
bool b_pass = Validation.userAuth(a_pass);
// Basic dXNlcjp1c2Vy
// Basic dXNlcjp1c2Vy
// "Basic ZGVmdHNvZnQ6ZGVmdHNvZnRhcGlrZXk="
string msg = "The authorization header is not valid.";
if (b_pass)
{
SV_db1Entities db = new SV_db1Entities();
var ref_ins = from a in db.ref_insurance_provider select a;
if (insurance_id > 0)
{
ref_ins = ref_ins.Where(a => a.id == insurance_id);
}
List <insurance> ins = new List <insurance>();
foreach (var i in ref_ins)
{
ins.Add(
new insurance
{
id = i.id, //i.PayerID.Split(',')[0],
provider = i.PayerName.Split('|')[0].Trim()
});
}
var ret1 = JsonConvert.SerializeObject(ins);
var json1 = Newtonsoft.Json.Linq.JArray.Parse(ret1);
return(Json(new { data = json1, message = "Record found.", success = true }));
}
return(Json(new { data = "", message = msg, success = false }));
}
public static bool saveClaimDoctor_ext(string _attr_name, string _dname, string _value, long doc_id = 0)
{
// 01/04/2018: used by Doctor signup/login (HS-67)
DateTime dt = DateTime.UtcNow;
SV_db1Entities dbEntity = new SV_db1Entities();
try
{
var d_ext = dbEntity.DOCTOR_ext.Where(a => a.attr_name == _attr_name && a.rel_DOCTOR_id == doc_id).FirstOrDefault();
if (d_ext == null) // add attr if does not exist yet
{
d_ext = new DOCTOR_ext();
d_ext.rel_DOCTOR_id = doc_id;
d_ext.attr_name = _attr_name;
d_ext.dname = _dname;
d_ext.value = _value;
d_ext.dt_create = dt;
d_ext.create_by__USER_id = 0;
dbEntity.DOCTOR_ext.Add(d_ext);
dbEntity.SaveChanges();
}
else // update the record if attr already exist
{
//DOCTOR_ext d_ext = new DOCTOR_ext();
//var d_ext = dbEntity.DOCTOR_ext.Where(a => a.attr_name == _attr_name && a.rel_DOCTOR_id == doc_id).FirstOrDefault();
d_ext.attr_name = _attr_name;
d_ext.dname = _dname;
d_ext.value = _value;
d_ext.dt_update = dt;
d_ext.update_by__USER_id = 0;
dbEntity.Entry(d_ext).State = System.Data.Entity.EntityState.Modified;
dbEntity.SaveChanges();
}
}
catch (Exception ex) { }
return(true);
}
/// <summary>
/// Get appointment type per Doctor.
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public appt_type _getDoctor_appointmenttype(long value)
{
SV_db1Entities dbEntity = new SV_db1Entities();
appt_type appt_type = new appt_type();
// long vappt_id = 0;
// bool isAppt = long.TryParse(value, out vappt_id);
var n1 = dbEntity.ref_APPOINTMENT_type.Find(value);
string vappt_name = n1.dname;
long vappt_id = n1.id;
//appt_type.Add(new appt_type
//{
// id = vappt_id,
// type = vappt_name
//});
appt_type.id = vappt_id;
appt_type.type = vappt_name;
return(appt_type);
}
