//
// GET: /Calendar/
public ActionResult Index()
{
ViewBag.Message = "Calendar";
CalendarModel c = new CalendarModel();
c.populateLists();
return View(c);
}
public ActionResult DeleteEvent(CalendarModel c)
{
int EventID = Int32.Parse(c.currentEventID);
string UserID = User.Identity.GetUserId();
if (UserID != null) {
MySqlConnection db = new MySqlConnection();
db.CreateConn();
SqlCommand cmd = new SqlCommand("DeleteCalendarEvent", db.Connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserId", UserID));
cmd.Parameters.Add(new SqlParameter("@EventId", EventID));
db.Command = cmd;
db.Command.Prepare();
db.Command.ExecuteNonQuery();
}
return RedirectToAction("Index");
}
/// <summary>
/// Translates the various time forms from the view into two DateTime variables, the data then gets passed to the InsertEvent function.
/// </summary>
/// <param name="c"></param>
/// <param name="EventName"></param>
/// <param name="EventDescription"></param>
/// <param name="EventStart"></param>
/// <param name="EventEnd"></param>
/// <returns></returns>
public ActionResult TranslateEventTime(CalendarModel c, string EventName, string EventDescription, string EventStart, string EventEnd)
{
// Translating user input into event start datetime variable
int startHour = c.startHourVal;
string startHourText;
if (startHour.ToString().Length == 1) {
startHourText = "0" + startHour.ToString();
} else {
startHourText = startHour.ToString();
}
if (c.startTimeframeText == null) {
c.startTimeframeText = "AM";
}
if (c.startMinuteText == null) {
c.startMinuteText = "00";
}
if (c.startTimeframeText == "PM" && startHour != 12) {
startHour += 12;
startHourText = startHour.ToString();
}
if (startHour == 12 && c.startTimeframeText == "AM") {
startHourText = "00";
}
var startTime = startHourText + ":" + c.startMinuteText + ":00";
startTime = EventStart + " " + startTime;
// Translating user input into event end datetime variable
int endHour = c.endHourVal;
string endHourText;
if (endHour.ToString().Length == 1) {
endHourText = "0" + endHour.ToString();
} else {
endHourText = endHour.ToString();
}
if (c.endTimeframeText == null) {
c.endTimeframeText = "AM";
}
if (c.endMinuteText == null) {
c.endMinuteText = "00";
}
if (c.endTimeframeText == "PM" && endHour != 12) {
endHour += 12;
endHourText = endHour.ToString();
}
if (endHour == 12 && c.endTimeframeText == "AM") {
endHourText = "00";
}
var endTime = endHourText + ":" + c.endMinuteText + ":00";
endTime = EventEnd + " " + endTime;
// Validate the start time and endtime to make sure they are actually dates in a calendar.
DateTime dtStart;
DateTime dtEnd;
if (DateTime.TryParseExact(startTime, "yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None, out dtStart) == true &&
DateTime.TryParseExact(endTime, "yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.None, out dtEnd) == true) {
if (dtStart != dtEnd) {
InsertEvent(EventName, EventDescription, dtStart, dtEnd);
}
}
return RedirectToAction("Index");
}