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>();
}
