public int catchDB(DateTime date, string category)
{
string datedb = date.ToString("yyyy-MM-dd");
int result;
MySqlConnection con = null;
MySqlCommand command, command2;
con = new MySqlConnection(conectabanco);
command = new MySqlCommand("SELECT SUM(Tempo) FROM `concurso` WHERE Categoria = '" + category + "' AND DataRevisao = '" + datedb + "'", con);
command2 = new MySqlCommand("SELECT count(DataRevisao) FROM concurso WHERE Categoria = '" + category + "' AND DataRevisao = '" + datedb + "'", con);
con.Open();
MySqlDataReader Reader1, Reader2;
Reader2 = command2.ExecuteReader();
Reader2.Read();
string valid = Reader2.GetString(0);
Reader2.Close();
if (Convert.ToInt32(valid) > 0)
{
Reader1 = command.ExecuteReader();
Reader1.Read();
result = Convert.ToInt32(Reader1.GetString(0));
Reader1.Close();
return(result);
}
else
{
return(0);
}
}
private void Project_Advisor_Load(object sender, EventArgs e)
{
String str = "Data Source=HAIER-PC\\NIMRASQLSERVER;Initial Catalog=ProjectA;Integrated Security=True";
String query = "select Id from Advisor";
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader Reader;
con.Open();
Reader = cmd.ExecuteReader();
while (Reader.Read())
{
comboBox2.Items.Add(Reader.GetInt32(0));
}
String query1 = "select Title from Project";
SqlConnection con1 = new SqlConnection(str);
SqlCommand cmd1 = new SqlCommand(query1, con1);
SqlDataReader Reader1;
con1.Open();
Reader1 = cmd1.ExecuteReader();
while (Reader1.Read())
{
comboBox1.Items.Add(Reader1.GetString(0));
}
}
public (string, string, string, string, string) ConnectDataBase(string Data, int nextresult)
{
string name, path, cate, time, revision;
name = "0"; path = "0"; cate = "0"; time = "0";
try
{
con = new MySqlConnection(conectabanco);
command2 = new MySqlCommand("SELECT count(Data) FROM concurso where DataRevisao='" + Data + "'", con);
command = new MySqlCommand("SELECT * FROM concurso where DataRevisao='" + Data + "'", con);
con.Open();
MySqlDataReader Reader1, Reader2;
Reader2 = command2.ExecuteReader();
Reader2.Read();
string v = Reader2.GetString(0);
int tam = Convert.ToInt32(v);
string[] namestr, pathstr, catestr, timestr, revistr;
namestr = new string[tam];
pathstr = new string[tam];
catestr = new string[tam];
timestr = new string[tam];
revistr = new string[tam];
Reader2.Close();
Reader1 = command.ExecuteReader();
int valid = Convert.ToInt32(v) - nextresult;
if (Convert.ToInt32(valid) > 0)
{
while (Reader1.HasRows)
{
int aux = 0;
while (Reader1.Read())
{
namestr[aux] = Reader1.GetString(0);
pathstr[aux] = Reader1.GetString(1);
catestr[aux] = Reader1.GetString(2);
revistr[aux] = Reader1.GetString(5);
timestr[aux] = Reader1.GetString(6);
aux++;
}
Reader1.NextResult();
}
name = namestr[nextresult];
path = pathstr[nextresult];
cate = catestr[nextresult];
time = timestr[nextresult];
revision = revistr[nextresult];
}
else
{
name = "0"; path = "0"; cate = "0"; time = "0"; revision = "0";
}
}
catch (Exception erro)
{
name = "ERRO"; path = "ERRO"; cate = "ERRO"; time = "ERRO"; revision = "ERRO";
MessageBox.Show(Convert.ToString(erro));
}
return(name, path, cate, time, revision);
}