public IActionResult MessageSave() { var message = Request.Form["messageToSend"]; int userIdFrom = Convert.ToInt32(Request.Form["userIdFrom"]); int userIdTo = Convert.ToInt32(Request.Form["userIdTo"]); if (message != string.Empty && userIdFrom != 0 && userIdTo != 0) { SqlConnection sqlConnection1 = new SqlConnection(context.GetDataBaseConectionString()); SqlCommand cmd = new SqlCommand(); string query = $"insert into Message values({userIdFrom}, '{message}', {userIdTo})"; cmd.CommandText = query; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConnection1; cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } return(PartialMessageView(new String[] { userIdTo.ToString() })); }
/// <summary> /// Inserta en la base de datos la hora actual de logueado /// </summary> public void NewUserLogin(int userId) { SqlConnection sqlConnection1 = new SqlConnection(context.GetDataBaseConectionString()); SqlCommand cmd = new SqlCommand(); string actualTime = DateTime.Now.ToString(); string query = "INSERT into LoginTime (UserID,Time) " + " VALUES (" + userId + ", '" + actualTime + "')"; cmd.CommandText = query; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConnection1; cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
/// <summary> /// Devuelve la información para generar una gráfica sobre las estadísticas de las máquinas del último año /// </summary> /// <returns></returns> public IActionResult PartialMachineStats(string arrayofvalues) { //Se almacena el id de la máquina seleccionada itemSelected = arrayofvalues; if (dateInfo == null) { dateInfo = new HashSet <DateTime>(); } if (dateInfo.Count > 0) { dateInfo.Clear(); } SqlConnection sqlConnection1 = new SqlConnection(context.GetDataBaseConectionString()); SqlCommand cmd = new SqlCommand(); SqlDataReader reader = null; DateTime currentDate = DateTime.Now; var currentYear = currentDate.Year; string query = $"select date from solded where IdMachine = {arrayofvalues} and Date >= '{currentYear}' "; cmd.CommandText = query; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConnection1; cmd.Connection.Open(); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dateInfo.Add((DateTime)reader["Date"]); } } cmd.Connection.Close(); return(RedirectToAction("MachineStats")); }