public List <NMRSpectralInfo> GetNMRSpectralInformation()
{
List <NMRSpectralInfo> lstNMRSpectrals = null;
try
{
if (dgvNmrValues.Rows.Count > 0)
{
lstNMRSpectrals = new List <NMRSpectralInfo>();
for (int i = 0; i < dgvNmrValues.Rows.Count; i++)
{
NMRSpectralInfo objNMRSpectral = new NMRSpectralInfo();
objNMRSpectral.SpectroMeter = dgvNmrValues.Rows[i].Cells["colNmrSpectrometer"].Value.ToString();
objNMRSpectral.Solvent = dgvNmrValues.Rows[i].Cells["colNmrSolvent"].Value.ToString();
objNMRSpectral.Nucleus = dgvNmrValues.Rows[i].Cells["colNmrNucles"].Value.ToString();
objNMRSpectral.Frequency = dgvNmrValues.Rows[i].Cells["colNmrFreq"].Value.ToString();
objNMRSpectral.StdSolvent = dgvNmrValues.Rows[i].Cells["colNmrStandard"].Value.ToString();
objNMRSpectral.ShiftValues = dgvNmrValues.Rows[i].Cells["colNmrShiftValues"].Value.ToString();
lstNMRSpectrals.Add(objNMRSpectral);
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
return(lstNMRSpectrals);
}
public static bool UpdateNMRSpectralInformation(NMRSpectralInfo nmrSpectralInfo, UserInfo usrInfo)
{
bool blStatus = false;
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = oraCon;
oraCmd.CommandText = "SAVE_NMR_SPECTRAL_DATA";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_COMP_ID", OracleDbType.Int32).Value = nmrSpectralInfo.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 InsertIntoNmrGrid(NMRSpectralInfo objNmr)
{
try
{
dgvNmrValues.Rows.Add();
int RowIndex = dgvNmrValues.Rows.Count - 1;
dgvNmrValues.Rows[RowIndex].Cells["colNmrSpectrometer"].Value = objNmr.SpectroMeter;
dgvNmrValues.Rows[RowIndex].Cells["colNmrFreq"].Value = objNmr.Frequency;
dgvNmrValues.Rows[RowIndex].Cells["colNmrStandard"].Value = objNmr.StdSolvent;
dgvNmrValues.Rows[RowIndex].Cells["colNmrSolvent"].Value = objNmr.Solvent;
dgvNmrValues.Rows[RowIndex].Cells["colNmrNucles"].Value = objNmr.Nucleus;
dgvNmrValues.Rows[RowIndex].Cells["colNmrShiftValues"].Value = objNmr.ShiftValues;
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void btnAddNMR_Click(object sender, EventArgs e)
{
try
{
string strErrMsg = "";
if (ValidateNMRControlValues(out strErrMsg))
{
objNmr = new NMRSpectralInfo();
objNmr.SpectroMeter = (string)cmbNmrSpectroMeter.SelectedItem;
objNmr.Frequency = (string)cmbNmrFreq.SelectedItem;
objNmr.StdSolvent = txtNmrStandard.Text;
objNmr.Solvent = (string)cmbNmrSolvent.SelectedItem;
objNmr.Nucleus = (string)cmbNmrNucleus.SelectedItem;
objNmr.ShiftValues = txtNmrShiftValues.Text;
if (blEditNmr)
{
if (bsNMR != null)
{
bsNMR.List[editRowIndxNmr] = objNmr;
bsNMR.ResetBindings(true);
}
}
else
{
List <NMRSpectralInfo> lstNMR = new List <NMRSpectralInfo>();
lstNMR.Add(objNmr);
BindDataToNMRGrid(lstNMR);
}
//Reset NMR controls
ResetNmrControls();
}
else
{
MessageBox.Show(strErrMsg, "Spectral Data Curation", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void UpdateRowNmrGrid(NMRSpectralInfo objNmr, int editRowIndx)
{
try
{
dgvNmrValues.Rows[editRowIndx].Cells["colNmrSpectrometer"].Value = objNmr.SpectroMeter;
dgvNmrValues.Rows[editRowIndx].Cells["colNmrFreq"].Value = objNmr.Frequency;
dgvNmrValues.Rows[editRowIndx].Cells["colNmrStandard"].Value = objNmr.StdSolvent;
dgvNmrValues.Rows[editRowIndx].Cells["colNmrSolvent"].Value = objNmr.Solvent;
dgvNmrValues.Rows[editRowIndx].Cells["colNmrNucles"].Value = objNmr.Nucleus;
dgvNmrValues.Rows[editRowIndx].Cells["colNmrShiftValues"].Value = objNmr.ShiftValues;
editRowIndxNmr = -1;
blEditNmr = false;
MessageBox.Show("Updated successfully", "Spectral Data Curation", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
