public static string getPatientData(Endorsement_PatientData id)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_PatientData> Endorsement_PatientData =
new List <Endorsement_PatientData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("select * from Endorsement_PatientData where id = @id",
con)
)
{
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id.id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_PatientData =
populateEndorsement_PatientDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_PatientData));
}
public static string getPatientsData(Endorsement_PatientData info)
{
string config =
Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_PatientData> Endorsement_PatientData =
new List <Endorsement_PatientData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (
SqlCommand cmd =
new SqlCommand("select * from Endorsement_PatientData WHERE Patient_Status = 1 and Branch_id = @Branch_id and Unit = @Unit",
con)
)
{
cmd.Parameters.Add("@Unit", SqlDbType.VarChar).Value = info.Unit;
cmd.Parameters.Add("@Branch_id", SqlDbType.VarChar).Value =
info.Branch_id;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_PatientData =
populateEndorsement_PatientDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_PatientData));
}
public static string updatePatientData(Endorsement_PatientData patient)
{
string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_PatientData> Endorsement_PatientData = new List <Endorsement_PatientData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd = new SqlCommand("update Endorsement_PatientData set Patient_FullName = @Patient_FullName,Age = @Age, Addmission_date = @Addmission_date, Consultant_Name = @Consultant_Name where id = @id ", con))
{
cmd.Parameters.Add("@id", SqlDbType.Int).Value = patient.id;
cmd.Parameters.Add("@Patient_FullName", SqlDbType.VarChar).Value = patient.Patient_FullName;
cmd.Parameters.Add("@Age", SqlDbType.VarChar).Value = patient.Age;
cmd.Parameters.Add("@Addmission_date", SqlDbType.VarChar).Value = patient.Addmission_date;
cmd.Parameters.Add("@Consultant_Name", SqlDbType.VarChar).Value = patient.Consultant_Name;
SqlDataReader idr = cmd.ExecuteReader();
if (idr.HasRows)
{
Endorsement_PatientData = populateEndorsement_PatientDataLisst(idr, con);
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_PatientData));
}
public static string newPatient(Endorsement_PatientData data)
{
string config = Convert.ToString(ConfigurationManager.ConnectionStrings["dbcon"]);
List <Endorsement_PatientData> Endorsement_PatientData = new List <Endorsement_PatientData>();
SqlConnection con = new SqlConnection(config);
con.Open();
using (SqlCommand cmd1 = new SqlCommand("insert into Endorsement_PatientData (Patient_FullName, Branch_id, Branch_name,Gender,Medical_Number,Unit,Room,Addmission_date,Age,Date_Birth,Consultant_Name,Specialty,Patient_Status) values (@Patient_FullName,@Branch_id, @Branch_name, @Gender, @Medical_Number, @Unit, @Room, @Addmission_date, @Age, @Date_Birth, @Consultant_Name, @Specialty, @Patient_Status)", con))
{
cmd1.Parameters.Add("@Patient_FullName", SqlDbType.VarChar).Value = data.Patient_FullName;
cmd1.Parameters.Add("@Branch_id", SqlDbType.Int).Value = data.Branch_id;
cmd1.Parameters.Add("@Branch_name", SqlDbType.VarChar).Value = data.Branch_name;
cmd1.Parameters.Add("@Gender", SqlDbType.VarChar).Value = data.Gender;
cmd1.Parameters.Add("@Medical_Number", SqlDbType.BigInt).Value = data.Medical_Number;
cmd1.Parameters.Add("@Unit", SqlDbType.VarChar).Value = data.Unit;
cmd1.Parameters.Add("@Room", SqlDbType.VarChar).Value = data.Room;
cmd1.Parameters.Add("@Addmission_date", SqlDbType.VarChar).Value = data.Addmission_date;
cmd1.Parameters.Add("@Age", SqlDbType.Int).Value = data.Age;
cmd1.Parameters.Add("@Date_Birth", SqlDbType.VarChar).Value = data.Date_Birth;
cmd1.Parameters.Add("@Consultant_Name", SqlDbType.VarChar).Value = data.Consultant_Name;
cmd1.Parameters.Add("@Specialty", SqlDbType.VarChar).Value = data.Specialty;
cmd1.Parameters.Add("@Patient_Status", SqlDbType.Int).Value = 1;
cmd1.ExecuteNonQuery();
}
con.Close();
// update units dashboard
using (SqlCommand cmd2 = new SqlCommand("select * from Endorsement_UnitsDashboard where Unit_name = @Unit_name", con))
{
con.Open();
cmd2.Parameters.Add("@Unit_name", SqlDbType.VarChar).Value = data.Unit;
SqlDataReader idr = cmd2.ExecuteReader();
if (idr.HasRows)
{
con.Close();
con.Open();
using (SqlCommand cmd1 = new SqlCommand("update Endorsement_UnitsDashboard Total_Census = Total_Census + 1, Admission = Admission + 1", con))
{
cmd1.ExecuteNonQuery();
}
con.Close();
}
}
con.Close();
return(JsonConvert.SerializeObject(Endorsement_PatientData));
}
