protected void AcceptButton_Click(object sender, EventArgs e) { User user = new User(); Rola role = new Rola(); user.login = EmailTxt.Text; user.imie = NameTxt.Text; user.nazwisko = SurnameTxt.Text; role.roleId =Int32.Parse(RoleDDL.SelectedValue); user.rola = role; try { inzPJATKSNM.Controllers.AuthenticationController.saveUser(user); } catch (Exception ex) { Response.Redirect("NewUserView.aspx?err=" + ex); } }
public static User getUser(String login) { User user = new User(); Rola role = new Rola(); String connStr = ConfigurationManager.ConnectionStrings["inzSNMConnectionString"].ConnectionString; // try // { using (SqlConnection Sqlcon = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand("GET_USER", Sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; SqlParameter outPutParameter = new SqlParameter(); cmd.Parameters.Add("@ID_USER", SqlDbType.Int); cmd.Parameters["@ID_USER"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@LOGIN", SqlDbType.VarChar); cmd.Parameters["@LOGIN"].Direction = ParameterDirection.Output; cmd.Parameters["@LOGIN"].Size = 250; cmd.Parameters.Add("@PWD", SqlDbType.VarChar); cmd.Parameters["@PWD"].Direction = ParameterDirection.Output; cmd.Parameters["@PWD"].Size = 250; cmd.Parameters.Add("@NAME", SqlDbType.VarChar); cmd.Parameters["@NAME"].Direction = ParameterDirection.Output; cmd.Parameters["@NAME"].Size = 250; cmd.Parameters.Add("@SURNAME", SqlDbType.VarChar); cmd.Parameters["@SURNAME"].Direction = ParameterDirection.Output; cmd.Parameters["@SURNAME"].Size = 250; cmd.Parameters.Add("@TOKEN", SqlDbType.VarChar); cmd.Parameters["@TOKEN"].Direction = ParameterDirection.Output; cmd.Parameters["@TOKEN"].Size = 250; cmd.Parameters.Add("@ID_ROLE", SqlDbType.Int); cmd.Parameters["@ID_ROLE"].Direction = ParameterDirection.Output; // try // { Sqlcon.Open(); cmd.Parameters.Add("@LOGIN2", SqlDbType.VarChar); cmd.Parameters["@LOGIN2"].Value = login; cmd.Parameters["@LOGIN2"].Size = 100; cmd.ExecuteNonQuery(); user.userId = Convert.ToInt32(cmd.Parameters["@ID_USER"].Value); user.login = cmd.Parameters["@LOGIN"].Value.ToString(); user.haslo = cmd.Parameters["@PWD"].Value.ToString(); user.imie = cmd.Parameters["@NAME"].Value.ToString(); user.nazwisko = cmd.Parameters["@SURNAME"].Value.ToString(); user.token = cmd.Parameters["@TOKEN"].Value.ToString(); role.roleId = Convert.ToInt32(cmd.Parameters["@ID_ROLE"].Value); user.rola = role; user.rola.roleId = role.roleId; } Sqlcon.Close(); } // } // catch (Exception e) // { // throw new Exception("Autor o podanym loginie nie istnieje w systemie!"); //} return user; }