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) { } }