public IActionResult About()
{
List <holidayModel> holidays = new List <holidayModel>();
var request = (HttpWebRequest)WebRequest.Create("https://holidayapi.com/v1/holidays?pretty&key=bb4b77e1-0cc2-47d9-872e-483b2449ba44&country=DE&year=2020");
request.Method = "GET";
using (var response = (HttpWebResponse)request.GetResponse())
{
using (var stream = response.GetResponseStream())
{
using (var sr = new StreamReader(stream))
{
var content = sr.ReadToEnd();
dynamic holidayInfo = JsonConvert.DeserializeObject(content);
var holidayName = holidayInfo.holidays[0].name;
foreach (var holiday in holidayInfo.holidays)
{
holidayModel hm = new holidayModel();
hm.Name = holiday.name;
hm.Date = holiday.date;
hm.Observed = holiday.observed;
// hm.Weekday = holiday.weekday.date.name;
holidays.Add(hm);
}
}
}
}
ViewBag.h = holidays;
return(View());
}
public holidayMasterModel master(holidayModel value)
{
holidayMasterModel result = new holidayMasterModel();
try
{
using (var context = new StandardCanEntities())
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
string sql = "select convert(nvarchar(4), year(mhd_date)) code ";
sql += " , convert(nvarchar(4), year(mhd_date)) [text] ";
sql += " from MAS_HOLIDAY ";
sql += " group by year(mhd_date) ";
sql += " order by year(mhd_date) ";
result.year = context.Database.SqlQuery <dropdown>(sql).ToList();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(result);
}
// POST api/<controller>
public HttpResponseMessage Post([FromBody] holidayModel value)
{
if (value == null)
{
return(null);
}
JavaScriptSerializer js = new JavaScriptSerializer();
holidayService service = new holidayService();
HttpResponseMessage response = null;
Object result = null;
switch (value.method)
{
case "master":
result = service.master(value);
break;
case "search":
result = service.search(value);
break;
case "calendarHoliday":
result = service.calendarHoliday(value);
break;
case "getHoliday":
result = service.getHoliday(value);
break;
case "getSchedule":
result = service.getSchedule(value);
break;
default:
break;
}
string json = js.Serialize(result);
response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json");
return(response);
}
public IEnumerable <sp_mb_get_holiday_Result> getHoliday(holidayModel value)
{
try
{
//if (String.IsNullOrEmpty(value.user_id))
//{
// throw new Exception("Unauthorized Access");
//}
//var userId = JwtHelper.GetUserIdFromToken(value.user_id);
//if (String.IsNullOrEmpty(userId))
//{
// throw new Exception("Unauthorized Access");
//}
StandardCanEntities context = new StandardCanEntities();
IEnumerable <sp_mb_get_holiday_Result> result = context.sp_mb_get_holiday().AsEnumerable();
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public IEnumerable <sp_holiday_search_Result> search(holidayModel value)
{
try
{
if (String.IsNullOrEmpty(value.user_id))
{
throw new Exception("Unauthorized Access");
}
var userId = JwtHelper.GetUserIdFromToken(value.user_id);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
StandardCanEntities context = new StandardCanEntities();
IEnumerable <sp_holiday_search_Result> result = context.sp_holiday_search(value.year).AsEnumerable();
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void Form1_Load(object sender, EventArgs e)
{
string url = string.Format("https://fangjia.51240.com/{0}__fangjia/", DateTime.Now.Year);
timerGetYearHoliday.Enabled = true;
HtmlNodeCollection aa = GetHtmlNode(url, "//table");
if (aa != null)
{
List <holidayModel> mylist = new List <holidayModel>();
holidayModel mymodel = null;
Regex regex = new Regex(@"<td>((\w|[、（）()~])*)</td>", RegexOptions.IgnoreCase);
MatchCollection matchlist = regex.Matches(aa[0].InnerHtml);
for (int i = 0; i < matchlist.Count; i += 3)
{
mymodel = new holidayModel();
mymodel.休息 = matchlist[i].Groups[1].Value;
mymodel.调休 = matchlist[i + 1].Groups[1].Value;
mymodel.放假天数 = matchlist[i + 2].Groups[1].Value;
mylist.Add(mymodel);
}
dataGridView1.DataSource = mylist;
}
}
