Esempio n. 1
0
        //Convert starting date to weekspan (all strings)
        public static string DateToWeekSpan(string dateStr)
        {
            //Parse value
            DateTime dateVal = new DateTime();

            if (UtilDotNET.ValidateDate(dateStr))
            {
                dateVal = UtilDotNET.StringToDate(dateStr);
            }
            else
            {
                return("ERROR: Please fix starting date from database table");
            }

            //Last Monday
            int      deltaToLastMonday = DayOfWeek.Monday - dateVal.DayOfWeek;
            DateTime lastMonday        = dateVal.AddDays(deltaToLastMonday).Date;

            //This sunday
            int deltaToThisSunday = DayOfWeek.Sunday - dateVal.DayOfWeek;

            if (deltaToThisSunday <= (int)dateVal.DayOfWeek)
            {
                deltaToThisSunday += 7;
            }
            DateTime thisSunday = dateVal.AddDays(deltaToThisSunday).Date;

            string weekspan = String.Format("{0}-{1}", lastMonday.ToString("MM/dd/yy"), thisSunday.ToString("MM/dd/yy"));

            return(weekspan);
        }
Esempio n. 2
0
        /*	================================================================================
         *	Event for combo box items change
         *	- Includes display
         *	- Changes current workweek
         *	================================================================================
         */
        private void cmbWeekSpan_SelectedValueChanged(object sender, EventArgs e)
        {
            //When initialized disable buttons save, back, and forth.
            if (cmbWeekSpan.Text == "")
            {
                btnSave.Enabled  = false;
                btnBack.Enabled  = false;
                btnForth.Enabled = false;
            }
            else
            {
                btnSave.Enabled  = true;
                btnBack.Enabled  = true;
                btnForth.Enabled = true;

                //Disable forth
                DateTime cmbDate   = WorkWeek.LastBeginningOfWeek(currentWorkWeek.Week);                        //Date we are in
                DateTime cmbMonday = WorkWeek.LastBeginningOfWeek(cmbDate.ToString());

                DateTime date = UtilDotNET.StringToDate(WorkWeek.ConvertWeekSpanToBeginningOfWeek(cmbWeekSpan.Text));                   //Date we want to go to (because it change)
                //MessageBox.Show(cmbMonday + " " + date);
                //Only execute on different date selections
                if (cmbMonday != date)
                {
                    //Load corresponding week
                    int currentIndex = cmbWeekSpan.Items.IndexOf(cmbWeekSpan.Text);
                    currentWorkWeek = employeeWorkWeekList[currentIndex];
                    Display(currentWorkWeek);
                }
            }
        }
Esempio n. 3
0
        //Updates Employee's information
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            if (!UtilDotNET.IsMatch(UtilDotNET.phonePattern1, txtPhone.Text))
            {
                MessageBox.Show("Error: not a valid phone format.");
                return;
            }


            if (!UtilDotNET.IsMatch(UtilDotNET.emailPattern, txtEmail.Text))
            {
                MessageBox.Show("Error: invalid email format.");
                return;
            }


            if (!UtilDotNET.ValidateDate(txtStartingDate.Text) && txtStartingDate.Text != "")
            {
                MessageBox.Show("Invalid date format");
                return;
            }

            EmployeeDatabase.UpdateEmployee(txtFirstName.Text, txtLastName.Text, txtDepartment.Text, txtPhone.Text, txtEmail.Text, txtStartingDate.Text);

            MessageBox.Show(string.Format("Updated: {0} {1}", txtFirstName.Text, txtLastName.Text));

            //Update listview display
            this.Form2_Load(this, null);
        }
Esempio n. 4
0
        //Reset "hint" on leave if nothing was written
        private void cell_Leave(object sender, EventArgs e)
        {
            TextBox cell = (TextBox)sender;

            //Reset default value on leave, if nothing was written
            CheckForDummies(cell);

            //If military time, and in columns of military time, then proceed
            if (timeAreas.IndexOf(ParseCellName(cell.Name)[2]) != -1 && cell.Text != "")
            {
                if (!UtilDotNET.ValidateMilitaryTextFormat(cell.Text))                                                                  //Leaving empty cell
                {
                    cell.Text      = "0000";
                    cell.ForeColor = Color.DarkGray;
                }
                else
                {
                    //Update grid cell with valid time input
                    GridCellUpdate(cell);

                    //Check valid time input: greater than previous
                    //- Date format known to be valid (tryparse exact in validatemilitary...)
                    DateTime dateLeaving = DateTime.ParseExact(cell.Text, "HHmm", CultureInfo.InvariantCulture, DateTimeStyles.None);

                    Point pos        = GridPos(cell);
                    int   movingLeft = pos.Y;
                    while (movingLeft > 0)                                                              //Columns to the left
                    {
                        movingLeft--;                                                                   //Starting for first column to the left of current cell
                        string comparisonText = grid[pos.X][movingLeft];                                //Text from left cell

                        DateTime tempDate;
                        if (DateTime.TryParseExact(comparisonText, "HHmm", CultureInfo.InvariantCulture, DateTimeStyles.None, out tempDate))
                        {
                            //Pass - text is military time
                            if (tempDate > dateLeaving)                                                                                 //Break; after check against a military time
                            {
                                cell.Text      = "0000";
                                cell.ForeColor = Color.DarkGray;
                            }
                            break;
                        }
                    }
                }
            }
        }
Esempio n. 5
0
        /*	====================================================
         *	GetLastMondayFromDate
         *	> Error-catch any possible undesirable change in table values
         *	====================================================
         */
        public static DateTime LastBeginningOfWeek(string dateStr)
        {
            DateTime date = UtilDotNET.StringToDate(dateStr);

            //Last Monday
            if (date != DateTime.MinValue)
            {
                int deltaToLastMonday = DayOfWeek.Monday - date.DayOfWeek;
                if (deltaToLastMonday > 0)
                {
                    deltaToLastMonday -= 7;
                }
                DateTime lastMonday = date.AddDays(deltaToLastMonday).Date;
                return(lastMonday);
            }
            else
            {
                return(date);
            }
        }
Esempio n. 6
0
        //Clear cells on click
        private void cell_Click(object sender, EventArgs e)
        {
            TextBox cell = (TextBox)sender;

            if (allCells.Contains(cell))
            {
                //If cell has dummy
                if (dummies.IndexOf(cell.Text) != -1)
                {
                    cell.Text      = "";
                    cell.ForeColor = SystemColors.WindowText;                               //WindowText is the default color for text boxes
                }

                if (UtilDotNET.ValidateMilitaryTextFormat(cell.Text))
                {
                    //Upgrade grid cell with new info
                    GridCellUpdate(cell);
                    //Display Hours
                    double hrs = CalculateHours();
                    lblTotal.Text = Math.Round(hrs, 1).ToString();
                }
            }
        }
Esempio n. 7
0
        //Submit button event, add employee, update auto complete, and include employee in timesheet
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            //Exit this function if there is any blank text leave out
            if (txtFirstName.Text == "" || txtLastName.Text == "" || txtDepartment.Text == "" || txtPhone.Text == "" || txtEmail.Text == "")
            {
                MessageBox.Show("Missing data; please fill in all fields.");
                return;
            }

            /* ==================================================================
             * Format invariants
             * - Phone: xxx-xxx-xxxx
             * - Department: enum match
             * - Email: _@_.com
             * - Date: MM/dd/yyyy (just tryparse)
             */
            if (!UtilDotNET.IsMatch(UtilDotNET.phonePattern1, txtPhone.Text))
            {
                MessageBox.Show("Error: not a valid phone format.");
                return;
            }


            if (!UtilDotNET.IsMatch(UtilDotNET.emailPattern, txtEmail.Text))
            {
                MessageBox.Show("Error: invalid email format.");
                return;
            }


            if (!UtilDotNET.ValidateDate(txtStartingDate.Text) && txtStartingDate.Text != "")
            {
                MessageBox.Show("Invalid date format");
                return;
            }



            //Exit if employee is already in list
            Employee solicitude = EmployeeDatabase.GetEmployee(txtFirstName.Text, txtLastName.Text);

            if (solicitude == null)
            {
                MessageBox.Show(string.Format("Employee {0} {1} already in records.", solicitude.FirstName, solicitude.LastName));
                return;
            }

            EmployeeDatabase.AddEmployee(txtFirstName.Text, txtLastName.Text, txtDepartment.Text, txtPhone.Text, txtEmail.Text, txtStartingDate.Text);
            //Load all employees
            allEmployees = EmployeeDatabase.GetAllEmployees();

            UtilWinforms.UpdateAutoComplete(ref allTextBoxControls, ref allEmployees);            //Update AutoComplete values

            //Some feedback on add employee
            MessageBox.Show("Added 1 employee to Employee table.");

            //Update timesheet table with new employee - name and employee id, the rest of the fields empty
            Employee employee = EmployeeDatabase.GetEmployee(txtFirstName.Text, txtLastName.Text);

            //Add to timsheet table
            TimeSheetDatabase.AddWeekWork(employee.EmployeeID.ToString(), employee.FirstName, employee.LastName, WorkWeek.zeroDummy, WorkWeek.zeroDummy, WorkWeek.zeroDummy, WorkWeek.zeroDummy, WorkWeek.ellipsisDummy, WorkWeek.dashDummy, WorkWeek.dashDummy, employee.StartingDate);

            //Clear out the form
            txtFirstName.Text    = "";
            txtLastName.Text     = "";
            txtDepartment.Text   = "";
            txtPhone.Text        = "";
            txtEmail.Text        = "";
            txtStartingDate.Text = "";

            this.Form2_Load(this, null);                                        //Update listview

            MessageBox.Show("Employee added to timesheet records.\nYou can start now updating employee's work days!");
        }