List <string> collectcompanydata()
{
try
{
using (MySqlConnection conn = new MySqlConnection("server=vps.p-and-c-ictsolutions.co.za;port=3306;database=mobile;user id=mobile;password=90op[],.;charset=utf8"))
{
List <string> data = new List <string>();
string cmd = "select concat(id, ' ',clockin_note) as Item from sla_visits where clockoutis !=1 and company = '" + company + "' and user = '******'";
MySqlDataAdapter adapter;
DataTable table = new DataTable();
adapter = new MySqlDataAdapter(cmd, conn);
adapter.Fill(table);
foreach (DataRow r in table.Rows)
{
data.Add(r[0].ToString());
}
return(data);
}
}
catch (MySqlException b)
{
List <string> data = new List <string>();
data.Add("P and C");
return(data);
}
}
List <string> collectcompanydata()
{
try
{
using (MySqlConnection conn = new MySqlConnection("server=154.127.59.43;port=3306;database=mobile;user id=mobile;password=90op[],.;charset=utf8"))
{
// MySqlConnection conn = new MySqlConnection("server=154.127.59.43;port=3306;database=mobile;user id=mobile;password=90op[],.;charset=utf8;connectiontimeout=500");
// conn.Open();
List <string> data = new List <string>();
string cmd = "select company from companies";
MySqlDataAdapter adapter;
DataTable table = new DataTable();
adapter = new MySqlDataAdapter(cmd, conn);
adapter.Fill(table);
foreach (DataRow r in table.Rows)
{
data.Add(r[0].ToString());
}
return(data);
}
}
catch (Exception b)
{
List <string> data = new List <string>();
data.Add("P and C");
return(data);
}
}
List <string> collectdata()
{
try
{
using (MySqlConnection conn = new MySqlConnection("server=154.127.59.43;port=3306;database=mobile;user id=mobile;password=90op[],.;charset=utf8"))
{
List <string> data = new List <string>();
string cmd = "select pass from Users where company = '" + company + "' and name = '" + username + "' ";
MySqlDataAdapter adapter;
DataTable table = new DataTable();
adapter = new MySqlDataAdapter(cmd, conn);
adapter.Fill(table);
foreach (DataRow r in table.Rows)
{
data.Add(r[0].ToString());
}
return(data);
}
}
catch (MySqlException b)
{
List <string> data = new List <string>();
data.Add("90op[],.");
return(data);
}
}
List <string[]> collectUserdata()
{
try
{
using (MySqlConnection conn = new MySqlConnection("server=vps.p-and-c-ictsolutions.co.za;port=3306;database=mobile;user id=mobile;password=90op[],.;charset=utf8"))
{
List <string[]> data = new List <string[]>();
string cmd = "select is_wind,is_wind_date,is_Scanned,is_Scanned_date from userinfo where concat(id, ' ', username ,' ' ,surname) = '" + user + "' and company = '" + globals._loggedin_company + "'";
MySqlDataAdapter adapter;
DataTable table = new DataTable();
adapter = new MySqlDataAdapter(cmd, conn);
adapter.Fill(table);
foreach (DataRow r in table.Rows)
{
data.Add(new string[] { r[0].ToString(), r[1].ToString(), r[2].ToString(), r[3].ToString() });
}
return(data);
}
}
catch (MySqlException b)
{
List <string[]> data = new List <string[]>();
data.Add(new string[] { "P and C" });
return(data);
}
}
List <string> collectcompanydata()
{
try
{
using (MySqlConnection conn = new MySqlConnection("server=vps.p-and-c-ictsolutions.co.za;port=3306;database=mobile;user id=mobile;password=90op[],.;charset=utf8"))
{
List <string> data = new List <string>();
string cmd = "select CONCAT (id, ' ', username, ' ' ,surname) from userinfo where is_wind = 0 or is_scanned = 0 and company = '" + globals._loggedin_company + "'";
MySqlDataAdapter adapter;
DataTable table = new DataTable();
adapter = new MySqlDataAdapter(cmd, conn);
adapter.Fill(table);
foreach (DataRow r in table.Rows)
{
data.Add(r[0].ToString());
}
return(data);
}
}
catch (MySqlException b)
{
List <string> data = new List <string>();
data.Add("P and C");
return(data);
}
}
List <string[]> collecthsdata()
{
try
{
using (MySqlConnection conn = new MySqlConnection("server=vps.p-and-c-ictsolutions.co.za;port=3306;database=mobile;user id=mobile;password=90op[],.;charset=utf8"))
{
List <string[]> data = new List <string[]>();
string cmd = "select clat,clon,hs_height from userinfo where username = '******' ";
MySqlDataAdapter adapter;
DataTable table = new DataTable();
adapter = new MySqlDataAdapter(cmd, conn);
adapter.Fill(table);
foreach (DataRow r in table.Rows)
{
data.Add(new string[] { r[0].ToString(), r[1].ToString(), r[2].ToString() });
}
return(data);
}
}
catch (MySqlException b)
{
List <string[]> data = new List <string[]>();
data.Add(new string[] { "0", "0", "15" });
return(data);
}
}
