/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="activityId"></param>
/// <param name="employeeName"></param>
/// <returns></returns>
public bool InsertTimeOut(ClockOutQueryModel clockOut)
{
DailyTimeOut newRecord = new DailyTimeOut();
try
{
using (TimeInEntities context = new TimeInEntities())
{
newRecord.EmployeeId = clockOut.UserId;
newRecord.ActivityCd = clockOut.ActivityId;
newRecord.TimeOutDttm = clockOut.ClockOutDateTime;
newRecord.IsActive = true;
newRecord.CreateDttm = DateTime.Now;
newRecord.CreateUserId = clockOut.UserName;
newRecord.UpdateDttm = DateTime.Now;
newRecord.UpdateUserId = clockOut.UserName;
context.DailyTimeOuts.Add(newRecord);
context.SaveChanges();
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
/// <summary>
/// Updates existing Activity.
/// </summary>
/// <param name="activityId"></param>
/// <param name="newActivity"></param>
/// <returns></returns>
public string UpdateActivity(int activityId, Activity newActivity)
{
Activity activityQuery = new Activity();
try
{
using (TimeInEntities context = new TimeInEntities())
{
activityQuery = context.Activities
.Where(x => x.ActivityId == activityId && x.IsActive == true).FirstOrDefault();
activityQuery.ActivityNm = newActivity.ActivityNm;
activityQuery.UpdateDttm = DateTime.Now;
context.Activities.Attach(activityQuery);
context.SaveChanges();
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("Activity updated.");
}
/// <summary>
///
/// </summary>
/// <param name="firstName"></param>
/// <param name="lastName"></param>
/// <param name="userName"></param>
/// <returns></returns>
public string InsertNewUser(string firstName, string lastName, string userName)
{
User newUser = new User();
try
{
using (TimeInEntities context = new TimeInEntities())
{
newUser.FirstName = firstName;
newUser.LastName = lastName;
newUser.IsActive = true;
newUser.UserName = userName;
newUser.UserPassword = "******";
newUser.CreateDttm = DateTime.Now;
newUser.CreateUserId = "Admin";
newUser.UpdateDttm = DateTime.Now;
newUser.UpdateUserId = "Admin";
context.Users.Add(newUser);
context.SaveChanges();
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("New user inserted.");
}
/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="newPassword"></param>
/// <returns></returns>
public string UpdatePassword(int userId, string newPassword)
{
User userQuery = new User();
try
{
using (TimeInEntities context = new TimeInEntities())
{
userQuery = context.Users.Where(x => x.UserKey == userId && x.IsActive == true).FirstOrDefault();
userQuery.UserPassword = newPassword;
userQuery.UpdateDttm = DateTime.Now;
userQuery.UpdateUserId = userQuery.UserName;
context.Users.Attach(userQuery);
context.Entry(userQuery).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("User record updated.");
}
/// <summary>
///
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public DailyTimeOut GetEmployeeDailyTimeOut(string userName, DateTime timeIn)
{
using (TimeInEntities context = new TimeInEntities())
{
var query = context.DailyTimeOuts.Include("Activity").Where(x => x.User.UserName.Equals(userName) &&
x.IsActive && DbFunctions.TruncateTime(x.TimeOutDttm) == timeIn.Date).FirstOrDefault();
return(query);
}
}
/// <summary>
///
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public DailyTimeIn GetEmployeeRecentTimeIn(string userName)
{
using (TimeInEntities context = new TimeInEntities())
{
var query = context.DailyTimeIns.Include("Activity").Where(x => x.User.UserName.Equals(userName) &&
x.IsActive).OrderByDescending(x => x.TimeInDttm).FirstOrDefault();
return(query);
}
}
/// <summary>
///
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public List <DailyTimeOut> GetDailyTimeOut(DateTime date)
{
List <DailyTimeOut> timeOutList = new List <DailyTimeOut>();
using (TimeInEntities context = new TimeInEntities())
{
timeOutList = context.DailyTimeOuts.Where(x => x.UpdateDttm.Date == date.Date).ToList();
}
return(timeOutList);
}
/// <summary>
/// Gets specific Activity from Activity table.
/// </summary>
/// <param name="activityId"></param>
/// <returns>Activity object</returns>
public Activity GetActivitySingle(int activityId)
{
Activity activityItem = new Activity();
using (TimeInEntities context = new TimeInEntities())
{
activityItem = context.Activities.Where(x => x.ActivityId == activityId && x.IsActive == true).FirstOrDefault();
}
return(activityItem);
}
/// <summary>
///
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public User GetUser(string userName)
{
User userQuery = new User();
using (TimeInEntities context = new TimeInEntities())
{
userQuery = context.Users.Where(x => x.UserName == userName && x.IsActive == true).FirstOrDefault();
}
return(userQuery);
}
/// <summary>
///
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public List <DailyTimeOut> GetMonthTimeOut(DateTime date)
{
DateTime firstDayOfMonth = new DateTime(date.Year, date.Month, 1);
DateTime lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);
List <DailyTimeOut> timeOutList = new List <DailyTimeOut>();
using (TimeInEntities context = new TimeInEntities())
{
timeOutList = context.DailyTimeOuts.Where(x => x.CreateDttm > firstDayOfMonth && x.CreateDttm < lastDayOfMonth).ToList();
}
return(timeOutList);
}
/// <summary>
///
/// </summary>
/// <param name="userKey"></param>
/// <param name="month"></param>
/// <returns></returns>
public List <DailyTimeOut> GetEmployeeMonthTimeOut(int userKey, DateTime month)
{
DateTime firstDayOfMonth = new DateTime(month.Year, month.Month, 1);
DateTime lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);
using (TimeInEntities context = new TimeInEntities())
{
var query = context.DailyTimeOuts.Where(x => x.EmployeeId == userKey &&
(x.TimeOutDttm > firstDayOfMonth && x.TimeOutDttm < lastDayOfMonth) &&
x.IsActive == true)
.ToList();
return(query);
}
}
/// <summary>
/// Inserts new Acitivity to the database.
/// </summary>
/// <param name="newActivity"></param>
/// <returns></returns>
public string InsertActivity(Activity newActivity)
{
try
{
using (TimeInEntities context = new TimeInEntities())
{
context.Activities.Add(newActivity);
context.SaveChanges();
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("Activity saved.");
}
/// <summary>
/// Gets all active Activities from database.
/// </summary>
/// <returns></returns>
public List <ActivityModel> GetAllActivities()
{
List <ActivityModel> activities = new List <ActivityModel>();
using (TimeInEntities context = new TimeInEntities())
{
activities = context.Activities.Where(x => x.IsActive == true).Select(x => new ActivityModel {
ActivityId = x.ActivityId,
ActivityNm = x.ActivityNm,
IsActive = x.IsActive,
CreateDttm = x.CreateDttm,
CreateUserId = x.CreateUserId,
UpdateDttm = x.UpdateDttm,
UpdateUserId = x.UpdateUserId
}).ToList();
}
return(activities);
}
/// <summary>
///
/// </summary>
/// <param name="firstName"></param>
/// <param name="lastName"></param>
/// <param name="password"></param>
/// <returns></returns>
public bool VerifyPassword(string firstName, string lastName, string password)
{
using (TimeInEntities context = new TimeInEntities())
{
var userQuery = context.Users
.Where(x => x.FirstName.Equals(firstName) &&
x.LastName.Equals(lastName) &&
x.UserPassword.Equals(password) && x.IsActive == true)
.FirstOrDefault();
if (userQuery != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Deactivates specified query. Application will not do hard delete.
/// </summary>
/// <param name="activityId"></param>
/// <returns></returns>
public string DeleteActivity(int activityId)
{
try
{
using (TimeInEntities context = new TimeInEntities())
{
var activityQuery = context.Activities
.Where(x => x.ActivityId == activityId).FirstOrDefault();
activityQuery.IsActive = false;
context.Activities.Attach(activityQuery);
context.SaveChanges();
}
}
catch (Exception ex)
{
return(ex.Message);
}
return("Activity deleted.");
}
