public ActionResult RegisterDoctor(RegisterDoctorModel model)
{
DoctorComposite doctor = new DoctorComposite
{
Doctor = new Doctor
{
Surname = model.Doctor.Surname,
Name = model.Doctor.Name,
Patronymic = model.Doctor.Patronymic,
Area = model.Doctor.Area,
Speciality = model.Doctor.Speciality
},
User = new User
{
Login = model.User.Login,
Password = model.User.Password
}
};
DbWork db = new DbWork();
db.RegisterDoctor(doctor);
return(RedirectToAction("Index", "Home"));
}
public RegisterDoctorModel(DoctorComposite db)
{
Doctor = new DoctorModel(db.Doctor);
User = new UserModel(db.User);
Areas = new List <AreaModel>();
Specialities = new List <SpecialityModel>();
}
public DoctorModel(DoctorComposite db)
{
Id = db.Doctor.Id;
Surname = db.Doctor.Surname;
Name = db.Doctor.Name;
Patronymic = db.Doctor.Patronymic;
Speciality = db.Doctor.Speciality;
SpecialityName = db.Doctor.SpecialityName;
Area = db.Doctor.Area;
Account = db.Doctor.Account;
}
public DoctorComposite GetDoctorByUserId(int userId)
{
DoctorComposite doctor = new DoctorComposite();
_connection.Open();
var sql = String.Format("select * from users join (doctors right join areas on area = area_id " +
"join specialities on speciality = speciality_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)
{
doctor = new DoctorComposite(dbDataRecord);
}
}
_connection.Close();
return(doctor);
}
public void RegisterDoctor(DoctorComposite doctor)
{
_connection.Open();
var sql = String.Format("insert into users (login, password, role) values ('{0}', '{1}', {2}) returning user_id", doctor.User.Login, doctor.User.Password, 1);
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 doctors (doctor_surname, doctor_name, doctor_patronymic, area, speciality, account)" +
"values ('{0}', '{1}', '{2}', {3}, {4}, {5})", doctor.Doctor.Surname, doctor.Doctor.Name, doctor.Doctor.Patronymic, doctor.Doctor.Area, doctor.Doctor.Speciality, id);
var cmd2 = new NpgsqlCommand(sql, _connection);
cmd2.ExecuteNonQuery();
_connection.Close();
}
