public List <OtherSpectralInfo> GetOtherSpectralInformation() { List <OtherSpectralInfo> lstOtherSpectrals = null; try { if (dgvMassIrUv.Rows.Count > 0) { lstOtherSpectrals = new List <OtherSpectralInfo>(); for (int i = 0; i < dgvMassIrUv.Rows.Count; i++) { OtherSpectralInfo objOthSpectral = new OtherSpectralInfo(); objOthSpectral.SpectroMeter = dgvMassIrUv.Rows[i].Cells["colNmrSpectrometer"].Value.ToString(); objOthSpectral.Method = dgvMassIrUv.Rows[i].Cells["colMassIrUvMethod"].Value.ToString(); objOthSpectral.ValueType = dgvMassIrUv.Rows[i].Cells["colMassIrUvCategory"].Value.ToString(); objOthSpectral.SamplePreparation = dgvMassIrUv.Rows[i].Cells["colMassIrUvSamplePrep"].Value.ToString(); objOthSpectral.PeakValues = dgvMassIrUv.Rows[i].Cells["colMassIrUvPeaks"].Value.ToString(); objOthSpectral.ElectronVolts = dgvMassIrUv.Rows[i].Cells["colMassIrUvEv"].Value.ToString(); lstOtherSpectrals.Add(objOthSpectral); } } } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } return(lstOtherSpectrals); }
public static bool UpdateOtherSpectralInformation(OtherSpectralInfo othSpectralInfo, UserInfo usrInfo) { bool blStatus = false; try { using (OracleConnection oraCon = ConnectionDB.GetOracleConnection()) { using (OracleCommand oraCmd = new OracleCommand()) { oraCmd.Connection = oraCon; oraCmd.CommandText = "SAVE_OTHER_SPECTRAL_DATA"; oraCmd.CommandType = CommandType.StoredProcedure; oraCmd.Parameters.Add("PIN_COMP_ID", OracleDbType.Int32).Value = othSpectralInfo.CompoundID; //OracleParameter paNMRID = new OracleParameter(); //paNMRID.ParameterName = "PINA_NMRID"; //paNMRID.CollectionType = OracleCollectionType.PLSQLAssociativeArray; //paNMRID.OracleDbType = OracleDbType.Int32; //if (compInfo..TKIDs != null) //{ // if (compInfo.TKIDs.Count > 0) // { // paNMRID.Value = compInfo.TKIDs.ToArray(); // } // else // { // paNMRID.Value = new string[1] { null }; // paNMRID.Size = 0; // } //} //else //{ // paNMRID.Value = new string[1] { null }; // paNMRID.Size = 0; //} //oraCmd.Parameters.Add(paNMRID); oraCmd.Parameters.Add("PIN_UR_ID", OracleDbType.Int32).Value = usrInfo.UserID; oraCon.Open(); oraCmd.ExecuteNonQuery(); oraCon.Close(); blStatus = true; } } } catch (Exception ex) { throw ex; } return(blStatus); }
private void InsertIntoMassIrUvGrid(OtherSpectralInfo objMassIrUv) { try { dgvMassIrUv.Rows.Add(); int RowIndex = dgvMassIrUv.Rows.Count - 1; dgvMassIrUv.Rows[RowIndex].Cells["colMassIrUvSpectrometer"].Value = objMassIrUv.SpectroMeter; dgvMassIrUv.Rows[RowIndex].Cells["colMassIrUvComments"].Value = objMassIrUv.Comments; dgvMassIrUv.Rows[RowIndex].Cells["colMassIrUvMethod"].Value = objMassIrUv.Method; dgvMassIrUv.Rows[RowIndex].Cells["colMassIrUvCategory"].Value = objMassIrUv.ValueType; dgvMassIrUv.Rows[RowIndex].Cells["colMassIrUvEv"].Value = objMassIrUv.ElectronVolts; dgvMassIrUv.Rows[RowIndex].Cells["colMassIrUvPeaks"].Value = objMassIrUv.PeakValues; //dgvMassIrUv.Rows[RowIndex].Cells["colMassIrUvSamplePrep"].Value = objMassIrUv.SamplePrep; } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } }
private void btnAddMassIRUV_Click(object sender, EventArgs e) { try { string strErrMsg = ""; if (ValidateMassIrUvControlValues(out strErrMsg)) { objMassIrUv = new OtherSpectralInfo(); objMassIrUv.SpectroMeter = (string)cmbMassSpectrometer.SelectedItem; objMassIrUv.Comments = txtMassIrUvComments.Text; objMassIrUv.Method = txtMassIrUvMethod.Text; objMassIrUv.ValueType = (string)cmbMassIrUvType.SelectedItem; objMassIrUv.ElectronVolts = txtEv.Text; objMassIrUv.PeakValues = txtMassIrUvPeaks.Text; if (blEditMassIrUv) { if (bsOtherNMR != null) { bsOtherNMR.List[editRowIndxMassIrUv] = objMassIrUv; bsOtherNMR.ResetBindings(true); } } else { List <OtherSpectralInfo> lstOtherNMR = new List <OtherSpectralInfo>(); lstOtherNMR.Add(objMassIrUv); BindDataToMassIrUVGrid(lstOtherNMR); } //Reset Control values ResetMassIrUvControls(); } else { MessageBox.Show(strErrMsg, "Spectral Data Curation", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } }
private void UpdateRowMassIrUvGrid(OtherSpectralInfo objMassIrUv, int editRowIndxMassIrUv) { try { dgvMassIrUv.Rows[editRowIndxMassIrUv].Cells["colMassIrUvSpectrometer"].Value = objMassIrUv.SpectroMeter; dgvMassIrUv.Rows[editRowIndxMassIrUv].Cells["colMassIrUvComments"].Value = objMassIrUv.Comments; dgvMassIrUv.Rows[editRowIndxMassIrUv].Cells["colMassIrUvMethod"].Value = objMassIrUv.Method; dgvMassIrUv.Rows[editRowIndxMassIrUv].Cells["colMassIrUvCategory"].Value = objMassIrUv.ValueType; dgvMassIrUv.Rows[editRowIndxMassIrUv].Cells["colMassIrUvEv"].Value = objMassIrUv.ElectronVolts; dgvMassIrUv.Rows[editRowIndxMassIrUv].Cells["colMassIrUvPeaks"].Value = objMassIrUv.PeakValues; //dgvMassIrUv.Rows[editRowIndxMassIrUv].Cells["colMassIrUvSamplePrep"].Value = objMassIrUv.SamplePrep; editRowIndxMassIrUv = -1; blEditMassIrUv = false; MessageBox.Show("Updated successfully", "Spectral Data Curation", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { ErrorHandling.WriteErrorLog(ex.ToString()); } }