/// <summary>
/// Function to get values for search based on parameters
/// </summary>
/// <param name="strCurrencyname"></param>
/// <param name="dtDateFrom"></param>
/// <param name="dtDateTo"></param>
/// <returns></returns>
public List <DataTable> ExchangeRateSearch(String strCurrencyname, DateTime dtDateFrom, DateTime dtDateTo)
{
List <DataTable> listObj = new List <DataTable>();
try
{
listObj = SPExchangeRate.ExchangeRateSearch(strCurrencyname, dtDateFrom, dtDateTo);
}
catch (Exception ex)
{
MessageBox.Show("ERBll8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(listObj);
}
/// <summary>
/// Function to fill datagridview
/// </summary>
public void GridFill()
{
try
{
ExchangeRateSP spExchangeRaterate = new ExchangeRateSP();
DataTable dtbl = new DataTable();
dtbl = spExchangeRaterate.ExchangeRateSearch(cmbCurrencyRate.Text.ToString(), Convert.ToDateTime(txtDatefrom.Text.ToString()), Convert.ToDateTime(txtDateTo.Text.ToString()));
dgvExchangeRate.DataSource = dtbl;
}
catch (Exception ex)
{
MessageBox.Show("ER9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}