//[Route("teamstructurebyselection/{selectedcode}/{selectedyear}/{selectedlevel}")] public HttpResponseMessage RunDate2(HttpRequestMessage request, string yearstring) { HttpResponseMessage res = null; //var newList = new List<string>(); List <rundateModel> newList = new List <rundateModel>(); string mislevel = Convert.ToString(System.Web.HttpContext.Current.Session["session_loggedinmislevel"]); using (var con = new SqlConnection(connectionString)) { var cmd = new SqlCommand("mpr_volume_analysis_rundates_v2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.Add(new SqlParameter { ParameterName = "Year", Value = yearstring, }); cmd.Parameters.Add(new SqlParameter { ParameterName = "MISCode", Value = mislevel, }); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { rundateModel cap = new rundateModel(); DateTime d = reader["rundate"] != DBNull.Value ? (Convert.ToDateTime(reader["rundate"].ToString())).Date : Convert.ToDateTime("19-01-01"); cap.RunDate = d.ToString("yyyy-MM-dd"); newList.Add(cap); } con.Close(); } // using res = request.CreateResponse <IEnumerable>(HttpStatusCode.OK, newList); return(res); }
//[Route("teamstructurebyselection/{selectedcode}/{selectedyear}/{selectedlevel}")] public HttpResponseMessage RunDate(HttpRequestMessage request, string yearstring) { HttpResponseMessage res = null; //var newList = new List<string>(); List <rundateModel> newList = new List <rundateModel>(); using (var con = new SqlConnection(connectionString)) { var cmd = new SqlCommand("dropdown_dailydate2", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; cmd.Parameters.Add(new SqlParameter { ParameterName = "Year", Value = yearstring, }); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { rundateModel cap = new rundateModel(); //var cap = reader["MainCaption"] != DBNull.Value ? reader["MainCaption"].ToString() : "null"; //cap.RunDate = reader["date"] != DBNull.Value ? (Convert.ToDateTime(reader["date"].ToString())).Date : Convert.ToDateTime("19-01-01"); DateTime d = reader["date"] != DBNull.Value ? (Convert.ToDateTime(reader["date"].ToString())).Date : Convert.ToDateTime("19-01-01"); cap.RunDate = d.ToString("yyyy-MM-dd"); //exProg.EstimatedTimeString = progressInfo.Select(x => x.EstimatedTime).FirstOrDefault().ToString("yyyy-MM-dd"); newList.Add(cap); } con.Close(); } // using res = request.CreateResponse <IEnumerable>(HttpStatusCode.OK, newList); return(res); }