public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LogDataInfo logInfo = db.LogDataInfos.Where(c => c.Id == id).Include("UserInfo.Department").Include("UserInfo.CommunityCenter").Include("UserInfo").FirstOrDefault();
LogDataInfoViewModel LogViewModel = logInfo;
if (logInfo == null)
{
return(HttpNotFound());
}
return(View(LogViewModel));
}
public ActionResult Edit([Bind(Include = "Id,LogInTime,LogOutTime")] LogDataInfoViewModel logInfo)
{
if (ModelState.IsValid)
{
LogDataInfo updatedInfo = db.LogDataInfos.Where(c => c.Id == logInfo.Id).FirstOrDefault();
updatedInfo.LogTime = logInfo.LogInTime;
updatedInfo.LogOutTime = logInfo.LogOutTime;
updatedInfo.UpdatedDate = DateTime.Now;
updatedInfo.UpdatedBy = User.Identity.GetUserName();
db.Entry(updatedInfo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(logInfo));
}
public ActionResult GetEmpDisDetails(int num, DateTime fromDate, DateTime toDate)
{
ApplicationDbContext _db = new ApplicationDbContext();
EmpDiscountDetails empDetails = new EmpDiscountDetails();
empDetails.EnrollNumber = num;
empDetails.Name = _db.UserInfos.FirstOrDefault(c => c.EnrollNumber == num.ToString())?.FullName;
empDetails.Logs = new List <LogDataInfoViewModel>();
empDetails.DailyVacations = new List <DailyVacationViewModel>();
empDetails.HourVacations = new List <HourVacationViewModel>();
List <LogDataInfo> logs = _db.LogDataInfos.Where(c => c.EnrollNum == num.ToString() &&
(c.LogDate >= fromDate && c.LogDate <= toDate))
.Include("UserInfo").Include("UserInfo.CommunityCenter").Include("UserInfo.Department").OrderBy(c => c.LogDate).ThenBy(c => c.LogTime)
.ThenBy(c => c.LogOutTime).ToList();
foreach (var log in logs)
{
LogDataInfoViewModel lvm = log;
empDetails.Logs.Add(lvm);
}
List <DailyVacation> dVacations = _db.DailyVacations.Include("VacationType")
.Where(c => c.UserInfo.EnrollNumber == num.ToString() &&
(c.IsActive) &&
(c.FromDate <= toDate)).OrderBy(c => c.FromDate).ToList();
foreach (var dv in dVacations)
{
DailyVacationViewModel d = dv;
empDetails.DailyVacations.Add(d);
}
List <HourlyVacation> hvacations = _db.HourlyVacations.Where(c => c.UserInfo.EnrollNumber == num.ToString() &&
(c.IsActive) && (c.VacationDate <= toDate)).OrderBy(c => c.VacationDate).ToList();
foreach (var hv in hvacations)
{
HourVacationViewModel hvm = hv;
empDetails.HourVacations.Add(hvm);
}
return(View(empDetails));
}
// GET: LogDataInfoes
public ActionResult Index(string sortOrder, string currentFilter, string fdtFilter, string tdFilter
, string searchString, string fromDate, string toDate, int?page)
{
ViewBag.CurrentSort = sortOrder;
ViewBag.NumSortParm = String.IsNullOrEmpty(sortOrder) ? "num_desc" : "";
ViewBag.NameSortParm = sortOrder == "Name" ? "name_desc" : "Name";
ViewBag.DaySortParm = sortOrder == "Day" ? "day_desc" : "Day";
ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date";
ViewBag.LogInSortParm = sortOrder == "LogIn" ? "login_desc" : "LogIn";
ViewBag.LogOutSortParm = sortOrder == "LogOut" ? "logout_desc" : "LogOut";
ViewBag.CommunityCenterSortParm = sortOrder == "CommunityCenterName" ? "cname_desc" : "CommunityCenterName";
ViewBag.DepartmentNameSortParm = sortOrder == "DepartmentName" ? "dname_desc" : "DepartmentName";
List <LogDataInfo> logs = db.LogDataInfos.Where(c => c.IsActive).Include("UserInfo")
.Include("UserInfo.CommunityCenter").Include("UserInfo.Department").ToList();
List <LogDataInfoViewModel> logsViewModel = new List <LogDataInfoViewModel>();
foreach (var log in logs)
{
LogDataInfoViewModel LVM = log;
logsViewModel.Add(LVM);
}
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
if (fromDate != null)
{
page = 1;
}
else
{
fromDate = fdtFilter;
}
if (toDate != null)
{
page = 1;
}
else
{
toDate = tdFilter;
}
ViewBag.CurrentFilter = searchString;
ViewBag.FDtFilter = fromDate;
ViewBag.TDFilter = toDate;
if (!String.IsNullOrEmpty(searchString))
{
logsViewModel = logsViewModel.Where(u => u.FullName.ToLower().Contains(searchString.ToLower()) ||
u.EnrollNum.ToString() == searchString).ToList();
}
if (!String.IsNullOrEmpty(fromDate) && !String.IsNullOrEmpty(toDate))
{
logsViewModel = logsViewModel.Where(u => u.LogDate.AsDateTime().Date >= fromDate.AsDateTime().Date&& u.LogDate.AsDateTime().Date <= toDate.AsDateTime().Date).ToList();
}
switch (sortOrder)
{
case "num_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.EnrollNum).ToList();
break;
case "Name":
logsViewModel = logsViewModel.OrderBy(c => c.FullName).ToList();
break;
case "name_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.FullName).ToList();
break;
case "date_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.LogDate).ToList();
break;
case "Date":
logsViewModel = logsViewModel.OrderBy(c => c.LogDate).ToList();
break;
case "Day":
logsViewModel = logsViewModel.OrderBy(c => c.LogDate.AsDateTime().DayOfWeek).ToList();
break;
case "day_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.LogDate.AsDateTime().DayOfWeek).ToList();
break;
case "cname_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.CommunityCenterName).ToList();
break;
case "CommunityCenterName":
logsViewModel = logsViewModel.OrderBy(c => c.CommunityCenterName).ToList();
break;
case "LogIn":
logsViewModel = logsViewModel.OrderBy(c => c.LogInTime).ToList();
break;
case "login_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.LogInTime).ToList();
break;
case "LogOut":
logsViewModel = logsViewModel.OrderBy(c => c.LogOutTime).ToList();
break;
case "logout_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.LogOutTime).ToList();
break;
case "dname_desc":
logsViewModel = logsViewModel.OrderByDescending(c => c.DepartmentName).ToList();
break;
case "DepartmentName":
logsViewModel = logsViewModel.OrderBy(c => c.DepartmentName).ToList();
break;
default:
logsViewModel = logsViewModel.OrderBy(c => c.EnrollNum).ToList();
break;
}
int pageSize = (int)Math.Ceiling(logsViewModel.Count / 10.0);
int pageNumber = (page ?? 1);
return(View(logsViewModel.ToPagedList(pageNumber, pageSize)));
#region Comments
//DeviceManipulator mainpulator = new DeviceManipulator();
//if (mainpulator.ConnectDevice("192.168.1.201", 4370) == ConnectStatus.Connected)
//{
// ICollection<LogDataInfo> logs = mainpulator.GetAllLogInfo(1);
// foreach (var log in logs)
// {
// log.CreatedBy = "r.mazed";
// var user = db.UserInfos.Where(c => c.EnrollNumber == log.EnrollNum).FirstOrDefault();
// if (user != null)
// {
// log.UserInfoId = user != null ? user.Id : 0;
// db.LogDataInfos.Add(log);
// db.SaveChanges();
// }
// }
// return View(new List<LogDataInfoViewModel>());
//}
//else
// return View(new List<LogDataInfoViewModel>());
#endregion
}
