// Button 'Week' in the room section // Display room reservation for this week private void buttonDisplayRoomWeek_Click(object sender, EventArgs e) { // Find this weeks start date and convert to readable format for MySQL DateTime datefrom = CalculateDate.GetFirstDayOfWeek(DateTime.Today); DateTime dateto = datefrom.AddDays(7); // Fetch dataset DataSet roomreservationDS = DBGetData.GetRoomBookingDGVBetweenDates(datefrom, dateto); if (roomreservationDS != null) { // No tables fetched if (roomreservationDS.Tables.Count == 0) { new StatusMessage("No datatable found, contact administrator."); return; } // No rows fetched else if (roomreservationDS.Tables[0].Rows.Count == 0) { new StatusMessage("No datarows found for this week."); return; } // Clear labelStatus for previous messages else { new StatusMessage(""); } // Set the dataset as source for datagridview and make sure its displayed dataGridViewRoom.DataSource = roomreservationDS; dataGridViewRoom.DataMember = "Get_RR_BetweenDates"; LoadDataGridViewRoom(); } }
// // GET: /Button/ public ActionResult Index() { CalculateDate calDate = new CalculateDate(new DateTime(2016, 04, 16, 11, 0, 0), DateTime.Now); ViewBag.View = calDate.ToString(); return(View()); }
public void CanStandariseAndCalculateDateFromString() { var date = CalculateDate.StringToDate("31-01/2016", ".", "/", "-"); Assert.AreEqual(date.Year, 2016); Assert.AreEqual(date.Month, 1); Assert.AreEqual(date.Day, 31); }
public void CanCalculateDateFromString() { var date = CalculateDate.StringToDate("31.01.2016", "."); Assert.AreEqual(date.Year, 2016); Assert.AreEqual(date.Month, 1); Assert.AreEqual(date.Day, 31); }
public ActionResult Edit([Bind(Include = "Id,Name,SurveyDate,NewPart,SummaryTitle")] SurveyTemplate surveyTemplate) { if (ModelState.IsValid) { var surveyDate = Request["SurveyDate1"]; surveyTemplate.SurveyDate = CalculateDate.StringToDate(surveyDate, ".", "/", "-"); ISaveModel <SurveyTemplate> saveSurveyTemplate = new SaveSurveyTemplate <SurveyTemplate>(); saveSurveyTemplate.Save(surveyTemplate, db); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,UserId,TeamId,PositionId,FirstName,LastName,HireDate")] Employee employee) { var hireDate = Request["HireDate1"]; employee.HireDate = CalculateDate.StringToDate(hireDate, ".", "/", "-"); IViewBagLoader viewBagLoader = new EmployeeEditViewBagLoader(); viewBagLoader.Load(this, _db); if (ModelState.IsValid) { _db.Entry(employee).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }
public ActionResult Create([Bind(Include = "Id,Name,SurveyDate")] SurveyTemplate surveyTemplate) { var surveyDate = Request["SurveyDate1"]; surveyTemplate.SurveyDate = CalculateDate.StringToDate(surveyDate, ".", "/", "-"); if (ModelState.IsValid) { if (surveyTemplate.PublishDate.Year < 1900) { surveyTemplate.PublishDate = new DateTime(1900, 1, 1); } db.T_SurveyTemplate.Add(surveyTemplate); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(surveyTemplate)); }
public JsonResult Get(string startDate, string endDate) { var result = Validate(startDate, endDate); LogData(startDate, endDate); CalculateDate a = new CalculateDate(); int resultDay = a.calculate(startDate, endDate); if (result == "ok") { var response = new { day = resultDay }; return(new JsonResult(response)); } else { return(new JsonResult(result)); } }