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