public dynamic getAttendancesOfClient(int clientId) { var context = new ubietydbEntities(); context.Configuration.ProxyCreationEnabled = false; return (from recordset in context.attRepTemps select recordset); }
public dynamic getAttendances(int id) { var context = new ubietydbEntities(); context.Configuration.ProxyCreationEnabled = false; var abc = (from recordset in context.attRepTemps where recordset.empid == id select recordset); return abc ; }
public int MarkAttendance(int empid, int shift) { var context = new ubietydbEntities(); Attendance attendance = new Attendance(); attendance.EmpId = empid; attendance.MarkFlagId = shift; attendance.MarkTime = TimeZoneInfo.ConvertTime(new DateTime(DateTime.Now.Ticks), TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")); context.Attendances.Add(attendance); return context.SaveChanges(); }
public dynamic GetEmpDetailsOfEmpId(int id) { var context = new ubietydbEntities(); context.Configuration.ProxyCreationEnabled = false; var dataset2 = (from recordset in context.Employees where recordset.EmpId == id select new EmployeeDTO { EmpId = recordset.EmpId, EmpNum = recordset.EmpNum, EmpName = recordset.EmpName, Email = recordset.Email, MobileNum = recordset.PrimaryMobile, ProfilePicURL = recordset.ProfilePic }); return new { employee = dataset2 }; }
public dynamic getAttendance(int id) { var context = new ubietydbEntities(); context.Configuration.ProxyCreationEnabled = false; var abc = (from recordset in context.attendancereports where recordset.empid == id select new AttendanceLineDetail { inMarkTime = recordset.inmarktime, inLatitude = recordset.inlatitude, inLongitude = recordset.inlongitude, inMarkCount = 1, empId = recordset.empid, outMarkTime = recordset.outmarktime, outLatitude = recordset.outlatitude, outLongitude = recordset.outlongitude, outMarkCount = 2 }); return new { attendance = abc }; }
public int MarkAttendanceWithLatLon(int empid, int shift, Double latitude, Double longitude, Int16 markcount) { var context = new ubietydbEntities(); Attendance attendance = new Attendance(); attendance.EmpId = empid; attendance.MarkFlagId = shift; attendance.MarkTime = TimeZoneInfo.ConvertTime(new DateTime(DateTime.Now.Ticks), TimeZoneInfo.FindSystemTimeZoneById("India Standard Time")); attendance.latitude = latitude; attendance.longitude = longitude; attendance.markcount = markcount; context.Attendances.Add(attendance); return context.SaveChanges(); }
public ICollection<Employee> GetOrgEmp(int ClientId) { var context = new ubietydbEntities(); context.Configuration.ProxyCreationEnabled = false; var empclients = context.Employees.Where(b => b.CompanyId == ClientId).ToList(); return empclients; }