public AdminUserStruct Register(string Name, string LastName, string Email, string Password)
{
_connection.SqlConnection.Open();
var sqlcmd = new SqlCommand("" +
"INSERT INTO ServiceUser " +
"(Password) VALUES (@password); " +
"SELECT IDENT_CURRENT('ServiceUser');", _connection.SqlConnection);
sqlcmd.Parameters.Add(new SqlParameter("password", Password));
var reader = sqlcmd.ExecuteReader();
List <AdminUserStruct> serviceUserStructs = new List <AdminUserStruct>();
decimal lastid = 0;
while (reader.Read())
{
lastid = reader.GetDecimal(0);
}
_connection.SqlConnection.Close();
_connection.SqlConnection.Open();
var sqlcmd2 = new SqlCommand("" +
"INSERT INTO [User] " +
"(Name, LastName, idCustomerUser idServiceUser, IsActive, Mail) " +
"VALUES (@name, @lastname, @idcustomeruser @idserviceuser @isactive, @mail); " +
"GO; " +
"SELECT [User].Name, [User].LastName ,[User].Mail, [User].IsActive " +
"FROM [User] " +
"INNER JOIN [ServiceUser] ON [User].idServiceUser = [ServiceUser].idServiceUser " +
"WHERE [User].id = @id; ", _connection.SqlConnection);
sqlcmd2.Parameters.Add(new SqlParameter("name", Name));
sqlcmd2.Parameters.Add(new SqlParameter("lastname", LastName));
sqlcmd2.Parameters.Add(new SqlParameter("idcustomeruser", null));
sqlcmd2.Parameters.Add(new SqlParameter("idserviceuser", lastid));
sqlcmd2.Parameters.Add(new SqlParameter("isactive", true));
sqlcmd2.Parameters.Add(new SqlParameter("mail", Email));
sqlcmd2.Parameters.Add(new SqlParameter("id", lastid));
reader = sqlcmd2.ExecuteReader();
AdminUserStruct sus = new AdminUserStruct();
while (reader.Read())
{
sus = new AdminUserStruct(
reader.GetString(0),
reader.GetString(1),
reader.GetString(2),
reader.GetBoolean(3)
);
}
_connection.SqlConnection.Close();
return(sus);
}
public AdminUser(AdminUserStruct serviceUserStruct)
{
this.Name = serviceUserStruct.Name;
this.LastName = serviceUserStruct.LastName;
this.Mail = serviceUserStruct.Mail;
this.IsActive = serviceUserStruct.IsActive;
}
public AdminUserStruct GetServiceUser(string Email)
{
_connection.SqlConnection.Open();
var cmd = new SqlCommand("" +
"SELECT [User].Name, [User].LastName ,[User].Mail, [User].IsActive " +
"FROM [User] " +
"INNER JOIN [ServiceUser] ON [User].idServiceUser = [ServiceUser].idServiceUser " +
"WHERE [User].Mail = @mail ", _connection.SqlConnection);
cmd.Parameters.Add(new SqlParameter("mail", Email));
var reader = cmd.ExecuteReader();
AdminUserStruct sus = new AdminUserStruct();
while (reader.Read())
{
sus = new AdminUserStruct(
reader.GetString(0),
reader.GetString(1),
reader.GetString(2),
reader.GetBoolean(3)
);
}
//Close Connection
_connection.SqlConnection.Close();
return(sus);
}
