private void CostUpdataItem(UIGridItem item)
{
if (item == null || item.mScripts == null || item.oData == null)
{
return;
}
CompoundInfo info = item.oData as CompoundInfo;
UISprite color = item.mScripts[0] as UISprite;
UITexture icon = item.mScripts[1] as UITexture;
UILabel num = item.mScripts[2] as UILabel;
UISprite add = item.mScripts[3] as UISprite;
color.spriteName = "color" + 1;
add.transform.gameObject.SetActive(info.m_select == 0);
item.transform.FindChild("contain").gameObject.SetActive(info.m_select == 1);
if (info.m_gem != null)
{
GemItem gem = GemItemConfig.GetGemItem(int.Parse(info.m_gem.itemID));
ItemInfo item_info = ItemManager.GetItemInfo(info.m_gem.itemID);
num.text = "1";
color.spriteName = "color" + item_info.color;
LoadSprite.LoaderItem(icon, item_info.itemID, false);
}
}
private void btnDeleteCompound_Click(object sender, EventArgs e)
{
try
{
CompoundInfo objCompInfo = ucSpectral.GetCompoundInformation();
if (objCompInfo != null)
{
if (objCompInfo.CompoundID > 0)
{
DialogResult diaRes = MessageBox.Show("Do you want to delete the compound?", "ChemInform", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (diaRes == System.Windows.Forms.DialogResult.Yes)
{
//Delete compound information in the database on CompoundID
if (SpectralCurationDB.DeleteCompoundDataOnID(objCompInfo))
{
//Reset control values
ucSpectral.ResetAllControlValues();
//Refresh Document Compounds after Compound deleted
DocCompounds = Dal.SpectralCurationDB.GetCompoundsOnDocumentID(DocumentID);
MaxRecCnt = DocCompounds.Rows.Count;
numGotoRecord.Maximum = MaxRecCnt;
if (currRecIndex < MaxRecCnt && currRecIndex > 1)
{
currRecIndex = currRecIndex - 1;
}
else if (currRecIndex == MaxRecCnt && MaxRecCnt > 1)
{
currRecIndex = currRecIndex; //currRecIndex - 1;
}
else if (currRecIndex < MaxRecCnt && currRecIndex == 1)
{
currRecIndex = currRecIndex + 1;
}
else if (currRecIndex > MaxRecCnt)//New condition on 13th Sep 2011
{
currRecIndex = MaxRecCnt;
}
blValidComp = true;
numGotoRecord.Value = currRecIndex;
btnAddCompound.Enabled = true;
MessageBox.Show("Compound deleted successfully", "ChemInform", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Error in compound delete", "ChemInform", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
public static bool DeleteCompoundDataOnID(CompoundInfo compInfo)
{
bool blStatus = false;
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = oraCon;
oraCon.Open();
oraCmd.CommandText = "DELETE_COMPOUND_DATA";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_COMP_ID", OracleDbType.Int32).Value = compInfo.CompoundID;
oraCmd.ExecuteNonQuery();
oraCon.Close();
blStatus = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(blStatus);
}
public static DataSet GetCompoundDataOnID(CompoundInfo compInfo)
{
DataSet dsCompData = null;
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = oraCon;
oraCmd.CommandText = "GET_COMPOUND_DATA";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_COMP_ID", OracleDbType.Int32).Value = compInfo.CompoundID;
oraCmd.Parameters.Add("PORC_COMP", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
dsCompData = new DataSet();
OracleDataAdapter oraAdpt = new OracleDataAdapter(oraCmd);
oraAdpt.Fill(dsCompData);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(dsCompData);
}
private static CompoundInfo GetCompoundInfoFromTable(DataTable compoundData)
{
CompoundInfo objCompInfo = null;
try
{
if (compoundData != null)
{
List <CompoundInfo> lstCompoundInfo = new List <CompoundInfo>();
if (compoundData.Rows.Count > 0)
{
lstCompoundInfo = (from p in compoundData.AsEnumerable()
select new CompoundInfo
{
Compound = p.Field <object>("COMPOUND_STRUCTURE"),
CompoundNo = p.Field <string>("COMPOUND_NO"),
IUPACName = p.Field <string>("IUPAC_NAME"),
MolFormula = p.Field <string>("MOLECULE_FORMULA"),
MolWeight = p.Field <string>("MOLECULE_WEIGHT"),
PageNo = p.Field <string>("PAGE_NO"),
Comments = p.Field <string>("COMMENTS"),
Synonyms = p.Field <string>("SYSNONYMS")
}).ToList();
objCompInfo = lstCompoundInfo[0];
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
return(objCompInfo);
}
private bool ValidateAndSaveCompoundData()
{
bool blStatus = false;
try
{
string strErrMsg = "";
//Validate Spectral curation controls
if (ValidateUserInputs(ref strErrMsg))
{
//Save Compound Information
CompoundInfo objCompInfo = ucSpectral.GetCompoundInformation();
if (objCompInfo != null)
{
SpectralCurationDB.UpdateCompoundInformation(objCompInfo, GlobalVariables.LogInUserInfo);
}
//Save NMR Spectral Information
List <NMRSpectralInfo> lstNMRSpectrals = ucSpectral.GetNMRSpectralInformation();
if (lstNMRSpectrals != null)
{
for (int i = 0; i < lstNMRSpectrals.Count; i++)
{
SpectralCurationDB.UpdateNMRSpectralInformation(lstNMRSpectrals[i], GlobalVariables.LogInUserInfo);
}
}
//Save Other Spectral Information
List <OtherSpectralInfo> lstOtherSpectrals = ucSpectral.GetOtherSpectralInformation();
if (lstOtherSpectrals != null)
{
for (int i = 0; i < lstOtherSpectrals.Count; i++)
{
SpectralCurationDB.UpdateOtherSpectralInformation(lstOtherSpectrals[i], GlobalVariables.LogInUserInfo);
}
}
blStatus = true;
}
else
{
MessageBox.Show(strErrMsg.Trim(), "ChemInform", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
return(blStatus);
}
private bool GetCompoundDataFromTableAndBindToControls(int recordIndex)
{
bool blStatus = false;
try
{
if (recordIndex >= 0)
{
if (DocCompounds != null)
{
if (DocCompounds.Rows.Count > 0)
{
ucSpectral.txtCompNo.Text = recordIndex.ToString();
int intCompId = 0;
if (int.TryParse(DocCompounds.Rows[recordIndex]["COMPOUND_ID"].ToString(), out intCompId))
{
CompoundInfo objCompInfo = new CompoundInfo();
objCompInfo.CompoundID = intCompId;
DataSet dsCompData = Dal.SpectralCurationDB.GetCompoundDataOnID(objCompInfo);
if (dsCompData != null)
{
SpectralInfo objSpectralInfo = ConvertToUserDefinedLists.ConvertToSpectralData(dsCompData);
if (objSpectralInfo != null)
{
////Bind Artilce information
//BindArticleInformationToControls(objSpectralInfo.ArticleInformation);
//Bind Spectral information
ucSpectral.BindSpectralInfoToControls(objSpectralInfo);
}
}
}
}
}
blStatus = true;
return(blStatus);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
return(blStatus);
}
private void BindCompoundDataToControls(CompoundInfo compData)
{
try
{
if (compData != null)
{
txtCompNo.Text = compData.CompoundNo;
txtMolFormula.Text = compData.MolFormula;
txtMolWeight.Text = compData.MolWeight;
txtIUPAC.Text = compData.IUPACName;
txtPageLabel.Text = compData.PageNo;
txtComments.Text = compData.Comments;
txtSynonyms.Text = compData.Synonyms;
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
public static bool UpdateCompoundInformation(CompoundInfo compInfo, UserInfo usrInfo)
{
bool blStatus = false;
try
{
using (OracleConnection oraCon = ConnectionDB.GetOracleConnection())
{
using (OracleCommand oraCmd = new OracleCommand())
{
oraCmd.Connection = oraCon;
oraCmd.CommandText = "SAVE_COMPOUND_DATA";
oraCmd.CommandType = CommandType.StoredProcedure;
oraCmd.Parameters.Add("PIN_COMP_ID", OracleDbType.Int32).Value = compInfo.CompoundID;
oraCmd.Parameters.Add("PIC_COMP_NO", OracleDbType.Varchar2).Value = compInfo.CompoundNo;
oraCmd.Parameters.Add("PIC_COMPOUND", OracleDbType.NVarchar2).Value = compInfo.Compound;
oraCmd.Parameters.Add("PIC_IUPAC", OracleDbType.NVarchar2).Value = compInfo.IUPACName;
oraCmd.Parameters.Add("PIC_INCHI_KEY", OracleDbType.Varchar2).Value = compInfo.InchiKey;
oraCmd.Parameters.Add("PIC_MOL_FORMULA", OracleDbType.Varchar2).Value = compInfo.MolFormula;
oraCmd.Parameters.Add("PIC_MOL_WEIGHT", OracleDbType.Varchar2).Value = compInfo.MolWeight;
oraCmd.Parameters.Add("PIC_PAGE_NO", OracleDbType.Varchar2).Value = compInfo.PageNo;
oraCmd.Parameters.Add("PIC_SYNONYMS", OracleDbType.Varchar2).Value = compInfo.Synonyms;
oraCmd.Parameters.Add("PIC_COMMENTS", OracleDbType.Varchar2).Value = compInfo.Comments;
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 List <object> CostListGrid()
{
List <object> listObj = new List <object>();
CompoundInfo info = null;
int amount = 0;
if (mCurGem != null)
{
amount = mCurGem.level < 9 ? 3 : 0;
}
for (int i = 0; i < amount; i++)
{
info = new CompoundInfo();
info.m_gem = select_gem;
info.m_select = select_gem == null ? 0 : 1;
listObj.Add(info);
}
return(listObj);
}
public CompoundInfo GetCompoundInformation()
{
CompoundInfo objCompInfo = null;
try
{
objCompInfo = new CompoundInfo();
objCompInfo.Compound = ChemRenditor.MolfileString;
objCompInfo.CompoundNo = txtCompNo.Text.Trim();
objCompInfo.CompoundLabel = txtCompLabel.Text.Trim();
objCompInfo.MolFormula = txtMolFormula.Text.Trim();
objCompInfo.MolWeight = txtMolWeight.Text.Trim();
objCompInfo.IUPACName = txtIUPAC.Text.Trim();
objCompInfo.PageNo = txtPageLabel.Text.Trim();
objCompInfo.Synonyms = txtSynonyms.Text.Trim();
objCompInfo.InchiKey = ChemistryOperations.GetStructureInchiKey(ChemRenditor.MolfileString);
objCompInfo.Comments = txtComments.Text.Trim();
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
return(objCompInfo);
}
public SilacCompoundInfo(CompoundInfo light, CompoundInfo heavy)
{
this.light = light;
this.heavy = heavy;
}
