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