// 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;
}
}
// 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));
}
// 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;
}
}
// GET: Members
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 s in db.Members
select s;
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "MemberID":
queryString = queryString.Where(s => s.MemberID.Contains(searchString));
break;
case "EmailAddress":
queryString = queryString.Where(s => s.EmailAddress.Contains(searchString));
break;
case "Name1":
queryString = queryString.Where(s => s.Name1.Contains(searchString));
break;
case "LastDeviceID":
queryString = queryString.Where(s => s.LastDeviceID.Contains(searchString));
break;
case "3rdAuthID":
queryString = queryString.Where(s => s.C3rdAuthID.Contains(searchString));
break;
case "PushNotificationID":
queryString = queryString.Where(s => s.PushNotificationID.Contains(searchString));
break;
default:
break;
}
}
// 기본 order 처리 - ItemName으로 정렬 처리 - 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 = "MembersController-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 = "MembersController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: CouponMembers/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 cm in db.CouponMember.ToList()
join c in db.Coupon on cm.CouponID equals c.CouponID
join m in db.Members on cm.MemberID equals m.MemberID
where cm.CouponMemberID == id //id값
select new CouponMember()
{
CouponMemberID = cm.CouponMemberID,
CouponID = cm.CouponID,
MemberID = cm.MemberID,
sCol1 = cm.sCol1,
sCol2 = cm.sCol2,
sCol3 = cm.sCol3,
sCol4 = cm.sCol4,
sCol5 = cm.sCol5,
sCol6 = cm.sCol6,
sCol7 = cm.sCol7,
sCol8 = cm.sCol8,
sCol9 = cm.sCol9,
sCol10 = cm.sCol10,
HideYN = cm.HideYN,
DeleteYN = cm.DeleteYN,
CreatedAt = cm.CreatedAt,
UpdatedAt = cm.UpdatedAt,
DataFromRegion = cm.DataFromRegion,
DataFromRegionDT = cm.DataFromRegionDT,
Coupon = new Coupon()
{
Title = c.Title
},
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 = "CouponMemberController-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 = "CouponMemberController-Details";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: ServerInfo/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 si in db.ServerInfo.ToList()
where si.InfoID == id //id값
select new ServerInfo()
{
InfoID = si.InfoID,
FEServerLists = si.FEServerLists,
SocketServerLists = si.SocketServerLists,
Version = si.Version,
ResourceLink = si.ResourceLink,
EULAText = si.EULAText,
sCol1 = si.sCol1,
sCol2 = si.sCol2,
sCol3 = si.sCol3,
sCol4 = si.sCol4,
sCol5 = si.sCol5,
CreatedAt = si.CreatedAt,
UpdatedAt = si.UpdatedAt,
DataFromRegion = si.DataFromRegion,
DataFromRegionDT = si.DataFromRegionDT
};
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 = "ServerInfoController-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 = "ServerInfoController-Details";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: ServerInfo
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 si in db.ServerInfo.ToList()
select new ServerInfo()
{
InfoID = si.InfoID,
FEServerLists = si.FEServerLists,
SocketServerLists = si.SocketServerLists,
Version = si.Version,
ResourceLink = si.ResourceLink,
EULAText = si.EULAText,
sCol1 = si.sCol1,
sCol2 = si.sCol2,
sCol3 = si.sCol3,
sCol4 = si.sCol4,
sCol5 = si.sCol5,
CreatedAt = si.CreatedAt,
UpdatedAt = si.UpdatedAt,
DataFromRegion = si.DataFromRegion,
DataFromRegionDT = si.DataFromRegionDT
};
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "InfoID":
queryString = queryString.Where(s => s.InfoID.Contains(searchString));
break;
case "FEServerLists":
queryString = queryString.Where(s => s.FEServerLists.Contains(searchString));
break;
case "SocketServerLists":
queryString = queryString.Where(s => s.SocketServerLists.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 = "ServerInfoController-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 = "ServerInfoController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: GameEvents
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 ge in db.GameEvents.ToList()
join il in db.ItemLists on ge.ItemListID equals il.ItemListID
select new GameEvents()
{
GameEventID = ge.GameEventID,
EventCategory1 = ge.EventCategory1,
EventCategory2 = ge.EventCategory2,
EventCategory3 = ge.EventCategory3,
ItemListID = ge.ItemListID,
ItemCount = ge.ItemCount,
Itemstatus = ge.Itemstatus,
TargetGroup = ge.TargetGroup,
TargetOS = ge.TargetOS,
TargetDevice = ge.TargetDevice,
EventImageLink = ge.EventImageLink,
Title = ge.Title,
Content = ge.Content,
sCol1 = ge.sCol1,
sCol2 = ge.sCol2,
sCol3 = ge.sCol3,
sCol4 = ge.sCol4,
sCol5 = ge.sCol5,
sCol6 = ge.sCol6,
sCol7 = ge.sCol7,
sCol8 = ge.sCol8,
sCol9 = ge.sCol9,
sCol10 = ge.sCol10,
CreateAdminID = ge.CreateAdminID,
HideYN = ge.HideYN,
DeleteYN = ge.DeleteYN,
OrderNumber = ge.OrderNumber,
EventDurationFrom = ge.EventDurationFrom,
EventDurationTo = ge.EventDurationTo,
CreatedAt = ge.CreatedAt,
UpdatedAt = ge.UpdatedAt,
DataFromRegion = ge.DataFromRegion,
DataFromRegionDT = ge.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
}
};
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "GameEventID":
queryString = queryString.Where(s => s.GameEventID.Contains(searchString));
break;
case "EventCategory1":
queryString = queryString.Where(s => s.EventCategory1.Contains(searchString));
break;
case "ItemListID":
queryString = queryString.Where(s => s.ItemListID.Contains(searchString));
break;
case "Title":
queryString = queryString.Where(s => s.Title.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.EventDurationFrom = UserTime.GetUserTime(item.EventDurationFrom.DateTime, Session["AdminTimeZone"].ToString());
item.EventDurationTo = UserTime.GetUserTime(item.EventDurationTo.DateTime, Session["AdminTimeZone"].ToString());
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 = "GameEventsController-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 = "GameEventsController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// 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: Notices
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 n in db.Notices.ToList()
select new Notices()
{
NoticeID = n.NoticeID,
NoticeCategory1 = n.NoticeCategory1,
NoticeCategory2 = n.NoticeCategory2,
NoticeCategory3 = n.NoticeCategory3,
TargetGroup = n.TargetGroup,
TargetOS = n.TargetOS,
TargetDevice = n.TargetDevice,
NoticeImageLink = n.NoticeImageLink,
title = n.title,
content = n.content,
sCol1 = n.sCol1,
sCol2 = n.sCol2,
sCol3 = n.sCol3,
sCol4 = n.sCol4,
sCol5 = n.sCol5,
sCol6 = n.sCol6,
sCol7 = n.sCol7,
sCol8 = n.sCol8,
sCol9 = n.sCol9,
sCol10 = n.sCol10,
NoticeDurationFrom = n.NoticeDurationFrom,
NoticeDurationTo = n.NoticeDurationTo,
OrderNumber = n.OrderNumber,
CreateAdminID = n.CreateAdminID,
HideYN = n.HideYN,
DeleteYN = n.DeleteYN,
CreatedAt = n.CreatedAt,
UpdatedAt = n.UpdatedAt,
DataFromRegion = n.DataFromRegion,
DataFromRegionDT = n.DataFromRegionDT
};
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "NoticeID":
queryString = queryString.Where(s => s.NoticeID.Contains(searchString));
break;
case "NoticeCategory1":
queryString = queryString.Where(s => s.NoticeCategory1.Contains(searchString));
break;
case "TargetGroup":
queryString = queryString.Where(s => s.TargetGroup.Contains(searchString));
break;
case "Title":
queryString = queryString.Where(s => s.title.Contains(searchString));
break;
default:
break;
}
}
// 기본 order 처리 - 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.NoticeDurationFrom = UserTime.GetUserTime(item.NoticeDurationFrom.DateTime, Session["AdminTimeZone"].ToString());
item.NoticeDurationTo = UserTime.GetUserTime(item.NoticeDurationTo.DateTime, Session["AdminTimeZone"].ToString());
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 = "NoticesController-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 = "NoticesController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: GiftDepositories/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 gd in db.GiftDepositories.ToList()
join il in db.ItemLists on gd.ItemListID equals il.ItemListID
join m in db.Members on gd.FromMemberID equals m.MemberID
join m2 in db.Members on gd.ToMemberID equals m2.MemberID
where gd.GiftDepositoryID == id //id값
select new GiftDepositories()
{
GiftDepositoryID = gd.GiftDepositoryID,
ItemListID = gd.ItemListID,
ItemCount = gd.ItemCount,
FromMemberID = m.MemberID,
ToMemberID = m2.MemberID,
sCol1 = gd.sCol1,
sCol2 = gd.sCol2,
sCol3 = gd.sCol3,
sCol4 = gd.sCol4,
sCol5 = gd.sCol5,
sCol6 = gd.sCol6,
sCol7 = gd.sCol7,
sCol8 = gd.sCol8,
sCol9 = gd.sCol9,
sCol10 = gd.sCol10,
SentMemberYN = gd.SentMemberYN,
HideYN = gd.HideYN,
DeleteYN = gd.DeleteYN,
CreatedAt = gd.CreatedAt,
UpdatedAt = gd.UpdatedAt,
DataFromRegion = gd.DataFromRegion,
DataFromRegionDT = gd.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
},
Members = new Members()
{
Name1 = m.Name1
},
Members1 = new Members()
{
Name1 = m2.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 = "GiftDepositoriesController-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 = "GiftDepositoriesController-Details";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: GiftDepositories
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 gd in db.GiftDepositories.ToList()
join il in db.ItemLists on gd.ItemListID equals il.ItemListID
join m in db.Members on gd.FromMemberID equals m.MemberID
join m2 in db.Members on gd.ToMemberID equals m2.MemberID
select new GiftDepositories()
{
GiftDepositoryID = gd.GiftDepositoryID,
ItemListID = gd.ItemListID,
ItemCount = gd.ItemCount,
FromMemberID = m.MemberID,
ToMemberID = m2.MemberID,
sCol1 = gd.sCol1,
sCol2 = gd.sCol2,
sCol3 = gd.sCol3,
sCol4 = gd.sCol4,
sCol5 = gd.sCol5,
sCol6 = gd.sCol6,
sCol7 = gd.sCol7,
sCol8 = gd.sCol8,
sCol9 = gd.sCol9,
sCol10 = gd.sCol10,
SentMemberYN = gd.SentMemberYN,
HideYN = gd.HideYN,
DeleteYN = gd.DeleteYN,
CreatedAt = gd.CreatedAt,
UpdatedAt = gd.UpdatedAt,
DataFromRegion = gd.DataFromRegion,
DataFromRegionDT = gd.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
},
Members = new Members()
{
Name1 = m.Name1
},
Members1 = new Members()
{
Name1 = m2.Name1
}
};
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "GiftDepositoryID":
queryString = queryString.Where(s => s.GiftDepositoryID.Contains(searchString));
break;
case "ItemListID":
queryString = queryString.Where(s => s.ItemListID.Contains(searchString));
break;
case "FromMemberID":
queryString = queryString.Where(s => s.FromMemberID.Contains(searchString));
break;
case "ToMemberID":
queryString = queryString.Where(s => s.ToMemberID.Contains(searchString));
break;
default:
break;
}
}
// 기본 order 처리 - ItemName으로 정렬 처리 - 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 = "GiftDepositoriesController-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 = "GiftDepositoriesController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET
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 mi in db.MemberItems.ToList()
join il in db.ItemLists on mi.ItemListID equals il.ItemListID
join m in db.Members on mi.MemberID equals m.MemberID
select new MemberItems()
{
MemberItemID = mi.MemberItemID,
MemberID = mi.MemberID,
ItemListID = mi.ItemListID,
ItemCount = mi.ItemCount,
ItemStatus = mi.ItemStatus,
sCol1 = mi.sCol1,
sCol2 = mi.sCol2,
sCol3 = mi.sCol3,
sCol4 = mi.sCol4,
sCol5 = mi.sCol5,
sCol6 = mi.sCol6,
sCol7 = mi.sCol7,
sCol8 = mi.sCol8,
sCol9 = mi.sCol9,
sCol10 = mi.sCol10,
HideYN = mi.HideYN,
DeleteYN = mi.DeleteYN,
CreatedAt = mi.CreatedAt,
UpdatedAt = mi.UpdatedAt,
DataFromRegion = mi.DataFromRegion,
DataFromRegionDT = mi.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
},
Members = new Members()
{
Name1 = m.Name1
}
};
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "MemberItemID":
queryString = queryString.Where(s => s.MemberItemID.Contains(searchString));
break;
case "MemberID":
queryString = queryString.Where(s => s.MemberID.Contains(searchString));
break;
case "ItemListID":
queryString = queryString.Where(s => s.ItemListID.Contains(searchString));
break;
default:
break;
}
}
// 기본 order 처리 - ItemName으로 정렬 처리 - 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);
}
}
//result = result.Include(x => x.itemList.ItemName);
//var result = db.MemberItems.SqlQuery("SELECT MemberItems.MemberItemID,MemberItems.MemberID,MemberItems.ItemListID,MemberItems.ItemCount,MemberItems.ItemStatus,MemberItems.sCol1,MemberItems.sCol2,MemberItems.sCol3,MemberItems.sCol4,MemberItems.sCol5,MemberItems.sCol6,MemberItems.sCol7,MemberItems.sCol8,MemberItems.sCol9,MemberItems.sCol10,MemberItems.HideYN,MemberItems.DeleteYN,MemberItems.CreatedAt,MemberItems.UpdatedAt,MemberItems.DataFromRegion,MemberItems.DataFromRegionDT,ItemLists.ItemName as ItemName FROM MemberItems inner join ItemLists on MemberItems.ItemListID = ItemLists.ItemListID").ToList();
//MemberItems.CreatedAt = UserTime.GetUserTime(MemberItems.CreatedAt.DateTime, Session["AdminTimeZone"].ToString());
//MemberItems.UpdatedAt = UserTime.GetUserTime(MemberItems.UpdatedAt.DateTime, Session["AdminTimeZone"].ToString());
//result = result.ToList<MemberItems>;
//날자 데이터 현지 시각으로 변환
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 = "MemberItemsController-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 = "MemberItemsController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: MemberItemPurchases/Edit/5
public ActionResult Edit(string id)
{
try
{
// Edit 세션체크
if (!CheckSession())
{
return(Redirect("/AdminLogin/Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//테이블 조인 처리
var result = from mip in db.MemberItemPurchases.ToList()
join m in db.Members on mip.MemberID equals m.MemberID
join il in db.ItemLists on mip.ItemListID equals il.ItemListID
where mip.MemberItemPurchaseID == id //id값
select new MemberItemPurchases()
{
MemberItemPurchaseID = mip.MemberItemPurchaseID,
MemberID = mip.MemberID,
ItemListID = mip.ItemListID,
PurchasePrice = mip.PurchasePrice,
PurchaseQuantity = mip.PurchaseQuantity,
PGinfo1 = mip.PGinfo1,
PGinfo2 = mip.PGinfo2,
PGinfo3 = mip.PGinfo3,
PGinfo4 = mip.PGinfo4,
PGinfo5 = mip.PGinfo5,
PurchaseDeviceID = mip.PurchaseDeviceID,
PurchaseDeviceIPAddress = mip.PurchaseDeviceIPAddress,
PurchaseDeviceMACAddress = mip.PurchaseDeviceMACAddress,
PurchaseDT = mip.PurchaseDT,
PurchaseCancelYN = mip.PurchaseCancelYN,
PurchaseCancelDT = mip.PurchaseCancelDT,
PurchaseCancelingStatus = mip.PurchaseCancelingStatus,
PurchaseCancelReturnedAmount = mip.PurchaseCancelReturnedAmount,
PurchaseCancelDeviceID = mip.PurchaseCancelDeviceID,
PurchaseCancelDeviceIPAddress = mip.PurchaseCancelDeviceIPAddress,
PurchaseCancelDeviceMACAddress = mip.PurchaseCancelDeviceMACAddress,
sCol1 = mip.sCol1,
sCol2 = mip.sCol2,
sCol3 = mip.sCol3,
sCol4 = mip.sCol4,
sCol5 = mip.sCol5,
sCol6 = mip.sCol6,
sCol7 = mip.sCol7,
sCol8 = mip.sCol8,
sCol9 = mip.sCol9,
sCol10 = mip.sCol10,
PurchaseCancelConfirmAdminMemberID = mip.PurchaseCancelConfirmAdminMemberID,
HideYN = mip.HideYN,
DeleteYN = mip.DeleteYN,
CreatedAt = mip.CreatedAt,
UpdatedAt = mip.UpdatedAt,
DataFromRegion = mip.DataFromRegion,
DataFromRegionDT = mip.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
},
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.PurchaseDT = UserTime.GetUserTime(DateTime.Parse(result1.PurchaseDT), Session["AdminTimeZone"].ToString()).ToString();
result1.PurchaseCancelDT = UserTime.GetUserTime(DateTime.Parse(result1.PurchaseCancelDT), Session["AdminTimeZone"].ToString()).ToString();
// 관리자 접근 로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "INFO";
logMessage.Logger = "MemberItemPurchasesController-Edit(id)";
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 = "MemberItemPurchasesController-Edit(id)";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: MemberItemPurchases
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 mip in db.MemberItemPurchases.ToList()
join m in db.Members on mip.MemberID equals m.MemberID
join il in db.ItemLists on mip.ItemListID equals il.ItemListID
select new MemberItemPurchases()
{
MemberItemPurchaseID = mip.MemberItemPurchaseID,
MemberID = mip.MemberID,
ItemListID = mip.ItemListID,
PurchasePrice = mip.PurchasePrice,
PurchaseQuantity = mip.PurchaseQuantity,
PGinfo1 = mip.PGinfo1,
PGinfo2 = mip.PGinfo2,
PGinfo3 = mip.PGinfo3,
PGinfo4 = mip.PGinfo4,
PGinfo5 = mip.PGinfo5,
PurchaseDeviceID = mip.PurchaseDeviceID,
PurchaseDeviceIPAddress = mip.PurchaseDeviceIPAddress,
PurchaseDeviceMACAddress = mip.PurchaseDeviceMACAddress,
PurchaseDT = mip.PurchaseDT,
PurchaseCancelYN = mip.PurchaseCancelYN,
PurchaseCancelDT = mip.PurchaseCancelDT,
PurchaseCancelingStatus = mip.PurchaseCancelingStatus,
PurchaseCancelReturnedAmount = mip.PurchaseCancelReturnedAmount,
PurchaseCancelDeviceID = mip.PurchaseCancelDeviceID,
PurchaseCancelDeviceIPAddress = mip.PurchaseCancelDeviceIPAddress,
PurchaseCancelDeviceMACAddress = mip.PurchaseCancelDeviceMACAddress,
sCol1 = mip.sCol1,
sCol2 = mip.sCol2,
sCol3 = mip.sCol3,
sCol4 = mip.sCol4,
sCol5 = mip.sCol5,
sCol6 = mip.sCol6,
sCol7 = mip.sCol7,
sCol8 = mip.sCol8,
sCol9 = mip.sCol9,
sCol10 = mip.sCol10,
PurchaseCancelConfirmAdminMemberID = mip.PurchaseCancelConfirmAdminMemberID,
HideYN = mip.HideYN,
DeleteYN = mip.DeleteYN,
CreatedAt = mip.CreatedAt,
UpdatedAt = mip.UpdatedAt,
DataFromRegion = mip.DataFromRegion,
DataFromRegionDT = mip.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
},
Members = new Members()
{
Name1 = m.Name1
}
};
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "MemberItemPurchaseID":
queryString = queryString.Where(s => s.MemberItemPurchaseID.Contains(searchString));
break;
case "MemberID":
queryString = queryString.Where(s => s.MemberID.Contains(searchString));
break;
case "ItemListID":
queryString = queryString.Where(s => s.ItemListID.Contains(searchString));
break;
case "PurchaseDeviceID":
queryString = queryString.Where(s => s.PurchaseDeviceID.Contains(searchString));
break;
case "PurchaseCancelingStatus":
queryString = queryString.Where(s => s.PurchaseCancelingStatus.Contains(searchString));
break;
case "PurchaseCancelDeviceID":
queryString = queryString.Where(s => s.PurchaseCancelDeviceID.Contains(searchString));
break;
default:
break;
}
}
// 기본 order 처리 - ItemName으로 정렬 처리 - 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.PurchaseDT = UserTime.GetUserTime(DateTime.Parse(item.PurchaseDT), Session["AdminTimeZone"].ToString()).ToString();
item.PurchaseCancelDT = UserTime.GetUserTime(DateTime.Parse(item.PurchaseCancelDT), Session["AdminTimeZone"].ToString()).ToString();
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 = "MemberItemPurchasesController-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 = "MemberItemPurchasesController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: GameEvents/Edit/5
public ActionResult Edit(string id)
{
try
{
// Edit 세션체크
if (!CheckSession())
{
return(Redirect("/AdminLogin/Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//GameEvents gameEvents = db.GameEvents.Find(id);
//테이블 조인 처리
var result =
from ge in db.GameEvents.ToList()
join il in db.ItemLists on ge.ItemListID equals il.ItemListID
where ge.GameEventID == id //id값
select new GameEvents()
{
GameEventID = ge.GameEventID,
EventCategory1 = ge.EventCategory1,
EventCategory2 = ge.EventCategory2,
EventCategory3 = ge.EventCategory3,
ItemListID = ge.ItemListID,
ItemCount = ge.ItemCount,
Itemstatus = ge.Itemstatus,
TargetGroup = ge.TargetGroup,
TargetOS = ge.TargetOS,
TargetDevice = ge.TargetDevice,
EventImageLink = ge.EventImageLink,
Title = ge.Title,
Content = ge.Content,
sCol1 = ge.sCol1,
sCol2 = ge.sCol2,
sCol3 = ge.sCol3,
sCol4 = ge.sCol4,
sCol5 = ge.sCol5,
sCol6 = ge.sCol6,
sCol7 = ge.sCol7,
sCol8 = ge.sCol8,
sCol9 = ge.sCol9,
sCol10 = ge.sCol10,
CreateAdminID = ge.CreateAdminID,
HideYN = ge.HideYN,
DeleteYN = ge.DeleteYN,
OrderNumber = ge.OrderNumber,
EventDurationFrom = ge.EventDurationFrom,
EventDurationTo = ge.EventDurationTo,
CreatedAt = ge.CreatedAt,
UpdatedAt = ge.UpdatedAt,
DataFromRegion = ge.DataFromRegion,
DataFromRegionDT = ge.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
}
};
if (result == null)
{
return(HttpNotFound());
}
// FirstOrDefault result1로 재처리
var result1 = result.FirstOrDefault();
//복호화 처리
if (globalVal.CloudBreadCryptSetting == "AES256")
{
DecryptResult(result1);
}
//UTC를 세션의 UserTimeZone으로 변환 - 안하면 UTC 그대로 보임
result1.EventDurationFrom = UserTime.GetUserTime(result1.EventDurationFrom.DateTime, Session["AdminTimeZone"].ToString());
result1.EventDurationTo = UserTime.GetUserTime(result1.EventDurationTo.DateTime, Session["AdminTimeZone"].ToString());
// 관리자 접근 로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "INFO";
logMessage.Logger = "GameEventsController-Edit(id)";
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 = "GameEventsController-Edit(id)";
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;
}
}
// GET: Notices/Edit/5
public ActionResult Edit(string id)
{
try
{
// Edit 세션체크
if (!CheckSession())
{
return(Redirect("/AdminLogin/Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//Notices notices = db.Notices.Find(id);
//테이블 조인 처리
var result =
from n in db.Notices.ToList()
where n.NoticeID == id //id값
select new Notices()
{
NoticeID = n.NoticeID,
NoticeCategory1 = n.NoticeCategory1,
NoticeCategory2 = n.NoticeCategory2,
NoticeCategory3 = n.NoticeCategory3,
TargetGroup = n.TargetGroup,
TargetOS = n.TargetOS,
TargetDevice = n.TargetDevice,
NoticeImageLink = n.NoticeImageLink,
title = n.title,
content = n.content,
sCol1 = n.sCol1,
sCol2 = n.sCol2,
sCol3 = n.sCol3,
sCol4 = n.sCol4,
sCol5 = n.sCol5,
sCol6 = n.sCol6,
sCol7 = n.sCol7,
sCol8 = n.sCol8,
sCol9 = n.sCol9,
sCol10 = n.sCol10,
NoticeDurationFrom = n.NoticeDurationFrom,
NoticeDurationTo = n.NoticeDurationTo,
OrderNumber = n.OrderNumber,
CreateAdminID = n.CreateAdminID,
HideYN = n.HideYN,
DeleteYN = n.DeleteYN,
CreatedAt = n.CreatedAt,
UpdatedAt = n.UpdatedAt,
DataFromRegion = n.DataFromRegion,
DataFromRegionDT = n.DataFromRegionDT
};
if (result == null)
{
return(HttpNotFound());
}
// FirstOrDefault result1로 재처리
var result1 = result.FirstOrDefault();
//복호화 처리
if (globalVal.CloudBreadCryptSetting == "AES256")
{
DecryptResult(result1);
}
//UTC를 세션의 UserTimeZone으로 변환 - 안하면 UTC 그대로 보임
result1.NoticeDurationFrom = UserTime.GetUserTime(result1.NoticeDurationFrom.DateTime, Session["AdminTimeZone"].ToString());
result1.NoticeDurationTo = UserTime.GetUserTime(result1.NoticeDurationTo.DateTime, Session["AdminTimeZone"].ToString());
// 관리자 접근 로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "INFO";
logMessage.Logger = "NoticesController-Edit(id)";
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 = "NoticesController-Edit(id)";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: ItemLists
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 s in db.ItemLists
select s;
//from il in db.ItemLists
//join mi in db.MemberItems
//on il.ItemListID equals mi.ItemListID
//select new{il.ItemListID, il.ItemName, il.ItemDescription, il.ItemPrice, il.ItemSellPrice, il.ItemCategory1, il.ItemCategory2, il.ItemCategory3, mi.MemberItemID, mi.MemberID};
if (!String.IsNullOrEmpty(searchString))
{
switch (SearchCondition)
{
case "ItemID":
queryString = queryString.Where(s => s.ItemListID.Contains(searchString));
break;
case "ItemName":
queryString = queryString.Where(s => s.ItemName.Contains(searchString));
break;
case "ItemDescription":
queryString = queryString.Where(s => s.ItemDescription.Contains(searchString));
break;
default:
break;
}
}
// 기본 order 처리 - ItemName으로 정렬 처리 - 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 = "ItemListsController-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 = "ItemListsController-Index";
logMessage.Message = string.Format("SearchString : {0} , SearchCondition : {1}", searchString, SearchCondition);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// GET: Coupons/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 c in db.Coupon.ToList()
join il in db.ItemLists on c.ItemListID equals il.ItemListID
where c.CouponID == id //id값
select new Coupon()
{
CouponID = c.CouponID,
CouponCategory1 = c.CouponCategory1,
CouponCategory2 = c.CouponCategory2,
CouponCategory3 = c.CouponCategory3,
ItemListID = c.ItemListID,
ItemCount = c.ItemCount,
ItemStatus = c.ItemStatus,
TargetGroup = c.TargetGroup,
TargetOS = c.TargetOS,
TargetDevice = c.TargetDevice,
Title = c.Title,
Content = c.Content,
sCol1 = c.sCol1,
sCol2 = c.sCol2,
sCol3 = c.sCol3,
sCol4 = c.sCol4,
sCol5 = c.sCol5,
sCol6 = c.sCol6,
sCol7 = c.sCol7,
sCol8 = c.sCol8,
sCol9 = c.sCol9,
sCol10 = c.sCol10,
CouponDurationFrom = c.CouponDurationFrom,
CouponDurationTo = c.CouponDurationTo,
OrderNumber = c.OrderNumber,
DupeYN = c.DupeYN,
CreateAdminID = c.CreateAdminID,
HideYN = c.HideYN,
DeleteYN = c.DeleteYN,
CreatedAt = c.CreatedAt,
UpdatedAt = c.UpdatedAt,
DataFromRegion = c.DataFromRegion,
DataFromRegionDT = c.DataFromRegionDT,
ItemLists = new ItemLists()
{
ItemName = il.ItemName
}
};
if (result == null)
{
return(HttpNotFound());
}
// FirstOrDefault result1로 재처리
var result1 = result.FirstOrDefault();
//복호화 처리
if (globalVal.CloudBreadCryptSetting == "AES256")
{
DecryptResult(result1);
}
//UTC를 세션의 UserTimeZone으로 변환 - 안하면 UTC 그대로 보임
result1.CouponDurationFrom = UserTime.GetUserTime(result1.CouponDurationFrom.DateTime, Session["AdminTimeZone"].ToString());
result1.CouponDurationTo = UserTime.GetUserTime(result1.CouponDurationTo.DateTime, Session["AdminTimeZone"].ToString());
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 = "CouponController-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 = "CouponController-Details";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}