/**/
public string insertAppointmentData(Appointment appointment, Userr user)
{
string message = "";
try
{
//establecemos la conexion
SqlConnection connection = new SqlConnection(this.connectionString);
String sql = "";
sql = "sp_insertAppoinment";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@date", appointment.date));
cmd.Parameters.Add(new SqlParameter("@hour", appointment.hour));
cmd.Parameters.Add(new SqlParameter("@identityCard", user.identityCard));
SqlParameter parameterId = new SqlParameter("@id", SqlDbType.Int);
parameterId.Direction = ParameterDirection.Output;
//Se asignan los parametros
cmd.Parameters.Add(parameterId);
SqlDataReader reader;
connection.Open();
reader = cmd.ExecuteReader();
string appointmentId = cmd.Parameters["@id"].Value.ToString();
connection.Close();
message = appointmentId;
}
catch (Exception ex)
{
message = "Error al ejecutar la operación en la base de datos";
}
return(message);
}
/**/
public string updateAppointmentData(Appointment appointment, Userr user, string oldDate, string oldHour)
{
string message = "";
try
{
//establecemos la conexion
SqlConnection connection = new SqlConnection(this.connectionString);
String sql = "";
sql = "sp_updateAppoinment";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@identityCard", user.identityCard));
cmd.Parameters.Add(new SqlParameter("@date", appointment.date));
cmd.Parameters.Add(new SqlParameter("@hour", appointment.hour));
cmd.Parameters.Add(new SqlParameter("@oldDate", oldDate));
cmd.Parameters.Add(new SqlParameter("@oldHour", oldHour));
SqlDataReader reader;
connection.Open();
reader = cmd.ExecuteReader();
connection.Close();
message = "La operación se realizo satisfactoriamente";
}
catch (Exception ex)
{
message = "Error al ejecutar la operación en la base de datos";
}
return(message);
}
protected void btnIngresarDiagnostico_Click(object sender, EventArgs e)
{
string date = clRecipeDate.SelectedDate.ToShortDateString();
string[] dateArray = date.Split(' ');
string[] formatDate = dateArray[0].Split('/');
finalDate = formatDate[2] + "-" + formatDate[0] + "-" + formatDate[1];
//Se valida la fecha
validateMessage = validateDate(finalDate, Convert.ToInt32(txtHour.Text));
if (validateMessage == "Disponible")
{
this.recipeBusiness = new RecipeBusiness(this.conn);
this.recipe = new Recipe(txtDescripcion.Text, finalDate, Convert.ToInt32(txtHour.Text));
this.user = new Userr(txtNumCedula.Text);
operationMessage = this.recipeBusiness.insertRecipeBusiness(this.recipe, this.user);
//Se valida que la operación sea exitosa
if (operationMessage != "Error al ejecutar la operación en la base de datos")
{
txtId.Text = operationMessage;
txtMensaje.Text = "La operación se realizó satisfactoriamente";
}
else
{
txtMensaje.Text = operationMessage;
}
}
else
{
txtMensaje.Text = validateMessage;
}
}
private async void ButtonClickFunc(object obj)
{
if (IsRegistrering)
{
if (Usernames.Count == 0)
{
MessageBox.Show("Undersøger om username er ledig.\nHvis dette gentager sig, kan der mangle forbindelse til serveren");
return;
}
foreach (var names in Usernames)
{
if (Username == names.Trim())
{
MessageBox.Show("Username " + Username + " exists!");
return;
}
}
Userr newUser = new Userr();
newUser.UserName = username;
newUser.Password = password;
newUser.EmailAdress = email;
newUser.StudyID = study.StudyID;
newUser.StudentNumber = studyID;
newUser.UserTypeID = userTypeStandard.UserTypeID;
Userr responsUser = await Data.User.Add(newUser);
if (responsUser.UserID == 0)
{
MessageBox.Show("User unsuccefully registrede! Check the connection to the server,\nVikingNote will start up in anonymous mode");
}
MessageBox.Show("User succefully registrede! Welcome " + username + ", dit userID er " + responsUser.UserID + " du logges nu ind");
Data.LoginService.User = responsUser;
return;
}
Data.LoginService.VertifyLogin(username, password);
}
/**/
public string deleteDiagnosisWithoutDiagnosisIdData(Diagnosis diagnosis, Userr user)
{
string message = "";
try
{
//establecemos la conexion
SqlConnection connection = new SqlConnection(this.connectionString);
String sql = "";
sql = "sp_deleteDiagnosisWithoutDiagnosisId";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@date", diagnosis.date));
cmd.Parameters.Add(new SqlParameter("@hour", diagnosis.hour));
cmd.Parameters.Add(new SqlParameter("@identityCard", user.identityCard));
SqlDataReader reader;
connection.Open();
reader = cmd.ExecuteReader();
connection.Close();
message = "La operación se realizo adecuadamente";
}
catch (Exception ex)
{
message = "Error al ejecutar la operación en la base de datos";
}
return(message);
}
/**/
public string updateDiagnosisWithoutDiagnosisIdData(Diagnosis diagnosis, Userr user)
{
string message = "";
try
{
//establecemos la conexion
SqlConnection connection = new SqlConnection(this.connectionString);
String sql = "";
sql = "sp_updateDiagnosis";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@identityCard", user.identityCard));
cmd.Parameters.Add(new SqlParameter("@description", diagnosis.description));
cmd.Parameters.Add(new SqlParameter("@date", diagnosis.date));
cmd.Parameters.Add(new SqlParameter("@hour", diagnosis.hour));
SqlDataReader reader;
connection.Open();
reader = cmd.ExecuteReader();
connection.Close();
message = "La operación se realizo adecuadamente";
}
catch (Exception ex)
{
message = "Error al ejecutar la operación en la base de datos";
}
return(message);
}
public override void OnAuthorization(HttpActionContext actionContext)
{
if (actionContext.Request.Headers.Authorization == null)
{
actionContext.Response = actionContext.Request
.CreateResponse(HttpStatusCode.Unauthorized);
}
else
{
string authenticationToken = actionContext.Request.Headers.Authorization.ToString();
Userr user = UserSecurity.Authentication(authenticationToken);
if (user != null)
{
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity(user.UserName), null);
}
else
{
actionContext.Response = actionContext.Request
.CreateResponse(HttpStatusCode.Unauthorized);
}
}
}
protected void btnCancelar_Click(object sender, EventArgs e)
{
string date = txtActualDate.Text;
finalDate = date;
this.appointmentBusiness = new AppointmentBusiness(this.conn);
this.appo = new SalutemDomain.Appointment(Convert.ToInt32(txtActualHour.Text), finalDate);
this.user = new Userr(txtIdentityCard.Text);
//Se guarda un mensaje basado en la operación que se realizo
operationMessage = this.appointmentBusiness.cancelAppointmentWithoutAppointmentIdBusiness(this.appo, this.user);
//Se valida que la operación sea exitosa
if (operationMessage != "Error al ejecutar la operación en la base de datos")
{
txtMensaje.Text = "La operación se realizo satisfactoriamente";
}
else
{
txtMensaje.Text = operationMessage;
}
}
/// <summary>
///
/// </summary>
/// <param name="recipe"></param>
/// <param name="user"></param>
/// <returns></returns>
public string updateRecipeWithoutRecipeIdData(Recipe recipe, Userr user, string oldDate, int oldHour)
{
string message = "";
try
{
//establecemos la conexion
SqlConnection connection = new SqlConnection(this.connectionString);
String sql = "";
sql = "updateRecipeWithoutRecipeIdData";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@identityCard", user.identityCard));
cmd.Parameters.Add(new SqlParameter("@description", recipe.description));
cmd.Parameters.Add(new SqlParameter("@date", recipe.date));
cmd.Parameters.Add(new SqlParameter("@hour", recipe.hour));
cmd.Parameters.Add(new SqlParameter("@oldDate", oldDate));
cmd.Parameters.Add(new SqlParameter("@oldHour", oldHour));
SqlDataReader reader;
connection.Open();
reader = cmd.ExecuteReader();
connection.Close();
}
catch (Exception ex)
{
message = "Error al ejecutar la operación en la base de datos";
}
return(message);
}
protected void btnUpdateDiagnosis_Click(object sender, EventArgs e)
{
string date = clDiagnosticDate.SelectedDate.ToShortDateString();
string[] dateArray = date.Split(' ');
string[] formatDate = dateArray[0].Split('/');
finalDate = formatDate[2] + "-" + formatDate[0] + "-" + formatDate[1];
//Se valida la fecha
validateMessage = validateDate(finalDate, Convert.ToInt32(txtHour.Text));
if (validateMessage == "Disponible")
{
this.diagnosisBusiness = new DiagnosisBusiness(this.conn);
this.diagnosis = new SalutemDomain.Diagnosis(txtDescripcion.Text, finalDate, Convert.ToInt32(txtHour.Text));
this.user = new Userr(txtNumCedula.Text);
//Se guarda un mensaje basado en la operación que se realizo
operationMessage = this.diagnosisBusiness.updateDiagnosisWithoutDiagnosisIdBusiness(this.diagnosis, this.user, txtOldDate.Text, txtOldHour.Text);
//Se valida que la operación sea exitosa
if (operationMessage != "Error al ejecutar la operación en la base de datos")
{
txtMensaje.Text = "La operación se realizo satisfactoriamente";
}
else
{
txtMensaje.Text = operationMessage;
}
}
else
{
txtMensaje.Text = validateMessage;
}
}
public UserLoggedInEventArg(ILoginService sef, Userr user)
{
self = sef;
User = user;
}
public FilesPage(Window win, Userr us)
{
InitializeComponent();
window = win;
user = us;
}
public static void RegisterUser(Userr user)
{
UserRepository.Insert(user);
}
public string cancelAppointmentWithoutAppointmentIdBusiness(Appointment appointment, Userr user)
{
string message = "";
message = appointmentData.cancelAppointmentWithoutAppointmentIdData(appointment, user);
return(message);
}
public static Userr FindByEmail(string Email)
{
Userr u = context.Userrs.Where(x => x.Email.Equals(Email)).FirstOrDefault();
return((u != null) ? u : null);
}
public bool Login(Userr userlogin)
{
}
public long Insert(Userr entity)
{
db.Userrs.Add(entity);
db.SaveChanges();
return(entity.id);
}
public Userr GetUser(string username)
{
Userr getuser = db.Userrs.SingleOrDefault(x => x.name == username);
return(getuser);
}
public static void Insert(Userr user)
{
context.Userrs.Add(user);
context.SaveChanges();
}
public static void Create(Userr user)
{
context.Userrs.Add(user);
context.SaveChanges();
}
public static bool IsRegistedUser(string Email)
{
Userr u = UserRepository.FindByEmail(Email);
return((u == null) ? false : true);
}
public async void testAddUpdateRemove()
{
AnswerQuizQuestionViewModel TestModel = new AnswerQuizQuestionViewModel(testQuiz)
{
};
Assert.That(TestModel.SelectedQuiz.QuizID, Is.EqualTo(2)); // Sikre rigtige bruger
Userr testUser = new Userr()
{
UserID = 999,
UserName = "******",
Password = "******",
EmailAdress = "*****@*****.**",
StudentNumber = "1337",
Salt = "No scooped by a 9 year old"
};
await data.User.Add(testUser); //Gemmer bruger
Userr resultUser = await data.User.GetAsync(999); //henter Quiz med ID 2
Assert.That(resultUser.UserID, Is.EqualTo(999));
Assert.That(resultUser.UserName, Is.EqualTo("Test Bruger"));
Assert.That(resultUser.Password, Is.EqualTo("1337M4CH1N3"));
Assert.That(resultUser.EmailAdress, Is.EqualTo("*****@*****.**"));
Assert.That(resultUser.StudentNumber, Is.EqualTo("1337"));
Assert.That(resultUser.Salt, Is.EqualTo("No scooped by a 9 year old"));
//update testes her
Userr testChangedUser = new Userr()
{
UserID = 999,
UserName = "******",
Password = "******",
EmailAdress = "*****@*****.**",
StudentNumber = "13375",
Salt = "No scooped by a 8 year old"
};
await data.User.Update(999, testChangedUser); //ændre quizzen
Userr assertUser = await data.User.GetAsync(999); //henter den ændrede Quiz
Assert.That(assertUser.UserID, Is.EqualTo(999));
Assert.That(assertUser.UserName, Is.EqualTo("Test Bruger1"));
Assert.That(assertUser.Password, Is.EqualTo("1337M4CH1N35"));
Assert.That(assertUser.EmailAdress, Is.EqualTo("*****@*****.**"));
Assert.That(assertUser.StudentNumber, Is.EqualTo("13375"));
Assert.That(assertUser.Salt, Is.EqualTo("No scooped by a 8 year old"));
//delete testes her
List <Userr> resultList = new List <Userr>();
resultList = await data.User.GetAllAsync();
int currentSize = resultList.Count;
data.User.Remove(999);
resultList = await data.User.GetAllAsync();
Assert.That(resultList.Count, Is.EqualTo(currentSize - 1));
}
public void UpdateProfile(Userr user)
{
UserRepository.UpdateProfile(user);
}
public LoginService(IUnitOfWork data)
{
Data = data;
user = new Userr();
}
