public static string getShiftData(Endorsement_shiftData data)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_shiftData> Endorsement_shiftData =
new List <Endorsement_shiftData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("select id,Shift,Patient_id,Diet_id,Diet_Name,Pain,P_Isolation,Fall, Allergy,Investegation_ToDo,Investegation_FollowUp,Contraptions_Infusions,Routise_PlanOfCare,Surgury_Procedures,DR_Diagnosis,DR_ProgressNotes,DR_Consultaion_Progress,Insert_Nurse,Insert_Nurse_Name,Insert_Nurse_Time,Update_Nurse,Update_Nurse_Name,Update_Nurse_Time, Update_Doctor,Update_Doctor_Name,Update_Doctor_Time,Insert_Doctor,Insert_Doctor_Name,Insert_Doctor_Time,Consultaion,Entry_date from Endorsement_PatientFollow where Patient_id = @Patient_id order by id asc",
con)
)
{
cmd.Parameters.Add("@Patient_id", SqlDbType.Int).Value =
data.Patient_id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_shiftData =
populateEndorsement_shiftDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_shiftData));
}
public static string getShiftData(Endorsement_shiftData data)
{
string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_shiftData> Endorsement_shiftData = new List <Endorsement_shiftData>();
List <user> user = new List <user>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd = new SqlCommand("select top(1) * from Endorsement_PatientFollow where Patient_id = @Patient_id order by id desc", con))
{
cmd.Parameters.Add("@Patient_id", SqlDbType.Int).Value = data.Patient_id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_shiftData = populateEndorsement_shiftDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_shiftData));
}
public static string insertFollowUpData(Endorsement_shiftData patient)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_shiftData> Endorsement_shiftData =
new List <Endorsement_shiftData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("insert into Endorsement_PatientFollow (Patient_id,Insert_Nurse,Insert_Nurse_Name,Insert_Nurse_Time,Insert_Doctor,Insert_Doctor_Name,Insert_Doctor_Time, Transfer_From, Transfer_To, Shift) values(@Patient_id, @Insert_Nurse,@Insert_Nurse_Name, @Insert_Nurse_Time,@Insert_Doctor,@Insert_Doctor_Name, @Insert_Doctor_Time, @Transfer_From, @Transfer_To, @Shift ) ",
con)
)
{
cmd.Parameters.Add("@Patient_id", SqlDbType.Int).Value =
patient.Patient_id;
cmd.Parameters.Add("@Insert_Nurse", SqlDbType.Int).Value =
patient.Insert_Nurse;
cmd.Parameters.Add("@Insert_Nurse_Name", SqlDbType.VarChar).Value =
patient.Insert_Nurse_Name;
cmd.Parameters.Add("@Insert_Nurse_Time", SqlDbType.VarChar).Value =
patient.Insert_Nurse_Time;
cmd.Parameters.Add("@Insert_Doctor", SqlDbType.Int).Value =
patient.Insert_Doctor;
cmd.Parameters.Add("@Insert_Doctor_Name", SqlDbType.VarChar).Value =
patient.Insert_Doctor_Name;
cmd.Parameters.Add("@Insert_Doctor_Time", SqlDbType.VarChar).Value =
patient.Insert_Doctor_Time;
cmd.Parameters.Add("@Transfer_From", SqlDbType.VarChar).Value =
patient.Transfer_From;
cmd.Parameters.Add("@Transfer_To", SqlDbType.VarChar).Value =
patient.Transfer_To;
cmd.Parameters.Add("@Shift", SqlDbType.VarChar).Value =
patient.Shift;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_shiftData =
populateEndorsement_shiftDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_shiftData));
}
public static string updateFollowUpData(Endorsement_shiftData patient)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_shiftData> Endorsement_shiftData =
new List <Endorsement_shiftData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("update Endorsement_PatientFollow set Update_Nurse = @Update_Nurse, Update_Nurse_Name = @Update_Nurse_Name, Update_Nurse_Time = @Update_Nurse_Time, Update_Doctor = @Update_Doctor,Update_Doctor_Name = @Update_Doctor_Name,Update_Doctor_Time = @Update_Doctor_Time, Transfer_From = @Transfer_From, Transfer_To = @Transfer_To where id = @id ",
con)
)
{
cmd.Parameters.Add("@id", SqlDbType.Int).Value = patient.id;
cmd.Parameters.Add("@Update_Nurse", SqlDbType.Int).Value =
patient.Update_Nurse;
cmd.Parameters.Add("@Update_Nurse_Name", SqlDbType.VarChar).Value =
patient.Update_Nurse_Name;
cmd.Parameters.Add("@Update_Nurse_Time", SqlDbType.VarChar).Value =
patient.Update_Nurse_Time;
cmd.Parameters.Add("@Update_Doctor", SqlDbType.Int).Value =
patient.Update_Doctor;
cmd.Parameters.Add("@Update_Doctor_Name", SqlDbType.VarChar).Value =
patient.Update_Doctor_Name;
cmd.Parameters.Add("@Update_Doctor_Time", SqlDbType.VarChar).Value =
patient.Update_Doctor_Time;
cmd.Parameters.Add("@Transfer_From", SqlDbType.VarChar).Value =
patient.Transfer_From;
cmd.Parameters.Add("@Transfer_To", SqlDbType.VarChar).Value =
patient.Transfer_To;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_shiftData =
populateEndorsement_shiftDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_shiftData));
}
public static string updateFollowUpData(Endorsement_shiftData patient)
{
string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_shiftData> Endorsement_shiftData = new List <Endorsement_shiftData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd = new SqlCommand("update Endorsement_PatientFollow set Shift = @Shift,Diet_id = @Diet_id, Diet_Name = @Diet_Name, Pain = @Pain, P_Isolation=@P_Isolation, Fall = @Fall, Allergy= @Allergy,Investegation_ToDo = @Investegation_ToDo, Investegation_FollowUp = @Investegation_FollowUp,Contraptions_Infusions = @Contraptions_Infusions, Routise_PlanOfCare=@Routise_PlanOfCare,Surgury_Procedures = @Surgury_Procedures,DR_Diagnosis = @DR_Diagnosis,DR_ProgressNotes = @DR_ProgressNotes, DR_Consultaion_Progress = @DR_Consultaion_Progress, Update_Nurse = @Update_Nurse, Update_Nurse_Name = @Update_Nurse_Name, Update_Nurse_Time = @Update_Nurse_Time, Update_Doctor = @Update_Doctor,Update_Doctor_Name = @Update_Doctor_Name,Update_Doctor_Time = @Update_Doctor_Time where id = @id ", con))
{
cmd.Parameters.Add("@id", SqlDbType.Int).Value = patient.id;
cmd.Parameters.Add("@Shift", SqlDbType.VarChar).Value = patient.Shift;
cmd.Parameters.Add("@Diet_id", SqlDbType.Int).Value = patient.Diet_id;
cmd.Parameters.Add("@Diet_Name", SqlDbType.VarChar).Value = patient.Diet_Name;
cmd.Parameters.Add("@Pain", SqlDbType.Int).Value = patient.Pain;
cmd.Parameters.Add("@P_Isolation", SqlDbType.VarChar).Value = patient.P_Isolation;
cmd.Parameters.Add("@Fall", SqlDbType.VarChar).Value = patient.Fall;
cmd.Parameters.Add("@Allergy", SqlDbType.VarChar).Value = patient.Allergy;
cmd.Parameters.Add("@Investegation_ToDo", SqlDbType.VarChar).Value = patient.Investegation_ToDo;
cmd.Parameters.Add("@Investegation_FollowUp", SqlDbType.VarChar).Value = patient.Investegation_FollowUp;
cmd.Parameters.Add("@Contraptions_Infusions", SqlDbType.VarChar).Value = patient.Contraptions_Infusions;
cmd.Parameters.Add("@Routise_PlanOfCare", SqlDbType.VarChar).Value = patient.Routise_PlanOfCare;
cmd.Parameters.Add("@Surgury_Procedures", SqlDbType.VarChar).Value = patient.Surgury_Procedures;
cmd.Parameters.Add("@DR_Diagnosis", SqlDbType.VarChar).Value = patient.DR_Diagnosis;
cmd.Parameters.Add("@DR_ProgressNotes", SqlDbType.VarChar).Value = patient.DR_ProgressNotes;
cmd.Parameters.Add("@DR_Consultaion_Progress", SqlDbType.VarChar).Value = patient.DR_Consultaion_Progress;
cmd.Parameters.Add("@Update_Nurse", SqlDbType.Int).Value = patient.Update_Nurse;
cmd.Parameters.Add("@Update_Nurse_Name", SqlDbType.VarChar).Value = patient.Update_Nurse_Name;
cmd.Parameters.Add("@Update_Nurse_Time", SqlDbType.DateTime).Value = patient.Update_Nurse_Time;
cmd.Parameters.Add("@Update_Doctor", SqlDbType.Int).Value = patient.Update_Doctor;
cmd.Parameters.Add("@Update_Doctor_Name", SqlDbType.VarChar).Value = patient.Update_Doctor_Name;
cmd.Parameters.Add("@Update_Doctor_Time", SqlDbType.DateTime).Value = patient.Update_Doctor_Time;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_shiftData = populateEndorsement_shiftDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_shiftData));
}