Exemple #1
0
        private void btnNew_Click(object sender, EventArgs e)
        {
            if (!MainForm.isPowerUser)
            {
                return;
            }

            FormInspectionType form = new FormInspectionType();

            if (form.ShowDialog() == DialogResult.OK)
            {
                OleDbCommand cmd = new OleDbCommand("", connection);

                cmd.CommandText =
                    "insert into INSPECTION_TYPES (INSPECTION_TYPE) \n" +
                    "values('" + MainForm.StrToSQLStr(form.inspectionType) + "')";

                if (MainForm.cmdExecute(cmd) >= 0)
                {
                    FillTypes();

                    MainForm.LocateGridRecord(form.inspectionType, "INSPECTION_TYPE", 1, dgvInspectionTypes);
                }
                else
                {
                    MessageBox.Show("Failed to create new record", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Exemple #2
0
        private void EditRecord()
        {
            if (!MainForm.isPowerUser)
            {
                return;
            }

            if (dgvInspectionTypes.Rows.Count == 0)
            {
                return;
            }

            FormInspectionType form = new FormInspectionType();

            form.inspectionType = dgvInspectionTypes.CurrentRow.Cells["INSPECTION_TYPE"].Value.ToString();

            int id = Convert.ToInt32(dgvInspectionTypes.CurrentRow.Cells["INSPECTION_TYPE_ID"].Value);

            form.InspectionTypeID = id;

            if (form.ShowDialog() == DialogResult.OK)
            {
                OleDbCommand cmd = new OleDbCommand("", connection);

                cmd.CommandText =
                    "update INSPECTION_TYPES set \n" +
                    "INSPECTION_TYPE='" + MainForm.StrToSQLStr(form.inspectionType) + "' \n" +
                    "where \n" +
                    "INSPECTION_TYPE_ID=" + id.ToString();

                if (MainForm.cmdExecute(cmd) >= 0)
                {
                    FillTypes();

                    MainForm.LocateGridRecord(form.inspectionType, "INSPECTION_TYPE_ID", 1, dgvInspectionTypes);
                }
                else
                {
                    MessageBox.Show("Failed to update record", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }