internal static void AddObject(TimeTable timeTable)
{
MoneyPacificEntities db = new MoneyPacificEntities();
db.TimeTables.AddObject(timeTable);
db.SaveChanges();
db.Connection.Close();
}
private void btn_goNext_Click(object sender, EventArgs e)
{
TimeTable tm = new TimeTable(_teacher.Id);
tm.SetFirstAndSecondWeek(drp_firstWeekDate.Value.Date);
_proxy.CreateTimeTable(tm);
new CreationTimeTableForm(_proxy, _parentForm, _teacher).Show();
this.Close();
}
public ActionResult Create(TimeTable timetable)
{
if (ModelState.IsValid)
{
db.TimeTables.Add(timetable);
db.Commit();
return RedirectToAction("Index");
}
return View(timetable);
}
// creates another 3 timetable objects for population by taking first yimetable and shuffling it.
// public void populateTimeTable(){
// int i=0;
// System.Console.WriteLine("populating started.......");
// while(i<6){
// TimeTable tempTimetable = timetbl;
// List<ClassRoom> allrooms = tempTimetable.getRoom();
// Iterator<ClassRoom> allroomsIterator = allrooms.iterator();
// while(allroomsIterator.hasNext()){
// ClassRoom room = allroomsIterator.next();
// List<Day> weekdays = room.getWeek().getWeekDays();
// Iterator<Day> daysIterator=weekdays.iterator();
// while(daysIterator.hasNext()){
// Day day = daysIterator.next();
// Collections.shuffle(day.getTimeSlot());
// }
// }
// timetable.Add(tempTimetable);
// i++;
// }
// System.Console.WriteLine("populating done.......");
// System.Console.WriteLine("display called.......");
// display();
//
// GeneticAlgorithm.populationAccepter(timetable);
// }
// displays all timetables
private void display()
{
// TODO Auto-generated method stub
int i = 1;
System.Console.WriteLine("displaying all tt\'s.......");
var timetableIterator = this.timetables.GetEnumerator();
while (timetableIterator.MoveNext())
{
System.Console.WriteLine(("+++++++++++++++++++++++++++++++++++++++++\nTime Table no. " + i));
TimeTable currentTimetable = timetableIterator.Current;
System.Console.WriteLine(("Score : " + currentTimetable.getFittness()));
List <ClassRoom> allrooms = currentTimetable.getRoom();
var allroomsIterator = allrooms.GetEnumerator();
while (allroomsIterator.MoveNext())
{
ClassRoom room = allroomsIterator.Current;
System.Console.WriteLine(("Room: " + room.getRoomNo()));
List <Day> weekdays = room.getWeek().getWeekDays();
var daysIterator = weekdays.GetEnumerator();
while (daysIterator.MoveNext())
{
Day day = daysIterator.Current;
List <TimeSlot> timeslots = day.getTimeSlot();
var timeslotIterator = timeslots.GetEnumerator();
//System.Console.Write(""+day.getName()+": ");
while (timeslotIterator.MoveNext())
{
TimeSlot lecture = ((TimeSlot)(timeslotIterator.Current));
if ((lecture.getLecture() != null))
{
//System.Console.Write(" (Subject: "+lecture.getLecture().getSubject()+" --> Professor: "+lecture.getLecture().getProfessor().getProfessorName()+" GrpName: "+lecture.getLecture().getStudentGroup().getName()+")");
System.Console.Write(("("
+ (lecture.getLecture().getSubject() + ("#"
+ (lecture.getLecture().getProfessor().getProfessorName() + ("#"
+ (lecture.getLecture().getStudentGroup().getName().Split('/')[0] + ")")))))));
}
else
{
System.Console.Write(" free ");
}
}
System.Console.Write("\n");
}
System.Console.Write("\n\n");
}
i++;
}
}
public ActionResult Create([Bind(Include = "Id,Day,StartTime,EndTime,SubjectId")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
db.TimeTables.Add(timeTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SubjectId = new SelectList(db.Subjects, "Id", "Name", timeTable.SubjectId);
return(View(timeTable));
}
public IHttpActionResult DeleteTimeTable(int id)
{
TimeTable timeTable = db.TimeTables.Find(id);
if (timeTable == null)
{
return(NotFound());
}
db.TimeTables.Remove(timeTable);
db.SaveChanges();
return(Json("Deleted Successfully"));
}
public IActionResult Create([Bind("Id,SubjectId,TeacherId,StarTime,EndTime,Day")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
_context.Add(timeTable);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
ViewData["SubjectId"] = new SelectList(_context.Subject, "Id", "Name", timeTable.SubjectId);
ViewData["TeacherId"] = new SelectList(_context.Teacher, "Id", "ContactNumber", timeTable.TeacherId);
return(View(timeTable));
}
//
// GET: /TimeManager/Edit/5
public ActionResult Edit(int id)
{
UserLeave userleave = db.UserLeaves.Find(id);
if (userleave == null)
{
return HttpNotFound();
}
TimeTable time = new TimeTable();
time.userLeave = userleave;
time.user = db.Users.Find(userleave.UserID);
return View(time);
}
public static TimeTableWithCourseNameOutputModel ToOutputModel(TimeTable timeTable)
{
return(new TimeTableWithCourseNameOutputModel
{
Id = (int)timeTable.Id,
CourseName = timeTable.Course.Name,
RoomNumber = timeTable.RoomNumber,
Day = timeTable.Day,
TimeStart = timeTable.TimeStart.ToString(@"hh\:mm"),
TimeEnd = timeTable.TimeEnd.ToString(@"hh\:mm")
});
}
public ActionResult Edit(TimeTable time)
{
UserLeave userLeave = time.userLeave;
userLeave.UpdateTime = DateTime.Now;
if (ModelState.IsValid)
{
db.Entry(userLeave).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(time);
}
public async Task <IActionResult> Create([Bind("TimeTableId,DateTime,ApplicationUserId,Applied,Assigned")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
_context.Add(timeTable);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ApplicationUserId"] = new SelectList(_context.Users, "Id", "Id", timeTable.ApplicationUserId);
return(View(timeTable));
}
private async Task CreateGroupAsync(CreateGroupViewModel groupViewModel, TimeTable timeTable)
{
Group group = new Group
{
UserId = groupViewModel.UserId,
BranchId = groupViewModel.BranchId,
TimeTableId = timeTable.Id
};
await _unitOfWork.Groups.CreateAsync(group);
await _unitOfWork.CompleteAsync();
}
public ActionResult Edit([Bind(Include = "TimeTableId,ModuleId,ClassId,StartTime,EndTime,Day")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
db.Entry(timeTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ClassId = new SelectList(db.Classes, "ClassId", "ClassDescription", timeTable.ClassId);
ViewBag.ModuleId = new SelectList(db.Modules, "ModuleId", "ModuleDescription", timeTable.ModuleId);
return(View(timeTable));
}
static Calendar CalendarFromTimeTable(TimeTable timeTable, IEnumerable <CourseConfig> courses)
{
var now = DateTime.Now;
var newCal = new Calendar();
//select lessons
var lessons = timeTable.Lessons
.SelectMany(ls => ls.Value.Select(l => (time: ls.Key, lesson: l)))
.ToList();
//Select lessons for each course
var cs = courses
.Select(c =>
(course: c,
lesson: lessons
.Select(l =>
(time: l.time,
lesson: l.lesson,
score: l.lesson
.Score(c.Filter)))
.Where(l => l.score != int.MaxValue)))
.ToList();
//Warn empty courses
foreach (var emptyC in cs.Where(c => !c.lesson.Any() && c.course.Warn == WarnMethod.NotFound))
{
logger.Warn("Course '{0}' does not have any lessons and the warning flag is not disabled.", emptyC.course.Filter);
}
//Actualy add courses
foreach (var l in cs.SelectMany(c => c.lesson.Select(l => (lesson: l.lesson, time: l.time, course: c.course))))
{
CalendarEvent item = new CalendarEvent()
{
DtStart = new CalDateTime(l.time.Start),
DtEnd = new CalDateTime(l.time.End),
Summary = l.lesson.ToString(),
};
if (Regex.IsMatch(l.course.Color, "^#[A-Fa-f0-9]{3}([A-Fa-f0-9]{3})?$"))
{
item.AddProperty("COLOR", l.course.Color);
}
else if (l.course.Color != "default")
{
logger.Warn("{0} is not a valid color value", l.course.Color);
}
newCal.Events.Add(item);
}
return(newCal);
}
public async Task <IActionResult> AddTimetable(TimeTable timetable)
{
var result = await _publicTransportRepository.AddTimetable(timetable);
if (result != null)
{
return(Ok(result));
}
else
{
return(BadRequest("Failed while creating new timetable"));
}
}
public ActionResult Edit([Bind(Include = "TimeTableID,ClassName,ClassType,Time,Day,TeacherID,GroupID,ModuleID")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
db.Entry(timeTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GroupID = new SelectList(db.Groups, "GroupID", "Name", timeTable.GroupID);
ViewBag.ModuleID = new SelectList(db.Modules, "ModuleID", "Name", timeTable.ModuleID);
ViewBag.TeacherID = new SelectList(db.Teachers, "TeacherID", "Name", timeTable.TeacherID);
return(View(timeTable));
}
public ActionResult Edit(TimeTable timetable)
{
if (ModelState.IsValid)
{
//db.Entry(timetable).State = EntityState.Modified;
db.TimeTables.GetById(timetable.Id).Date = timetable.Date;
db.TimeTables.GetById(timetable.Id).TimeTableEntries = timetable.TimeTableEntries;
db.Commit();
return(RedirectToAction("Index"));
}
return(View(timetable));
}
public async Task <IActionResult> UpdateTimetable(int timetableId, TimeTable timetable)
{
var result = await _publicTransportRepository.UpdateTimetable(timetableId, timetable);
if (result != null)
{
return(Ok(result));
}
else
{
return(BadRequest("Failed to update timetable"));
}
}
private async Task <TimeTable> CreateTimeTableAsync(CreateGroupViewModel groupViewModel)
{
TimeTable timeTable = new TimeTable();
timeTable.Day1 = groupViewModel.Day1;
timeTable.Day2 = groupViewModel.Day2;
timeTable.Time = groupViewModel.Time;
await _unitOfWork.TimeTables.CreateAsync(timeTable);
await _unitOfWork.CompleteAsync();
return(await _unitOfWork.TimeTables.GetIdTimeTable(timeTable));
}
public HttpResponseMessage Create(TimeTable TimeTable)
{
try
{
_context.TimeTables.Add(TimeTable);
_context.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.Created));
}
catch (Exception ex)
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
public async Task <ActionResult> Delete(TimeTable timeTable)
{
try
{
await _timeTableService.DeleteTimeTable(timeTable);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(RedirectToAction(nameof(Index)));
}
}
public void ReadBusLine()
{
// ARRAnge
string root_url = "http://busmon.westeurope.cloudapp.azure.com/csv/buses.csv";
TimeTable model = TablesBLL.ModelWithToken("navas", root_url);
// Act
model = TablesBLL.ArrivalTimes("navas", model.EMTToken, root_url); //emt.TimeArrivalBus()
// assert
Assert.IsTrue(false);
}
public ActionResult Create([Bind(Include = "PassageId,TimeTableName,TrainNumber,RouteId,DepartureTime,ArrivalTime,Canceled,Detained,TicketPrice")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
db.TimeTable.Add(timeTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RouteId = new SelectList(db.Routs, "RouteId", "RouteName", timeTable.RouteId);
ViewBag.TrainNumber = new SelectList(db.Trains, "TrainId", "TrainNumber", timeTable.TrainNumber);
return(View(timeTable));
}
public ActionResult Create([Bind(Include = "TimeId,HallId,ShowId,Time")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
db.TimeTables.Add(timeTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.HallId = new SelectList(db.Halls, "HallId", "Name", timeTable.HallId);
ViewBag.ShowId = new SelectList(db.Shows, "ShowId", "Title", timeTable.ShowId);
return(View(timeTable));
}
public void Setup()
{
var testData = new[]
{
"939", "7,13,x,x,59,x,31,19"
};
var mockPuzzleInput = new Mock <IPuzzleInput>();
mockPuzzleInput.Setup(p => p.GetPuzzleInputAsArray(It.IsAny <string>())).Returns(testData);
_timeTable = new TimeTable(mockPuzzleInput.Object);
}
public ActionResult Edit([Bind(Include = "Id,CoachId,GymId,DayOfWeekId,Time_From,Duration")] TimeTable timeTable)
{
if (ModelState.IsValid)
{
db.Entry(timeTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CoachId = new SelectList(db.Users, "Id", "Email", timeTable.CoachId);
ViewBag.DayOfWeekId = new SelectList(db.DaysOfWeek, "Id", "Name", timeTable.DayOfWeekId);
ViewBag.GymId = new SelectList(db.Gyms, "Id", "Address", timeTable.GymId);
return(View(timeTable));
}
public ActionResult Edit([Bind(Include = "TimeTableID,SchoolID,ClassID,SectionID,PeriodID,TeacherID,SubjectID,IsClassTeacher")] TimeTable timeTable, string existing)
{
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
if (ModelState.IsValid)
{
string name = timeTable.SchoolID.ToString() + timeTable.ClassID.ToString() + timeTable.SectionID.ToString() + timeTable.PeriodID.ToString();
if (name != existing)
{
TimeTable exist = db.TimeTables.Include(c => c.CurrentClass).Where(c => c.SchoolID == timeTable.SchoolID && c.ClassID == timeTable.ClassID && c.SectionID == timeTable.SectionID && c.PeriodID == timeTable.PeriodID).FirstOrDefault();
if (exist != null)
{
Session["err"] = "Time Table already exists";
ViewBag.Existing = existing;
ViewBag.Message = Session["msg"];
ViewBag.Error = Session["err"];
Session["err"] = "";
Session["msg"] = "";
ViewBag.ClassName = exist.CurrentClass.Name;
ViewBag.SectionID = new SelectList(db.Sections, "SectionID", "Name", timeTable.SectionID);
ViewBag.PeriodID = new SelectList(db.Periods, "PeriodID", "Name", timeTable.PeriodID);
ViewBag.TeacherID = new SelectList(db.Teachers, "TeacherID", "Name", timeTable.TeacherID);
ViewBag.SubjectID = new SelectList(db.Subjects.Where(c => c.ClassID == timeTable.ClassID), "SubjectID", "Name", timeTable.SubjectID);
return(View(timeTable));
}
}
db.Entry(timeTable).State = EntityState.Modified;
db.SaveChanges();
Session["err"] = "";
Session["msg"] = "Modified Successfully";
return(RedirectToAction("Index"));
}
ViewBag.Existing = existing;
ViewBag.Message = Session["msg"];
ViewBag.Error = Session["err"];
Session["err"] = "";
Session["msg"] = "";
TimeTable timeTableexist = db.TimeTables.Include(c => c.CurrentClass).Where(c => c.TimeTableID == timeTable.TimeTableID).FirstOrDefault();
ViewBag.ClassName = timeTableexist.CurrentClass.Name;
ViewBag.SectionID = new SelectList(db.Sections, "SectionID", "Name", timeTable.SectionID);
ViewBag.PeriodID = new SelectList(db.Periods, "PeriodID", "Name", timeTable.PeriodID);
ViewBag.TeacherID = new SelectList(db.Teachers, "TeacherID", "Name", timeTable.TeacherID);
ViewBag.SubjectID = new SelectList(db.Subjects.Where(c => c.ClassID == timeTable.ClassID), "SubjectID", "Name", timeTable.SubjectID);
return(View(timeTable));
}
// GET: TimeTables/Create
public IActionResult Create()
{
ViewBag.Types = new List <SelectListItem> {
new SelectListItem {
Value = "week", Text = "Týden"
}
};
TimeTable timeTable = new TimeTable()
{
SleepTemp = 38, NoFrostTemp = 30, EcoTemp = 42, WarmTemp = 46
};
return(View("Edit", timeTable));
}
// GET: TimeTables/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TimeTable timeTable = db.TimeTables.Find(id);
if (timeTable == null)
{
return(HttpNotFound());
}
return(View(timeTable));
}
public void TimeTable_Equals_DifferentDaysActive()
{
var normal = new TimeTable();
Action <TimeTable> assert = t => Assert.AreNotEqual(normal, t);
assert(new TimeTable(TimeSlot.Default(DayOfWeek.Monday, i => i != 0)));
assert(new TimeTable(tuesday: TimeSlot.Default(DayOfWeek.Tuesday, i => i != 0)));
assert(new TimeTable(wednesday: TimeSlot.Default(DayOfWeek.Wednesday, i => i != 0)));
assert(new TimeTable(thursday: TimeSlot.Default(DayOfWeek.Thursday, i => i != 0)));
assert(new TimeTable(friday: TimeSlot.Default(DayOfWeek.Friday, i => i != 0)));
assert(new TimeTable(saturday: TimeSlot.Default(DayOfWeek.Saturday, i => i != 0)));
assert(new TimeTable(sunday: TimeSlot.Default(DayOfWeek.Sunday, i => i != 0)));
}
public async Task <IHttpActionResult> DeleteTimeTable(int id)
{
TimeTable timeTable = await db.TimeTables.FindAsync(id);
if (timeTable == null)
{
return(NotFound());
}
db.TimeTables.Remove(timeTable);
await db.SaveChangesAsync();
return(Ok(timeTable));
}
public IActionResult TimeTable()
{
TimeTable timetablesFromMemoryCashe = (TimeTable)_memoryCache.Get(Request.Path.Value.ToLower());
if (Request.Cookies["coockiesTimeTables"] != null)
{
TimeTable timetables = JsonConvert.DeserializeObject <TimeTable>(Request.Cookies["coockiesTimeTables"].ToString());
ViewBag.timetablesCoockies = timetables;
}
ViewBag.timetablesFromMemory = timetablesFromMemoryCashe;
ViewBag.timetables = _context.Timetables.Include(v => v.Group).ToList();
return(View());
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Caption,Type,NoFrostTemp,SleepTemp,EcoTemp,WarmTemp,TimersSerialized")] TimeTable timeTable)
{
if (id != timeTable.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
commandService.SaveTimeTable(timeTable);
return(RedirectToAction(nameof(Index)));
}
return(View(timeTable));
}
public static TimeTable ToDataModel(TimeTableInputModel inputModel)
{
var result = new TimeTable
{
Id = inputModel.Id,
GroupId = inputModel.GroupId,
RoomNumber = inputModel.RoomNumber,
Day = Convert.ToDateTime(inputModel.Day),
TimeStart = TimeSpan.Parse(inputModel.TimeStart),
TimeEnd = TimeSpan.Parse(inputModel.TimeEnd)
};
return(result);
}
public List <TimeTable> Select(TimeTable time)
{
try
{
using (var connection = new SQLiteConnection(dataPath))
{
return(connection.Table <TimeTable>().ToList());
}
}catch (SQLiteException e)
{
Log.Info("SQLiteEX", e.Message);
return(null);
}
}
internal static void AddIfNotExists(int storeManagerId)
{
for (int i = 0; i < 7; i++)
{
for (int j = 0; j < 24; j++)
{
string dayName = GetDay(i + 1);
TimeItem timeItem = TimeItemDAO.GetItem(dayName, j);
TimeTable timeTable = TimeTableDAO.GetItem(timeItem.Id, storeManagerId);
if (timeTable == null)
{
timeTable = new TimeTable {
TimeItemId = timeItem.Id,
ManagerId = storeManagerId,
Enabled = true
};
TimeItemDAO.AddObject(timeTable);
}
}
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
var transfer = (timerToChartsTransfer)e.Parameter;
var tc = new TelemetryClient();
tc.TrackEvent("Charts Viewed");
Demands.Clear();
//for(int i=0; i<transfer.trackact.activity[(int)transfer.activity_pos].timer_data.Count; i++)
//{
// TimeTable tb = new TimeTable();
// tb.eventCount = i + 1;
// tb.seconds = transfer.trackact.activity[(int)transfer.activity_pos].timer_data[i].time_in_seconds;
// Demands.Add(tb);
//}
DateTime dt = (DateTime.Now).AddDays(-10);
for (int i = 0; i < transfer.trackact.activity[(int)transfer.activity_pos].timer_data.Count; i++)
{
TimeTable tb = new TimeTable();
DateTime da = transfer.trackact.activity[(int)transfer.activity_pos].timer_data[i].startTime;
tb.Demand = da.ToLocalTime();
tb.runningMedian = transfer.trackact.activity[(int)transfer.activity_pos].timer_data[i].running_median;
tb.seconds = transfer.trackact.activity[(int)transfer.activity_pos].timer_data[i].time_in_seconds;
Demands.Add(tb);
}
//SfChart chart = new SfChart();
myChart.HorizontalAlignment = HorizontalAlignment.Center;
myChart.VerticalAlignment = VerticalAlignment.Center;
myChart.Header = "Time and Median";
myChart.Foreground = new SolidColorBrush(Colors.White);
DateTimeCategoryAxis primaryCategoryAxis = new DateTimeCategoryAxis();
primaryCategoryAxis.Interval = 1;
primaryCategoryAxis.Header = "Timer Started";
primaryCategoryAxis.LabelFormat = "dd/MM hh:mm tt";
primaryCategoryAxis.Foreground = new SolidColorBrush(Colors.White);
myChart.PrimaryAxis = primaryCategoryAxis;
NumericalAxis secondaryNumericalAxis = new NumericalAxis();
secondaryNumericalAxis.Header = "Time (in seconds)";
secondaryNumericalAxis.Minimum = 0;
secondaryNumericalAxis.Foreground = new SolidColorBrush(Colors.White);
myChart.SecondaryAxis = secondaryNumericalAxis;
SplineSeries series2 = new SplineSeries();
series2.ItemsSource = Demands;
series2.ShowTooltip = true;
series2.Label = "Median Time";
series2.XBindingPath = "Demand";
series2.YBindingPath = "runningMedian";
series2.EnableAnimation = true;
ColumnSeries series1 = new ColumnSeries();
series1.EnableAnimation = true;
series1.ShowTooltip = true;
series1.Label = "Time (in seconds)";
series1.ItemsSource = Demands;
series1.XBindingPath = "Demand";
series1.YBindingPath = "seconds";
myChart.Series.Add(series1);
myChart.Series.Add(series2);
myChart.Legend = new ChartLegend() { Visibility = Visibility.Visible };
//Hashtable datetime_ht = new Hashtable();
//List<long> total_time_day = new List<long>();
//datetime_ht.Clear();
//total_time_day.Clear();
//Demands = new ObservableCollection<GoldDemand>();
//transfer = (timerToChartsTransfer)e.Parameter;
//var activity = transfer.trackact.activity[(int)transfer.activity_pos];
//int m = 0;
//for (int l = 0; l < activity.timer_data.Count; l++)
//{
// if (!datetime_ht.Contains(((activity.timer_data[l].startTime).ToLocalTime()).Date))
// {
// datetime_ht.Add(((activity.timer_data[l].startTime).ToLocalTime()).Date, m);
// total_time_day.Add(activity.timer_data[l].time_in_seconds);
// m++;
// }
// else
// {
// int pos = (int)datetime_ht[((activity.timer_data[l].startTime).ToLocalTime()).Date];
// total_time_day[pos] = total_time_day[pos] + activity.timer_data[l].time_in_seconds;
// }
//}
//Demands.Clear();
//int i = 0;
//foreach (var act in activity.timer_data)
//{
// GoldDemand dem_event = new GoldDemand();
// if (datetime_ht.Contains(((act.startTime).ToLocalTime()).Date))
// {
// GoldDemand dem = new GoldDemand();
// dem.date = ((act.startTime).ToLocalTime()).Date;
// dem.Demand = String.Format("{0:dd/MM}", dem.date);
// //myChart.Header = ;
// //dem.Demand = i + 1;
// int pos = (int)datetime_ht[((act.startTime).ToLocalTime()).Date];
// dem.seconds = total_time_day[pos];
// datetime_ht.Remove(((act.startTime).ToLocalTime()).Date);
// Demands.Add(dem);
// //total_time_day.RemoveAt(pos);
// }
// dem_event.event_count = i;
// i = i + 1;
//}
//this.DataContext = this;
//i = 0;
}
public IEnumerable<TimeTable> timeManager()
{
List<TimeTable> timeTable = new List<TimeTable>();
//var userLeave = db.UserLeaves.ToList();
var userLeave = db.UserLeaves.Where(o=>(o.AnnualDays!=0)||(o.OverTime!=0)).ToList();
foreach (var item in userLeave)
{
var user = db.Users.Where(o => o.UserID == item.UserID).FirstOrDefault();
if (user.IsDeparted == false)
{
TimeTable time = new TimeTable();
time.userLeave = item;
time.user = user;
timeTable.Add(time);
}
}
return timeTable.OrderBy(o=>o.user.UserName);
}
public ActionResult Edit(TimeTable timetable)
{
if (ModelState.IsValid)
{
//db.Entry(timetable).State = EntityState.Modified;
db.TimeTables.GetById(timetable.Id).Date = timetable.Date;
db.TimeTables.GetById(timetable.Id).TimeTableEntries = timetable.TimeTableEntries;
db.Commit();
return RedirectToAction("Index");
}
return View(timetable);
}
public void SetTimeTable(TimeTable tbl)
{
if (this.currentTbl != null && this.currentTbl.TimeTableID == tbl.TimeTableID)
return;
else
{
this.currentTbl = tbl;
this.colCount = tbl.Periods.MaxWeekDay;
this.rowCount = tbl.Periods.MaxPeriodNo;
//this.createHeaders();
this.createCells();
}
}
private void LoadTimeTable()
{
if (h == null || activeRoute == null || m_LockTimeTable)
return;
string req = String.Format("{0}/{1}/{2}/{3}/{4}/{5}", pathToJson, "time-table", activeRoute.Id, h.Id, GetToday(), direction == RouteDirection.Forward ? "0" : "1");
WebRequest.DefaultWebProxy = new WebProxy();
WebRequest reqGET = WebRequest.Create(req);
WebResponse resp = reqGET.GetResponse();
Stream stream = resp.GetResponseStream();
StreamReader sr = new StreamReader(stream);
string json = sr.ReadToEnd();
timeTable = new TimeTable();
timeTable.Parse(json);
listView1.Items.Clear();
if (!listView1.Visible)
listView1.Visible = true;
listView1.BeginUpdate();
for (int i = 0, c = timeTable.GetTimeCount(); i < c; i++)
listView1.Items.Add(timeTable[i].ToShortTimeString());
listView1.EndUpdate();
}
private void ReloadTimeTable()
{
TimeTable tmp = new TimeTable();
using (SqlConnection reposConn = new SqlConnection(GetReposConnectionString("Manager")))
{
reposConn.Open();
using (SqlCommand reposCmd = reposConn.CreateCommand())
{
reposCmd.CommandText = "SELECT Id, TargetId, MetricGroupId, OffsetInSecondsFromMidnight, IntervalInSeconds, RetentionPeriodInHours FROM dbo.Schedule ORDER BY Id";
reposCmd.CommandType = CommandType.Text;
using (SqlDataReader reposReader = reposCmd.ExecuteReader())
{
while (reposReader.Read())
{
tmp.TryAdd(
(int)reposReader["Id"],
(int)reposReader["TargetId"],
(int)reposReader["MetricGroupId"],
new Schedule(
(int)reposReader["OffsetInSecondsFromMidnight"],
(int)reposReader["IntervalInSeconds"],
(int)reposReader["RetentionPeriodInHours"]
)
);
}
reposReader.Close();
}
}
reposConn.Close();
}
timeTable = tmp;
}
public void InitSchedule(int weekday, int periodcount)
{
this.currentTbl = null;
this.colCount = weekday;
this.rowCount = periodcount;
//this.createHeaders();
this.createCells();
}
public int CreateTimeTable(TimeTable tmt)
{
try
{
return TimeTable.CreateNew(tmt);
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
public Configuration(Manager manager)
{
_mgr = manager;
inMemoryCache = new InMemoryCache();
timeTable = new TimeTable();
}
