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