private void Carrega()
{
DateTime data = DateTime.Now;
var vmes = data.ToString("MM");
int mes = int.Parse(vmes);
var vano = data.ToString("yyyy");
int ano = int.Parse(vano);
//PRIMEIRO PEGA O PRIMEIRO E O ULTIMO DIA DO MES
//DateTime com o primeiro dia do mês
DateTime primeiroDiaDoMes = new DateTime(data.Year, data.Month, 1);
var dtinicial = primeiroDiaDoMes.ToString("dd/MM/yyyy");
//DateTime com o último dia do mês
DateTime ultimoDiaDoMes = new DateTime(data.Year, data.Month, DateTime.DaysInMonth(data.Year, data.Month));
var dtfinal = ultimoDiaDoMes.ToString("dd/MM/yyyy");
var UltimoDia = ultimoDiaDoMes.ToString("dd");
//define um array de strings com nCOlunas
string[] linhaDados = new string[5];
//LIMPAR GRID
Grid.Rows.Clear();
Grid.Refresh();
MySql.Data.MySqlClient.MySqlDataReader dr = null;
if (Parametros.Pesq == "Devolve")
{
dr = Classes.Mysql.Pedido.PesqSaidaOficio("FECHADO", int.Parse(Usuario.Coddepartamento.ToString()), 1, 1);
}
else
{
dr = Classes.Mysql.Pedido.PesqSaidaOficio(int.Parse(Usuario.Coddepartamento.ToString()));
}
if (dr.HasRows)
{
while (dr.Read())
{
linhaDados[0] = dr.GetString(dr.GetOrdinal("NUMEROPEDIDO"));
linhaDados[1] = dr.GetString(dr.GetOrdinal("DATAPEDIDO"));
linhaDados[2] = dr.GetString(dr.GetOrdinal("CODUNIDADE"));
linhaDados[3] = dr.GetString(dr.GetOrdinal("UNIDADE"));
linhaDados[4] = dr.GetString(dr.GetOrdinal("CODPEDIDO"));
Grid.Rows.Add(linhaDados);
}
}
dr.Close();
dr.Dispose();
}
protected System.Data.DataTable parseResults(MySql.Data.MySqlClient.MySqlDataReader reader)
{
System.Data.DataTable results = new System.Data.DataTable();
try
{
if (reader.HasRows)
{
for (int i = 0; i < reader.FieldCount; i++)
{
System.Data.DataColumn col = new System.Data.DataColumn(reader.GetName(i), typeof(String));
results.Columns.Add(col);
}
}
while (reader.HasRows && reader.Read())
{
System.Data.DataRow row = results.NewRow();
for (int i = 0; i < reader.FieldCount; i++)
{
row[reader.GetName(i)] = reader[i];
}
results.Rows.Add(row);
}
}
catch (Exception ex)
{
}
finally
{
if (reader != null)
{
try
{
reader.Close();
}
finally
{
reader.Dispose();
}
}
}
return(results);
}
public List <softTime_info> findsoftTime(string findtext)
{
// findtext = sqlAddPCID(findtext);
MySql.Data.MySqlClient.MySqlDataReader reader = NewMySqlHelper.ExecuteReader(findtext);
List <softTime_info> ClaimReport_Server = new List <softTime_info>();
while (reader.Read())
{
softTime_info item = new softTime_info();
if (reader.GetValue(0) != null && Convert.ToString(reader.GetValue(0)) != "")
{
item._id = Convert.ToString(reader.GetValue(0));
}
if (reader.GetValue(1) != null && Convert.ToString(reader.GetValue(1)) != "")
{
item.name = reader.GetString(1);
}
if (reader.GetValue(2) != null && Convert.ToString(reader.GetValue(2)) != "")
{
item.starttime = reader.GetString(2);
}
if (reader.GetValue(3) != null && Convert.ToString(reader.GetValue(3)) != "")
{
item.endtime = reader.GetString(3);
}
if (reader.GetValue(4) != null && Convert.ToString(reader.GetValue(4)) != "")
{
item.soft_name = reader.GetString(4);
}
if (reader.GetValue(5) != null && Convert.ToString(reader.GetValue(5)) != "")
{
item.denglushijian = reader.GetString(5);
}
if (reader.GetValue(6) != null && Convert.ToString(reader.GetValue(6)) != "")
{
item.password = reader.GetString(6);
}
if (reader.GetValue(7) != null && Convert.ToString(reader.GetValue(7)) != "")
{
item.pid = reader.GetString(7);
}
if (reader.GetValue(8) != null && Convert.ToString(reader.GetValue(8)) != "")
{
item.mark1 = reader.GetString(8);
}
if (reader.GetValue(9) != null && Convert.ToString(reader.GetValue(9)) != "")
{
item.mark2 = reader.GetString(9);
}
if (reader.GetValue(10) != null && Convert.ToString(reader.GetValue(10)) != "")
{
item.mark3 = reader.GetString(10);
}
if (reader.GetValue(11) != null && Convert.ToString(reader.GetValue(11)) != "")
{
item.mark4 = reader.GetString(11);
}
if (reader.GetValue(12) != null && Convert.ToString(reader.GetValue(12)) != "")
{
item.mark5 = reader.GetString(12);
}
ClaimReport_Server.Add(item);
//这里做数据处理....
}
reader.Dispose();
reader.Close();
// cmd.Dispose();
return(ClaimReport_Server);
}
public void TeselarData()
{
try
{
if (AbrirConexion())
{
lock (this)
{
string sSql = "";
try
{
sSql = "SELECT DISTINCT ip FROM `00equipos`;";
MySql.Data.MySqlClient.MySqlCommand MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySql.Data.MySqlClient.MySqlDataReader MyReaderEquipos = MySQLComm.ExecuteReader();
IList <string> Equipos = new List <string>();
if (MyReaderEquipos.HasRows)
{
while (MyReaderEquipos.Read())
{
if (!MyReaderEquipos.IsDBNull(0))
{
Equipos.Add(MyReaderEquipos.GetString("ip"));
}
}
}
MyReaderEquipos.Close();
MyReaderEquipos.Dispose();
foreach (string Eq in Equipos)
{
//Solo calcula los datos a día pasado
sSql = "SELECT COUNT(equipo) AS Registros FROM `02diario` WHERE (fecha = '" + DateTime.Now.Date.AddDays(-1.0).AddHours(12.0).ToString("yyyy-MM-dd HH:mm:ss") + "') AND (equipo = '" + Eq + "')";
MySQLComm =
new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
if (MySQLComm.ExecuteScalar().ToString() == "0")
{
//Selecciona los datos diarios
//De cada dispositivo
sSql = "SELECT fecha, temperatura, humedad, co, consumo FROM `01input` WHERE (equipo = '" + Eq + "') AND (fecha BETWEEN '" + DateTime.Now.Date.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss") + "' AND '" + DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss") + "')";
MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySql.Data.MySqlClient.MySqlDataReader MyReaderDiario = MySQLComm.ExecuteReader();
IList <Lectura> Lecturas = new List <Lectura>();
if (MyReaderDiario.HasRows)
{
while (MyReaderDiario.Read())
{
Lecturas.Add(new Lectura(MyReaderDiario.GetDateTime("fecha"),
"",
MyReaderDiario.GetDouble("temperatura"),
MyReaderDiario.GetDouble("humedad"),
MyReaderDiario.GetDouble("co"),
MyReaderDiario.GetDouble("consumo")));
}
}
MyReaderDiario.Close();
MyReaderDiario.Dispose();
//Genera el resumen diario
if (Lecturas.Count > 0)
{
Lectura LecturaDiaria = new Lectura(DateTime.Now.Date.AddDays(-1.0).AddHours(12.0),
Eq,
Lecturas.Select(L => L.Temperatura).Average(),
Lecturas.Select(L => L.Humedad).Average(),
Lecturas.Select(L => L.CO).Average(),
Lecturas.Select(L => L.Consumo).Average());
sSql = string.Format("INSERT" + "\n" +
"INTO {0} ({1}, {3}, {5}, {7}, {9}, {11})" + "\n" +
"VALUES('{2}', '{4}', {6}, {8}, {10}, {12});",
"`02diario`",
"fecha", LecturaDiaria.Fecha.ToString("yyyy-MM-dd HH:mm:ss"),
"equipo", LecturaDiaria.IpEquipo,
"temperatura", LecturaDiaria.Temperatura.ToString("0.00").Replace(',', '.'),
"humedad", LecturaDiaria.Humedad.ToString("0.00").Replace(',', '.'),
"co", LecturaDiaria.CO.ToString("0.0000").Replace(',', '.'),
"consumo", LecturaDiaria.Consumo.ToString("0.00").Replace(',', '.'));
MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySQLComm.ExecuteNonQuery();
}
}
//Solo calcula los datos a mes pasado
DateTime mespasado = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(-1);
sSql = "SELECT COUNT(equipo) AS Registros FROM `03mensual` WHERE (fecha = '" + mespasado.AddDays(14.0).AddHours(12.0).ToString("yyyy-MM-dd HH:mm:ss") + "') AND (equipo = '" + Eq + "')";
MySQLComm =
new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
if (MySQLComm.ExecuteScalar().ToString() == "0")
{
//Selecciona los datos diarios
//De cada dispositivo
sSql = "SELECT fecha, temperatura, humedad, co, consumo FROM `02diario` WHERE (equipo = '" + Eq + "') AND (fecha BETWEEN '" + mespasado.ToString("yyyy-MM-dd HH:mm:ss") + "' AND '" + mespasado.AddMonths(1).ToString("yyyy-MM-dd HH:mm:ss") + "');";
MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySql.Data.MySqlClient.MySqlDataReader MyReaderMensual = MySQLComm.ExecuteReader();
IList <Lectura> Lecturas = new List <Lectura>();
if (MyReaderMensual.HasRows)
{
while (MyReaderMensual.Read())
{
Lecturas.Add(new Lectura(MyReaderMensual.GetDateTime("fecha"),
"",
MyReaderMensual.GetDouble("temperatura"),
MyReaderMensual.GetDouble("humedad"),
MyReaderMensual.GetDouble("co"),
MyReaderMensual.GetDouble("consumo")));
}
}
MyReaderMensual.Close();
MyReaderMensual.Dispose();
//Genera el resumen diario
if (Lecturas.Count > 0)
{
Lectura LecturaDiaria = new Lectura(mespasado.AddDays(14.0).AddHours(12.0),
Eq,
Lecturas.Select(L => L.Temperatura).Average(),
Lecturas.Select(L => L.Humedad).Average(),
Lecturas.Select(L => L.CO).Average(),
Lecturas.Select(L => L.Consumo).Average());
sSql = string.Format("INSERT INTO {0} ({1}, {3}, {5}, {7}, {9}, {11})" + "\n" +
"VALUES('{2}', '{4}', {6}, {8}, {10}, {12})",
"`03mensual`",
"fecha", LecturaDiaria.Fecha.ToString("yyyy-MM-dd HH:mm:ss"),
"equipo", LecturaDiaria.IpEquipo,
"temperatura", LecturaDiaria.Temperatura.ToString("0.00").Replace(',', '.'),
"humedad", LecturaDiaria.Humedad.ToString("0.00").Replace(',', '.'),
"co", LecturaDiaria.CO.ToString("0.0000").Replace(',', '.'),
"consumo", LecturaDiaria.Consumo.ToString("0.00").Replace(',', '.'));
MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySQLComm.ExecuteNonQuery();
}
}
}
}
catch (MySql.Data.MySqlClient.MySqlException MyEx)
{
ErrLogger.LogError(MyEx.ToString() + "\n" + sSql, System.Diagnostics.EventLogEntryType.Error);
}
}
}
else
{
ErrLogger.LogError("Sin conexión con SQLServer.", System.Diagnostics.EventLogEntryType.Error);
}
}
catch (System.Data.SqlClient.SqlException SqlEx)
{
ErrLogger.LogError(SqlEx.ToString(), System.Diagnostics.EventLogEntryType.Error);
}
catch (Exception Ex)
{
ErrLogger.LogError(Ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
}
}
public bool SetData(string CadenaLectura)
{
try
{
if (AbrirConexion())
{
Lectura RecLectura = new Lectura(CadenaLectura);
bool Res = false;
lock (this)
{
string sSql = "";
try
{
sSql = "SELECT ip FROM `00equipos` WHERE (ip = '" + RecLectura.IpEquipo + "')";
MySql.Data.MySqlClient.MySqlCommand MySQLComm =
new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySql.Data.MySqlClient.MySqlDataReader DR1 = MySQLComm.ExecuteReader();
bool hasRows = DR1.HasRows;
DR1.Close();
DR1.Dispose();
if (!hasRows)
{
sSql = "INSERT INTO `00equipos` (ip, nombre) VALUES('" + RecLectura.IpEquipo + "', 'Pendiente de Nombre');";
//no existe el equipo
MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySQLComm.ExecuteNonQuery();
}
sSql = string.Format("INSERT" + "\n" +
"INTO {0} ({1}, {3}, {5}, {7}, {9}, {11})" + "\n" +
"VALUES('{2}', '{4}', {6}, {8}, {10}, {12});",
"`01input`",
"fecha", RecLectura.Fecha.ToString("yyyy-MM-dd HH:mm:ss"),
"equipo", RecLectura.IpEquipo,
"temperatura", RecLectura.Temperatura.ToString("0.00").Replace(',', '.'),
"humedad", RecLectura.Humedad.ToString("0.00").Replace(',', '.'),
"co", RecLectura.CO.ToString("0.0000").Replace(',', '.'),
"consumo", RecLectura.Consumo.ToString("0.00").Replace(',', '.'));
//TODO: UPDATE en 00current para la última lectura
MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySQLComm.ExecuteNonQuery();
sSql = string.Format("INSERT INTO {0} ({1}, {3}, {5}, {7}, {9}, {11})" + "\n" +
"VALUES('{2}', '{4}', {6}, {8}, {10}, {12})" + "\n" +
"ON DUPLICATE KEY" + "\n" +
"UPDATE {1}='{2}', {5}={6}, {7}={8}, {9}={10}, {11}={12}",
"`00current`",
"fecha", RecLectura.Fecha.ToString("yyyy-MM-dd HH:mm:ss"),
"equipo", RecLectura.IpEquipo,
"temperatura", RecLectura.Temperatura.ToString("0.00").Replace(',', '.'),
"humedad", RecLectura.Humedad.ToString("0.00").Replace(',', '.'),
"co", RecLectura.CO.ToString("0.0000").Replace(',', '.'),
"consumo", RecLectura.Consumo.ToString("0.00").Replace(',', '.'));
MySQLComm = new MySql.Data.MySqlClient.MySqlCommand(sSql, MySQLConn);
MySQLComm.ExecuteNonQuery();
Res = true;
}
catch (MySql.Data.MySqlClient.MySqlException MyEx)
{
ErrLogger.LogError(MyEx.ToString() + "\n" + sSql, System.Diagnostics.EventLogEntryType.Error);
Res = false;
}
}
return(Res);
}
else
{
ErrLogger.LogError("Sin conexión con SQLServer.", System.Diagnostics.EventLogEntryType.Error);
return(false);
}
}
catch (System.Data.SqlClient.SqlException SqlEx)
{
ErrLogger.LogError(SqlEx.ToString(), System.Diagnostics.EventLogEntryType.Error);
return(false);
}
catch (Exception Ex)
{
ErrLogger.LogError(Ex.ToString(), System.Diagnostics.EventLogEntryType.Error);
return(false);
}
}
public DashboardJson(int ID_UTILIZATOR, int ID_SOCIETATE, string conStr)
{
DataAccess da = new DataAccess(ID_UTILIZATOR, conStr, System.Data.CommandType.StoredProcedure, "DASHBOARDsp_select", new object[] { new MySql.Data.MySqlClient.MySqlParameter("_ID_SOCIETATE", ID_SOCIETATE), new MySql.Data.MySqlClient.MySqlParameter("_EXPIRATION_DAYS", 15) }); // TO DO: de adaugat parametru in setari !!!
MySql.Data.MySqlClient.MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
System.Data.IDataRecord dj = (System.Data.IDataRecord)r;
try { this.DOSARE_TOTAL = Convert.ToInt32(dj["DOSARE_TOTAL"]); }
catch { }
try { this.DOSARE_CASCO_TOTAL = Convert.ToInt32(dj["DOSARE_CASCO_TOTAL"]); }
catch { }
try { this.DOSARE_RCA_TOTAL = Convert.ToInt32(dj["DOSARE_RCA_TOTAL"]); }
catch { }
// -- doar pt. Admin si Super --
try { this.DOSARE_NEASIGNATE = Convert.ToInt32(dj["DOSARE_NEASIGNATE"]); }
catch { }
try { this.DOSARE_CASCO_NEASIGNATE = Convert.ToInt32(dj["DOSARE_CASCO_NEASIGNATE"]); }
catch { }
try { this.DOSARE_RCA_NEASIGNATE = Convert.ToInt32(dj["DOSARE_RCA_NEASIGNATE"]); }
catch { }
try { this.DOSARE_NEASIGNATE_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_NEASIGNATE_FROM_LAST_LOGIN"]); }
catch { }
try { this.DOSARE_NEASIGNATE_CASCO_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_NEASIGNATE_CASCO_FROM_LAST_LOGIN"]); }
catch { }
try { this.DOSARE_NEASIGNATE_RCA_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_NEASIGNATE_RCA_FROM_LAST_LOGIN"]); }
catch { }
// -- pt. All --
try { this.DOSARE_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_FROM_LAST_LOGIN"]); }
catch { }
try { this.DOSARE_CASCO_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_CASCO_FROM_LAST_LOGIN"]); }
catch { }
try { this.DOSARE_RCA_FROM_LAST_LOGIN = Convert.ToInt32(dj["DOSARE_RCA_FROM_LAST_LOGIN"]); }
catch { }
try { this.DOSARE_NEOPERATE = Convert.ToInt32(dj["DOSARE_NEOPERATE"]); }
catch { this.DOSARE_NEOPERATE = 0; }
try { this.DOSARE_CASCO_NEOPERATE = Convert.ToInt32(dj["DOSARE_CASCO_NEOPERATE"]); }
catch { this.DOSARE_CASCO_NEOPERATE = 0; }
try { this.DOSARE_RCA_NEOPERATE = Convert.ToInt32(dj["DOSARE_RCA_NEOPERATE"]); }
catch { this.DOSARE_RCA_NEOPERATE = 0; }
try { this.PROCESE_TOTAL = Convert.ToInt32(dj["PROCESE_TOTAL"]); }
catch { this.PROCESE_TOTAL = 0; }
try { this.PROCESE_RECLAMANT_TOTAL = Convert.ToInt32(dj["PROCESE_RECLAMANT_TOTAL"]); }
catch { this.PROCESE_RECLAMANT_TOTAL = 0; }
try { this.PROCESE_PARAT_TOTAL = Convert.ToInt32(dj["PROCESE_PARAT_TOTAL"]); }
catch { this.PROCESE_PARAT_TOTAL = 0; }
try { this.PROCESE_NOI_TOTAL = Convert.ToInt32(dj["PROCESE_NOI_TOTAL"]); }
catch { this.PROCESE_NOI_TOTAL = 0; }
/* -- PT. STATUS DOSARE -- */
try { this.DOSARE_INCOMPLETE = Convert.ToInt32(dj["DOSARE_INCOMPLETE"]); }
catch { this.DOSARE_INCOMPLETE = 0; }
try { this.DOSARE_NEAVIZATE = Convert.ToInt32(dj["DOSARE_NEAVIZATE"]); }
catch { this.DOSARE_NEAVIZATE = 0; }
try { this.DOSARE_AVIZATE = Convert.ToInt32(dj["DOSARE_AVIZATE"]); }
catch { this.DOSARE_AVIZATE = 0; }
try { this.DOSARE_AVIZATE_NEEXPEDIATE = Convert.ToInt32(dj["DOSARE_AVIZATE_NEEXPEDIATE"]); }
catch { this.DOSARE_AVIZATE_NEEXPEDIATE = 0; }
try { this.DOSARE_NEACHITATE = Convert.ToInt32(dj["DOSARE_NEACHITATE"]); }
catch { this.DOSARE_NEACHITATE = 0; }
try { this.DOSARE_ACHITATE_PARTIAL = Convert.ToInt32(dj["DOSARE_ACHITATE_PARTIAL"]); }
catch { this.DOSARE_ACHITATE_PARTIAL = 0; }
try { this.DOSARE_ACHITATE = Convert.ToInt32(dj["DOSARE_ACHITATE"]); }
catch { this.DOSARE_ACHITATE = 0; }
try { this.DOSARE_AVIZATE_TOTAL = DOSARE_AVIZATE + DOSARE_NEACHITATE + DOSARE_ACHITATE_PARTIAL + DOSARE_ACHITATE; }
catch { this.DOSARE_AVIZATE_TOTAL = 0; }
try { this.DOSARE_FARA_DOCUMENTE = Convert.ToInt32(dj["DOSARE_FARA_DOCUMENTE"]); }
catch { this.DOSARE_FARA_DOCUMENTE = 0; }
try { this.DOSARE_FARA_PROCES = Convert.ToInt32(dj["DOSARE_FARA_PROCES"]); }
catch { this.DOSARE_FARA_PROCES = 0; }
/* --- */
/* -- PENTRU TERMENE -- */
try { this.TERMENE_IN_URMATOARELE_7_ZILE = Convert.ToInt32(dj["TERMENE_IN_URMATOARELE_7_ZILE"]); }
catch { this.TERMENE_IN_URMATOARELE_7_ZILE = 0; }
try { this.TERMENE_DEPASITE = Convert.ToInt32(dj["TERMENE_DEPASITE"]); }
catch { this.TERMENE_DEPASITE = 0; }
/* --- */
/* -- PENTRU MESAJE -- */
try { this.MESAJE_NOI = Convert.ToInt32(dj["MESAJE_NOI"]); }
catch { }
try { this.MESAJE_NOI_DOSAR_NOU = Convert.ToInt32(dj["MESAJE_NOI_DOSAR_NOU"]); }
catch { }
try { this.MESAJE_NOI_DOCUMENT_NOU = Convert.ToInt32(dj["MESAJE_NOI_DOCUMENT_NOU"]); }
catch { }
/* --- */
break;
}
LABELS_STATUS = new List <string>()
{
socisaV2.Resources.DashboardResx.DOSARE_INCOMPLETE,
socisaV2.Resources.DashboardResx.DOSARE_NEOPERATE,
socisaV2.Resources.DashboardResx.DOSARE_AVIZATE_TOTAL
};
LABELS_STATUS_AVIZATE = new List <string>()
{
socisaV2.Resources.DashboardResx.DOSARE_AVIZATE,
socisaV2.Resources.DashboardResx.DOSARE_NEACHITATE,
socisaV2.Resources.DashboardResx.DOSARE_ACHITATE_PARTIAL,
socisaV2.Resources.DashboardResx.DOSARE_ACHITATE
};
VALUES_STATUS = new List <int>()
{
DOSARE_INCOMPLETE,
DOSARE_NEAVIZATE,
DOSARE_AVIZATE_TOTAL
};
VALUES_STATUS_AVIZATE = new List <int>()
{
DOSARE_AVIZATE,
DOSARE_NEACHITATE,
DOSARE_ACHITATE_PARTIAL,
DOSARE_ACHITATE
};
r.Close(); r.Dispose(); da.CloseConnection();
}
public String LocalSetupGet(my.MySqlClient.MySqlConnection conn)
{
string strQuery = String.Empty;
strQuery = string.Format("SELECT username, domain, ipaddress, computer_name, process_name, process_path, process_starttime, processid, process_description, process_exittime, version, productname, companyname, semester, process_path_commandline, sid, fullname, department, role, idactivity FROM app_performance.activity WHERE process_exittime BETWEEN '2016-10-06 11:00:30' AND '2016-11-09 20:21:30'");
my.MySqlClient.MySqlCommand cmd = new my.MySqlClient.MySqlCommand(strQuery, conn);
my.MySqlClient.MySqlDataReader myReader = null;
try
{
myReader = cmd.ExecuteReader();
int n = 0;
try {
System.IO.Directory.CreateDirectory(@"C:\bithubReports");
} catch (Exception ex) {
return(ex.Message.ToString());
}
//var filepath = @"C:\bithubReports\report.txt";
var csv = new System.Text.StringBuilder();
while (myReader.Read())
{
HttpContext.Current.Response.Write(myReader.GetString(0) + "\n");
string result = "";
string name, domain, ip, cpu, proc, procPath, procStart, procID, procDesc, procExit, v, pName, cName, sem, ppcl, sid, fName, dep, role, id;
if (myReader.IsDBNull(0))
{
name = " ";
}
else
{
name = String.Format("{0}", myReader.GetString(0));
}
if (myReader.IsDBNull(1))
{
domain = " ";
}
else
{
domain = String.Format("{0}", myReader.GetString(1));
}
if (myReader.IsDBNull(2))
{
ip = " ";
}
else
{
ip = String.Format("{0}", myReader.GetString(2));
}
if (myReader.IsDBNull(3))
{
cpu = " ";
}
else
{
cpu = String.Format("{0}", myReader.GetString(3));
}
if (myReader.IsDBNull(4))
{
proc = " ";
}
else
{
proc = String.Format("{0}", myReader.GetString(4));
}
if (myReader.IsDBNull(5))
{
procPath = " ";
}
else
{
procPath = String.Format("{0}", myReader.GetString(5));
}
if (myReader.IsDBNull(6))
{
procStart = " ";
}
else
{
procStart = String.Format("{0}", myReader.GetDateTime(6));
}
if (myReader.IsDBNull(7))
{
procID = " ";
}
else
{
procID = String.Format("{0}", myReader.GetInt64(7));
}
if (myReader.IsDBNull(8))
{
procDesc = " ";
}
else
{
procDesc = String.Format("{0}", myReader.GetString(8));
}
if (myReader.IsDBNull(9))
{
procExit = " ";
}
else
{
procExit = String.Format("{0}", myReader.GetDateTime(9));
}
if (myReader.IsDBNull(10))
{
v = " ";
}
else
{
v = String.Format("{0}", myReader.GetString(10));
}
if (myReader.IsDBNull(11))
{
pName = " ";
}
else
{
pName = String.Format("{0}", myReader.GetString(11));
}
if (myReader.IsDBNull(12))
{
cName = " ";
}
else
{
cName = String.Format("{0}", myReader.GetString(12));
}
if (myReader.IsDBNull(13))
{
sem = " ";
}
else
{
sem = String.Format("{0}", myReader.GetString(13));
}
if (myReader.IsDBNull(14))
{
ppcl = " ";
}
else
{
ppcl = String.Format("{0}", myReader.GetString(14));
}
if (myReader.IsDBNull(15))
{
sid = " ";
}
else
{
sid = String.Format("{0}", myReader.GetString(15));
}
if (myReader.IsDBNull(16))
{
fName = " ";
}
else
{
fName = String.Format("{0}", myReader.GetString(16));
}
if (myReader.IsDBNull(17))
{
dep = " ";
}
else
{
dep = String.Format("{0}", myReader.GetString(17));
}
if (myReader.IsDBNull(18))
{
role = " ";
}
else
{
role = String.Format("{0}", myReader.GetString(18));
}
if (myReader.IsDBNull(19))
{
id = " ";
}
else
{
id = String.Format("{0}", myReader.GetString(19));
}
result = name + "," + domain + "," + ip + "," + cpu + "," + proc + "," + procPath + "," + procStart + "," + procID + "," + procDesc + "," + procExit + "," + v + "," + pName + "," + cName + "," + sem + "," + ppcl + "," + sid + "," + fName + "," + dep + "," + role + "," + id;
string line = result;
try{
csv.AppendLine(line);
} catch (Exception ex) {
return(ex.Message.ToString());
}
n = 0;
}
try{
System.IO.File.WriteAllText(filepath, csv.ToString());
} catch (Exception ex) {
return(ex.Message.ToString());
}
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
try
{
String email = "*****@*****.**";
send_email(email);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
if (myReader != null)
{
if (myReader.IsClosed == false)
{
myReader.Close();
myReader.Dispose();
}
}
if (conn != null)
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
HttpContext.Current.Response.Write("Success");
return("Success");
}
public ActionResult TokenLogin(string _url, string _token)
{
//string Token = HttpContext.Request.Params["URL"].ToString().Substring(HttpContext.Request.Params["URL"].ToString().LastIndexOf('/') + 1);
if (!String.IsNullOrWhiteSpace(_token) && _token.IndexOf('|') > -1)
{
if (Session["CURENT_USER_ID"] != null && Session["ID_SOCIETATE"] != null) // s-a mai accesat odata linkul (de exemplu pt. email si pt. printare documente
{
HttpContext.Session["TOKEN"] = _token;
return(Redirect(String.Format("{0}{1}", HttpUtility.UrlDecode(_url), _token)));
}
else // aici trebuie sa trimitem cod pe email
{
if (TempData["TOKEN"] == null || String.IsNullOrWhiteSpace(TempData["TOKEN"].ToString()))
{
string conStr = HttpContext.Server.MapPath("~").ToLower().IndexOf("test") > 0 ? CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySQLConnectionString_test"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()) : CommonFunctions.StringCipher.Decrypt(ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ConnectionString, CommonFunctions.StringCipher.RetrieveKey()); // separam socisa de socisa_test
Utilizator u = null;
MySql.Data.MySqlClient.MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection(conStr);
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "UTILIZATORIsp_GetByUserName";
cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("_USER_NAME", "email"));
con.Open();
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (r.Read())
{
int authenticatedUserId = Convert.ToInt32(r["ID"]);
u = new Utilizator(Convert.ToInt32(authenticatedUserId), conStr, r);
break;
}
r.Close(); r.Dispose();
if (con != null && con.State == System.Data.ConnectionState.Open)
{
con.Close();
con.Dispose();
}
if (u == null)
{
TempData.Clear();
return(Redirect("~"));
}
else
{
TempData["TOKEN"] = _token;
TempData["URL"] = _url;
string[] separator = { "|" };
string[] token = _token.Split(separator, StringSplitOptions.RemoveEmptyEntries);
string md5p = token[0];
int id = Convert.ToInt32(token[1]);
Dosar d = new Dosar(Convert.ToInt32(u.ID), conStr, id);
MD5 md5h = MD5.Create();
if (!CommonFunctions.VerifyMd5Hash(md5h, d.NR_DOSAR_CASCO, md5p))
{
TempData.Clear();
return(Redirect("~"));
}
else
{
if (Convert.ToBoolean(ConfigurationManager.AppSettings["UseDoubleAutentificationForEmail"]))
{
SocietateAsigurare sa = (SocietateAsigurare)d.GetSocietateRca().Result;
TempData["tempLogin"] = u;
//string rnd = "1234"; // pt. test
Random generator = new Random();
string rnd = generator.Next(0, 1000000).ToString("D6");
SendVerificationCode(EmailProfiles.AwsCereriSES, sa.EMAIL_NOTIFICARI, rnd);
TempData["verificationCode"] = rnd;
TempData["verificationCodeIssueTime"] = DateTime.Now;
return(View("TokenLogin", new LoginJson()));
//return RedirectToAction("TokenLogin", "Utilizatori");
}
else
{
return(InternalTokenLogin(_token, _url, u));
}
}
}
}
else
{
TempData.Clear();
return(Redirect("~"));
}
}
}
else
{
return(Redirect("~"));
}
}
