public static void subCloseGGCCRegDetails() { try { objGGCCRegDetails.Close(); objGGCCRegDetails.Dispose(); objGGCCRegDetails = null; } catch (Exception ex) { clsErr.subLogErr("subCloseGGCCRegDetails", ex); } }
public static void subShowGGCCRegDetails(Form _mdiParent, long _lngGGCCRegWebID) { try { if (objGGCCRegDetails == null) objGGCCRegDetails = new GGCC.frmGGCCRegDetails(); objGGCCRegDetails.lngGGCCRegWebID = _lngGGCCRegWebID; objGGCCRegDetails.MdiParent = _mdiParent; objGGCCRegDetails.Show(); } catch (Exception ex) { clsErr.subLogErr("subShowGGCCRegDetails", ex); } }
public static long fcnGetWebRegIR(frmGGCCRegDetails _objGGCCRegDetails) { //match existing or add new ir for received ggccregweb id. //return matched or new ir id. long lngRes = 0; try { long lngStateID = 0; try { lngStateID = ((clsCboItem)_objGGCCRegDetails.cboState.SelectedItem).ID; } catch { lngStateID = 0; } clsIR irToSearch = new clsIR(0, lngStateID, _objGGCCRegDetails.txtFName.Text, _objGGCCRegDetails.txtLName.Text, _objGGCCRegDetails.txtCompanyName.Text, _objGGCCRegDetails.txtAddress.Text, _objGGCCRegDetails.txtCity.Text, _objGGCCRegDetails.txtZip.Text, _objGGCCRegDetails.txtHomePhone.Text, _objGGCCRegDetails.txtWorkPhone.Text, _objGGCCRegDetails.txtCellPhone.Text, _objGGCCRegDetails.txtEMail.Text); //fill in ir details to pass to search screen irToSearch.blnGender = true; irToSearch.lngRecordWebID = _objGGCCRegDetails.lngRecordWebID; irToSearch.lngRecordID = _objGGCCRegDetails.lngRecordID; irToSearch.strEmail = _objGGCCRegDetails.txtEMail.Text; irToSearch.strHomePhone = _objGGCCRegDetails.txtHomePhone.Text; irToSearch.strCellPhone = _objGGCCRegDetails.txtCellPhone.Text; irToSearch.strZip = _objGGCCRegDetails.txtZip.Text; irToSearch.strCity = _objGGCCRegDetails.txtCity.Text; irToSearch.strAddress = _objGGCCRegDetails.txtAddress.Text; irToSearch.strLName = _objGGCCRegDetails.txtLName.Text; irToSearch.strFName = _objGGCCRegDetails.txtFName.Text; using (frmFindIR objFindIR = new frmFindIR(irToSearch, "Find camper record")) { if (objFindIR.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if (objFindIR.irToSearch.lngRecordID == 0) return 0; else { lngRes = objFindIR.irToSearch.lngRecordID; if (!objFindIR.blnAddNew) { using (IRUtils.frmReconcileIR objReconcileIR = new global::CTWebMgmt.IRUtils.frmReconcileIR("tblWebRecordsGGCCReg", _objGGCCRegDetails.lngRecordID, _objGGCCRegDetails.lngRecordWebID)) { if (objReconcileIR.ShowDialog() == System.Windows.Forms.DialogResult.Cancel) return 0; else _objGGCCRegDetails.lngRecordID = objReconcileIR.lngDBID; } } } } else return 0; } if (lngRes > 0) { string strSQL = ""; using (OleDbConnection conDB = new OleDbConnection(clsAppSettings.GetAppSettings().strCTConn)) { conDB.Open(); strSQL = "UPDATE tblRecords " + "SET blnCamper=-1 " + "WHERE lngRecordID=" + lngRes.ToString(); using (OleDbCommand cmdDB = new OleDbCommand(strSQL, conDB)) { try { cmdDB.ExecuteNonQuery(); } catch { } } conDB.Close(); } } } catch (Exception ex) { clsErr.subLogErr("fcnGetWebRegIR", ex); } return lngRes; }