public ActionResult Index()
{
int id_item_user = GetIdItemUser();
if (id_item_user == 0)
{
return(RedirectToAction("Login", "Account", new { ReturnUrl = "/TimeTable" }));
}
ViewBag.UserFullName = db.FormItemFields.SingleOrDefault(fif => fif.id_item == id_item_user && fif.id_fcontrol == 2).strvalue;
TimeTableViewModel[] days = new TimeTableViewModel[5];
for (int day = 1; day <= 5; day++)
{
days[day - 1] = GetDay(id_item_user, day);
}
if (Request.IsAjaxRequest())
{
return(PartialView("_DayList", days));
}
else
{
ViewBag.TimeTableUrl = GetTimeTableURL();
return(View(days));
}
}
// GET: TimeTable
public ActionResult Index(int?uid)
{
int id_item_user = uid ?? 0;
if (id_item_user != 0)
{
ViewBag.UserFullName = db.FormItemFields.SingleOrDefault(fif => fif.id_item == id_item_user && fif.id_fcontrol == 2).strvalue;
}
else
{
ViewBag.UserFullName = "";
}
TimeTableViewModel[] days = new TimeTableViewModel[5];
for (int day = 1; day <= 5; day++)
{
days[day - 1] = GetDay(id_item_user, day);
}
if (ControllerContext.IsChildAction)
{
return(PartialView(days));
}
else
{
ViewBag.ddlUser = new SelectList(db.Staff.OrderBy(s => s.PRIJMENI), "id_item", "Jmeno", uid);
return(View(days));
}
}
public async Task <IActionResult> Create(int?CoupleCount)
{
TimeTableViewModel model = new TimeTableViewModel();
if (CoupleCount != null && CoupleCount > 0)
{
model.Audiences = await _context.Audiences.ToListAsync();
model.Disciplines = await _context.Disciplines.ToListAsync();
model.Groups = await _context.Groups.ToListAsync();
model.Teachers = await _userManager.GetUsersInRoleAsync("преподаватель");
//for (int i = 0; i < CoupleCount; i++)
//{
// model.TimeTableGroup.Couples.Add(new Couple());
// for (int j = 0; j < 2; j++)
// {
// model.TimeTableGroup.Couples.ElementAt(i).Lessons.Add(new Lesson());
// }
//}
for (int i = 0; i < CoupleCount * 2; i++)
{
model.Lessons.Add(new LessonViewModel());
}
}
return(View(model));
}
public IView CreateView(string type, string id)
{
IView view = null;
IController controller = null;
IModel model = null;
switch (type)
{
case TrainTimeTableConst.TrainTimeTableView:
view = new TrainTimeTableView();
view.ViewType = TrainTimeTableConst.TrainTimeTableView;
controller = new TimeTableViewController();
model = new TimeTableViewModel();
controller.Attach(model, view);
break;
case TrainTimeTableConst.TimeTableWindowView:
view = new TimeTableWindow();
view.ViewType = TrainTimeTableConst.TimeTableWindowView;
controller = new TimeTableWindowController();
model = new TimeTableWindowModel();
controller.Attach(model, view);
break;
default:
break;
}
view.ViewID = id;
return(view);
}
public ActionResult EditTimeTableEvents(Guid id)
{
TimeTableDTO timeTableDto = _timeTableService.GetTimeTableDTOById(id);
TimeTableViewModel timeTableViewModel = _mapper.Map <TimeTableDTO, TimeTableViewModel>(timeTableDto);
return(View(timeTableViewModel));
}
public IActionResult GetEvents()
{
var events = new List <TimeTableViewModel>();
var timeTableView = new TimeTableViewModel();
var bookings = this._context.Bookings.ToList().OrderByDescending(b => b.UpdatedAt);
foreach (var item in bookings)
{
timeTableView.BookingId = item.Id;
timeTableView.ServiceId = item.ServiceId;
timeTableView.Service = this._context.Services.FirstOrDefault(ss => ss.Id == item.ServiceId);
timeTableView.UserName = item.UserName;
timeTableView.Title = item.Title;
timeTableView.Description = item.Description;
timeTableView.Price = item.Price;
timeTableView.BookingStatus = item.BookingStatus;
timeTableView.PaymentType = item.PaymentType;
timeTableView.ServiceType = item.ServiceType;
timeTableView.VehicleType = item.VehicleType;
timeTableView.UserName = item.UserName;
timeTableView.PhoneNumber = item.PhoneNumber;
timeTableView.Email = item.Email;
timeTableView.Start = item.UpdatedAt.ToString();
timeTableView.End = item.Time;
events.Add(timeTableView);
}
//string json = JsonConvert.SerializeObject(events);
return(new JsonResult(JsonConvert.SerializeObject(events)));
}
public TimeTableView()
{
stud = eFStudent.GetStudentById((int)user.idStudent);
InitializeComponent();
timeTableViewModel = new TimeTableViewModel();
LoadTimeTableIfEmpty();
LoadGroupsId();
}
public TimeTable()
{
InitializeComponent();
/*var tb = new TimeTableViewModel();
* DataContext = tb;
* var c = grid.DataContext;*/
DataContext = new TimeTableViewModel();
}
private void __ShowTimeTableWindow(Station Station)
{
IsTimeTableDropDownOpen = false;
var Window = new TimeTableView(Station.ShortSymbol);
var VM = new TimeTableViewModel(Window.Dispatcher, Station);
__OpenChildWindow(Window, VM);
}
private TimeTableViewModel GetDay(int id_item_user, int day)
{
TimeTableViewModel timeTableViewModel = new TimeTableViewModel();
string sid_item_user = id_item_user.ToString();
string sday = day.ToString();
timeTableViewModel.Day = day;
var item = db.FormItems
.SingleOrDefault(fi => fi.FormItemFields.Any(fif => fif.id_fcontrol == 11 && fif.strvalue == sid_item_user) &&
fi.FormItemFields.Any(fif => fif.id_fcontrol == 13 && fif.strvalue == sday));
int id_item = 0;
if (item != null)
{
id_item = item.id_item;
}
if (id_item != 0)
{
timeTableViewModel.Hours = db.FormItemFields
.Where(fif => fif.id_item == id_item && fif.id_fcontrol >= 14 && fif.id_fcontrol <= 27)
.OrderBy(fif => fif.id_fcontrol)
.AsEnumerable()
.Select((fif, h) =>
{
string val = fif.strvalue.Replace(" ", "");
string[] tmp = val.Split('|');
if (tmp.Length == 2)
{
return(new TimeTableHour {
Text = tmp[0], Type = Int32.Parse(tmp[1])
});
}
else
{
return(new TimeTableHour {
Text = val, Type = (h > 1 && h < 7 ? 4 : 0)
});
}
})
.ToArray();
}
if (timeTableViewModel.Hours == null || timeTableViewModel.Hours.Length == 0)
{
timeTableViewModel.Hours = Enumerable.Range(0, 14).Select(h => new TimeTableHour {
Text = "", Type = (h > 1 && h < 7 ? 4 : 0)
}).ToArray();
}
return(timeTableViewModel);
}
public string AddUpdateTimeTable(TimeTableViewModel objTimeTable)
{
if (objTimeTable.DateType == "single")
{
objTimeTable.ToDate = objTimeTable.FromDate;
}
foreach (DateTime day in EachDay(Convert.ToDateTime(objTimeTable.FromDate), Convert.ToDateTime(objTimeTable.ToDate)))
{
List <SqlParameter> sqlParameterList = new List <SqlParameter>();
sqlParameterList.Add(new SqlParameter("TimeTableID", objTimeTable.TimeTableID));
sqlParameterList.Add(new SqlParameter("Description", !string.IsNullOrEmpty(objTimeTable.Description) ? objTimeTable.Description : string.Empty));
sqlParameterList.Add(new SqlParameter("TimeTableDate", day.Date));
sqlParameterList.Add(new SqlParameter("ShiftID", objTimeTable.ShiftID));
sqlParameterList.Add(new SqlParameter("SessionID", objTimeTable.SessionID));
sqlParameterList.Add(new SqlParameter("BatchID", string.Join(",", objTimeTable.BatchID)));
sqlParameterList.Add(new SqlParameter("LectureID", string.Join(",", objTimeTable.LectureID)));
sqlParameterList.Add(new SqlParameter("IsActive", true));
sqlParameterList.Add(new SqlParameter("CreatedByUserID", 1));
sqlParameterList.Add(new SqlParameter("CreatedOnDate", DGeneric.SystemDateTime));
int TimeTableID = Convert.ToInt32(DGeneric.RunSP_ReturnScaler("sp_AddUpdateTimeTable", sqlParameterList));
if (TimeTableID > 0)
{
for (int i = 0; i < objTimeTable.LectureList.Count; i++)
{
objTimeTable.LectureList[i].TimeTableID = TimeTableID;
objTimeTable.LectureList[i].FacultyID = objTimeTable.LectureList[i].FacultyID;
objTimeTable.LectureList[i].CreatedByUserID = 1;
objTimeTable.LectureList[i].CreatedOnDate = DGeneric.SystemDateTime;
objTimeTable.LectureList[i].IsActive = true;
objTimeTable.LectureList[i].Time_From = objTimeTable.LectureList[i].Lecture.Time_From;
objTimeTable.LectureList[i].Time_To = objTimeTable.LectureList[i].Lecture.Time_To;
objTimeTable.LectureList[i].BatchID = objTimeTable.LectureList[i].Batch.BatchID;
objTimeTable.LectureList[i].LectureID = objTimeTable.LectureList[i].Lecture.LectureID;
}
DataTable dt = DGeneric.ListToDataTable(objTimeTable.LectureList);
dt.Columns.Remove("Batch");
dt.Columns.Remove("Lecture");
dt.Columns.Remove("Faculty");
dt.Columns.Remove("ID");
List <SqlParameter> sqlParameterList1 = new List <SqlParameter>();
sqlParameterList1.Add(new SqlParameter("@TimeTableID", TimeTableID));
DGeneric.RunSP_ExecuteNonQuery("sp_DeleteLecture", sqlParameterList1);
List <SqlParameter> sqlParameterList2 = new List <SqlParameter>();
sqlParameterList2.Add(new SqlParameter("@LectureDetails", dt));
string LectureID = DGeneric.RunSP_ReturnScaler("sp_AddLecture", sqlParameterList2);
}
}
return("Success");
}
private void BtnGetTimetable_Click(object sender, RoutedEventArgs args)
{
TimeTableViewModel vm = DataContext as TimeTableViewModel;
try
{
vm.GetTimeTable();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
public string AddUpdateTimeTable(TimeTableViewModel objTimeTable)
{
var timeTableData = _iDTimeTable.AddUpdateTimeTable(objTimeTable);
if (!string.IsNullOrEmpty(timeTableData))
{
return(timeTableData);
}
else
{
return(timeTableData);
}
}
public ActionResult BuyTicket(TimeTableViewModel model)
{
var buyModel = new BuyTicketViewModel
{
Amount = model.Price * model.Quantity,
ArrivalStop = model.ArrivalStop,
DepartureDate = model.DepartureDate,
DepartureStop = model.DepartureStop,
TameTableId = model.TameTableId,
RouteId = model.RouteId,
Quantity = model.Quantity
};
return(View(buyModel));
}
public ActionResult AddTimeTable()
{
IEnumerable <GroupDTO> groupDtos = _timeTableService.GetGroups();
var groupViewModels = _mapper.Map <IEnumerable <GroupDTO>, List <GroupViewModel> >(groupDtos).Where(g => g.TimeTable == null);
ViewBag.GroupList = new SelectList(groupViewModels, "Id", "Name");
var newTimeTable = new TimeTableViewModel
{
Start = DateTime.Now,
End = DateTime.Now.AddMonths(1)
};
return(PartialView("_AddTimeTableFormPartial", newTimeTable));
}
public ActionResult Index()
{
List <WashTime> times = db.WashTimes.Where(x => x.Time.Year == DateTime.Today.Year).ToList();
List <WashTime> thisWeek =
times.Where(
time =>
HelperFunctions.GetIso8601WeekOfYear(time.Time) ==
HelperFunctions.GetIso8601WeekOfYear(DateTime.Today)
).OrderBy(f => f.Time.Date).ThenBy(f => f.Time.Hour).ThenBy(f => f.Machine
).GroupBy(
f => new { f.Time.Date, f.Time.Hour, f.Machine }
).Select(
group => group.First()
).ToList();
if (thisWeek.Count < (126 * 2))
{
FillWeek();
times = db.WashTimes.Where(x => x.Time.Year == DateTime.Today.Year).ToList();
thisWeek =
times.Where(
time =>
HelperFunctions.GetIso8601WeekOfYear(time.Time) ==
HelperFunctions.GetIso8601WeekOfYear(DateTime.Today)
).OrderBy(f => f.Time.Date).ThenBy(f => f.Time.Hour).ThenBy(f => f.Machine
).GroupBy(
f => new { f.Time.Date, f.Time.Hour, f.Machine }
).Select(
group => group.First()
).ToList();
}
TimeTableViewModel weekTableViewModel = new TimeTableViewModel(thisWeek)
{
User = GetBookingViewModel()
};
if (Request.IsAjaxRequest())
{
return(PartialView("Index", weekTableViewModel));
}
return(View(weekTableViewModel));
}
public static string TestOnWeb()
{
string myJsonString = "";
List <object> myList = new List <object>();
TimeTableViewModel t_table = new TimeTableViewModel("XYZ", "2018-07-01", "2018-07-02", "Y"); // SINCE EVERYTHING FAILED I AM TRYING WITH STATIC DATA
myList.Add(t_table);
myList.Add(new TimeTableViewModel("abc", "2018-07-08", "2018-07-09", "Z"));
myList.Add(new TimeTableViewModel("cde", "2018-07-11", "2018-07-14", "X"));
myJsonString = JsonConvert.SerializeObject(myList);
return(myJsonString);
}
public IHttpActionResult UpdateTimeTable([FromBody] TimeTableViewModel value)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_scheduleData.UpdateTimeTable(value);
return(Ok());
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IActionResult TimeTable(bool eventCheckbox, bool homeworkCheckbox)
{
ViewData["Message"] = "Страница с расписанием";
var model = new TimeTableViewModel(HttpContext.Request.Cookies);
if (!model.IsStudent)
{
return(Redirect("/"));
}
var date = DateTime.Now.Date;
while (date.DayOfWeek != DayOfWeek.Monday)
{
date -= new TimeSpan(1, 0, 0, 0);
}
if (!eventCheckbox && !homeworkCheckbox)
{
eventCheckbox = homeworkCheckbox = true;
}
if (eventCheckbox)
{
var events = DatabaseManager.GetMain().GetEventsByTime(date, date + new TimeSpan(14, 0, 0, 0));
foreach (var item in events)
{
CreateDayIfNotExists(model.Days, item.StartTime.Date);
model.Days[item.StartTime.Date].Events.Add(item);
}
}
if (homeworkCheckbox)
{
var homeworkList = DatabaseManager.GetMain().GetHomeworksByTime(model.UserID, date, date + new TimeSpan(365 * 2, 0, 0, 0));
foreach (var item in homeworkList)
{
CreateDayIfNotExists(model.Days, item.Deadline.Date);
model.Days[item.Deadline.Date].HomeWorks.Add(item);
}
}
model.EventChecked = eventCheckbox;
model.HomeworkChecked = homeworkCheckbox;
model.Days = model.Days.OrderBy(x => x.Key).ToDictionary(x => x.Key, y => y.Value);
return(View(model));
}
private void UpdateTT(string week)
{
if (stud.IsHeadman)
{
int course = Convert.ToInt32(Choose_course.SelectedValue);
int group = Convert.ToInt32(Choose_group.SelectedValue);
int subgroup = Convert.ToInt32(Choose_subgroup.SelectedValue);
timeTableViewModel.GetByWeekAdmin(week, course, group, subgroup);
DataContext = new TimeTableViewModel(course, group, subgroup, week);
//int idGroup = Convert.ToInt32(IdGroup.SelectedItem);
//timeTableViewModel.GetByWeek(week, idGroup);
//DataContext = new TimeTableViewModel(idGroup, week);
}
else
{
timeTableViewModel.GetByWeek(week, (int)stud.idGroup);
DataContext = new TimeTableViewModel((int)stud.idGroup, week);
}
}
public ActionResult AddTimeTable(TimeTableViewModel timeTableViewModel)
{
try
{
if (ModelState.IsValid)
{
GroupDTO groupDto = _timeTableService.GetGroupDTOById(new Guid(timeTableViewModel.GroupId));
TimeTableDTO timeTableDto = _mapper.Map <TimeTableViewModel, TimeTableDTO>(timeTableViewModel);
var timeTableId = _timeTableService.AddTimeTable(timeTableDto);
return(Json(new { success = true, id = timeTableId, GroupName = groupDto.Name }));
}
}
catch (ValidationException ex)
{
ViewBag.Error = ex.Message;
return(Json(new { success = false, errorMessage = ex.Message }));
}
return(PartialView("_AddTimeTableFormPartial", timeTableViewModel));
}
public JsonResult Edit(TimeTableViewModel timeTableToEdit)
{
var validationResult = _tableViewModelValidator.Validate(timeTableToEdit);
if (!validationResult.IsValid)
{
RecordValidationMessages(validationResult);
return(Json(new { result = validationResult.Errors }, JsonRequestBehavior.AllowGet));
}
try
{
var timetable = Mapper.Map <TimeTable>(timeTableToEdit);
_timeTableRepository.Update(timetable);
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { result = e.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Add(TimeTableViewModel timeTableToAdd)
{
var validationResult = _tableViewModelValidator.Validate(timeTableToAdd);
if (!validationResult.IsValid)
{
RecordValidationMessages(validationResult);
return(Json(new { result = validationResult.Errors.Select(x => x.ErrorMessage).ToList() }, JsonRequestBehavior.AllowGet));
}
try
{
var timetableToSave = Mapper.Map <TimeTable>(timeTableToAdd);
_timeTableRepository.Add(timetableToSave);
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { result = e.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EditTimeTable(TimeTableViewModel timeTableViewModel)
{
try
{
if (ModelState.IsValid)
{
TimeTableDTO timeTableDto = _mapper.Map <TimeTableViewModel, TimeTableDTO>(timeTableViewModel);
_timeTableService.UpdateTimeTable(timeTableDto);
return(Json(new { success = true }));
}
}
catch (ValidationException ex)
{
ViewBag.Error = ex.Message;
return(Json(new { success = false, errorMessage = ex.Message }));
}
return(PartialView("_EditTimeTableFormPartial", timeTableViewModel));
}
private void dataGrid_CellTapped(object sender, GridCellTappedEventArgs e)
{
int columnIndex = e.RowColumnIndex.ColumnIndex;
if (columnIndex == 0)
{
return;
}
var record = e.Record;
TimeTableViewModel vm = DataContext as TimeTableViewModel;
if ((record as table).tiet[columnIndex - 1] != null)
{
vm.selectedUsingClassID = (record as table).tiet[columnIndex - 1].Item1;
}
else
{
vm.selectedUsingClassID = "";
}
}
public Response <TimeTableViewModel> GetTimeTableByDate(TimeTableViewModel objTimeTable)
{
var timeTableData = _iDTimeTable.GetTimeTableByDate(objTimeTable);
if (timeTableData != null)
{
return(new Response <TimeTableViewModel>
{
IsSuccessful = true,
Object = timeTableData,
Message = "Success"
});
}
else
{
return(new Response <TimeTableViewModel>
{
IsSuccessful = false,
Message = "error",
Object = null
});
}
}
public HttpResponseMessage GetTimeTableByDate(TimeTableViewModel objTimeTable)
{
return(Request.CreateResponse(HttpStatusCode.OK, _iBTimeTable.GetTimeTableByDate(objTimeTable)));
}
public HttpResponseMessage AddUpdateTimeTable(TimeTableViewModel objTimeTable)
{
return(Request.CreateResponse(HttpStatusCode.OK, _iBTimeTable.AddUpdateTimeTable(objTimeTable)));
// return null;
}
public void AddTimeTable(TimeTableViewModel value)
{
var timeTableData = ObjectMapper.Mapper.Map <TimeTable>(value);
_timeTableRepo.Add(timeTableData);
}
public void DeleteTimeTable(TimeTableViewModel value)
{
var timeTableData = ObjectMapper.Mapper.Map <TimeTable>(value);
_timeTableRepo.Delete(timeTableData);
}
