public ActionResult RegisterPacient(RegisterPatientModel model) { PatientComposite patient = new PatientComposite { Patient = new Patient { Surname = model.Patient.Surname, Name = model.Patient.Name, Patronymic = model.Patient.Patronymic, Street = model.Patient.Street, House = model.Patient.House, Room = model.Patient.Room }, User = new User { Login = model.User.Login, Password = model.User.Password } }; DbWork db = new DbWork(); db.RegistryPatient(patient); return(RedirectToAction("Index", "Home")); }
public PatientComposite GetPatientByUserId(int userId) { PatientComposite patient = new PatientComposite(); _connection.Open(); var sql = String.Format("select patient_id, patient_surname, patient_name, patient_patronymic, street, house, room, account, " + "street_id, street_name, area,user_id, login, password, role " + "from users join(patients join streets on street = street_id) on account = user_id" + " where user_id = {0}", userId); var cmd = new NpgsqlCommand(sql, _connection); NpgsqlDataReader npgSqlDataReader = cmd.ExecuteReader(); if (npgSqlDataReader.HasRows) { foreach (DbDataRecord dbDataRecord in npgSqlDataReader) { patient = new PatientComposite(dbDataRecord); } } _connection.Close(); return(patient); }
public void RegistryPatient(PatientComposite patient) { _connection.Open(); var sql = String.Format("insert into users (login, password, role) values ('{0}', '{1}', {2}) returning user_id", patient.User.Login, patient.User.Password, 3); var cmd = new NpgsqlCommand(sql, _connection); NpgsqlDataReader npgSqlDataReader = cmd.ExecuteReader(); int id = 0; while (npgSqlDataReader.Read()) { id = Int32.Parse(npgSqlDataReader["user_id"].ToString()); } _connection.Close(); _connection.Open(); sql = String.Format("insert into patients (patient_surname, patient_name, patient_patronymic, street, house, room, account)" + "values ('{0}', '{1}', '{2}', {3}, {4}, {5}, {6})", patient.Patient.Surname, patient.Patient.Name, patient.Patient.Patronymic, patient.Patient.Street, patient.Patient.House, patient.Patient.Room, id); var cmd2 = new NpgsqlCommand(sql, _connection); cmd2.ExecuteNonQuery(); _connection.Close(); }
public PatientModel(PatientComposite pacient) { Id = pacient.Patient.Id; Surname = pacient.Patient.Surname; Name = pacient.Patient.Name; Patronymic = pacient.Patient.Patronymic; Street = pacient.Patient.Street; StreetName = pacient.Patient.StreetName; House = pacient.Patient.House; Room = pacient.Patient.Room; Account = pacient.Patient.Account; StreetName = pacient.Street.Name; }
public RegisterPatientModel(PatientComposite db) { Patient = new PatientModel(db.Patient); User = new UserModel(db.User); Streets = new List <StreetModel>(); }