public list_of_specialty DetailsSpecialty(int Specialty_id)
{
List <list_of_specialty> listSpecialty = new List <list_of_specialty>();
list_of_specialty list = new list_of_specialty();
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM list_of_specialty where Specialty_id = @P0";
list = ctx.Database.SqlQuery <list_of_specialty>(query, Specialty_id).ToList().First();
}
return(list);
}
public list_of_diagnoses DetailsDiagnosis(int List_diagnoses_id)
{
List <list_of_diagnoses> listDiagnoses = new List <list_of_diagnoses>();
list_of_diagnoses list = new list_of_diagnoses();
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM list_of_diagnoses where List_diagnoses_id = @P0";
list = ctx.Database.SqlQuery <list_of_diagnoses>(query, List_diagnoses_id).ToList().First();
}
return(list);
}
public doctor DetailsDoctor(int Doctor_id)
{
List <doctor> listDoctor = new List <doctor>();
doctor doctor = new doctor();
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM doctor where Doctor_id = @P0";
doctor = ctx.Database.SqlQuery <doctor>(query, Doctor_id).ToList().First();
}
return(doctor);
}
public patient DetailsPatient(int Patient_id)
{
List <patient> listPatient = new List <patient>();
patient patient = new patient();
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM patient where Patient_id = @P0";
patient = ctx.Database.SqlQuery <patient>(query, Patient_id).ToList().First();
}
return(patient);
}
public ActionResult Create(/*int id = 0*/)
{
doctor doctor = new doctor();
using (PolyclinicEntities db = new PolyclinicEntities())
{
/* if (id != 0)
* doctor = db.doctor.Where(x => x.Doctor_id == id).FirstOrDefault();*/
doctor.ListSpetialty = db.list_of_specialty.ToList <list_of_specialty>();
}
return(View(doctor));
}
public void EditDiagnosis(list_of_diagnoses model, int List_diagnoses_id)
{
using (var ctx = new PolyclinicEntities())
{
string query = "update list_of_diagnoses set Diagnose_name=@P1, Description=@P2 where List_diagnoses_id=@P0";
List <object> parameterList = new List <object> {
List_diagnoses_id,
model.Diagnose_name,
model.Description
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
public void EditSpecialty(list_of_specialty model, int Specialty_id)
{
using (var ctx = new PolyclinicEntities())
{
string query = "update list_of_specialty set Spetialty_name=@P1, Description=@P2 where Specialty_id=@P0";
List <object> parameterList = new List <object> {
Specialty_id,
model.Spetialty_name,
model.Description
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
public List <list_of_diagnoses> GetDiagnoses()
{
List <list_of_diagnoses> diagnoses = new List <list_of_diagnoses>();
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM list_of_diagnoses";
diagnoses.AddRange(ctx.Database.SqlQuery <list_of_diagnoses>(query).ToList());
}
}
catch (Exception ex)
{ }
return(diagnoses);
}
public List <doctor> GetDoctor()
{
List <doctor> doctors = new List <doctor>();
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM doctor";
doctors.AddRange(ctx.Database.SqlQuery <doctor>(query).ToList());
}
}
catch (Exception ex)
{ }
return(doctors);
}
public List <patient> GetPatient()
{
List <patient> patients = new List <patient>();
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM patient";
patients.AddRange(ctx.Database.SqlQuery <patient>(query).ToList());
}
}
catch (Exception ex)
{ }
return(patients);
}
public List <list_of_specialty> GetSpecialty()
{
List <list_of_specialty> specialties = new List <list_of_specialty>();
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "SELECT * FROM list_of_specialty";
specialties.AddRange(ctx.Database.SqlQuery <list_of_specialty>(query).ToList());
}
}
catch (Exception ex)
{ }
return(specialties);
}
public void CreateDiagnosis(list_of_diagnoses model)
{
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "INSERT INTO list_of_diagnoses (Diagnose_name, Description) VALUES(@P0, @P1)";
List <object> parameterList = new List <object> {
model.Diagnose_name,
model.Description
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
catch (Exception ex)
{ }
}
public void EditDoctor(doctor model, int Doctor_id)
{
using (var ctx = new PolyclinicEntities())
{
string query = "update doctor set Surname=@P1, Name=@P2, Patronymic=@P3, Date_of_birth=@P4, Phone_number=@P5, id_specialty=@P6, Education=@P7 where Doctor_id=@P0";
List <object> parameterList = new List <object> {
model.Doctor_id,
model.Surname,
model.Name,
model.Patronymic,
model.Date_of_birth,
model.Phone_number,
model.id_specialty,
model.Education
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
public void EditPatient(patient model, int Patient_id)
{
using (var ctx = new PolyclinicEntities())
{
string query = "update patient set Surname=@P1, Name=@P2, Patronymic=@P3, Date_of_birth=@P4, Phone_number=@P5, Adress=@P6, Insurance_policy=@P7 where Patient_id=@P0";
List <object> parameterList = new List <object> {
Patient_id,
model.Surname,
model.Name,
model.Patronymic,
model.Date_of_birth,
model.Phone_number,
model.Adress,
model.Insurance_policy
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
public void CreateDoctor(doctor model)
{
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "INSERT INTO doctor (Surname, Name, Patronymic, Date_of_birth, Phone_number, id_specialty, Education) VALUES(@P0, @P1, @P2, @P3, @P4, @P5, @P6)";
List <object> parameterList = new List <object> {
model.Surname,
model.Name,
model.Patronymic,
model.Date_of_birth,
model.Phone_number,
model.id_specialty,
model.Education
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
catch (Exception ex)
{ }
}
public void CreatePatient(patient model)
{
try
{
using (var ctx = new PolyclinicEntities())
{
string query = "INSERT INTO patient (Surname, Name, Patronymic, Date_of_birth, Phone_number, Adress, Insurance_policy) VALUES(@P0, @P1, @P2, @P3, @P4, @P5, @P6)";
List <object> parameterList = new List <object> {
model.Surname,
model.Name,
model.Patronymic,
model.Date_of_birth,
model.Phone_number,
model.Adress,
model.Insurance_policy
};
object[] parameters = parameterList.ToArray();
int result = ctx.Database.ExecuteSqlCommand(query, parameters);
}
}
catch (Exception ex)
{ }
}
