public IEnumerable <SolutionRunDate> GetRunDate()
{
//var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
var connectionString = CoreContext.GetDataConnection();
var solutionrundates = new List <SolutionRunDate>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_getarchiverundate", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var solutionrundate = new SolutionRunDate();
if (reader["AchRunDate"] != DBNull.Value)
{
solutionrundate.RunDate = DateTime.Parse(reader["AchRunDate"].ToString());
}
solutionrundates.Add(solutionrundate);
}
con.Close();
}
return(solutionrundates);
}
public void UploadData(string actionName, SqlParameter [] parameters)
{
SqlDataManager.RunProcedure(CoreContext.GetDataConnection(), actionName, parameters);
}
