public ActionResult Registo() { var model = new RegistoModel { ListaLocalizacoes = CustomHelper.GetListaLocalizacoes(ConnectionString) }; return(View(model)); }
public ActionResult Registo(RegistoModel model) { if (!ModelState.IsValid) { model.ListaLocalizacoes = CustomHelper.GetListaLocalizacoes(ConnectionString); return(PartialView(model)); } string sql = $@"INSERT INTO utilizador ( [username], [password], [nome_completo], [email], [morada], [codigo_postal], [id_localizacao] ) VALUES ( @username, @password, @nome_completo, @email, @morada, @codigo_postal, @id_localizacao)"; using (var connection = new SqlConnection(ConnectionString)) using (var command = new SqlCommand(sql, connection)) { connection.Open(); command.Parameters.AddWithValue("@username", model.Username); command.Parameters.AddWithValue("@password", model.Password); command.Parameters.AddWithValue("@nome_completo", model.Nome); command.Parameters.AddWithValue("@email", model.Email); command.Parameters.AddWithValue("@morada", model.Morada); command.Parameters.AddWithValue("@codigo_postal", model.CodigoPostal); command.Parameters.AddWithValue("@id_localizacao", model.IdLocalizacao); command.ExecuteNonQuery(); connection.Close(); } return(Json(new { })); }
public ActionResult EditarPerfil(RegistoModel model) { ModelState.Remove("Password"); if (!ModelState.IsValid) { model.ListaLocalizacoes = CustomHelper.GetListaLocalizacoes(ConnectionString); return(PartialView(model)); } var sql = $@"update utilizador set [username] = @userName, [nome_completo] = @nome_completo, [email] = @email, [morada] = @morada, [codigo_postal] = @codigo_postal, [id_localizacao] = @id_localizacao where id_user = @id_user"; using (var connection = new SqlConnection(ConnectionString)) using (var command = new SqlCommand(sql, connection)) { connection.Open(); command.Parameters.AddWithValue("@id_user", model.IdUser); command.Parameters.AddWithValue("@username", model.Username); command.Parameters.AddWithValue("@nome_completo", model.Nome); command.Parameters.AddWithValue("@email", model.Email); command.Parameters.AddWithValue("@morada", model.Morada); command.Parameters.AddWithValue("@codigo_postal", model.CodigoPostal); command.Parameters.AddWithValue("@id_localizacao", model.IdLocalizacao); command.ExecuteNonQuery(); connection.Close(); } return(Json(new { Notify = true, Type = CustomHelper.Constantes.TiposNotificacao.Success, Message = "Alterações gravadas com sucesso!", Time = 7500 })); }
public ActionResult EditarPerfil() { ViewBag.LoggedIn = IsLoggedIn(); var utilizador = (LoginModel)Session[SessionUtilizador]; var model = new RegistoModel { ListaLocalizacoes = CustomHelper.GetListaLocalizacoes(ConnectionString), IdUser = utilizador.IdUser }; var sql = "SELECT * from utilizador where id_user = @userId"; using (var connection = new SqlConnection(ConnectionString)) using (var command = new SqlCommand(sql, connection)) { connection.Open(); command.Parameters.AddWithValue("@userId", utilizador.IdUser); using (var reader = command.ExecuteReader()) { if (reader.Read()) { model.Username = reader["UserName"].ToString(); model.Password = reader["password"].ToString(); model.Nome = reader["nome_completo"].ToString(); model.Email = reader["Email"].ToString(); model.Morada = reader["morada"].ToString(); model.CodigoPostal = reader["codigo_postal"].ToString(); model.IdLocalizacao = Convert.ToInt16(reader["id_localizacao"]); } } connection.Close(); } return(View(model)); }