data is not being saved after a time period

MY CODE IS AS BELOW....

protected void timer1_tick(object sender, EventArgs e)

{

// clientSocket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);

// clientSocket.Connect(new IPEndPoint(IPAddress.Parse("101.0.0.173"), 9000));

// clientSocket.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.ReuseAddress, true);

// clientSocket.Connect(new IPEndPoint(IPAddress.Parse("101.0.0.173"), 9000));

ClientThreadStart(clientSocket);

}

private Boolean ClientThreadStart(Socket clientSocket)

{

// Send the file name.

// clientSocket.Send(Encoding.ASCII.GetBytes(m_fileName));

// Receive the length of the filename.

try

{

currentTime = DateTime.Now; currentTimeForSMS = DateTime.Now;

if (previousTime == DateTime.Now || currentTime.TimeOfDay.Minutes - previousTime.TimeOfDay.Minutes == 1)

{

InsertInDB();

}

string receivedValue = string.Empty;

byte[] receivedBytes = new byte[1024];

int numBytes = clientSocket.Receive(receivedBytes);

//int length = BitConverter.ToInt32(data, 0);

receivedValue += Encoding.ASCII.GetString(receivedBytes,

0, numBytes);

if (receivedValue.Length == 0)

actualValue = 0;

else

{

if (receivedValue.Length > 3)

receivedValue = receivedValue.Remove(3);

else

receivedValue = receivedValue;

actualValue = Convert.ToDecimal(Convert.ToDecimal(receivedValue) * 100) / 255;

actualValue = Math.Round(actualValue, 2);

}

//Response.Write(DateTime.Now);

//actualValue = 21;

if (actualValue < 2)

{

txtStatus.Value = "Not Running";

}

else

{

txtStatus.Value = "Running";

}

if (actualValue > 20 )

{

// txtStatus.Value = "Not Running";

int count = currentTimeForSMS.TimeOfDay.Minutes - previousTimeForSMS.TimeOfDay.Minutes;

if (count == 0)

{

editsmshigh();

System.Diagnostics.Process.Start(Server.MapPath("\\asms\\smsh.bat"));

// System.Diagnostics.Process.Start("C:\\asms\\smsh.bat");

// previousTimeForSMS = DateTime.Now;

}

if (count == 10)

{

editsmshigh();

System.Diagnostics.Process.Start(Server.MapPath("\\asms\\smsh.bat"));

// System.Diagnostics.Process.Start("C:\\asms\\smsh.bat");

previousTimeForSMS = DateTime.Now;

sentSMS = true;

}

// count = count + 1;

}

else

{

// txtStatus.Value = "Running";

if (sentSMS == true)

{

// SendSMS("9574000515", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");

// SendSMS("9574000551", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");

// SendSMS("9574000501", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");

//SendSMS("9574000589", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");

System.Diagnostics.Process.Start("C:\\asms\\smsn.bat");

sentSMS = false;

}

previousTimeForSMS = currentTimeForSMS;

}

if (receivedValue.IndexOf("[FINAL]") > -1)

{

}

// Console.WriteLine("Received value: {0}", actualValue);

// Response.Write("Received value:" + actualValue);

txtSPM.Value = Convert.ToString(actualValue);

// SendSMS("9574000515", username, "Dear Sir Opacity Meter Reading is -" + actualValue + ". please check.");

// SendSMS("9574000589", username, "Dear Sir Opacity Meter Reading is -" + actualValue + ". please check.");

}

catch (Exception)

{

return false;

}

return true;

}

private Boolean InsertInDB()

{

object objAffected;

try

{

cnStr = "Data Source=xxx; User Id = XXX; Password = XXX;";

//query

query = "INSERT INTO opacity_data (P_VALUE,P_DATE) Values(" + txtSPM.Value + ", sysdate)";

//Connection via Connection open Property.

cn.Open(cnStr, null, null, 0);

cn.Execute(query, out objAffected, 0);

cn.Close();

previousTime = DateTime.Now;

return true;

}

catch (Exception)

{

return false;

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Your thread is sleeping after time so your data not inserted kindly check your code thoroughly ..
Vishal agrawal11y ago
MY CODE IS AS BELOW....

protected void timer1_tick(object sender, EventArgs e)
{
// clientSocket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
// clientSocket.Connect(new IPEndPoint(IPAddress.Parse("101.0.0.173"), 9000));
// clientSocket.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.ReuseAddress, true);
// clientSocket.Connect(new IPEndPoint(IPAddress.Parse("101.0.0.173"), 9000));
ClientThreadStart(clientSocket);
}
private Boolean ClientThreadStart(Socket clientSocket)
{
// Send the file name.
// clientSocket.Send(Encoding.ASCII.GetBytes(m_fileName));
// Receive the length of the filename.
try
{
currentTime = DateTime.Now; currentTimeForSMS = DateTime.Now;
if (previousTime == DateTime.Now || currentTime.TimeOfDay.Minutes - previousTime.TimeOfDay.Minutes == 1)
{
InsertInDB();
}
string receivedValue = string.Empty;
byte[] receivedBytes = new byte[1024];
int numBytes = clientSocket.Receive(receivedBytes);
//int length = BitConverter.ToInt32(data, 0);
receivedValue += Encoding.ASCII.GetString(receivedBytes,
0, numBytes);
if (receivedValue.Length == 0)
actualValue = 0;
else
{
if (receivedValue.Length > 3)
receivedValue = receivedValue.Remove(3);
else
receivedValue = receivedValue;
actualValue = Convert.ToDecimal(Convert.ToDecimal(receivedValue) * 100) / 255;
actualValue = Math.Round(actualValue, 2);
}
//Response.Write(DateTime.Now);
//actualValue = 21;
if (actualValue < 2)
{
txtStatus.Value = "Not Running";
}
else
{
txtStatus.Value = "Running";
}
if (actualValue > 20 )
{
// txtStatus.Value = "Not Running";
int count = currentTimeForSMS.TimeOfDay.Minutes - previousTimeForSMS.TimeOfDay.Minutes;
if (count == 0)
{
editsmshigh();
System.Diagnostics.Process.Start(Server.MapPath("\\asms\\smsh.bat"));
// System.Diagnostics.Process.Start("C:\\asms\\smsh.bat");
// previousTimeForSMS = DateTime.Now;
}
if (count == 10)
{
editsmshigh();
System.Diagnostics.Process.Start(Server.MapPath("\\asms\\smsh.bat"));
// System.Diagnostics.Process.Start("C:\\asms\\smsh.bat");
previousTimeForSMS = DateTime.Now;
sentSMS = true;
}
// count = count + 1;
}
else
{
// txtStatus.Value = "Running";
if (sentSMS == true)
{
// SendSMS("9574000515", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");
// SendSMS("9574000551", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");
// SendSMS("9574000501", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");
//SendSMS("9574000589", username, "Dear Sir Opacity Meter Reading is OK - " + actualValue + ".");
System.Diagnostics.Process.Start("C:\\asms\\smsn.bat");
sentSMS = false;

}
previousTimeForSMS = currentTimeForSMS;
}
if (receivedValue.IndexOf("[FINAL]") > -1)
{
}
// Console.WriteLine("Received value: {0}", actualValue);
// Response.Write("Received value:" + actualValue);
txtSPM.Value = Convert.ToString(actualValue);
// SendSMS("9574000515", username, "Dear Sir Opacity Meter Reading is -" + actualValue + ". please check.");
// SendSMS("9574000589", username, "Dear Sir Opacity Meter Reading is -" + actualValue + ". please check.");
}
catch (Exception)
{
return false;
}
return true;
}

private Boolean InsertInDB()
{
object objAffected;
try
{
cnStr = "Data Source=xxx; User Id = XXX; Password = XXX;";
//query
query = "INSERT INTO opacity_data (P_VALUE,P_DATE) Values(" + txtSPM.Value + ", sysdate)";
//Connection via Connection open Property.
cn.Open(cnStr, null, null, 0);
cn.Execute(query, out objAffected, 0);
cn.Close();
previousTime = DateTime.Now;
return true;
}
catch (Exception)
{
return false;
}
}
Pankaj Kumar Choudhary11y ago
Hello @Vishal can you post your code .....
ramya bharath11y ago
Check whether the event is running after 10 minutes or its getting timed out or is it showing any error