public void AddConsumable([NotNull] ProtoEntityViewModel conumableViewModel, double intensity)
{
ConsumableList.Add(new ConsumableInfo()
{
ConsumableViewModel = conumableViewModel,
Name = conumableViewModel.Title,
Intensity = intensity,
});
ConsumableList = ConsumableList.OrderByDescending(c => c.Intensity).ThenBy(c => c.Name).ToList();
InputItemsList.Add(conumableViewModel);
}
public bool PostConsumableList(ConsumableList list)
{
bool ret = true;
string conString = WebConfigurationManager.ConnectionStrings["Database1"].ToString();
SqlConnection sqlConnection = new SqlConnection(conString);
try
{
if (list.ConsumableIDs.Count != list.Residuals.Count)
{
return(false);
}
sqlConnection.Open();
for (int n = 0; n < list.ConsumableIDs.Count; ++n)
{
SqlCommand cmd = new SqlCommand
{
Connection = sqlConnection,
CommandText = "IF EXISTS(SELECT * FROM ConsumableData WHERE DeviceID = @para1 AND ConsumableID = @para2) " +
"BEGIN " +
"UPDATE ConsumableData SET Residual = @para3 WHERE DeviceID = @para1 AND ConsumableID = @para2 " +
"END " +
"ELSE " +
"BEGIN " +
"INSERT INTO ConsumableData(DeviceID, ConsumableID, Residual) VALUES(@para1, @para2, @para3) " +
"END"
};
cmd.Parameters.Add("@para1", SqlDbType.Int).Value = list.DeviceID;
cmd.Parameters.Add("@para2", SqlDbType.Int).Value = list.ConsumableIDs[n];
cmd.Parameters.Add("@para3", SqlDbType.Int).Value = list.Residuals[n];
cmd.ExecuteNonQuery();
}
sqlConnection.Close();
}
catch (Exception ex)
{
sqlConnection.Close();
ret = false;
}
return(ret);
}
