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