public static void UpdateControl(SerialCon serialCon)
{
SqlConnection conn = new SqlConnection("Data Source=tcp:s14.winhost.com;Initial Catalog=DB_134003_orders;User ID=DB_134003_orders_user;Password=Electronics1;Integrated Security=False;");
string query = "";
if (serialCon.controlMode == 1)
{
//time control need to also include times
query = "Update dbo.SmartBlinds set controlMode = " + serialCon.controlMode.ToString() + " , timecontrolopentime ='" + serialCon.openTime + "' , timecontrolclosetime = '" + serialCon.closeTime + "' , blindState = 2 where BlindID = 1";
}
else if (serialCon.controlMode == 0)
{
query = "Update dbo.SmartBlinds set controlMode = " + serialCon.controlMode.ToString() + ", blindState = 2 where BlindID = 1";
}
else
{
//easy just update the controlMode value
query = "Update dbo.SmartBlinds set controlMode = " + serialCon.controlMode.ToString() + " where BlindID = 1";
}
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
cmd.ExecuteReader();
conn.Close();
conn.Dispose();
}
public static SerialCon GetLightMode()
{
SqlConnection conn = new SqlConnection("Data Source=tcp:s14.winhost.com;Initial Catalog=DB_134003_orders;User ID=DB_134003_orders_user;Password=Electronics1;Integrated Security=False;");
SerialCon serialCon = new SerialCon();
try
{
string query = "Select * from dbo.SmartBlinds where BlindID = 1";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
serialCon.controlMode = Convert.ToInt32(reader["controlMode"]);
}
reader.Close();
conn.Close();
conn.Dispose();
}
catch (Exception e)
{
}
return(serialCon);
}
public static void SendCommand(SerialCon serialCon)
{
//need to send the database the value of the blindState
SqlConnection conn = new SqlConnection("Data Source=tcp:s14.winhost.com;Initial Catalog=DB_134003_orders;User ID=DB_134003_orders_user;Password=Electronics1;Integrated Security=False;");
string query = "Update dbo.SmartBlinds set blindState = " + serialCon.blindState.ToString() + " where BlindID = 1";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
cmd.ExecuteReader();
conn.Close();
conn.Dispose();
}