public static IEnumerable <AttendenceViewModel> GetAttendencesToStudent(string snn)
{
using (var context = new FinalSchool())
{
var student = context.Students.Find(snn);
var studentAttendences = (from stu in context.Students
join attend in context.Attendences
on stu.StudentId equals attend.StudentId
where stu.StudentId == snn
select attend)
.ToList();
var studentAttendViewList = new List <AttendenceViewModel>();
foreach (var item in studentAttendences)
{
var studentAttendView = new AttendenceViewModel()
{
StudentSNN = item.StudentId,
CourseName = item.Session.Course.Name,
IsAttended = item.IsAttended,
SessionDate = item.Session.StartDate,
StudentName = item.Student.FName + ' ' + item.Student.FName,
TeacherName = item.Session.Teacher.FName + ' ' + item.Session.Teacher.LName,
};
studentAttendViewList.Add(studentAttendView);
}
return(studentAttendViewList);
}
}
public static void ChangeAttendenceState(AttendenceViewModel attendenceViewModel)
{
using (var context = new FinalSchool())
{
var studentAtt = context.Students.FirstOrDefault(x => x.StudentId == attendenceViewModel.StudentSNN);
var courseAtt = context.Courses.FirstOrDefault(x => x.Name == attendenceViewModel.CourseName);
var teacher = context.Teachers.FirstOrDefault(x => x.FName == attendenceViewModel.TeacherName);
var session = new Session
{
Course = courseAtt,
CourseId = courseAtt.CourseId,
StartDate = DateTime.Now,
Teacher = teacher,
TeacherId = teacher.TeacherId,
};
context.Sessions.Add(session);
context.SaveChanges();
var attendence = new Attendence()
{
Student = studentAtt,
StudentId = studentAtt.StudentId,
IsAttended = attendenceViewModel.IsAttended,
Session = session,
SessionId = session.SessionId,
};
context.Attendences.Add(attendence);
context.SaveChanges();
}
}
public List <AttendenceViewModel> GetAllAttendence()
{
var returningList = new List <AttendenceViewModel>();
var models = närvaroDb.GetAllAttendenceItems();
foreach (var model in models)
{
var viewModel = new AttendenceViewModel
{
DateConcerning = model.DateConcerning,
DeltagarIdInQuestion = model.DeltagarIdInQuestion,
DeltagarNamn = deltagareDb.GetDeltagare(model.DeltagarIdInQuestion).DeltagarNamn,
Måndag = HelperConvertLogic.GetAttendenceOptionFromString(model.Måndag),
Tisdag = HelperConvertLogic.GetAttendenceOptionFromString(model.Tisdag),
Onsdag = HelperConvertLogic.GetAttendenceOptionFromString(model.Onsdag),
Torsdag = HelperConvertLogic.GetAttendenceOptionFromString(model.Torsdag),
Fredag = HelperConvertLogic.GetAttendenceOptionFromString(model.Fredag),
ExpectedMåndag = HelperConvertLogic.GetWorkDayFromString(model.ExpectedMåndag),
ExpectedTisdag = HelperConvertLogic.GetWorkDayFromString(model.ExpectedTisdag),
ExpectedOnsdag = HelperConvertLogic.GetWorkDayFromString(model.ExpectedOnsdag),
ExpectedTorsdag = HelperConvertLogic.GetWorkDayFromString(model.ExpectedTorsdag),
ExpectedFredag = HelperConvertLogic.GetWorkDayFromString(model.ExpectedFredag),
Id = model.Id
};
returningList.Add(viewModel);
}
return(returningList);
}
public ActionResult Create(AttendenceViewModel viewModel)
{
if (ModelState.IsValid)
{
try
{
Attendence attendence = Mapper.Map <Attendence>(viewModel);
attendence.Id = Guid.NewGuid();
attendence.CompanyId = CompanyCookie.CompId;
_dbContext.Attendences.Add(attendence);
_dbContext.SaveChanges();
Salary salary = new Salary();
salary.CompanyId = CompanyCookie.CompId;
salary.Date = viewModel.Date;
_dbContext.Salary.Add(salary);
_dbContext.SaveChanges();
TempData["MessageToClientSuccess"] = "Attendence Date SuccessFully Created";
}
catch (Exception ex)
{
// Log4NetHelper.Log(String.Format("Cannot Create Deparment {0} ", viewModel.Id), LogLevel.ERROR, "Department", viewModel.Id, User.Identity.Name, ex);
var msg = new ModelStateException(ex);
TempData["MessageToClientError"] = msg;
}
return(RedirectToAction("Index"));
}
ViewBag.CompanyId = new SelectList(_dbContext.Companyies, "Id", "CompanyName");
return(View(viewModel));
}
public AttendenceHomePage(AttendenceViewModel _viewModel)
{
InitializeComponent();
viewModel = _viewModel;
greetingMessage = greetingMessages[new Random().Next(0, greetingMessages.Length - 1)] + " " + viewModel.UserName + "!";
GreetingMessage.Text = greetingMessage;
if (!viewModel.ClassesRegistered)
{
ClassesRegisteredLabel.Text = "You are not a member of any classes. To get started, create a class or join one!";
}
}
public ActionResult Edit(AttendenceViewModel viewModel)
{
if (ModelState.IsValid)
{
Attendence attendence = Mapper.Map <Attendence>(viewModel);
_dbContext.Entry(attendence).State = EntityState.Modified;
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CompanyId = new SelectList(_dbContext.Companyies, "Id", "CompanyName");
return(View(viewModel));
}
public IActionResult Post([FromBody] AttendenceViewModel attendence)
{
if (attendence == null)
{
return(BadRequest("Attendence is null."));
}
attendence.LogDate = DateTime.Now;
_dataRepository.Add(_mapper.Map <Attendence>(attendence));
return(CreatedAtRoute(
"Get",
new { Id = attendence.ID },
attendence));
}
public ActionResult Edit(int?id, AttendenceViewModel obj)
{
try
{
db.Attendences.Find(id).Date = obj.Date;
db.Attendences.Find(id).Status = obj.Status;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Delete(int?id, AttendenceViewModel obj)
{
try
{
// TODO: Add insert logic here
var v = db.Attendences.Where(a => a.AttendenceID == id).First();
db.Entry(v).State = EntityState.Deleted;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
// GET: Attendences/Edit/5
public ActionResult Edit(int?id)
{
AttendenceViewModel obj = new AttendenceViewModel();
Attendence A = db.Attendences.Find(id);
if (A == null)
{
return(HttpNotFound());
}
else
{
obj.AttendenceID = A.AttendenceID;
obj.Date = A.Date;
obj.Status = A.Status;
obj.StaffID = A.StaffID;
}
return(View(obj));
}
public ActionResult Create(int id, AttendenceViewModel obj)
{
try
{
Attendence Att = new Attendence();
Att.Date = obj.Date;
Att.Status = obj.Status.ToString();
Att.StaffID = id;
db.Attendences.Add(Att);
db.SaveChanges();
// return RedirectToAction("Index");
ViewBag.Message = "Attendence has been Marked ";
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public static IEnumerable <AttendenceViewModel> GetAll()
{
using (var context = new FinalSchool())
{
var attendViewList = new List <AttendenceViewModel>();
foreach (var attend in context.Attendences.ToList())
{
var attendenceView = new AttendenceViewModel()
{
CourseName = attend.Session.Course.Name,
IsAttended = attend.IsAttended,
SessionDate = attend.Session.StartDate,
StudentName = attend.Student.FName + ' ' + attend.Student.LName,
TeacherName = attend.Session.Teacher.FName + ' ' + attend.Session.Teacher.LName,
};
attendViewList.Add(attendenceView);
}
return(attendViewList);
}
}
public IActionResult UpdateNärvaro(AttendenceViewModel viewModel)
{
if (User.Identity.Name != "admin" && User.Identity.Name != "piahag")
{
return(RedirectToAction("index", "inventarie"));
}
string rawdate = HttpContext.Request.Cookies["userSelectedDate"];
DateTime date = Convert.ToDateTime(rawdate);
var deltagare = deltagarList.FirstOrDefault(x => x.DeltagarNamn == viewModel.DeltagarNamn);
var ogViewModel = närvaroLogic.GetAttendenceForDate(date).First(x => x.DeltagarNamn == viewModel.DeltagarNamn);
ogViewModel.Måndag = viewModel.Måndag;
ogViewModel.Tisdag = viewModel.Tisdag;
ogViewModel.Onsdag = viewModel.Onsdag;
ogViewModel.Torsdag = viewModel.Torsdag;
ogViewModel.Fredag = viewModel.Fredag;
närvaroLogic.UpdateAttendence(ogViewModel);
return(RedirectToAction("Attendence"));
}
public void AddNärvaro(AttendenceViewModel viewModel)
{
var deltagare = deltagareDb.GetAllDeltagarModels().First(x => x.DeltagarNamn == viewModel.DeltagarNamn);
var model = new AttendenceModel
{
DateConcerning = viewModel.DateConcerning,
DeltagarIdInQuestion = deltagare.Id,
Måndag = viewModel.Måndag.ToString(),
Tisdag = viewModel.Tisdag.ToString(),
Onsdag = viewModel.Onsdag.ToString(),
Torsdag = viewModel.Torsdag.ToString(),
Fredag = viewModel.Fredag.ToString(),
ExpectedMåndag = deltagare.Måndag,
ExpectedTisdag = deltagare.Tisdag,
ExpectedOnsdag = deltagare.Onsdag,
ExpectedTorsdag = deltagare.Torsdag,
ExpectedFredag = deltagare.Fredag
};
närvaroDb.AddAttendence(model);
}
/// <summary>
/// Custom sort the datagrid since the actual records are stored in the
/// server, not in the items collection of the datagrid.
/// </summary>
/// <param name="sender">The parts data grid.</param>
/// <param name="e">Contains the column to be sorted.</param>
private void AttendencesDataGrid_Sorting(object sender, DataGridSortingEventArgs e)
{
e.Handled = true;
AttendenceViewModel attViewModel = (AttendenceViewModel)DataContext;
string sortField = String.Empty;
// Use a switch statement to check the SortMemberPath
// and set the sort column to the actual column name. In this case,
// the SortMemberPath and column names match.
switch (e.Column.SortMemberPath)
{
case ("Sn"):
sortField = "Sn";
break;
case ("Name"):
sortField = "Name";
break;
case ("AtTime"):
sortField = "AtTime";
break;
}
ListSortDirection direction = (e.Column.SortDirection != ListSortDirection.Ascending) ?
ListSortDirection.Ascending : ListSortDirection.Descending;
bool sortAscending = direction == ListSortDirection.Ascending;
attViewModel.Sort(sortField, sortAscending);
currentSortColumn.SortDirection = null;
e.Column.SortDirection = direction;
currentSortColumn = e.Column;
currentSortDirection = direction;
}
// GET: Attendences
public ActionResult Index()
{
try
{
List <Attendence> list = db.Attendences.ToList();
List <AttendenceViewModel> viewList = new List <AttendenceViewModel>();
foreach (Attendence A in list)
{
AttendenceViewModel obj = new AttendenceViewModel();
obj.AttendenceID = A.AttendenceID;
obj.Date = A.Date;
obj.Status = A.Status;
obj.StaffID = A.StaffID;
viewList.Add(obj);
}
return(View(viewList));
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateAttendence(AttendenceViewModel attendence)
{
var deltagare = deltagareDb.GetAllDeltagarModels().First(x => x.DeltagarNamn == attendence.DeltagarNamn);
var model = new AttendenceModel
{
DateConcerning = attendence.DateConcerning,
DeltagarIdInQuestion = deltagare.Id,
Måndag = attendence.Måndag.ToString(),
Tisdag = attendence.Tisdag.ToString(),
Onsdag = attendence.Onsdag.ToString(),
Torsdag = attendence.Torsdag.ToString(),
Fredag = attendence.Fredag.ToString(),
ExpectedMåndag = attendence.ExpectedMåndag.ToString(),
ExpectedTisdag = attendence.ExpectedTisdag.ToString(),
ExpectedOnsdag = attendence.ExpectedOnsdag.ToString(),
ExpectedTorsdag = attendence.ExpectedTorsdag.ToString(),
ExpectedFredag = attendence.ExpectedFredag.ToString(),
Id = attendence.Id,
};
närvaroDb.UpdateAttendence(model);
}
public AttendeesControl()
{
InitializeComponent();
model = new AttendenceViewModel();
this.DataContext = model;
}
public List <AttendenceViewModel> GetAttendenceForDate(DateTime date, DeltagareViewModel deltagarModel)
{
if (date.DayOfWeek == DayOfWeek.Tuesday)
{
date = date.AddDays(-1);
}
else if (date.DayOfWeek == DayOfWeek.Wednesday)
{
date = date.AddDays(-2);
}
else if (date.DayOfWeek == DayOfWeek.Thursday)
{
date = date.AddDays(-3);
}
else if (date.DayOfWeek == DayOfWeek.Friday)
{
date = date.AddDays(-4);
}
else if (date.DayOfWeek == DayOfWeek.Saturday)
{
date = date.AddDays(-5);
}
else if (date.DayOfWeek == DayOfWeek.Sunday)
{
date = date.AddDays(-6);
}
var returningList = new List <AttendenceViewModel>();
var deltagarnaActive = deltagareDb.GetAllDeltagarModels().Where(x => x.DeltagarNamn == deltagarModel.DeltagarNamn).ToList();
foreach (var deltagare in deltagarnaActive)
{
var attendences = närvaroDb.GetAttendenceForDate(date).Where(x => x.DeltagarIdInQuestion == deltagare.Id).ToList();
if (attendences.Count == 0)
{
var model = new AttendenceModel
{
DateConcerning = date,
DeltagarIdInQuestion = deltagare.Id,
ExpectedFredag = deltagare.Fredag,
ExpectedTorsdag = deltagare.Torsdag,
ExpectedOnsdag = deltagare.Onsdag,
ExpectedTisdag = deltagare.Tisdag,
ExpectedMåndag = deltagare.Måndag,
Fredag = AttendenceOption.Frånvarande.ToString(),
Torsdag = AttendenceOption.Frånvarande.ToString(),
Onsdag = AttendenceOption.Frånvarande.ToString(),
Tisdag = AttendenceOption.Frånvarande.ToString(),
Måndag = AttendenceOption.Frånvarande.ToString()
};
närvaroDb.AddAttendence(model);
model = närvaroDb.GetAttendenceForDate(date).LastOrDefault(x => x.DeltagarIdInQuestion == deltagare.Id);
var viewModel = new AttendenceViewModel
{
DateConcerning = date,
DeltagarIdInQuestion = deltagare.Id,
DeltagarNamn = deltagareDb.GetDeltagare(model.DeltagarIdInQuestion).DeltagarNamn,
ExpectedFredag = HelperConvertLogic.GetWorkDayFromString(deltagare.Fredag),
ExpectedTorsdag = HelperConvertLogic.GetWorkDayFromString(deltagare.Torsdag),
ExpectedOnsdag = HelperConvertLogic.GetWorkDayFromString(deltagare.Onsdag),
ExpectedTisdag = HelperConvertLogic.GetWorkDayFromString(deltagare.Tisdag),
ExpectedMåndag = HelperConvertLogic.GetWorkDayFromString(deltagare.Måndag),
Fredag = AttendenceOption.Frånvarande,
Torsdag = AttendenceOption.Frånvarande,
Onsdag = AttendenceOption.Frånvarande,
Tisdag = AttendenceOption.Frånvarande,
Måndag = AttendenceOption.Frånvarande,
Id = model.Id
};
returningList.Add(viewModel);
}
else
{
var model = attendences.FirstOrDefault(x => x.DeltagarIdInQuestion == deltagare.Id);
var viewModel = new AttendenceViewModel
{
Id = model.Id,
DateConcerning = date,
DeltagarIdInQuestion = deltagare.Id,
DeltagarNamn = deltagareDb.GetDeltagare(model.DeltagarIdInQuestion).DeltagarNamn,
ExpectedFredag = HelperConvertLogic.GetWorkDayFromString(deltagare.Fredag),
ExpectedTorsdag = HelperConvertLogic.GetWorkDayFromString(deltagare.Torsdag),
ExpectedOnsdag = HelperConvertLogic.GetWorkDayFromString(deltagare.Onsdag),
ExpectedTisdag = HelperConvertLogic.GetWorkDayFromString(deltagare.Tisdag),
ExpectedMåndag = HelperConvertLogic.GetWorkDayFromString(deltagare.Måndag),
Fredag = HelperConvertLogic.GetAttendenceOptionFromString(model.Fredag),
Torsdag = HelperConvertLogic.GetAttendenceOptionFromString(model.Torsdag),
Onsdag = HelperConvertLogic.GetAttendenceOptionFromString(model.Onsdag),
Tisdag = HelperConvertLogic.GetAttendenceOptionFromString(model.Tisdag),
Måndag = HelperConvertLogic.GetAttendenceOptionFromString(model.Måndag)
};
returningList.Add(viewModel);
}
}
return(returningList);
}
public AttendenceRecord2()
{
InitializeComponent();
DataContext = new AttendenceViewModel();
}
public void Post(AttendenceViewModel attendenceViewModel)
{
AttendenceService.ChangeAttendenceState(attendenceViewModel);
}
