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);
}
