public static ViewNotesModel GetVisitDetails(int iVisitID)
{
string sql = @"select ID as VisitID, VisitDate, Problem_ID as ProblemID from dbo.Patient_Visits WHERE ID=" + iVisitID + ";";
ViewNotesModel rec = SqlDataAccessProd.LoadRecord(sql);
return(rec);
}
//public int ID { get; set; }
//public bool Active { get; set; }
//public string First_Name { get; set; }
//public string Middle_Name { get; set; }
//public string Last_Name { get; set; }
//public Nullable<System.DateTime> Date_Of_Birth { get; set; }
//public string Home_Phone { get; set; }
//public string Work_Phone { get; set; }
//public string Alternate_Phone { get; set; }
//public string Sex { get; set; }
//public string Directions { get; set; }
//public string SSN { get; set; }
//public string Address1 { get; set; }
//public string Address2 { get; set; }
//public string City { get; set; }
//public string State { get; set; }
//public string Zip { get; set; }
//public int LanguageID { get; set; }
//public string Email { get; set; }
public static int CreateNew(string firstName, string middleName, string lastName, System.DateTime dob,
string homePhone, string workPhone, string altPhone, string sex, string directions, string ssn, string address1, string address2,
string city, string state, string zip, int language, string email)
{
PatientModel data = new PatientModel
{
First_Name = firstName,
Middle_Name = middleName,
Last_Name = lastName,
Date_Of_Birth = dob,
Home_Phone = homePhone,
Work_Phone = workPhone,
Alternate_Phone = altPhone,
Sex = sex,
Directions = directions,
SSN = ssn,
Address1 = address1,
Address2 = address2,
City = city,
State = state,
Zip = zip,
LanguageID = language,
Email = email
};
string sql = @"insert into dbo.Patients (active, First_Name, Middle_Name, Last_Name, Date_Of_Birth, Home_Phone, Work_Phone,
Alternate_Phone, Sex, Directions, SSN, Address1, Address2, City, State, Zip, LanguageID, Email)
values (1, @First_Name, @Middle_Name, @Last_Name, @Date_Of_Birth, @Home_Phone, @Work_Phone,
@Alternate_Phone, @Sex, @Directions, @SSN, @Address1, @Address2, @City, @State, @Zip, @LanguageID, @Email);";
return(SqlDataAccessProd.SaveData(sql, data));
}
//public string SubjectiveText { get; set; }
//public string ObjectiveText { get; set; }
//public string AssessmentText { get; set; }
//public string PlanText { get; set; }
//public int Duration { get; set; }
//public int Resource_ID { get; set; }
//public bool Cancellation { get; set; }
//public bool NoShow { get; set; }
public static int UpdateNote(int iVisitId, string sSubjectiveText, string sObjectiveText, string sAssessmentText, string sPlanText,
int iDuration, int iResource_ID, bool bCancellation, bool bNoShow)
{
DataLibrary.Models.ViewNotesModel data = new DataLibrary.Models.ViewNotesModel
{
SubjectiveText = sSubjectiveText,
ObjectiveText = sObjectiveText,
AssessmentText = sAssessmentText,
PlanText = sPlanText,
Duration = iDuration,
Resource_ID = iResource_ID,
Cancellation = bCancellation,
NoShow = bNoShow
};
string sqlU = @"update dbo.Patient_Visit_Notes set [SubjectiveText]=@SubjectiveText, [ObjectiveText]=@ObjectiveText
where Visit_ID=" + iVisitId + ";";
SqlDataAccessProd.SaveData(sqlU, data);
sqlU = @"update dbo.Patient_Visits set [AssessmentText]=@AssessmentText, [PlanText]=@PlanText, [Cancellation]=@Cancellation, [No_Show]=@NoShow, [Duration]=@Duration, [Resource_ID]=@Resource_ID
where ID=" + iVisitId + ";";
return(SqlDataAccessProd.SaveData(sqlU, data));
}
public static List <ViewNotesModel> spGetPatientVisit70(int iVisitId)
{
var p = new DynamicParameters();
p.Add("@lngVisitID", iVisitId);
//p.Add("@b", dbType: DbType.Int32, direction: ParameterDirection.Output);
//p.Add("@c", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);
//Guid guVisitID = ToGuid(iVisitId);
return(SqlDataAccessProd.LoadSP2 <ViewNotesModel>("spGetPatientVisit70", p));
}
public static List <VisitWorkModel> LoadWorkForVisit(int iVisitId)
{
string sql = @"SELECT Patient_Visits.VisitDate, Daily_Work_Records.Comment, Daily_Work_Records.Exercise_Modality_Code,
Exercises_Modalities.Exercise_Modality_Description, Daily_Work_Records.Sets, Daily_Work_Records.Reps,
Daily_Work_Records.Weight, Daily_Work_Records.Duration, Daily_Work_Records.On_Hold, Exercises_Modalities.Sets_Reps_Weight,
Exercises_Modalities.Label
FROM Exercises_Modalities
INNER JOIN Patient_Visits INNER JOIN Daily_Work_Records ON Patient_Visits.ID = Daily_Work_Records.Visit_ID ON Exercises_Modalities.Exercise_Modality_Code = Daily_Work_Records.Exercise_Modality_Code LEFT OUTER JOIN Patient_Treatment_Plan ON Patient_Visits.Problem_ID = Patient_Treatment_Plan.Problem_ID AND Exercises_Modalities.Exercise_Modality_Code = Patient_Treatment_Plan.Exercise_Modality_Code
WHERE (Patient_Visits.ID=" + iVisitId + ") ORDER BY Patient_Treatment_Plan.Sort_Order;";
return(SqlDataAccessProd.LoadData <VisitWorkModel>(sql));
}
////public class PatientVisitsBillingModel
////{
//// public short Units { get; set; }
//// public decimal Unit_Amount { get; set; }
////}
public static int UpdateRecord(int iId, int Billing_ID, string Code, short Units, Decimal Unit_Amount)
{
PatientVisitsBillingModel data = new PatientVisitsBillingModel
{
ID = iId,
Billing_ID = Billing_ID,
Code = Code,
Units = Units,
Unit_Amount = Unit_Amount
};
string sqlU = @"update dbo.Patient_Visit_Billings set Billing_ID=@Billing_ID, Billing_Code=@Code, Units=@Units,
Unit_Amount=@Unit_Amount where ID=@ID; ";
return(SqlDataAccessProd.SaveData(sqlU, data));
}
public static List <AnySelectListModel> LoadSelectList(string sTableName)
{
string sql = "";
// Resources
if (sTableName == "Resources")
{
sql = @"select ID, Active, Last_Name + ', ' + First_Name as Description from dbo." + sTableName + " WHERE NonResource=0 ORDER BY Last_Name, First_Name;";
}
else
{
if (sTableName == "Billing_Codes")
{
sql = @"select ID, Description + ' (' + Code + ')' as Description from dbo." + sTableName + " WHERE Active=1 ORDER BY Description;";
}
}
return(SqlDataAccessProd.LoadData <AnySelectListModel>(sql));
}
public static List <PatientModel> LoadPatientsSearch(int PageNo, int PageSize, string SearchFor)
{
string sql = @"select * from dbo.Patients;";
if (SearchFor == "")
{
sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id ASC) AS RowNum,* " +
"FROM dbo.Patients WHERE 1 = 1 ) a WHERE a.RowNum " +
"BETWEEN(CAST(" + PageNo + " AS int) -1)* CAST(" + PageSize + " AS int) " +
"+1 AND (CAST(" + PageNo + " AS int)* CAST(" + PageSize + " AS int)); ";
}
else
{
sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id ASC) AS RowNum,* " +
"FROM dbo.Patients WHERE " + SearchFor + " ) a WHERE a.RowNum " +
"BETWEEN(CAST(" + PageNo + " AS int) -1)* CAST(" + PageSize + " AS int) " +
"+1 AND (CAST(" + PageNo + " AS int)* CAST(" + PageSize + " AS int)); ";
}
return(SqlDataAccessProd.LoadData <PatientModel>(sql));
}
public static int UpdateRecord(int iId, string firstName, string middleName, string lastName, DateTime dob,
string homePhone, string workPhone, string altPhone, string sex, string directions, string ssn, string address1, string address2,
string city, string state, string zip, int language, string email)
{
// remove the time part
var dob_date = dob.Date;
PatientModel data = new PatientModel
{
ID = iId,
First_Name = firstName,
Middle_Name = middleName,
Last_Name = lastName,
Date_Of_Birth = dob_date,
Home_Phone = homePhone,
Work_Phone = workPhone,
Alternate_Phone = altPhone,
Sex = sex,
Directions = directions,
SSN = ssn,
Address1 = address1,
Address2 = address2,
City = city,
State = state,
Zip = zip,
LanguageID = language,
Email = email
};
string sqlU = @"update dbo.Patients set First_Name=@First_Name, Middle_Name=@Middle_Name, Last_Name=@Last_Name,
Date_Of_Birth=@Date_Of_Birth, Home_Phone=@Home_Phone, Work_Phone=@Work_Phone, Alternate_Phone=@Alternate_Phone, Sex=@Sex,
Directions=@Directions, SSN=@SSN, Address1=@Address1, Address2=@Address2, City=@City, State=@State,
Zip=@Zip, LanguageID=@LanguageID, Email=@Email
where ID=@ID; ";
return(SqlDataAccessProd.SaveData(sqlU, data));
}
public static List <LanguageModel> LoadLanguages()
{
string sql = @"select * from dbo.Language;";
return(SqlDataAccessProd.LoadData <LanguageModel>(sql));
}
public static int DeleteRecord(int iId)
{
string sqlU = @"delete from dbo.Patients where ID=" + iId + ";";
return(SqlDataAccessProd.DeleteData(sqlU));
}
public static List <PatientModel> LoadOneRecord(int iId)
{
string sql = @"select * from dbo.Patients where ID=" + iId + ";";
return(SqlDataAccessProd.LoadData <PatientModel>(sql));
}
public static string GetOneBillingCode(int iId)
{
string sql = @"select Code from dbo.Billing_Codes where ID=" + iId + ";";
return(SqlDataAccessProd.LoadOneRecord <string>(sql));
}
public static int CountRecords()
{
string sqlU = @"select count(*) as count from dbo.Patients;";
return(SqlDataAccessProd.CountData(sqlU));
}
public static List <PatientModel> LoadAllRecords()
{
string sql = @"select * from dbo.Patients;";
return(SqlDataAccessProd.LoadData <PatientModel>(sql));
}
public static List <PatientVisitsModel> LoadAllVisitsForPatient(int iId)
{
string sql = @"select VisitDate, ID from dbo.Patient_Visits WHERE Problem_ID=" + iId + " ORDER BY VisitDate DESC;";
return(SqlDataAccessProd.LoadData <PatientVisitsModel>(sql));
}
public static PatientVisitsBillingModel GetOneItem(int iId)
{
string sql = @"select ID, Billing_ID, Billing_Code as Code, Units, Unit_Amount from dbo.Patient_Visit_Billings where ID=" + iId + ";";
return(SqlDataAccessProd.LoadOneRecord <PatientVisitsBillingModel>(sql));
}
