public IHttpActionResult GetQAFromDateTimeOLDWAY(string date, string time) { string xdate = "2-15-2017"; string xtime = "11"; string timeExt = ":00"; string combinedTime = date + ' ' + time + timeExt; string sprocName = "GetQAListByDateTime"; var qaLists = new List <QAList>(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["qaList"])) { try { using (SqlDataAdapter da = new SqlDataAdapter()) { da.SelectCommand = new SqlCommand(sprocName, conn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@datetime", SqlDbType.DateTime).Value = combinedTime; DataSet ds = new DataSet(); da.Fill(ds, "qaList"); DataTable dt = ds.Tables["qaList"]; foreach (DataRow row in dt.Rows) { var qaList = new QAList { Agent = CommonUtilities.ConvertFromDbVal <string>(row["Agent"]).Trim(), Calldate = CommonUtilities.ConvertFromDbVal <DateTime>(row["Calldate"]), CallLength = CommonUtilities.ConvertFromDbVal <int>(row["CallLength"]), ClientName = CommonUtilities.ConvertFromDbVal <string>(row["ClientName"]), InboundCall = CommonUtilities.ConvertFromDbVal <string>(row["InboundCall"]), OutboundCall = CommonUtilities.ConvertFromDbVal <string>(row["OutboundCall"]), CreatedDateTime = CommonUtilities.ConvertFromDbVal <DateTime>(row["CreatedDateTime"]) }; qaLists.Add(qaList); } if (qaLists.Any() == false) { return(NotFound()); } } } catch (SqlException ex) { } catch (Exception e) { throw; } } return(Ok(qaLists)); }