public bool Add(string UserName, string SystemID) { AUTH_LOGIN_LOG LoginLog = new AUTH_LOGIN_LOG(); LoginLog.LOG_ID = LoginLogRepository.GetNewID("AUTH_LOGIN_LOG", "LOG_ID"); LoginLog.LOGIN_PC = System.Net.Dns.Resolve(System.Net.Dns.GetHostName()).AddressList[0].ToString(); LoginLog.LOGIN_TIME = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); LoginLog.SYSTEM_SYSTEM_ID = SystemID; LoginLog.USER_USER_ID = UserRepository.GetSingle(i => i.USER_NAME == UserName).USER_ID; LoginLogRepository.Add(LoginLog); LoginLogRepository.SaveChanges(); return(true); }
public bool UpdateLoginLog(string user_name, string logout_time) { var LoginLog = LoginLogRepository.GetQueryable().Where(s => s.User.UserName == user_name).Select(s => s).OrderByDescending(s => s.LoginTime).ToArray(); if (LoginLog.Length > 0) { LoginLog[0].LogoutTime = logout_time; LoginLogRepository.SaveChanges(); return(true); } else { return(false); } }
public bool Delete(string loginLogId, out string strResult) { strResult = string.Empty; bool result = false; Guid loid = new Guid(loginLogId); var log = LoginLogRepository.GetQueryable().FirstOrDefault(lo => lo.LogID == loid); if (log != null) { LoginLogRepository.Delete(log); LoginLogRepository.SaveChanges(); result = true; } else { strResult = "原因:未找到当前需要删除的数据!"; } return(result); }
public bool Emptys(out string strResult) { strResult = string.Empty; bool result = false; var log = LoginLogRepository.GetQueryable(); if (log != null) { foreach (var lo in log) { LoginLogRepository.Delete(lo); } LoginLogRepository.SaveChanges(); result = true; } else { strResult = "原因:未找到当前需要删除的数据!"; } return(result); }
public bool CreateLoginLog(string login_time, string user_name, Guid system_ID, string ipaddress) { var userid = UserRepository.GetQueryable().Where(s => s.UserName == user_name).Select(s => new { userId = s.UserID }); if (userid.ToArray().Length > 0) { var LoginLog = new LoginLog() { LogID = Guid.NewGuid(), LoginPC = ipaddress, LoginTime = login_time, LogoutTime = "", User_UserID = userid.ToArray()[0].userId, System_SystemID = system_ID }; LoginLogRepository.Add(LoginLog); LoginLogRepository.SaveChanges(); return(true); } else { return(false); } }
/// <summary>Save DAR for QRC Type /// <CreatedFor>For Insert QRC Type</CreatedFor> /// <CreatedBy>Bhusha n Dod</CreatedBy> /// <CreatedOn>Feb-13-2015</CreatedOn> /// </summary> /// <param name="obj"></param> /// <returns></returns> public ServiceDARModel SaveDARDetails(ServiceDARModel obj) { ObjUserRepository = new UserRepository(); objDARRepository = new DARRepository(); workorderEMSEntities _workorderEMSEntities = new workorderEMSEntities(); bool IsContinuesWOExist = false; string startTimeDAR = ""; string endTimeDAR = ""; string activityString = string.Empty; string activityStringForWONumber = string.Empty; try { if (obj.LocationId > 0 && obj.ServiceAuthKey != null) { var authuser = ObjUserRepository.GetSingleOrDefault(x => x.ServiceAuthKey == obj.ServiceAuthKey && x.IsDeleted == false); if (obj.ActivityDetails != null) { activityString = obj.ActivityDetails.Substring(obj.ActivityDetails.LastIndexOf(',') + 1); activityStringForWONumber = activityString.Substring(activityString.LastIndexOf('r') + 1); } //322 and 323 is used for continues pause and resume var IsPauseResume = obj.TaskType == Convert.ToInt64(ContinuesPauseResume.Pause) ? true : obj.TaskType == Convert.ToInt64(ContinuesPauseResume.Resume) ? true : false; if (authuser != null && authuser.UserId > 0 && obj.TaskType != 280) { //TO find Any continues WO complete before Notification Arrival var clientdt = DateTime.UtcNow.GetClientDateTimeNow(); //flag status for if user filter record in time span so to date is till midnight. bool isUTCDay = true; DateTime _fromDate = clientdt.Date; DateTime _toDate = clientdt.AddDays(1).Date; var todayDARDetails = _workorderEMSEntities.DARDetails.Where(x => x.UserId == authuser.UserId && x.LocationId == obj.LocationId && x.IsDeleted == false && x.CreatedOn >= _fromDate && (x.TaskType == 320 || x.TaskType == 321) && x.CreatedOn <= _toDate).ToList(); foreach (var item in todayDARDetails) { var darActivity = item.ActivityDetails; var stringCon = darActivity.Substring(darActivity.LastIndexOf(',') + 1); var stringCon1 = stringCon.Substring(stringCon.LastIndexOf('r') + 1); if (activityStringForWONumber == stringCon1) { IsContinuesWOExist = true; startTimeDAR = item.StartTime.ToString(); endTimeDAR = item.EndTime.ToString(); } } if (IsContinuesWOExist == true && IsPauseResume == false) { if (startTimeDAR != "" && endTimeDAR == "") { obj.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture); obj.ResponseMessage = CommonMessage.AlreadyContinuesWOStart(activityStringForWONumber); } else if (startTimeDAR == "" && endTimeDAR != "") { obj.Response = Convert.ToInt32(ServiceResponse.NoRecord, CultureInfo.CurrentCulture); obj.ResponseMessage = CommonMessage.AlreadyContinuesWOComplete(activityStringForWONumber); } } else { //obj.ActivityDetails = DarMessage.QrcVehicleCleaning(obj.UserName); var result = objDARRepository.SaveDARDetails(obj); if (result != null && result > 0) { obj.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture); obj.DARId = result; obj.ResponseMessage = CommonMessage.SaveSuccessMessage(); } else { obj.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture); obj.DARId = result; obj.ResponseMessage = CommonMessage.WrongParameterMessage(); } } } else if (authuser != null && authuser.UserId > 0 && obj.TaskType == 280) { var objLoginLogRepository = new LoginLogRepository(); obj.ActivityDetails = DarMessage.ShiftEnd(obj.UserName); var result = objDARRepository.SaveDARDetails(obj); if (result != null && result > 0) { var loginlog = objLoginLogRepository.GetSingleOrDefault(x => x.UserID == authuser.UserId && x.LogId == obj.LogId && x.IsDeleted == false && x.IsActive == true); if (loginlog.LogId != 0) { loginlog.IsActive = false; loginlog.ShiftEnd = DateTime.Now; objLoginLogRepository.Update(loginlog); objLoginLogRepository.SaveChanges(); } var data = ObjUserRepository.GetSingleOrDefault(v => v.UserId == obj.UserId && v.IsDeleted == false); if (data != null) { data.ModifiedBy = obj.UserId; data.ModifiedDate = DateTime.UtcNow; data.IdleTimeLimit = Convert.ToDateTime("00:30"); ObjUserRepository.Update(data); obj.Response = Convert.ToInt32(ServiceResponse.SuccessResponse, CultureInfo.CurrentCulture); obj.DARId = result; obj.ResponseMessage = CommonMessage.SaveSuccessMessage(); } } else { obj.Response = Convert.ToInt32(ServiceResponse.ExeptionResponse, CultureInfo.CurrentCulture); obj.DARId = result; obj.ResponseMessage = CommonMessage.WrongParameterMessage(); } } else { obj.Response = Convert.ToInt32(ServiceResponse.InvalidSessionResponse, CultureInfo.CurrentCulture); obj.ResponseMessage = CommonMessage.InvalidUser(); } } else { obj.Response = Convert.ToInt32(ServiceResponse.FailedResponse, CultureInfo.CurrentCulture); obj.ResponseMessage = CommonMessage.WrongParameterMessage(); } } catch (Exception) { throw; } return(obj); }