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());
}
}
