示例#1
0
        private void frmConfig_Load(object sender, EventArgs e)
        {
            ic             = new initConnection(Properties.Settings.Default.Server, Properties.Settings.Default.DBName);
            txtHead1.Text  = Properties.Settings.Default.Header1;
            txtHead2.Text  = Properties.Settings.Default.Header2;
            txtServer.Text = Properties.Settings.Default.Server;
            txtDB.Text     = Properties.Settings.Default.DBName;

            lblStatus.Text = "Status: " + (ic.isSQLConnected() ? "Terhubung" : "Tidak Terhubung");
            greet.Checked  = Properties.Settings.Default.greet;
            if (Properties.Settings.Default.greet == true)
            {
                custgreet.Visible = true;
                custgreet.Checked = Properties.Settings.Default.customgreet;
                if (Properties.Settings.Default.customgreet == true)
                {
                    gbGreet.Visible = true;
                }
                else
                {
                    gbGreet.Visible = false;
                }
                txtGreet.Text = Properties.Settings.Default.greettext;
            }
            else
            {
                custgreet.Visible = false;
                gbGreet.Visible   = false;
            }
        }
示例#2
0
        private void button2_Click(object sender, EventArgs e)
        {
            if ((txtServer.Text == "") && (txtDBName.Text == ""))
            {
                MessageBox.Show(this, "Mohon isi informasi koneksi dengan valid!", "Invalid Connection", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            else
            {
                initConnection ic = new initConnection(txtServer.Text, txtDBName.Text);

                if (ic.isSQLConnected())
                {
                    Properties.Settings.Default.Server = txtServer.Text;
                    Properties.Settings.Default.DBName = txtDBName.Text;
                    Properties.Settings.Default.Save();

                    MessageBox.Show(this, "Berhasil terhubung dengan server!", "Connection Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    lbStatus.Text = "Status: Terhubung";
                }
                else
                {
                    MessageBox.Show(this, "Gagal terhubung dengan server!", "Connection Failed", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    lbStatus.Text = "Status: Tidak Terhubung";
                }
            }
        }
示例#3
0
 private void button3_Click(object sender, EventArgs e)
 {
     lblStatus.Text = "Status: Menghubungkan...";
     ic             = new initConnection(txtServer.Text, txtDB.Text);
     if (ic.isSQLConnected())
     {
         lblStatus.Text = "Status: Terhubung";
         Properties.Settings.Default.Server = txtServer.Text;
         Properties.Settings.Default.DBName = txtDB.Text;
         Properties.Settings.Default.Save();
         MessageBox.Show(this, "Koneksi smart system berhasil terhubung ke database dan konfigurasi berhasil disimpan!", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     else
     {
         lblStatus.Text = "Status: Tidak Terhubung";
         MessageBox.Show(this, "Koneksi smart system gagal terhubung ke database", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
示例#4
0
        private void frmConfig_Load(object sender, EventArgs e)
        {
            txtHead1.Text = Properties.Settings.Default.header1;
            txtHead2.Text = Properties.Settings.Default.header2;
            txtFoot.Text  = Properties.Settings.Default.footer;

            txtServer.Text = Properties.Settings.Default.Server;
            txtDBName.Text = Properties.Settings.Default.DBName;

            numtarif.Value   = Properties.Settings.Default.tarifper;
            txtTrfMotor.Text = Properties.Settings.Default.tarifmotor.ToString();
            txtTrfMobil.Text = Properties.Settings.Default.tarifmobil.ToString();

            initConnection ic = new initConnection(Properties.Settings.Default.Server, Properties.Settings.Default.DBName);

            if (ic.isSQLConnected())
            {
                lbStatus.Text = "Status: Terhubung";
            }
            else
            {
                lbStatus.Text = "Status: Tidak Terhubung";
            }
        }
示例#5
0
        private void button2_Click(object sender, EventArgs e)
        {
            try {
                button1.Enabled = false;
                button2.Enabled = false;
                DateTime dt   = DateTime.Now;
                var      list = new List <string[]>()
                {
                };
                conn = new initConnection(Properties.Settings.Default.Server, Properties.Settings.Default.DBName);

                using (SqlConnection myConnection = new SqlConnection()) {
                    string     oString = "SELECT * FROM lokasi WHERE jenis_kend = 'Mobil'";
                    SqlCommand oCmd    = new SqlCommand(oString, myConnection);
                    myConnection.ConnectionString = @"Data Source=" + Properties.Settings.Default.Server + "; Initial Catalog=" + Properties.Settings.Default.DBName + "; Integrated Security=True";
                    myConnection.Open();
                    using (SqlDataReader oReader = oCmd.ExecuteReader()) {
                        while (oReader.Read())
                        {
                            string[] baru = new string[2];
                            baru[0] = oReader["kode_lokasi"].ToString();
                            baru[1] = oReader["kuota"].ToString();
                            list.Add(baru);

                            //matchingPerson.firstName = oReader["FirstName"].ToString();
                            //matchingPerson.lastName = oReader["LastName"].ToString();
                        }

                        myConnection.Close();
                    }
                }

                using (SqlConnection bcc = new SqlConnection()) {
                    bcc.ConnectionString = @"Data Source=" + Properties.Settings.Default.Server + "; Initial Catalog=" + Properties.Settings.Default.DBName + "; Integrated Security=True";
                    bcc.Open();
                    foreach (string[] y in list)
                    {
                        string     oString2 = "SELECT COUNT(*) FROM parkir WHERE kode_lokasi = '" + y[0] + "'";
                        SqlCommand oCmd2    = new SqlCommand(oString2, bcc);
                        if (int.Parse(oCmd2.ExecuteScalar().ToString()) < int.Parse(y[1].ToString()))
                        {
                            didapat = y[0].ToString();
                            kode    = dt.ToString("yyyyMMddHHmmss");
                            break;
                        }
                    }
                    bcc.Close();
                }

                if (didapat == "")
                {
                    MessageBox.Show(this, "Tempat parkir penuh semua!!", "Not enough", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                else
                {
                    using (SqlConnection scn = new SqlConnection()) {
                        scn.ConnectionString = @"Data Source=" + Properties.Settings.Default.Server + "; Initial Catalog=" + Properties.Settings.Default.DBName + "; Integrated Security=True";
                        scn.Open();
                        SqlCommand cmd = new SqlCommand();
                        cmd.Connection  = scn;
                        cmd.CommandText = "tambah_kend";
                        cmd.CommandType = CommandType.StoredProcedure;

                        SqlParameter id_parkir   = new SqlParameter("@id_parkir", SqlDbType.VarChar);
                        SqlParameter jenis_kend  = new SqlParameter("@jenis_kend", SqlDbType.VarChar);
                        SqlParameter tgl_masuk   = new SqlParameter("@tgl_masuk", SqlDbType.DateTime);
                        SqlParameter kode_lokasi = new SqlParameter("@kode_lokasi", SqlDbType.VarChar);

                        id_parkir.Value   = kode;
                        jenis_kend.Value  = "Mobil";
                        tgl_masuk.Value   = DateTime.Now;
                        kode_lokasi.Value = didapat;

                        cmd.Parameters.Add(id_parkir);
                        cmd.Parameters.Add(jenis_kend);
                        cmd.Parameters.Add(tgl_masuk);
                        cmd.Parameters.Add(kode_lokasi);

                        cmd.ExecuteNonQuery();
                        scn.Close();
                    }
                }
                PrintDocument pd = new PrintDocument();
                pd.PrintPage += new PrintPageEventHandler(printMobil);
                // Set the printer name.
                //pd.PrinterSettings.PrinterName = "\\NS5\hpoffice
                //pd.PrinterSettings.PrinterName = "Zebra New GK420t"
                pd.Print();
                if (Properties.Settings.Default.greet)
                {
                    if (Properties.Settings.Default.customgreet)
                    {
                        SpeechSynthesizer sc = new SpeechSynthesizer();
                        sc.SpeakAsync(Properties.Settings.Default.greettext);
                    }
                    else
                    {
                        playWelcome();
                    }
                }
                frmInfo frm = new frmInfo();
                frm.lbTempat.Text  = didapat;
                frm.lbKet.Text     = "Mobil";
                frm.timer1.Enabled = true;
                frm.ShowDialog(this);
            } catch (Exception ex) {
                MessageBox.Show("Error: " + ex.ToString());
            } finally {
                didapat         = "";
                kode            = "";
                button1.Enabled = true;
                button2.Enabled = true;
            }
        }