private void expiryTemperatureButton_Click(object sender, EventArgs e)
{
TemperatureCriteria tempCriteria = new TemperatureCriteria();
tempCriteria.MinTemperature = getMinTemperature();
tempCriteria.MaxTemperature = getMaxTemperature();
mainForm.ExpiryCriterias.Add(tempCriteria);
expiryTemperatureButton.Enabled = false;
}
private void checkCriteria(int itemID)
{
DateCriteria dateCriteria = DateCriteria.GetDateCriteria(itemID);
if (dateCriteria != null)
{
expireLabel.Text = "Expiry Date: " + dateCriteria.ExpiryDate.ToShortDateString() + "\n";
}
TemperatureCriteria tempCriteria = TemperatureCriteria.GetTemperatureCriteria(itemID);
if (tempCriteria != null)
{
expireLabel.Text += "Best Temp: from " + tempCriteria.MinTemperature + "Cْ to " + tempCriteria.MaxTemperature + "Cْ";
}
}
private void checkCriteria(int itemID)
{
string toolTipText = "";
DateCriteria dateCriteria = DateCriteria.GetDateCriteria(itemID);
if (dateCriteria != null)
{
expireLabel.Text = "Expiry Date: " + dateCriteria.ExpiryDate.ToShortDateString() + "\n";
TimeSpan time = dateCriteria.ExpiryDate - DateTime.Now;
if (time.Days > 0 && time.Days < 8)
{
itemToolTip.ToolTipIcon = ToolTipIcon.Warning;
toolTipText = "Expiry Date after " + (time.Days).ToString() + " day(s).";
}
else if (time.Days < 0)
{
itemToolTip.ToolTipIcon = ToolTipIcon.Error;
toolTipText = "Item has been expired" + (time.Days).ToString() + " day(s)ago.";
}
}
TemperatureCriteria tempCriteria = TemperatureCriteria.GetTemperatureCriteria(itemID);
if (tempCriteria != null)
{
expireLabel.Text += "Temp: from " + tempCriteria.MinTemperature + " Cْ to " + tempCriteria.MaxTemperature + " Cْ ْ";
int refTemp = Properties.Settings.Default.refrigeratorInternalTemperature;
if (refTemp < tempCriteria.MinTemperature || refTemp > tempCriteria.MaxTemperature)
{
if (toolTipText != "")
{
toolTipText += "\n";
}
if (refTemp < tempCriteria.MinTemperature)
{
toolTipText += "Temperature's too low for this item.";
}
else
{
toolTipText += "Temperature's too high for this item.";
}
}
}
if (toolTipText != "")
{
itemToolTip.SetToolTip(this, toolTipText);
}
}
public static TemperatureCriteria GetTemperatureCriteria(int itemID)
{
SqlConnection sqlConnection = new SqlConnection(Properties.Settings.Default.MyConnectionString);
string query = "Select dbo.temperatureExpiryTbl.* from dbo.temperatureExpiryTbl,dbo.expiryCriteriaTbl where (dbo.expiryCriteriaTbl.ID=dbo.temperatureExpiryTbl.ExpiryCriteriaID) AND (dbo.expiryCriteriaTbl.ItemID=" + itemID + ")";
SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
TemperatureCriteria tempratureCriteria = null;
if (sqlDataReader.Read())
{
tempratureCriteria = new TemperatureCriteria();
tempratureCriteria.MaxTemperature = Int32.Parse(sqlDataReader["MaxTemperature"].ToString());
tempratureCriteria.MinTemperature = Int32.Parse(sqlDataReader["MinTemperature"].ToString());
tempratureCriteria.ID = Int32.Parse(sqlDataReader["ExpiryCriteriaID"].ToString());
}
sqlConnection.Close();
return(tempratureCriteria);
}