/**/ 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(); }