C#

Member 8605543 wrote:

I would prefer to have the data transferred realtime (upon input), rather than
the KDS sending frequent queries to the database.

Member 8605543 wrote:

when you've already paid for your meal,

Member 8605543 wrote:

isnt this cpu intensive?

Member 8605543 wrote:

Just like those being used in fastfood chains, when you've already paid for your
meal, you cannot make any changes, not unless you make a new transaction

Member 8605543 wrote:

isnt this cpu intensive?

BobJanova wrote:

I'm going to disagree with almost everyone else and say that you want to do this
with sockets, albeit with the central server storing information in a database
for audit/recovery reasons. That's because polling is almost always an inferior
solution (you're transferring, at best, the same data, and generally the same
data plus a large number of empty poll requests, while having a slower response
time), and not necessary in this case.
 

BobJanova wrote:

Polling isn't really any less complex than persistent sockets,

When you create the folder in the path: Environment.SpecialFolder.ProgramFiles
it always comes up to the error UnauthorizedAccessException do not know how I can handle it, unfortunately OS (Windows 7)

String idtoselect = row.Cells[0].Value.ToString();
String str1 = idtoselect.ToString();

string sql2 = "select NAME_Product from Product where  Product.ID_Product = '"+str1+"' ";

while (rdr.Read())
{
    test = rdr["NAME_Product"].ToString();
}

if (rdr.Read())

CultureInfo ci = new CultureInfo("th-TH");

string sql = "SELECT * FROM Order1 where ID_Product = '"+str1+"' AND DATE_Order BETWEEN '" + dateTimePicker1.Value.ToString("s") + "' AND '" + dateTimePicker2.Value.ToString("s") + "' ";

string sql = "SELECT * FROM Order1 where ID_Product = @ID AND DATE_Order BETWEEN @D1 AND @D2";
da = new SqlDataAdapter(sql, conn);
da.SelectCommand.Parameters.AddWithValue("@ID", idtoselect);
da.SelectCommand.Parameters.AddWithValue("@D1", dateTimePicker1.Value);
da.SelectCommand.Parameters.AddWithValue("@D2", dateTimePicker2.Value);

string test = "";

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                if (row.Cells[1].Value != null && (bool)row.Cells[1].FormattedValue)
                {                       
                        String idtoselect = row.Cells[0].Value.ToString();
                        
                        try
                        {
                            string sql2 = "select NAME_Product from Product where  Product.ID_Product = '"+idtoselect+"' ";
                            SqlCommand testcommand2 = new SqlCommand(sql2, conn);
                            rdr = testcommand2.ExecuteReader();

                            if (rdr.Read())
                            {
                                test = rdr["NAME_Product"].ToString();
                            }
                            rdr.Close();

                            try
                            {
                                CultureInfo ci = new CultureInfo("th-TH");
                                string sql = "SELECT * FROM Order1 where ID_Product = @ID AND DATE_Order BETWEEN @D1 AND @D2";
                                da = new SqlDataAdapter(sql, conn);
                                da.SelectCommand.Parameters.AddWithValue("@ID", idtoselect);
                                da.SelectCommand.Parameters.AddWithValue("@D1", dateTimePicker1.Value);
                                da.SelectCommand.Parameters.AddWithValue("@D2", dateTimePicker2.Value);
                                
                                ds = new DataSet();
                                da.Fill(ds, "Order1");
                                chart1.DataSource = ds.Tables["Order1"];
                                chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                                
                                chart1.Series.Add(test);
                                chart1.Series[test].ChartArea = "ChartArea1";
                                chart1.Series[test].BorderWidth = 4;
                                chart1.Series[test].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;                                
                                chart1.Series[test].YValueMembers += "QUANTITY_Order";
                                chart1.Series[test].XValueMember += "DATE_Order";

                                chart1.DataBind();
                                MessageBox.Show("test :" );
                            }
                            catch (Exception ex)
                            {
                                MessageBox.Show("test :" + ex);
                            }
       
                        }
                        catch
                        {
                            MessageBox.Show("Exception");
                        }
                

                }

datatb = new DataTable();
da.Fill(datatb);
chart1.DataSource = datatb;