/// <summary>
/// Qso Update
/// </summary>
/// <param name="QSOs"></param>
public void QsoUpdate(ERAD.DataSetErad.QSOSDataTable QSOs)
{
try
{
m_DataAdapterQSO.Update(QSOs);
}
catch (Exception Chyba)
{
MessageBox.Show("Spojení nebyla uložena do databáze!\n\n" + Chyba.Message, "QSO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
/// Fill table Qsos
/// </summary>
/// <param name="QSOs"></param>
/// <param name="FolderID"></param>
/// <param name="filtr"></param>
public void QsoFill(ERAD.DataSetErad.QSOSDataTable QSOs, int FolderID, string filtr)
{
try
{
m_DataAdapterQSO.SelectCommand.CommandText = String.Format("SELECT * FROM QSOS WHERE QsoFolder = @QsoFolder AND ( {0} ) ORDER BY QsoDate DESC", filtr);
m_DataAdapterQSO.SelectCommand.Parameters["@QsoFolder"].Value = FolderID;
m_DataAdapterQSO.Fill(QSOs);
}
catch (InvalidCastException Chyba)
{
MessageBox.Show(Chyba.Message);
}
}
/// <summary>
/// Fill table Qsos
/// </summary>
/// <param name="QSOs"></param>
/// <param name="FolderID"></param>
public void QsoFill(ERAD.DataSetErad.QSOSDataTable QSOs, int FolderID)
{
try
{
m_DataAdapterQSO.SelectCommand.CommandText = QsoSelectStandard;
m_DataAdapterQSO.SelectCommand.Parameters["@QsoFolder"].Value = FolderID;
m_DataAdapterQSO.Fill(QSOs);
}
catch (InvalidCastException Chyba)
{
MessageBox.Show(Chyba.Message);
}
}
/// <summary>
/// Fill table Qsos
/// </summary>
/// <param name="QSOs"></param>
/// <param name="StationCall"></param>
public void QsoFill(ERAD.DataSetErad.QSOSDataTable QSOs, string StationCall)
{
QSOs.Rows.Clear();
m_DataAdapterQSO.SelectCommand.Parameters["@StationCall"].Value = StationCall;
m_DataAdapterQSO.Fill(QSOs);
}