private void Btn_time_out_Click(object sender, RoutedEventArgs e) { UserTime utiem = new UserTime(); TimeItem itemtime = new TimeItem(); utiem.getclockin(mitem._EMPID); DateTime timein; DateTime.TryParse(ClockInItem.Clockin.TIME_IN, out timein); DateTime timeout; DateTime.TryParse(DateTime.Now.ToString("HH:mm"), out timeout); //double totalHours = (timeout - timein).TotalHours; TimeSpan totalHours = timeout.Subtract(timein); int totalMinutes = timeout.Subtract(timein).Minutes; itemtime.EMP_ID = mitem._EMPID; itemtime.TIME_OUT = DateTime.Now.ToString("hh:mm:ss tt"); itemtime.HOURS = totalHours; itemtime.LOG_ID = LogItem.staticLogIdItem.LOG_ID; Timeout(itemtime); btn_time_in.IsEnabled = true; btn_time_out.IsEnabled = false; }
public string GetProperty(string strPropertyName, string strFormat, System.Globalization.CultureInfo formatProvider, Entities.Users.UserInfo AccessingUser, Scope AccessLevel, ref bool PropertyNotFound) { DateTime now = UserTime.CurrentTimeForUser(AccessingUser); switch (strPropertyName.ToLower()) { case "current": if (strFormat == string.Empty) { strFormat = "D"; } return(now.ToString(strFormat, formatProvider)); case "now": if (strFormat == string.Empty) { strFormat = "g"; } return(now.ToString(strFormat, formatProvider)); default: PropertyNotFound = true; return(string.Empty); } }
// GET: Members/Details/5 public ActionResult Details(string id) { try { // Detail 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //테이블 조회 - 필요할 경우 조인 Members members = db.Members.Find(id); if (members == null) { return(HttpNotFound()); } //복호화 처리 if (globalVal.CloudBreadCryptSetting == "AES256") { DecryptResult(members); //members 타입 } //UTC를 세션의 UserTimeZone으로 변환 - 안하면 UTC 그대로 보임 members.LastLoginDT = UserTime.GetUserTime(DateTime.Parse(members.LastLoginDT), Session["AdminTimeZone"].ToString()).ToString(); members.LastLogoutDT = UserTime.GetUserTime(DateTime.Parse(members.LastLogoutDT), Session["AdminTimeZone"].ToString()).ToString(); members.AccountBlockEndDT = UserTime.GetUserTime(DateTime.Parse(members.AccountBlockEndDT), Session["AdminTimeZone"].ToString()).ToString(); members.CreatedAt = UserTime.GetUserTime(members.CreatedAt.DateTime, Session["AdminTimeZone"].ToString()); members.UpdatedAt = UserTime.GetUserTime(members.UpdatedAt.DateTime, Session["AdminTimeZone"].ToString()); members.DataFromRegionDT = UserTime.GetUserTime(members.DataFromRegionDT.DateTime, Session["AdminTimeZone"].ToString()); // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "membersController-Details"; logMessage.Message = string.Format("id : {0}", id); Logging.RunLog(logMessage); return(View(members)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "membersController-Details"; logMessage.Message = string.Format("id : {0}", id); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
public ActionResult DoAdminReservation(string hourSelected) { if (!existSession()) { return(RedirectToAction("Login", "Login", new { area = "Login" })); } UserTime userTime = (UserTime)Session["userTime"]; DateTime reservationDate = userTime.dateOfReservation; reservationDate = reservationDate.AddHours(Convert.ToInt32(hourSelected.Substring(0, 2))); reservationDate = reservationDate.AddMinutes(Convert.ToInt32(hourSelected.Substring(3, 2))); Reservation reservation = new Reservation(); reservation.Date = reservationDate; reservation.Status = true; reservation.UserId = userTime.user.UserId; db.Reservations.Add(reservation); db.SaveChanges(); String message = "Reservation on date" + reservation.Date.ToString() + "is succesfully!"; service.sendEmail(userTime.user.Email, message, "Reservation"); return(RedirectToAction("Index", "Admin")); }
// GET: ItemLists/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ItemLists itemLists = db.ItemLists.Find(id); if (itemLists == null) { return(HttpNotFound()); } //복호화 처리 if (globalVal.CloudBreadCryptSetting == "AES256") { DecryptResult(itemLists); //ItemLists 타입 } //UTC를 UserTimeZone으로 변환 itemLists.CreatedAt = UserTime.GetUserTime(itemLists.CreatedAt.DateTime, Session["AdminTimeZone"].ToString()); itemLists.UpdatedAt = UserTime.GetUserTime(itemLists.UpdatedAt.DateTime, Session["AdminTimeZone"].ToString()); return(View(itemLists)); }
public bool CreateClockOut([FromBody] UserTime time) { if (!ModelState.IsValid) { throw new Exception("Invalid Information."); } return(_repo.CreateClockOut(time)); }
public UserTime CreateClockIn([FromBody] UserTime time) { if (!ModelState.IsValid) { throw new Exception("Invalid information"); } return(_repo.CreateClockIn(time)); }
public void Setup() { UserTime = new UserTime() { CurrentUserTime = new DateTime(2019, 07, 01, 12, 00, 00), }; Parser = new DesiredTimeParser(UserTime); }
internal bool CreateClockOut(UserTime time) { int success = _db.Execute(@"UPDATE employeeTimes SET clockOut = @ClockOut WHERE id = @Id;", time); return(success == 1); }
public ResultHelper Post([FromBody] UserTime UserTime) { if (UserTime == null) { return(new ResultHelper(true, UserTime.UserTimeID, ResultHelper.UnSuccessMessage)); } userTimeService.Create(UserTime); return(new ResultHelper(true, UserTime.UserTimeID, ResultHelper.SuccessMessage)); }
public ResultHelper Put(int id, [FromBody] UserTime UserTime) { if (UserTime == null) { return(new ResultHelper(true, UserTime.UserTimeID, ResultHelper.UnSuccessMessage)); } userTimeService.Set(UserTime); return(new ResultHelper(true, UserTime.UserTimeID, ResultHelper.SuccessMessage)); }
public ActionResult Index() { if (User.Identity.IsAuthenticated) { var today = UserTime.LocalNow().Date; return(RedirectToAction("Index", "Month", new { today.Year, today.Month })); } return(RedirectToAction("Login", "Account")); }
internal UserTime CreateClockIn(UserTime time) { int id = _db.ExecuteScalar <int>(@"INSERT INTO employeeTimes (employeeId, businessId, clockIn) VALUES (@EmployeeId, @BusinessId, @ClockIn); SELECT LAST_INSERT_ID();", time); time.Id = id; return(time); }
public ActionResult FindReservation(string daySelected) { if (!existSession()) { return RedirectToAction("Login", "Login", new { area = "Login" }); } UserTime userTime = new UserTime(); try { userTime.dateOfReservation=userTime.dateOfReservation.AddYears(Convert.ToInt32(daySelected.Substring(0, 4))-1); userTime.dateOfReservation=userTime.dateOfReservation.AddMonths(Convert.ToInt32(daySelected.Substring(5, 2))-1); userTime.dateOfReservation=userTime.dateOfReservation.AddDays (Convert.ToInt32(daySelected.Substring(8, 2))-1); userTime.startHour=userTime.startHour.AddHours(8); userTime.endHour=userTime.endHour.AddHours(16); }catch(Exception) { RedirectToAction("Reservation", "User", new { area = "User" }); return Content("<script language='javascript' type='text/javascript'>alert('Insert correct date!');</script>"); } List<Reservation> busyDates = db.Reservations.SqlQuery("SELECT * FROM dbo.Reservation WHERE(DATEPART(yy, Date) = @year AND DATEPART(mm, Date) = @month AND DATEPART(dd, Date) = @day)", new SqlParameter("@year", userTime.dateOfReservation.Year), new SqlParameter("@month", userTime.dateOfReservation.Month), new SqlParameter("@day", userTime.dateOfReservation.Day)).ToList(); List<string> hoursBusy = new List<string>(); for (int index = 0; index < busyDates.Count; index++) { string hour = busyDates.ElementAt(index).Date.ToString().Substring(10, 5); hoursBusy.Add(hour); } List<string> availableHours = new List<string>(); if (hoursBusy.Count > 0) { while (userTime.startHour.AddMinutes(15) <= userTime.endHour) { userTime.startHour=userTime.startHour.AddMinutes(15); string reservationHour = userTime.startHour.Hour.ToString("00.##") + ":" + userTime.startHour.Minute.ToString("00.##"); if (!hoursBusy.Contains(reservationHour)) { availableHours.Add(reservationHour); } } } else { while (userTime.startHour.AddMinutes(15) <= userTime.endHour) { userTime.startHour=userTime.startHour.AddMinutes(15); string reservationHour = userTime.startHour.Hour.ToString("00.##") + ":" + userTime.startHour.Minute.ToString("00.##"); availableHours.Add(reservationHour); } } Session["userTime"] = userTime; return PartialView("../PartialView/_AvailableReservation", availableHours); }
public ActionResult Entry(DateTime?date) { if (!date.HasValue) { var today = UserTime.LocalNow().Date; return(RedirectToAction("Entry", new { date = today.ToString("yyyy-MM-dd") })); } var model = ModelBuilder.Create <DateTime, DayEntryModel>(date.Value); return(View(model)); }
public ResultHelper Delete(int id) { UserTime UserTime = userTimeService.Get(id); if (UserTime == null) { return(new ResultHelper(true, UserTime.UserTimeID, ResultHelper.UnSuccessMessage)); } userTimeService.Delete(UserTime); return(new ResultHelper(true, UserTime.UserTimeID, ResultHelper.SuccessMessage)); }
// GET: AdminMembers/Edit/5 public ActionResult Edit(string id) { try { // Edit 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AdminMembers adminMembers = db.AdminMembers.Find(id); if (adminMembers == null) { return(HttpNotFound()); } //복호화 안함 //복호화 처리 //if (globalVal.CloudBreadCryptSetting == "AES256") //{ // DecryptResult(adminMembers); //} //UTC를 세션의 UserTimeZone으로 변환 - 안하면 UTC 그대로 보임 adminMembers.LastLoginDT = UserTime.GetUserTime(DateTime.Parse(adminMembers.LastLoginDT), Session["AdminTimeZone"].ToString()).ToString(); adminMembers.LastLogoutDT = UserTime.GetUserTime(DateTime.Parse(adminMembers.LastLogoutDT), Session["AdminTimeZone"].ToString()).ToString(); // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "AdminMembersController-Edit(id)"; logMessage.Message = string.Format("id : {0}", id); Logging.RunLog(logMessage); return(View(adminMembers)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "AdminMembersController-Edit(id)"; logMessage.Message = string.Format("id : {0}", id); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
public ActionResult AdminReservation(int?id) { if (!existSession()) { return(RedirectToAction("Login", "Login", new { area = "Login" })); } UserTime userTime = new UserTime(); userTime.user = db.Users.Find(id); Session["userTime"] = userTime; return(View()); }
private void AddOrUpdateUserToChannel(int userId, int channelId) { // Make sure the user has an entry. UserActivtyEntry entry = null; while (!m_userMap.TryGetValue(userId, out entry)) { // Create a new entry for this user. entry = new UserActivtyEntry() { ActiveChannels = new Dictionary <int, UserTime>() }; // Try to add the user to the map. m_userMap.TryAdd(userId, entry); } // Check if the user is already known to be watching or not. bool fireNotification = false; DateTime joined = DateTime.MinValue; lock (entry.ActiveChannels) { UserTime time; if (entry.ActiveChannels.TryGetValue(channelId, out time)) { // Update the last time we saw this entry.ActiveChannels[channelId].LastSeen = DateTime.Now; } else { // Create a new entry. joined = DateTime.Now; fireNotification = true; time = new UserTime() { Joined = joined, LastSeen = DateTime.Now }; // Add it to the user's list entry.ActiveChannels.Add(channelId, time); } } // If we should fire a notification and we found a new user fire the event. if (fireNotification) { FireUserActivity(userId, channelId, true, joined); } }
public ActionResult Edit([Bind(Include = "MemberItemPurchaseID,MemberID,ItemListID,PurchaseQuantity,PurchasePrice,PGinfo1,PGinfo2,PGinfo3,PGinfo4,PGinfo5,PurchaseDeviceID,PurchaseDeviceIPAddress,PurchaseDeviceMACAddress,PurchaseDT,PurchaseCancelYN,PurchaseCancelDT,PurchaseCancelingStatus,PurchaseCancelReturnedAmount,PurchaseCancelDeviceID,PurchaseCancelDeviceIPAddress,PurchaseCancelDeviceMACAddress,sCol1,sCol2,sCol3,sCol4,sCol5,sCol6,sCol7,sCol8,sCol9,sCol10,HideYN,DeleteYN,PurchaseCancelConfirmAdminMemberID,CreatedAt,UpdatedAt,DataFromRegion,DataFromRegionDT")] MemberItemPurchases memberItemPurchases) { try { // Edit 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } if (ModelState.IsValid) { // Edit 입력값 자동처리 memberItemPurchases.PurchaseDT = UserTime.SetUtcTime(DateTime.Parse(memberItemPurchases.PurchaseDT), Session["AdminTimeZone"].ToString()).ToString(); memberItemPurchases.PurchaseCancelDT = UserTime.SetUtcTime(DateTime.Parse(memberItemPurchases.PurchaseCancelDT), Session["AdminTimeZone"].ToString()).ToString(); memberItemPurchases.UpdatedAt = DateTimeOffset.UtcNow; //UserTime.SetUtcTime() // 암호화 처리 if (globalVal.CloudBreadCryptSetting == "AES256") { EncryptResult(memberItemPurchases); } db.Entry(memberItemPurchases).State = EntityState.Modified; // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "MemberItemPurchasesController-Edit(memberItemPurchases)"; logMessage.Message = JsonConvert.SerializeObject(memberItemPurchases); Logging.RunLog(logMessage); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(memberItemPurchases)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "MemberItemPurchasesController-Edit(memberItemPurchases)"; logMessage.Message = JsonConvert.SerializeObject(memberItemPurchases); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
public ActionResult Edit([Bind(Include = "NoticeID,NoticeCategory1,NoticeCategory2,NoticeCategory3,TargetGroup,TargetOS,TargetDevice,NoticeImageLink,title,content,sCol1,sCol2,sCol3,sCol4,sCol5,sCol6,sCol7,sCol8,sCol9,sCol10,NoticeDurationFrom,NoticeDurationTo,OrderNumber,CreateAdminID,HideYN,DeleteYN,CreatedAt,UpdatedAt,DataFromRegion,DataFromRegionDT")] Notices notices) { try { // Edit 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } if (ModelState.IsValid) { // Edit 입력값 자동처리 notices.NoticeDurationFrom = UserTime.SetUtcTime(notices.NoticeDurationFrom.DateTime, Session["AdminTimeZone"].ToString()); notices.NoticeDurationTo = UserTime.SetUtcTime(notices.NoticeDurationTo.DateTime, Session["AdminTimeZone"].ToString()); notices.UpdatedAt = DateTimeOffset.UtcNow; // 암호화 처리 if (globalVal.CloudBreadCryptSetting == "AES256") { EncryptResult(notices); } db.Entry(notices).State = EntityState.Modified; // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "NoticesController-Edit(notices)"; logMessage.Message = JsonConvert.SerializeObject(notices); Logging.RunLog(logMessage); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(notices)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "NoticesController-Edit(notices)"; logMessage.Message = JsonConvert.SerializeObject(notices); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
public ActionResult FindReservation(string daySelected) { UserTime userTime = new UserTime(); userTime.dateOfReservation = userTime.dateOfReservation.AddYears(Convert.ToInt32(daySelected.Substring(0, 4)) - 1); userTime.dateOfReservation = userTime.dateOfReservation.AddMonths(Convert.ToInt32(daySelected.Substring(5, 2)) - 1); userTime.dateOfReservation = userTime.dateOfReservation.AddDays(Convert.ToInt32(daySelected.Substring(8, 2)) - 1); userTime.startHour = userTime.startHour.AddHours(8); userTime.endHour = userTime.endHour.AddHours(16); List <Reservation> busyDates = db.Reservations.SqlQuery("SELECT * FROM dbo.Reservation WHERE(DATEPART(yy, Date) = @year AND DATEPART(mm, Date) = @month AND DATEPART(dd, Date) = @day)", new SqlParameter("@year", userTime.dateOfReservation.Year), new SqlParameter("@month", userTime.dateOfReservation.Month), new SqlParameter("@day", userTime.dateOfReservation.Day)).ToList(); List <string> hoursBusy = new List <string>(); for (int index = 0; index < busyDates.Count; index++) { string hour = busyDates.ElementAt(index).Date.ToString().Substring(10, 5); hoursBusy.Add(hour); } List <string> availableHours = new List <string>(); if (hoursBusy.Count > 0) { while (userTime.startHour.AddMinutes(15) <= userTime.endHour) { userTime.startHour = userTime.startHour.AddMinutes(15); string reservationHour = userTime.startHour.Hour.ToString("00.##") + ":" + userTime.startHour.Minute.ToString("00.##"); if (!hoursBusy.Contains(reservationHour)) { availableHours.Add(reservationHour); } } } else { while (userTime.startHour.AddMinutes(15) <= userTime.endHour) { userTime.startHour = userTime.startHour.AddMinutes(15); string reservationHour = userTime.startHour.Hour.ToString("00.##") + ":" + userTime.startHour.Minute.ToString("00.##"); availableHours.Add(reservationHour); } } Session["userTime"] = userTime; return(PartialView("../PartialView/_AvailableReservation", availableHours)); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (!String.IsNullOrEmpty(CssClass)) { lblDate.CssClass = CssClass; } var objUserTime = new UserTime(); if (!String.IsNullOrEmpty(DateFormat)) { lblDate.Text = objUserTime.CurrentUserTime.ToString(DateFormat); } else { lblDate.Text = objUserTime.CurrentUserTime.ToLongDateString(); } }
protected void Page_Load(Object sender, EventArgs e) { // public attributes if (!String.IsNullOrEmpty(CssClass)) { lblDate.CssClass = CssClass; } UserTime objUserTime = new UserTime(); if (!String.IsNullOrEmpty(DateFormat)) { lblDate.Text = string.Format(DateFormat, objUserTime.CurrentUserTime); } else { lblDate.Text = objUserTime.CurrentUserTime.ToLongDateString(); } }
public IJob GetJob(int?userID, string messageText) { if (userID == null) { return(new WelcomeJob()); } var userTimeInfo = new UserTime() //todo: get by userID { CurrentUserTime = DateTime.Now }; var parsedMessage = _parser.Parse(messageText, userTimeInfo); if (parsedMessage != null) { return(new ScheduleReminderJob()); } throw new NotImplementedException("Cannot process message"); }
public ActionResult DoReservation(string hourSelected) { if (!existSession()) { return(RedirectToAction("Login", "Login", new { area = "Login" })); } UserTime userTime = (UserTime)Session["userTime"]; DateTime reservationDate = userTime.dateOfReservation; reservationDate = reservationDate.AddHours(Convert.ToInt32(hourSelected.Substring(0, 2))); reservationDate = reservationDate.AddMinutes(Convert.ToInt32(hourSelected.Substring(3, 2))); Reservation reservation = new Reservation(); reservation.Date = reservationDate; reservation.Status = true; reservation.UserId = Convert.ToInt32(Session["UserId"].ToString()); db.Reservations.Add(reservation); db.SaveChanges(); return(RedirectToAction("Home", "Home")); }
public DayEntryModel Create(DateTime input) { var entryId = DayEntry.GenerateId(_userId, input); var entry = _session.Load <DayEntry>(entryId); var model = new DayEntryModel(input); if (entry != null) { model.PreviousAnswer = new DayEntryModel.Previous(entry.HoursWorked, UserTime.FromUtc(entry.Timestamp)); model.Command.HoursWorked = entry.HoursWorked; } return(model); }
// GET: MemberAccountBlockLogs/Details/5 public ActionResult Details(string id) { try { // Detail 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //테이블 조인 처리 var result = from mab in db.MemberAccountBlockLog.ToList() join m in db.Members on mab.MemberID equals m.MemberID where mab.MemberAccountBlockID == id //id값 select new MemberAccountBlockLog() { MemberAccountBlockID = mab.MemberAccountBlockID, MemberID = mab.MemberID, MemberAccountBlockReasonCategory1 = mab.MemberAccountBlockReasonCategory1, MemberAccountBlockReasonCategory2 = mab.MemberAccountBlockReasonCategory2, MemberAccountBlockReasonCategory3 = mab.MemberAccountBlockReasonCategory3, MemberAccountBlockReason = mab.MemberAccountBlockReason, MemberAccountBlockProcess = mab.MemberAccountBlockProcess, sCol1 = mab.sCol1, sCol2 = mab.sCol2, sCol3 = mab.sCol3, sCol4 = mab.sCol4, sCol5 = mab.sCol5, sCol6 = mab.sCol6, sCol7 = mab.sCol7, sCol8 = mab.sCol8, sCol9 = mab.sCol9, sCol10 = mab.sCol10, CreateAdminID = mab.CreateAdminID, HideYN = mab.HideYN, DeleteYN = mab.DeleteYN, CreatedAt = mab.CreatedAt, UpdatedAt = mab.UpdatedAt, DataFromRegion = mab.DataFromRegion, DataFromRegionDT = mab.DataFromRegionDT, Members = new Members() { Name1 = m.Name1 } }; if (result == null) { return(HttpNotFound()); } // FirstOrDefault result1로 재처리 var result1 = result.FirstOrDefault(); //복호화 처리 if (globalVal.CloudBreadCryptSetting == "AES256") { DecryptResult(result1); } //UTC를 세션의 UserTimeZone으로 변환 - 안하면 UTC 그대로 보임 result1.CreatedAt = UserTime.GetUserTime(result1.CreatedAt.DateTime, Session["AdminTimeZone"].ToString()); result1.UpdatedAt = UserTime.GetUserTime(result1.UpdatedAt.DateTime, Session["AdminTimeZone"].ToString()); result1.DataFromRegionDT = UserTime.GetUserTime(result1.DataFromRegionDT.DateTime, Session["AdminTimeZone"].ToString()); // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "MemberAccountBlockLogController-Details"; logMessage.Message = string.Format("id : {0}", id); Logging.RunLog(logMessage); return(View(result1)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "MemberAccountBlockLogController-Details"; logMessage.Message = string.Format("id : {0}", id); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
// GET: MemberAccountBlockLogs public ActionResult Index(string searchString, string SearchCondition, string currentFilter, int?page) { try { // Index 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } //페이징 기본 처리 if (searchString != null) { page = 1; } else { searchString = currentFilter; } //암호화일 경우 searchString도 암호화해 검색 해야 한다. if (globalVal.CloudBreadCryptSetting == "AES256" && searchString != null) { searchString = Crypto.AES_encrypt(searchString, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); ViewBag.CurrentFilter = searchString; } else { ViewBag.CurrentFilter = searchString; } ViewBag.SearchCondition = SearchCondition; var queryString = from mab in db.MemberAccountBlockLog.ToList() join m in db.Members on mab.MemberID equals m.MemberID select new MemberAccountBlockLog() { MemberAccountBlockID = mab.MemberAccountBlockID, MemberID = mab.MemberID, MemberAccountBlockReasonCategory1 = mab.MemberAccountBlockReasonCategory1, MemberAccountBlockReasonCategory2 = mab.MemberAccountBlockReasonCategory2, MemberAccountBlockReasonCategory3 = mab.MemberAccountBlockReasonCategory3, MemberAccountBlockReason = mab.MemberAccountBlockReason, MemberAccountBlockProcess = mab.MemberAccountBlockProcess, sCol1 = mab.sCol1, sCol2 = mab.sCol2, sCol3 = mab.sCol3, sCol4 = mab.sCol4, sCol5 = mab.sCol5, sCol6 = mab.sCol6, sCol7 = mab.sCol7, sCol8 = mab.sCol8, sCol9 = mab.sCol9, sCol10 = mab.sCol10, CreateAdminID = mab.CreateAdminID, HideYN = mab.HideYN, DeleteYN = mab.DeleteYN, CreatedAt = mab.CreatedAt, UpdatedAt = mab.UpdatedAt, DataFromRegion = mab.DataFromRegion, DataFromRegionDT = mab.DataFromRegionDT, Members = new Members() { Name1 = m.Name1 } }; if (!String.IsNullOrEmpty(searchString)) { switch (SearchCondition) { case "MemberAccountBlockID ": queryString = queryString.Where(s => s.MemberAccountBlockID.Contains(searchString)); break; case "MemberID ": queryString = queryString.Where(s => s.MemberID.Contains(searchString)); break; default: break; } } // 기본 order 처리 - CreatedAt으로 정렬 처리 - ToPagedList의 제약 조건 queryString = queryString.OrderByDescending(s => s.CreatedAt); int pageSize = globalVal.CloudBreadAdminWebListPageSize; int pageNumber = (page ?? 1); var result = queryString.ToPagedList(pageNumber, pageSize); if (globalVal.CloudBreadCryptSetting == "AES256") { // 복호화 foreach (var item in result) { DecryptResult(item); } } //날자 데이터 현지 시각으로 변환 foreach (var item in result) { item.CreatedAt = UserTime.GetUserTime(item.CreatedAt.DateTime, Session["AdminTimeZone"].ToString()); item.UpdatedAt = UserTime.GetUserTime(item.UpdatedAt.DateTime, Session["AdminTimeZone"].ToString()); } // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "MemberAccountBlockLogController-Index"; logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition); Logging.RunLog(logMessage); return(View(result)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "MemberAccountBlockLogController-Index"; logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
public UserTime Add(UserTime NewUserTime) { UserTimes.Add(NewUserTime); NewUserTime.Id = UserTimes.Max(ut => ut.Id) + 1; return(NewUserTime); }