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); }