Exemplo n.º 1
0
        private void deleteCSFPServices(string deleteIDs)
        {
            int nbrRows = CCFBGlobal.executeQuery("Delete From CSFPLog "
                                                  + "Where ID in (" + deleteIDs + ")");

            MessageBox.Show(nbrRows.ToString() + " CSFP Service have been deleted."
                            , "Delete CSFP Service", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
Exemplo n.º 2
0
        private void updateExistingService(string updateIDs)
        {
            int nbrRows = CCFBGlobal.executeQuery("Update CSFPLog Set TrxDate='" + dtpSvcDate.Value.ToString() + "', "
                                                  + "Lbs=" + tbLbsCSFP.Text + ", Modified='" + DateTime.Now.ToString() + "', "
                                                  + "ModifiedBy='" + CCFBGlobal.dbUserName + "' "
                                                  + "Where ID in (" + updateIDs + ")");

            MessageBox.Show("The TrxDate and Lbs on " + nbrRows.ToString() + " CSFP Transaction Log has been changed"
                            , "Update Existing CSFP Service", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
Exemplo n.º 3
0
        public int insert(int weekday, string jobid, string jobtitle, string shiftstart, string shiftend, string volidprimary, string volidbackup)
        {
            string sql = "INSERT INTO [FBJobsPlan] "
                         + "([WeekDay],[JobID],[JobTitle],[ShiftStart],[ShiftEnd]"
                         + ",[VolIdPrimary],[VolIdBackup]"
                         + ",[Created],[CreatedBy],[Modified],[ModifiedBy]) "
                         + "VALUES (" + weekday.ToString() + "," + jobid + ",'" + jobtitle + "'"
                         + ",'" + shiftstart + "','" + shiftend + "'"
                         + "," + volidprimary + "," + volidbackup
                         + ",'" + DateTime.Now + "','" + CCFBGlobal.dbUserName + "'"
                         + ",NULL,'')";

            return(CCFBGlobal.executeQuery(sql));
        }
Exemplo n.º 4
0
        private void btnProcess_Click(object sender, EventArgs e)
        {
            int nbrRows = 0;

            if (rdoBtn1.Checked == true)
            {
                nbrRows = CCFBGlobal.executeQuery("Update Household Set Inactive = 1 Where Inactive = 0");
            }
            else
            {
                nbrRows = CCFBGlobal.executeQuery("Update Household Set Inactive = 1 Where InActive = 0 AND LatestService < '"
                                                  + dateTimePicker1.Value.ToShortDateString() + "'");
            }
            if (nbrRows != 0)
            {
                MessageBox.Show(nbrRows.ToString() + " households were marked as inactive.", "Mark Households Inactive Results", MessageBoxButtons.OK, MessageBoxIcon.Information);
                needToRefresh = true;
            }
            this.Hide();
        }
Exemplo n.º 5
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            string checkState = "0";

            if (chkCSFP.Checked == true)
            {
                checkState = "1";
            }
            string updateIDs = getHhMUpdateIds();

            if (updateIDs != "")
            {
                int nbrRows = CCFBGlobal.executeQuery("Update HouseholdMembers Set CSFPExpiration =' "
                                                      + dtpExpDate.Value.ToString() + "', CSFP = " + checkState
                                                      + " Where ID IN (" + updateIDs + ")");
                MessageBox.Show("The CSFP Expiration date on " + nbrRows.ToString() + " CSFP Clients has been changed to [" + dtpExpDate.Value.ToString() + "]"
                                , "CSFP Expiration Date Change", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            changeGroupBoxVisibility(0);
            refreshdgvCSFP();
        }
Exemplo n.º 6
0
        private void tsbMarkStatus_Click(object sender, EventArgs e)
        {
            ToolStripButton btn       = (ToolStripButton)sender;
            string          newStatus = btn.Tag.ToString();
            string          updateIDs = getHhMUpdateIds();

            if (updateIDs != "")
            {
                int nbrRows = CCFBGlobal.executeQuery("Update Householdmembers Set CSFPStatus=" + newStatus
                                                      + ", Modified='" + DateTime.Now.ToString() + "', "
                                                      + "ModifiedBy='" + CCFBGlobal.dbUserName + "' "
                                                      + "Where ID in (" + updateIDs + ")");
                MessageBox.Show("The CSFPStatus on " + nbrRows.ToString() + " CSFP Clients has been changed to [" + btn.Text.Replace("Mark", "") + "]"
                                , "CSFP Status Change", MessageBoxButtons.OK, MessageBoxIcon.Information);
                refreshdgvCSFP();
            }
            else
            {
                MessageBox.Show("No CSFP Clients are selected", "Change CSFP Status", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
Exemplo n.º 7
0
        }                       // end of grid_CellBeginEdit

        //-----------------------------------------------------------------------------------------
        /// <summary>
        /// Detect the DELETE button and delete the row from the grid and the database. Re-order
        /// the Sort Order values and decrement the values that are greater than the one deleted.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        //-----------------------------------------------------------------------------------------
        private void grid_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.ColumnIndex == 4)
            {
                int row = CurrentRow;                                           // Current row in the grid.
                //			string	sortOrder;								// Sort Order value temp (used for renumbering).
                string       sortOrderDeleted;                                  // Sort order value of the deleted row.
                string       typeCodeName;                                      // The "Type" field from the DB.
                int          NbrRows = 0;
                DialogResult retValue;
                //if (gridTypeCodes[e.ColumnIndex,e.RowIndex].ValueType
                switch (gridTypeCodes[e.ColumnIndex, e.RowIndex].Value.ToString())
                {
                case BTN_TEXT_DELETE:
                    typeCodeName = gridTypeCodes[COLUMN_GRID_TYPE, row].FormattedValue.ToString();
                    NbrRows      = AreTypeCodesUsed();
                    if (NbrRows > 0)
                    {
                        retValue = MessageBox.Show("The type code '" + typeCodeName + "' has " + NbrRows.ToString()
                                                   + " entries int the database. \r\n"
                                                   + "Deleting this code will cause errors in the system.\r\n"
                                                   + "Press Yes to delete anyway.\r\n"
                                                   + "Press No to be prompted for a replacement code.\r\n"
                                                   + "Press Cancel to skip the delete process."
                                                   , "Delete Type Code Warning"
                                                   , MessageBoxButtons.YesNoCancel
                                                   , MessageBoxIcon.Question
                                                   , MessageBoxDefaultButton.Button2);
                        switch (retValue)
                        {
                        case DialogResult.Yes:         //Delete anyway
                        { break; }

                        case DialogResult.No:           //Prompt for new id
                        {
                            TypeCodeChangeForm frmChangeTypeCode = new TypeCodeChangeForm(TableName,
                                                                                          Convert.ToInt32(gridTypeCodes.CurrentRow.Cells[0].Value));
                            frmChangeTypeCode.ShowDialog();

                            if (frmChangeTypeCode.Canceled == false)
                            {
                                CCFBGlobal.executeQuery("Update " + m_updatetypeCodeFields[cboTypeCodes_TableName.SelectedIndex]
                                                        .Replace("xxx", frmChangeTypeCode.SelectedID.ToString())
                                                        + gridTypeCodes.CurrentRow.Cells[0].Value.ToString());
                            }

                            return;
                        }

                        case DialogResult.Cancel:         //Do nothing
                        { return; }
                        }
                    }

                    sortOrderDeleted = gridTypeCodes[COLUMN_GRID_SORT_ORDER, row].FormattedValue.ToString();
                    if (DialogResult.OK == MessageBox.Show(
                            "Delete the \"" + typeCodeName + "\" Type Code?\r\n" +
                            "Are you sure?",
                            "Delete Type Code",
                            MessageBoxButtons.OKCancel,
                            MessageBoxIcon.Question))
                    {
                        //						gridTypeCodes.Rows.RemoveAt (row);			// Remove the current line from grid.
                        string uid = gridTypeCodes[COLUMN_GRID_ID, e.RowIndex].Value.ToString();
                        if (CCFBGlobal.executeQuery("DELETE FROM " + TableName + " WHERE ID = " + uid) < 1)
                        {
                            MessageBox.Show("Deletion Failed");
                        }
                        else
                        {
                            if (m_dataChanged == true)
                            {
                                Save();
                            }

                            refreshFromDB();
                            m_dataChanged = false;
                        }
                    }
                    break;

                case BTN_TEXT_UNDELETE:
                    gridTypeCodes[COLUMN_GRID_BUTTON, row].Value = BTN_TEXT_DELETE;
                    break;

                default:
                    return;
                }               // end of switch
            }
        }                       // end of grid_CellClick
Exemplo n.º 8
0
 public void updateField(string id, string fldname, int datavalue)
 {
     CCFBGlobal.executeQuery("UPDATE " + tblName + " SET " + fldname + " = " + datavalue.ToString() + " WHERE PlanID = " + id);
 }