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