コード例 #1
0
        private void LoadGrid()
        {
            try
            {
                String path = @"Data.csv";
                using (StreamReader reader = new StreamReader(path))
                {
                    String line = "";
                    if (File.Exists(path))
                    {
                        dataGridTable.Rows.Clear();
                        while (!reader.EndOfStream)
                        {
                            line = reader.ReadLine();
                            String[]        rowData = line.Split(',');
                            int             rowNum  = dataGridTable.Rows.Add();
                            DataGridViewRow row     = dataGridTable.Rows[rowNum];

                            String   inn = rowData[6];
                            DateTime t   = DateTime.Parse(rowData[6]);

                            row.Cells["ColnCardNum"].Value    = rowData[0];
                            row.Cells["ColnFullName"].Value   = rowData[1];
                            row.Cells["ColnPhNum"].Value      = rowData[2];
                            row.Cells["ColnEmail"].Value      = rowData[3];
                            row.Cells["ColnOccupation"].Value = rowData[4];
                            row.Cells["ColnGender"].Value     = rowData[5];
                            row.Cells["ColnInTime"].Value     = DateTime.Parse(rowData[6]).ToString("hh:mm tt");
                            DateTime outTime = DateTime.Parse(rowData[7]);
                            if (!outTime.Equals(default(DateTime)))
                            {
                                row.Cells["ColnOutTime"].Value = outTime.ToString("hh:mm tt");
                            }
                            row.Cells["ColnDay"].Value = rowData[8];

                            Visitors visitors = new Visitors(int.Parse(rowData[0]), rowData[1], rowData[2], rowData[3], rowData[4], rowData[5], DateTime.Parse(rowData[6]), DateTime.Parse(rowData[7]), DateTime.Parse(rowData[6]).DayOfWeek);

                            LsVisitors.Add(visitors);
                        }
                    }
                }
            }
            catch (Exception err)
            {
                MessageBox.Show("Error while loading data from the csv file.", "Error!");
            }
        }
コード例 #2
0
 private void BtnCheckIn_Click(object sender, EventArgs e)
 {
     try
     {
         int       cardNo     = int.Parse(txtCardNo.Text);
         int       cNo        = 0;
         String    name       = "";
         String    phNo       = "";
         String    email      = "";
         String    occupation = "";
         String    gender     = "";
         DateTime  inTime     = DateTime.Now;
         DateTime  outTime    = default(DateTime);
         DayOfWeek day        = inTime.DayOfWeek;
         foreach (Visitors v in LsVisitors)
         {
             if (v.CardNo == cardNo && !v.OutTime.Equals(default(DateTime)))
             {
                 cNo            = v.CardNo;
                 name           = v.Name;
                 phNo           = v.PhNo;
                 email          = v.Email;
                 occupation     = v.Occupation;
                 gender         = v.Gender;
                 txtCardNo.Text = "";
             }
             else if (v.CardNo == cardNo && v.OutTime.Equals(default(DateTime)))
             {
                 MessageBox.Show("This visitor has not exited previously.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                 txtCardNo.Text = "";
                 return;
             }
         }
         Visitors visit = new Visitors(cNo, name, phNo, email, occupation, gender, inTime, outTime, day);
         LsVisitors.Add(visit);
         String data = cNo + "," + name + "," + phNo + "," + email + "," + occupation + "," + gender + "," + inTime + "," + outTime + "," + day;
         ToCSV(data);
         MessageBox.Show("The visitor has checked in.", "Info!", MessageBoxButtons.OK, MessageBoxIcon.Information);
         LoadGrid();
     } catch (Exception a)
     {
         MessageBox.Show("Enter correct value!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
         txtCardNo.Text = "";
     }
 }
コード例 #3
0
        private void BtnSave_Click(object sender, EventArgs e)
        {
            try
            {
                Regex rx   = new Regex(@"^98*([0-9]{8})$");
                Regex rgx  = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$");
                Regex name = new Regex(@"^\w+\s\w+\s?\w+$");

                int cardNo = 0;

                String path = @"Data.csv";
                if (!File.Exists(path))
                {
                    File.Create(path);
                }
                using (StreamReader reader = new StreamReader(path))
                {
                    String line = "";
                    if (File.Exists(@"Data.csv"))
                    {
                        int[] cN      = new int[dataGridTable.RowCount];
                        int   counter = 0;
                        while (!reader.EndOfStream)
                        {
                            line = reader.ReadLine();
                            String[] rowData = line.Split(',');
                            cardNo      = int.Parse(rowData[0]);
                            cN[counter] = int.Parse(rowData[0]);
                            counter++;
                        }
                        int greatest = 0;
                        for (int i = 0; i < cN.Length; i++)
                        {
                            if (cN[i] > greatest)
                            {
                                greatest = cN[i];
                            }
                        }
                        if (cardNo >= greatest)
                        {
                            cardNo = ++cardNo;
                        }
                        else
                        {
                            cardNo = greatest + 1;
                        }
                    }
                }
                String visitorName;
                if (String.IsNullOrEmpty(txtName.Text.Trim()) || !name.IsMatch(txtName.Text.Trim()))
                {
                    MessageBox.Show("The name field is empty or incorrect!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    visitorName = txtName.Text.Trim();
                }
                String email;
                if (String.IsNullOrEmpty(txtEmail.Text.Trim()) || !rgx.IsMatch(txtEmail.Text.Trim()))
                {
                    MessageBox.Show("The email field is empty or incorrect!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    email = txtEmail.Text.Trim();
                }
                String occupation;
                if (cmbOccupation.SelectedItem == null)
                {
                    MessageBox.Show("Please select an occupation", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    btnClearAll.PerformClick();
                    return;
                }
                else
                {
                    occupation = cmbOccupation.Text;
                }

                String gender;

                if (radMale.Checked)
                {
                    gender = radMale.Text;
                }
                else
                {
                    gender = radFemale.Text;
                }

                DateTime  inTime  = DateTime.Now;
                DateTime  outTime = default(DateTime);
                TimeSpan  opens   = new TimeSpan(10, 0, 0);
                TimeSpan  closes  = new TimeSpan(17, 0, 0);
                DayOfWeek day     = inTime.DayOfWeek;
                //if (day == DayOfWeek.Saturday || day == DayOfWeek.Sunday)
                //{
                //    MessageBox.Show("The museum is closed.");
                //    btnClearAll.PerformClick();
                //    return;
                //}
                //else if (inTime.TimeOfDay > opens && inTime.TimeOfDay < closes)
                //{

                //}
                //else
                //{
                //    MessageBox.Show("The musuem is now close, please visit between 10 AM and 5 PM");
                //    btnClearAll.PerformClick();
                //    return;
                //}

                String phNo;
                if (String.IsNullOrEmpty(txtPhNo.Text.Trim()) || !rx.IsMatch(txtPhNo.Text.Trim()))
                {
                    MessageBox.Show("The phone field is empty or incorrect!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    phNo = txtPhNo.Text.Trim();
                }
                int check = ValidateRedundancy(visitorName, phNo, occupation, gender, email);
                if (check == 0)
                {
                    MessageBox.Show("This is an old visitor.", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    btnClearAll.PerformClick();
                    return;
                }
                Visitors visitors = new Visitors(cardNo, visitorName, phNo, email, occupation, gender, inTime, outTime, day);
                LsVisitors.Add(visitors);
                String data = cardNo + "," + visitorName + "," + phNo + "," + email + "," + occupation + "," + gender + "," + inTime + "," + outTime + "," + day;
                ToCSV(data);
                LoadGrid();
                MessageBox.Show("The visitor has been registered and checked in with card no." + cardNo + ".", "Alert!", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception f)
            {
                MessageBox.Show("The values entered are either missing or incorrect!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }