//암호화 처리 public MemberAccountBlockLog EncryptResult(MemberAccountBlockLog item) { try { item.MemberAccountBlockID = Crypto.AES_encrypt(item.MemberAccountBlockID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberAccountBlockReasonCategory1 = Crypto.AES_encrypt(item.MemberAccountBlockReasonCategory1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberAccountBlockReasonCategory2 = Crypto.AES_encrypt(item.MemberAccountBlockReasonCategory2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberAccountBlockReasonCategory3 = Crypto.AES_encrypt(item.MemberAccountBlockReasonCategory3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberAccountBlockReason = Crypto.AES_encrypt(item.MemberAccountBlockReason, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberAccountBlockProcess = Crypto.AES_encrypt(item.MemberAccountBlockProcess, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public GameEvents EncryptResult(GameEvents item) { try { item.GameEventID = Crypto.AES_encrypt(item.GameEventID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.EventCategory1 = Crypto.AES_encrypt(item.EventCategory1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.EventCategory2 = Crypto.AES_encrypt(item.EventCategory2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.EventCategory3 = Crypto.AES_encrypt(item.EventCategory3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemListID = Crypto.AES_encrypt(item.ItemListID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemCount = Crypto.AES_encrypt(item.ItemCount, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Itemstatus = Crypto.AES_encrypt(item.Itemstatus, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.TargetGroup = Crypto.AES_encrypt(item.TargetGroup, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.TargetOS = Crypto.AES_encrypt(item.TargetOS, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.TargetDevice = Crypto.AES_encrypt(item.TargetDevice, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.EventImageLink = Crypto.AES_encrypt(item.EventImageLink, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Title = Crypto.AES_encrypt(item.Title, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Content = Crypto.AES_encrypt(item.Content, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public Notices EncryptResult(Notices item) { try { item.NoticeID = Crypto.AES_encrypt(item.NoticeID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.NoticeCategory1 = Crypto.AES_encrypt(item.NoticeCategory1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.NoticeCategory2 = Crypto.AES_encrypt(item.NoticeCategory2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.NoticeCategory3 = Crypto.AES_encrypt(item.NoticeCategory3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.TargetGroup = Crypto.AES_encrypt(item.TargetGroup, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.TargetOS = Crypto.AES_encrypt(item.TargetOS, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.TargetDevice = Crypto.AES_encrypt(item.TargetDevice, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.NoticeImageLink = Crypto.AES_encrypt(item.NoticeImageLink, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.title = Crypto.AES_encrypt(item.title, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.content = Crypto.AES_encrypt(item.content, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public CouponMember EncryptResult(CouponMember item) { try { item.CouponMemberID = Crypto.AES_encrypt(item.CouponMemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.CouponID = Crypto.AES_encrypt(item.CouponID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public GameEventMember EncryptResult(GameEventMember item) { try { item.GameEventMemberID = Crypto.AES_encrypt(item.GameEventMemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.eventID = Crypto.AES_encrypt(item.eventID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.GameEvents.Title = Crypto.AES_encrypt(item.GameEvents.Title, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members.Name1 = Crypto.AES_encrypt(item.Members.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
public MemberItems EncryptResult(MemberItems result) { result.GetType().GetProperties().ToList().ForEach(p => { // Edit이나 Create의 경우는 필드를 체크할 필요 없음. - EF의 특성임. // Edit에서 암호화 시작 if (p.Name == "IteamUpdateAdminID" || p.Name == "IteamCreateAdminID" || p.Name == "Id" || p.Name == "Version" || p.Name == "Deleted" || p.Name == "CreatedAt" || p.Name == "UpdatedAt" || p.Name == "HideYN" || p.Name == "DeleteYN") // 현재 암호화 안하고 통과 시킬 녀석들 { // 추가 처리 } else { // edit을 저장하려 할 경우 EF에서 빈문자열의 경우 null이 들어오고 처리 되지 않는다. // view에서 annotation? // EF의 특성 // string이 아닌 datetimeoffset 등에서도 오류가 발생한다. int도 발생하겠지. // reflection 쓰지 말까... Debug.WriteLine(p.PropertyType.FullName); Debug.WriteLine((p.GetValue(result, null) ?? "").ToString()); p.SetValue(result, Crypto.AES_encrypt((p.GetValue(result, null) ?? "").ToString(), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV), null); // null인 경우 오류 가능성. 빈문자열로 치환해 암호화 한다. } }); return(result); }
//암호화 처리 public GiftDepositories EncryptResult(GiftDepositories item) { try { item.GiftDepositoryID = Crypto.AES_encrypt(item.GiftDepositoryID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemListID = Crypto.AES_encrypt(item.ItemListID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemCount = Crypto.AES_encrypt(item.ItemCount, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.FromMemberID = Crypto.AES_encrypt(item.FromMemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members.Name1 = Crypto.AES_encrypt(item.Members.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ToMemberID = Crypto.AES_encrypt(item.ToMemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members1.Name1 = Crypto.AES_encrypt(item.Members1.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public Members EncryptResult(Members item) { try { item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberPWD = Crypto.AES_encrypt(item.MemberPWD, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.EmailAddress = Crypto.AES_encrypt(item.EmailAddress, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.EmailConfirmedYN = Crypto.AES_encrypt(item.EmailConfirmedYN, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PhoneNumber1 = Crypto.AES_encrypt(item.PhoneNumber1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PhoneNumber2 = Crypto.AES_encrypt(item.PhoneNumber2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PINumber = Crypto.AES_encrypt(item.PINumber, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Name1 = Crypto.AES_encrypt(item.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Name2 = Crypto.AES_encrypt(item.Name2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Name3 = Crypto.AES_encrypt(item.Name3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.DOB = Crypto.AES_encrypt(item.DOB, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.RecommenderID = Crypto.AES_encrypt(item.RecommenderID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberGroup = Crypto.AES_encrypt(item.MemberGroup, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.LastDeviceID = Crypto.AES_encrypt(item.LastDeviceID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.LastIPaddress = Crypto.AES_encrypt(item.LastIPaddress, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.LastLoginDT = Crypto.AES_encrypt(item.LastLoginDT, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.LastLogoutDT = Crypto.AES_encrypt(item.LastLogoutDT, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.LastMACAddress = Crypto.AES_encrypt(item.LastMACAddress, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.AccountBlockYN = Crypto.AES_encrypt(item.AccountBlockYN, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.AccountBlockEndDT = Crypto.AES_encrypt(item.AccountBlockEndDT, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.AnonymousYN = Crypto.AES_encrypt(item.AnonymousYN, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.C3rdAuthProvider = Crypto.AES_encrypt(item.C3rdAuthProvider, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.C3rdAuthID = Crypto.AES_encrypt(item.C3rdAuthID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.C3rdAuthParam = Crypto.AES_encrypt(item.C3rdAuthParam, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PushNotificationID = Crypto.AES_encrypt(item.PushNotificationID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PushNotificationProvider = Crypto.AES_encrypt(item.PushNotificationProvider, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PushNotificationGroup = Crypto.AES_encrypt(item.PushNotificationGroup, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public MemberItemPurchases EncryptResult(MemberItemPurchases item) { try { item.MemberItemPurchaseID = Crypto.AES_encrypt(item.MemberItemPurchaseID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members.Name1 = Crypto.AES_encrypt(item.Members.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemListID = Crypto.AES_encrypt(item.ItemListID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemLists.ItemName = Crypto.AES_encrypt(item.ItemLists.ItemName, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchasePrice = Crypto.AES_encrypt(item.PurchasePrice, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseQuantity = Crypto.AES_encrypt(item.PurchaseQuantity, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PGinfo1 = Crypto.AES_encrypt(item.PGinfo1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PGinfo2 = Crypto.AES_encrypt(item.PGinfo2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PGinfo3 = Crypto.AES_encrypt(item.PGinfo3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PGinfo4 = Crypto.AES_encrypt(item.PGinfo4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PGinfo5 = Crypto.AES_encrypt(item.PGinfo5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseDeviceID = Crypto.AES_encrypt(item.PurchaseDeviceID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseDeviceIPAddress = Crypto.AES_encrypt(item.PurchaseDeviceIPAddress, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseDeviceMACAddress = Crypto.AES_encrypt(item.PurchaseDeviceMACAddress, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseDT = Crypto.AES_encrypt(item.PurchaseDT, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseCancelYN = Crypto.AES_encrypt(item.PurchaseCancelYN, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseCancelDT = Crypto.AES_encrypt(item.PurchaseCancelDT, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseCancelingStatus = Crypto.AES_encrypt(item.PurchaseCancelingStatus, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseCancelReturnedAmount = Crypto.AES_encrypt(item.PurchaseCancelReturnedAmount, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseCancelDeviceID = Crypto.AES_encrypt(item.PurchaseCancelDeviceID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseCancelDeviceIPAddress = Crypto.AES_encrypt(item.PurchaseCancelDeviceIPAddress, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.PurchaseCancelDeviceMACAddress = Crypto.AES_encrypt(item.PurchaseCancelDeviceMACAddress, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public ItemLists EncryptResult(ItemLists item) { try { item.ItemListID = Crypto.AES_encrypt(item.ItemListID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemName = Crypto.AES_encrypt(item.ItemName, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemDescription = Crypto.AES_encrypt(item.ItemDescription, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemPrice = Crypto.AES_encrypt(item.ItemPrice, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemSellPrice = Crypto.AES_encrypt(item.ItemSellPrice, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemCategory1 = Crypto.AES_encrypt(item.ItemCategory1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemCategory2 = Crypto.AES_encrypt(item.ItemCategory2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemCategory3 = Crypto.AES_encrypt(item.ItemCategory3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); //result.GetType().GetProperties().ToList().ForEach(p => //{ // // 암호화 안할 항복 체크 // if (p.Name == "IteamUpdateAdminID" || p.Name == "IteamCreateAdminID" || p.Name == "HideYN" || p.Name == "DeleteYN" || p.Name == "CreatedAt" || p.Name == "UpdatedAt" || p.Name == "DataFromRegion" || p.Name == "DataFromRegionDT") // { // // 추가 처리 // } // else // { // Debug.WriteLine(p.PropertyType.FullName); // Debug.WriteLine((p.GetValue(result, null) ?? "").ToString()); // p.SetValue(result, Crypto.AES_encrypt((p.GetValue(result, null) ?? "").ToString(), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV), null); // null인 경우 오류 가능성. 빈문자열로 치환해 암호화 한다. // } //}); } catch (Exception) { throw; } return(item); }
//암호화 처리 public MemberItems EncryptResult(MemberItems item) { try { item.MemberItemID = Crypto.AES_encrypt(item.MemberItemID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members.Name1 = Crypto.AES_encrypt(item.Members.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemListID = Crypto.AES_encrypt(item.ItemListID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemLists.ItemName = Crypto.AES_encrypt(item.ItemLists.ItemName, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemCount = Crypto.AES_encrypt(item.ItemCount, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemStatus = Crypto.AES_encrypt(item.ItemStatus, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); //result.GetType().GetProperties().ToList().ForEach(p => //{ // // Edit에서 암호화 시작 // if (p.Name == "HideYN" || p.Name == "DeleteYN" || p.Name == "CreatedAt" || p.Name == "UpdatedAt" || p.Name == "DataFromRegion" || p.Name == "DataFromRegionDT") // { // // 추가 처리 // } // else // { // Debug.WriteLine(p.PropertyType.FullName); // Debug.WriteLine((p.GetValue(result, null) ?? "").ToString()); // p.SetValue(result, Crypto.AES_encrypt((p.GetValue(result, null) ?? "").ToString(), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV), null); // null인 경우 오류 가능성. 빈문자열로 치환해 암호화 한다. // } //}); } catch (Exception) { throw; } return(item); }
//암호화 처리 public MemberGameInfoStages EncryptResult(MemberGameInfoStages item) { try { item.MemberGameInfoStageID = Crypto.AES_encrypt(item.MemberGameInfoStageID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members.Name1 = Crypto.AES_encrypt(item.Members.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.StageName = Crypto.AES_encrypt(item.StageName, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.StageStatus = Crypto.AES_encrypt(item.StageStatus, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Category1 = Crypto.AES_encrypt(item.Category1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Category2 = Crypto.AES_encrypt(item.Category2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Category3 = Crypto.AES_encrypt(item.Category3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Mission1 = Crypto.AES_encrypt(item.Mission1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Mission2 = Crypto.AES_encrypt(item.Mission2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Mission3 = Crypto.AES_encrypt(item.Mission3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Mission4 = Crypto.AES_encrypt(item.Mission4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Mission5 = Crypto.AES_encrypt(item.Mission5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Points = Crypto.AES_encrypt(item.Points, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.StageStat1 = Crypto.AES_encrypt(item.StageStat1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.StageStat2 = Crypto.AES_encrypt(item.StageStat2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.StageStat3 = Crypto.AES_encrypt(item.StageStat3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.StageStat4 = Crypto.AES_encrypt(item.StageStat4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.StageStat5 = Crypto.AES_encrypt(item.StageStat5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public ServerInfo EncryptResult(ServerInfo item) { try { item.InfoID = Crypto.AES_encrypt(item.InfoID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.FEServerLists = Crypto.AES_encrypt(item.FEServerLists, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.SocketServerLists = Crypto.AES_encrypt(item.SocketServerLists, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Version = Crypto.AES_encrypt(item.Version, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ResourceLink = Crypto.AES_encrypt(item.ResourceLink, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.EULAText = Crypto.AES_encrypt(item.EULAText, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
//암호화 처리 public MemberGameInfoes EncryptResult(MemberGameInfoes item) { try { item.MemberID = Crypto.AES_encrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members.Name1 = Crypto.AES_encrypt(item.Members.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Level = Crypto.AES_encrypt(item.Level, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Exps = Crypto.AES_encrypt(item.Exps, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Points = Crypto.AES_encrypt(item.Points, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT1 = Crypto.AES_encrypt(item.UserSTAT1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT2 = Crypto.AES_encrypt(item.UserSTAT2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT3 = Crypto.AES_encrypt(item.UserSTAT3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT4 = Crypto.AES_encrypt(item.UserSTAT4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT5 = Crypto.AES_encrypt(item.UserSTAT5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT6 = Crypto.AES_encrypt(item.UserSTAT6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT7 = Crypto.AES_encrypt(item.UserSTAT7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT8 = Crypto.AES_encrypt(item.UserSTAT8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT9 = Crypto.AES_encrypt(item.UserSTAT9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.UserSTAT10 = Crypto.AES_encrypt(item.UserSTAT10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_encrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_encrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_encrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_encrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_encrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_encrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_encrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_encrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_encrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_encrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); } catch (Exception) { throw; } return(item); }
public HttpResponseMessage Post(SelItem1InputParams p) { // try decrypt data if (!string.IsNullOrEmpty(p.token) && globalVal.CloudBreadCryptSetting == "AES256") { try { string decrypted = Crypto.AES_decrypt(p.token, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); p = JsonConvert.DeserializeObject <SelItem1InputParams>(decrypted); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Decrypt Error", ex); throw ex; } } // Get the sid or memberID of the current user. string sid = CBAuth.getMemberID(p.MemberID, this.User as ClaimsPrincipal); p.MemberID = sid; Logging.CBLoggers logMessage = new Logging.CBLoggers(); string jsonParam = JsonConvert.SerializeObject(p); List <SelItem1Model> result = new List <SelItem1Model>(); HttpResponseMessage response = new HttpResponseMessage(); EncryptedData encryptedResult = new EncryptedData(); try { /// Database connection retry policy RetryPolicy retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(globalVal.conRetryCount, TimeSpan.FromSeconds(globalVal.conRetryFromSeconds)); using (SqlConnection connection = new SqlConnection(globalVal.DBConnectionString)) { using (SqlCommand command = new SqlCommand("uspSelItem1", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ItemListID", SqlDbType.NVarChar, -1).Value = p.ItemListID; connection.OpenWithRetry(retryPolicy); using (SqlDataReader dreader = command.ExecuteReaderWithRetry(retryPolicy)) { while (dreader.Read()) { SelItem1Model workItem = new SelItem1Model() { ItemListID = dreader[0].ToString(), ItemName = dreader[1].ToString(), ItemDescription = dreader[2].ToString(), ItemPrice = dreader[3].ToString(), ItemSellPrice = dreader[4].ToString(), ItemCategory1 = dreader[5].ToString(), ItemCategory2 = dreader[6].ToString(), ItemCategory3 = dreader[7].ToString(), sCol1 = dreader[8].ToString(), sCol2 = dreader[9].ToString(), sCol3 = dreader[10].ToString(), sCol4 = dreader[11].ToString(), sCol5 = dreader[12].ToString(), sCol6 = dreader[13].ToString(), sCol7 = dreader[14].ToString(), sCol8 = dreader[15].ToString(), sCol9 = dreader[16].ToString(), sCol10 = dreader[17].ToString(), }; result.Add(workItem); } dreader.Close(); } connection.Close(); } /// Encrypt the result response if (globalVal.CloudBreadCryptSetting == "AES256") { try { encryptedResult.token = Crypto.AES_encrypt(JsonConvert.SerializeObject(result), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); response = Request.CreateResponse(HttpStatusCode.OK, encryptedResult); return(response); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Encrypt Error", ex); throw ex; } } response = Request.CreateResponse(HttpStatusCode.OK, result); return(response); } } catch (Exception ex) { // error log logMessage.memberID = p.MemberID; logMessage.Level = "ERROR"; logMessage.Logger = "CBSelItem1Controller"; logMessage.Message = jsonParam; 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; } }
public HttpResponseMessage Post(DWMarketCheckInputParam p) { // try decrypt data if (!string.IsNullOrEmpty(p.token) && globalVal.CloudBreadCryptSetting == "AES256") { try { string decrypted = Crypto.AES_decrypt(p.token, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); p = JsonConvert.DeserializeObject <DWMarketCheckInputParam>(decrypted); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Decrypt Error", ex); throw ex; } } Logging.CBLoggers logMessage = new Logging.CBLoggers(); string jsonParam = JsonConvert.SerializeObject(p); HttpResponseMessage response = new HttpResponseMessage(); EncryptedData encryptedResult = new EncryptedData(); try { DWMarketCheckModel result = GetResult(p); /// Encrypt the result response if (globalVal.CloudBreadCryptSetting == "AES256") { try { encryptedResult.token = Crypto.AES_encrypt(JsonConvert.SerializeObject(result), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); response = Request.CreateResponse(HttpStatusCode.OK, encryptedResult); return(response); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Encrypt Error", ex); throw ex; } } response = Request.CreateResponse(HttpStatusCode.OK, result); return(response); } catch (Exception ex) { // error log logMessage.memberID = "Version Check"; logMessage.Level = "ERROR"; logMessage.Logger = "DWMarketVersionCheckController"; logMessage.Message = jsonParam; 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; } }
public HttpResponseMessage Post(SelLoginInfoInputParams p) { // try decrypt data if (!string.IsNullOrEmpty(p.token) && globalVal.CloudBreadCryptSetting == "AES256") { try { string decrypted = Crypto.AES_decrypt(p.token, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); p = JsonConvert.DeserializeObject <SelLoginInfoInputParams>(decrypted); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Decrypt Error", ex); throw ex; } } // Get the sid or memberID of the current user. string sid = CBAuth.getMemberID(p.memberID, this.User as ClaimsPrincipal); p.memberID = sid; Logging.CBLoggers logMessage = new Logging.CBLoggers(); string jsonParam = JsonConvert.SerializeObject(p); List <SelLoginInfoModel> result = new List <SelLoginInfoModel>(); HttpResponseMessage response = new HttpResponseMessage(); EncryptedData encryptedResult = new EncryptedData(); try { // start task log //logMessage.memberID = p.memberID; //logMessage.Level = "INFO"; //logMessage.Logger = "CBSelLoginInfoController"; //logMessage.Message = jsonParam; //Logging.RunLog(logMessage); /// Database connection retry policy RetryPolicy retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(globalVal.conRetryCount, TimeSpan.FromSeconds(globalVal.conRetryFromSeconds)); using (SqlConnection connection = new SqlConnection(globalVal.DBConnectionString)) { using (SqlCommand command = new SqlCommand("uspSelLoginInfo", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@MemberID", SqlDbType.NVarChar, -1).Value = p.memberID; command.Parameters.Add("@MemberPWD", SqlDbType.NVarChar, -1).Value = p.memberPWD; command.Parameters.Add("@LastDeviceID", SqlDbType.NVarChar, -1).Value = p.memberPWD; command.Parameters.Add("@LastIPaddress", SqlDbType.NVarChar, -1).Value = p.memberPWD; command.Parameters.Add("@LastMACAddress", SqlDbType.NVarChar, -1).Value = p.memberPWD; connection.OpenWithRetry(retryPolicy); using (SqlDataReader dreader = command.ExecuteReaderWithRetry(retryPolicy)) { while (dreader.Read()) { SelLoginInfoModel workItem = new SelLoginInfoModel() { MemberID = dreader[0].ToString(), MemberPWD = dreader[1].ToString(), EmailAddress = dreader[2].ToString(), EmailConfirmedYN = dreader[3].ToString(), PhoneNumber1 = dreader[4].ToString(), PhoneNumber2 = dreader[5].ToString(), PINumber = dreader[6].ToString(), Name1 = dreader[7].ToString(), Name2 = dreader[8].ToString(), Name3 = dreader[9].ToString(), DOB = dreader[10].ToString(), RecommenderID = dreader[11].ToString(), MemberGroup = dreader[12].ToString(), LastDeviceID = dreader[13].ToString(), LastIPaddress = dreader[14].ToString(), LastLoginDT = dreader[15].ToString(), LastLogoutDT = dreader[16].ToString(), LastMACAddress = dreader[17].ToString(), AccountBlockYN = dreader[18].ToString(), AccountBlockEndDT = dreader[19].ToString(), AnonymousYN = dreader[20].ToString(), _3rdAuthProvider = dreader[21].ToString(), _3rdAuthID = dreader[22].ToString(), _3rdAuthParam = dreader[23].ToString(), PushNotificationID = dreader[24].ToString(), PushNotificationProvider = dreader[25].ToString(), PushNotificationGroup = dreader[26].ToString(), sCol1 = dreader[27].ToString(), sCol2 = dreader[28].ToString(), sCol3 = dreader[29].ToString(), sCol4 = dreader[30].ToString(), sCol5 = dreader[31].ToString(), sCol6 = dreader[32].ToString(), sCol7 = dreader[33].ToString(), sCol8 = dreader[34].ToString(), sCol9 = dreader[35].ToString(), sCol10 = dreader[36].ToString() }; result.Add(workItem); } dreader.Close(); } connection.Close(); // end task log logMessage.memberID = p.memberID; logMessage.Level = "INFO"; logMessage.Logger = "CBSelLoginInfoController"; logMessage.Message = jsonParam; Logging.RunLog(logMessage); } /// Encrypt the result response if (globalVal.CloudBreadCryptSetting == "AES256") { try { encryptedResult.token = Crypto.AES_encrypt(JsonConvert.SerializeObject(result), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); response = Request.CreateResponse(HttpStatusCode.OK, encryptedResult); return(response); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Encrypt Error", ex); throw ex; } } response = Request.CreateResponse(HttpStatusCode.OK, result); return(response); } } catch (Exception ex) { // error log logMessage.memberID = p.memberID; logMessage.Level = "ERROR"; logMessage.Logger = "CBSelLoginInfoController"; logMessage.Message = jsonParam; logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
public HttpResponseMessage Post(InsRegMemberInputParams p) { // try decrypt data if (!string.IsNullOrEmpty(p.token) && globalVal.CloudBreadCryptSetting == "AES256") { try { string decrypted = Crypto.AES_decrypt(p.token, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); p = JsonConvert.DeserializeObject <InsRegMemberInputParams>(decrypted); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Decrypt Error", ex); throw ex; } } // Get the sid or memberID of the current user. string sid = CBAuth.getMemberID(p.MemberID_Members, this.User as ClaimsPrincipal); p.MemberID_Members = sid; Logging.CBLoggers logMessage = new Logging.CBLoggers(); string jsonParam = JsonConvert.SerializeObject(p); HttpResponseMessage response = new HttpResponseMessage(); EncryptedData encryptedResult = new EncryptedData(); RowcountResult rowcountResult = new RowcountResult(); try { // task start log //logMessage.memberID = p.MemberID_Members; //logMessage.Level = "INFO"; //logMessage.Logger = "CBuspInsRegMemberCheckController"; //logMessage.Message = jsonParam; //Logging.RunLog(logMessage); /// Database connection retry policy RetryPolicy retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(globalVal.conRetryCount, TimeSpan.FromSeconds(globalVal.conRetryFromSeconds)); using (SqlConnection connection = new SqlConnection(globalVal.DBConnectionString)) { using (SqlCommand command = new SqlCommand("uspInsRegMember", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@MemberID_Members", SqlDbType.NVarChar, -1).Value = p.MemberID_Members; command.Parameters.Add("@MemberPWD_Members", SqlDbType.NVarChar, -1).Value = p.MemberPWD_Members; command.Parameters.Add("@EmailAddress_Members", SqlDbType.NVarChar, -1).Value = p.EmailAddress_Members; command.Parameters.Add("@EmailConfirmedYN_Members", SqlDbType.NVarChar, -1).Value = p.EmailConfirmedYN_Members; command.Parameters.Add("@PhoneNumber1_Members", SqlDbType.NVarChar, -1).Value = p.PhoneNumber1_Members; command.Parameters.Add("@PhoneNumber2_Members", SqlDbType.NVarChar, -1).Value = p.PhoneNumber2_Members; command.Parameters.Add("@PINumber_Members", SqlDbType.NVarChar, -1).Value = p.PINumber_Members; command.Parameters.Add("@Name1_Members", SqlDbType.NVarChar, -1).Value = p.Name1_Members; command.Parameters.Add("@Name2_Members", SqlDbType.NVarChar, -1).Value = p.Name2_Members; command.Parameters.Add("@Name3_Members", SqlDbType.NVarChar, -1).Value = p.Name3_Members; command.Parameters.Add("@DOB_Members", SqlDbType.NVarChar, -1).Value = p.DOB_Members; command.Parameters.Add("@RecommenderID_Members", SqlDbType.NVarChar, -1).Value = p.RecommenderID_Members; command.Parameters.Add("@MemberGroup_Members", SqlDbType.NVarChar, -1).Value = p.MemberGroup_Members; command.Parameters.Add("@LastDeviceID_Members", SqlDbType.NVarChar, -1).Value = p.LastDeviceID_Members; command.Parameters.Add("@LastIPaddress_Members", SqlDbType.NVarChar, -1).Value = p.LastIPaddress_Members; command.Parameters.Add("@LastLoginDT_Members", SqlDbType.NVarChar, -1).Value = p.LastLoginDT_Members; command.Parameters.Add("@LastLogoutDT_Members", SqlDbType.NVarChar, -1).Value = p.LastLogoutDT_Members; command.Parameters.Add("@LastMACAddress_Members", SqlDbType.NVarChar, -1).Value = p.LastMACAddress_Members; command.Parameters.Add("@AccountBlockYN_Members", SqlDbType.NVarChar, -1).Value = p.AccountBlockYN_Members; command.Parameters.Add("@AccountBlockEndDT_Members", SqlDbType.NVarChar, -1).Value = p.AccountBlockEndDT_Members; command.Parameters.Add("@AnonymousYN_Members", SqlDbType.NVarChar, -1).Value = p.AnonymousYN_Members; command.Parameters.Add("@3rdAuthProvider_Members", SqlDbType.NVarChar, -1).Value = p._3rdAuthProvider_Members; command.Parameters.Add("@3rdAuthID_Members", SqlDbType.NVarChar, -1).Value = p._3rdAuthID_Members; command.Parameters.Add("@3rdAuthParam_Members", SqlDbType.NVarChar, -1).Value = p._3rdAuthParam_Members; command.Parameters.Add("@PushNotificationID_Members", SqlDbType.NVarChar, -1).Value = p.PushNotificationID_Members; command.Parameters.Add("@PushNotificationProvider_Members", SqlDbType.NVarChar, -1).Value = p.PushNotificationProvider_Members; command.Parameters.Add("@PushNotificationGroup_Members", SqlDbType.NVarChar, -1).Value = p.PushNotificationGroup_Members; command.Parameters.Add("@sCol1_Members", SqlDbType.NVarChar, -1).Value = p.sCol1_Members; command.Parameters.Add("@sCol2_Members", SqlDbType.NVarChar, -1).Value = p.sCol2_Members; command.Parameters.Add("@sCol3_Members", SqlDbType.NVarChar, -1).Value = p.sCol3_Members; command.Parameters.Add("@sCol4_Members", SqlDbType.NVarChar, -1).Value = p.sCol4_Members; command.Parameters.Add("@sCol5_Members", SqlDbType.NVarChar, -1).Value = p.sCol5_Members; command.Parameters.Add("@sCol6_Members", SqlDbType.NVarChar, -1).Value = p.sCol6_Members; command.Parameters.Add("@sCol7_Members", SqlDbType.NVarChar, -1).Value = p.sCol7_Members; command.Parameters.Add("@sCol8_Members", SqlDbType.NVarChar, -1).Value = p.sCol8_Members; command.Parameters.Add("@sCol9_Members", SqlDbType.NVarChar, -1).Value = p.sCol9_Members; command.Parameters.Add("@sCol10_Members", SqlDbType.NVarChar, -1).Value = p.sCol10_Members; command.Parameters.Add("@TimeZoneID_Members", SqlDbType.NVarChar, -1).Value = p.TimeZoneID_Members; command.Parameters.Add("@Level_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.Level_MemberGameInfoes; command.Parameters.Add("@Exps_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.Exps_MemberGameInfoes; command.Parameters.Add("@Points_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.Points_MemberGameInfoes; command.Parameters.Add("@UserSTAT1_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT1_MemberGameInfoes; command.Parameters.Add("@UserSTAT2_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT2_MemberGameInfoes; command.Parameters.Add("@UserSTAT3_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT3_MemberGameInfoes; command.Parameters.Add("@UserSTAT4_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT4_MemberGameInfoes; command.Parameters.Add("@UserSTAT5_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT5_MemberGameInfoes; command.Parameters.Add("@UserSTAT6_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT6_MemberGameInfoes; command.Parameters.Add("@UserSTAT7_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT7_MemberGameInfoes; command.Parameters.Add("@UserSTAT8_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT8_MemberGameInfoes; command.Parameters.Add("@UserSTAT9_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT9_MemberGameInfoes; command.Parameters.Add("@UserSTAT10_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.UserSTAT10_MemberGameInfoes; command.Parameters.Add("@sCol1_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol1_MemberGameInfoes; command.Parameters.Add("@sCol2_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol2_MemberGameInfoes; command.Parameters.Add("@sCol3_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol3_MemberGameInfoes; command.Parameters.Add("@sCol4_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol4_MemberGameInfoes; command.Parameters.Add("@sCol5_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol5_MemberGameInfoes; command.Parameters.Add("@sCol6_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol6_MemberGameInfoes; command.Parameters.Add("@sCol7_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol7_MemberGameInfoes; command.Parameters.Add("@sCol8_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol8_MemberGameInfoes; command.Parameters.Add("@sCol9_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol9_MemberGameInfoes; command.Parameters.Add("@sCol10_MemberGameInfoes", SqlDbType.NVarChar, -1).Value = p.sCol10_MemberGameInfoes; connection.OpenWithRetry(retryPolicy); using (SqlDataReader dreader = command.ExecuteReaderWithRetry(retryPolicy)) { while (dreader.Read()) { rowcountResult.result = dreader[0].ToString(); } dreader.Close(); } connection.Close(); // task end log logMessage.memberID = p.MemberID_Members; logMessage.Level = "INFO"; logMessage.Logger = "CBuspInsRegMemberCheckController"; logMessage.Message = jsonParam; Logging.RunLog(logMessage); /// Encrypt the result response if (globalVal.CloudBreadCryptSetting == "AES256") { try { encryptedResult.token = Crypto.AES_encrypt(JsonConvert.SerializeObject(rowcountResult), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); response = Request.CreateResponse(HttpStatusCode.OK, encryptedResult); return(response); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Encrypt Error", ex); throw ex; } } response = Request.CreateResponse(HttpStatusCode.OK, rowcountResult); return(response); } } } catch (Exception ex) { // error log logMessage.memberID = p.MemberID_Members; logMessage.Level = "ERROR"; logMessage.Logger = "CBuspInsRegMemberCheckController"; logMessage.Message = jsonParam; 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 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: 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; } }
public HttpResponseMessage Post(ComUdtMemberItemPurchaseInputParams p) { // try decrypt data if (!string.IsNullOrEmpty(p.token) && globalVal.CloudBreadCryptSetting == "AES256") { try { string decrypted = Crypto.AES_decrypt(p.token, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); p = JsonConvert.DeserializeObject <ComUdtMemberItemPurchaseInputParams>(decrypted); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Decrypt Error", ex); throw ex; } } // Get the sid or memberID of the current user. string sid = CBAuth.getMemberID(p.MemberID, this.User as ClaimsPrincipal); p.MemberID = sid; Logging.CBLoggers logMessage = new Logging.CBLoggers(); string jsonParam = JsonConvert.SerializeObject(p); HttpResponseMessage response = new HttpResponseMessage(); EncryptedData encryptedResult = new EncryptedData(); RowcountResult rowcountResult = new RowcountResult(); try { // task start log //logMessage.memberID = p.MemberID; //logMessage.Level = "INFO"; //logMessage.Logger = "CBComUdtMemberItemPurchaseController"; //logMessage.Message = jsonParam; //Logging.RunLog(logMessage); /// Database connection retry policy RetryPolicy retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(globalVal.conRetryCount, TimeSpan.FromSeconds(globalVal.conRetryFromSeconds)); using (SqlConnection connection = new SqlConnection(globalVal.DBConnectionString)) { using (SqlCommand command = new SqlCommand("uspComUdtMemberItemPurchase", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@MemberItemPurchaseID", SqlDbType.NVarChar, -1).Value = p.MemberItemPurchaseID; command.Parameters.Add("@MemberID", SqlDbType.NVarChar, -1).Value = p.MemberID; command.Parameters.Add("@ItemListID", SqlDbType.NVarChar, -1).Value = p.ItemListID; command.Parameters.Add("@PurchaseQuantity", SqlDbType.NVarChar, -1).Value = p.PurchaseQuantity; command.Parameters.Add("@PurchasePrice", SqlDbType.NVarChar, -1).Value = p.PurchasePrice; command.Parameters.Add("@PGinfo1", SqlDbType.NVarChar, -1).Value = p.PGinfo1; command.Parameters.Add("@PGinfo2", SqlDbType.NVarChar, -1).Value = p.PGinfo2; command.Parameters.Add("@PGinfo3", SqlDbType.NVarChar, -1).Value = p.PGinfo3; command.Parameters.Add("@PGinfo4", SqlDbType.NVarChar, -1).Value = p.PGinfo4; command.Parameters.Add("@PGinfo5", SqlDbType.NVarChar, -1).Value = p.PGinfo5; command.Parameters.Add("@PurchaseDeviceID", SqlDbType.NVarChar, -1).Value = p.PurchaseDeviceID; command.Parameters.Add("@PurchaseDeviceIPAddress", SqlDbType.NVarChar, -1).Value = p.PurchaseDeviceIPAddress; command.Parameters.Add("@PurchaseDeviceMACAddress", SqlDbType.NVarChar, -1).Value = p.PurchaseDeviceMACAddress; command.Parameters.Add("@PurchaseDT", SqlDbType.NVarChar, -1).Value = p.PurchaseDT; command.Parameters.Add("@PurchaseCancelYN", SqlDbType.NVarChar, -1).Value = p.PurchaseCancelYN; command.Parameters.Add("@PurchaseCancelDT", SqlDbType.NVarChar, -1).Value = p.PurchaseCancelDT; command.Parameters.Add("@PurchaseCancelingStatus", SqlDbType.NVarChar, -1).Value = p.PurchaseCancelingStatus; command.Parameters.Add("@PurchaseCancelReturnedAmount", SqlDbType.NVarChar, -1).Value = p.PurchaseCancelReturnedAmount; command.Parameters.Add("@PurchaseCancelDeviceID", SqlDbType.NVarChar, -1).Value = p.PurchaseCancelDeviceID; command.Parameters.Add("@PurchaseCancelDeviceIPAddress", SqlDbType.NVarChar, -1).Value = p.PurchaseCancelDeviceIPAddress; command.Parameters.Add("@PurchaseCancelDeviceMACAddress", SqlDbType.NVarChar, -1).Value = p.PurchaseCancelDeviceMACAddress; command.Parameters.Add("@sCol1", SqlDbType.NVarChar, -1).Value = p.sCol1; command.Parameters.Add("@sCol2", SqlDbType.NVarChar, -1).Value = p.sCol2; command.Parameters.Add("@sCol3", SqlDbType.NVarChar, -1).Value = p.sCol3; command.Parameters.Add("@sCol4", SqlDbType.NVarChar, -1).Value = p.sCol4; command.Parameters.Add("@sCol5", SqlDbType.NVarChar, -1).Value = p.sCol5; command.Parameters.Add("@sCol6", SqlDbType.NVarChar, -1).Value = p.sCol6; command.Parameters.Add("@sCol7", SqlDbType.NVarChar, -1).Value = p.sCol7; command.Parameters.Add("@sCol8", SqlDbType.NVarChar, -1).Value = p.sCol8; command.Parameters.Add("@sCol9", SqlDbType.NVarChar, -1).Value = p.sCol9; command.Parameters.Add("@sCol10", SqlDbType.NVarChar, -1).Value = p.sCol10; connection.OpenWithRetry(retryPolicy); using (SqlDataReader dreader = command.ExecuteReaderWithRetry(retryPolicy)) { while (dreader.Read()) { rowcountResult.result = dreader[0].ToString(); } dreader.Close(); } connection.Close(); // task end log logMessage.memberID = p.MemberID; logMessage.Level = "INFO"; logMessage.Logger = "CBComUdtMemberItemPurchaseController"; logMessage.Message = jsonParam; Logging.RunLog(logMessage); /// Encrypt the result response if (globalVal.CloudBreadCryptSetting == "AES256") { try { encryptedResult.token = Crypto.AES_encrypt(JsonConvert.SerializeObject(rowcountResult), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); response = Request.CreateResponse(HttpStatusCode.OK, encryptedResult); return(response); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Encrypt Error", ex); throw ex; } } response = Request.CreateResponse(HttpStatusCode.OK, rowcountResult); return(response); } } } catch (Exception ex) { // error log logMessage.memberID = p.MemberID; logMessage.Level = "ERROR"; logMessage.Logger = "CBComUdtMemberItemPurchaseController"; logMessage.Message = jsonParam; logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
public HttpResponseMessage Post(UdtGameEventMemberToItemInputParams p) { // try decrypt data if (!string.IsNullOrEmpty(p.token) && globalVal.CloudBreadCryptSetting == "AES256") { try { string decrypted = Crypto.AES_decrypt(p.token, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); p = JsonConvert.DeserializeObject <UdtGameEventMemberToItemInputParams>(decrypted); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Decrypt Error", ex); throw ex; } } // Get the sid or memberID of the current user. string sid = CBAuth.getMemberID(p.MemberID_MemberItems, this.User as ClaimsPrincipal); p.MemberID_MemberItems = sid; p.MemberID_GameEventMember = sid; Logging.CBLoggers logMessage = new Logging.CBLoggers(); string jsonParam = JsonConvert.SerializeObject(p); HttpResponseMessage response = new HttpResponseMessage(); EncryptedData encryptedResult = new EncryptedData(); RowcountResult rowcountResult = new RowcountResult(); try { // start task log //logMessage.memberID = p.MemberID_MemberItems; //logMessage.Level = "INFO"; //logMessage.Logger = "CBUdtGameEventMemberToItemController"; //logMessage.Message = jsonParam; //Logging.RunLog(logMessage); /// Database connection retry policy RetryPolicy retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(globalVal.conRetryCount, TimeSpan.FromSeconds(globalVal.conRetryFromSeconds)); using (SqlConnection connection = new SqlConnection(globalVal.DBConnectionString)) { using (SqlCommand command = new SqlCommand("uspUdtGameEventMemberToItem", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@InsertORUpdate ", SqlDbType.NVarChar, -1).Value = p.InsertORUpdate.ToUpper(); command.Parameters.Add("@MemberItemID_MemberItems ", SqlDbType.NVarChar, -1).Value = p.MemberItemID_MemberItems; command.Parameters.Add("@MemberID_MemberItems", SqlDbType.NVarChar, -1).Value = p.MemberID_MemberItems; command.Parameters.Add("@ItemListID_MemberItems", SqlDbType.NVarChar, -1).Value = p.ItemListID_MemberItems; command.Parameters.Add("@ItemCount_MemberItems", SqlDbType.NVarChar, -1).Value = p.ItemCount_MemberItems; command.Parameters.Add("@ItemStatus_MemberItems", SqlDbType.NVarChar, -1).Value = p.ItemStatus_MemberItems; command.Parameters.Add("@sCol1_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol1_MemberItems; command.Parameters.Add("@sCol2_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol2_MemberItems; command.Parameters.Add("@sCol3_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol3_MemberItems; command.Parameters.Add("@sCol4_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol4_MemberItems; command.Parameters.Add("@sCol5_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol5_MemberItems; command.Parameters.Add("@sCol6_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol6_MemberItems; command.Parameters.Add("@sCol7_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol7_MemberItems; command.Parameters.Add("@sCol8_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol8_MemberItems; command.Parameters.Add("@sCol9_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol9_MemberItems; command.Parameters.Add("@sCol10_MemberItems", SqlDbType.NVarChar, -1).Value = p.sCol10_MemberItems; command.Parameters.Add("@eventID_GameEventMember", SqlDbType.NVarChar, -1).Value = p.eventID_GameEventMember; command.Parameters.Add("@MemberID_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.MemberID_GameEventMember; command.Parameters.Add("@sCol1_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol1_GameEventMember; command.Parameters.Add("@sCol2_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol2_GameEventMember; command.Parameters.Add("@sCol3_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol3_GameEventMember; command.Parameters.Add("@sCol4_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol4_GameEventMember; command.Parameters.Add("@sCol5_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol5_GameEventMember; command.Parameters.Add("@sCol6_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol6_GameEventMember; command.Parameters.Add("@sCol7_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol7_GameEventMember; command.Parameters.Add("@sCol8_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol8_GameEventMember; command.Parameters.Add("@sCol9_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol9_GameEventMember; command.Parameters.Add("@sCol10_GameEventMember ", SqlDbType.NVarChar, -1).Value = p.sCol10_GameEventMember; connection.OpenWithRetry(retryPolicy); using (SqlDataReader dreader = command.ExecuteReaderWithRetry(retryPolicy)) { while (dreader.Read()) { rowcountResult.result = dreader[0].ToString(); } dreader.Close(); } connection.Close(); // end task log logMessage.memberID = p.MemberID_MemberItems; logMessage.Level = "INFO"; logMessage.Logger = "CBUdtGameEventMemberToItemController"; logMessage.Message = jsonParam; Logging.RunLog(logMessage); /// Encrypt the result response if (globalVal.CloudBreadCryptSetting == "AES256") { try { encryptedResult.token = Crypto.AES_encrypt(JsonConvert.SerializeObject(rowcountResult), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); response = Request.CreateResponse(HttpStatusCode.OK, encryptedResult); return(response); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Encrypt Error", ex); throw ex; } } response = Request.CreateResponse(HttpStatusCode.OK, rowcountResult); return(response); } } } catch (Exception ex) { // error log logMessage.memberID = p.MemberID_MemberItems; logMessage.Level = "ERROR"; logMessage.Logger = "CBUdtGameEventMemberToItemController"; logMessage.Message = jsonParam; 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: 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: 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: ItemLists //public ActionResult Index(string sortOrder) // 정렬 방식 테스트 public ActionResult Index(string searchString, string SearchCondition, string currentFilter, int?page) // 검색 방식 테스트 + 페이징 { //ViewBag.CurrentSort = sortOrder; //ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "itemname_desc" : ""; //ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; // 정렬 처리 //ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "ItemName" : ""; //var result = from s in db.ItemLists // select s; //switch (sortOrder) //{ // case "ItemName": // result = result.OrderBy(s => s.ItemName); // break; // default: // result = result.OrderBy(s => s.ItemName); // break; //} //페이징 기본 처리 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; 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; } //result = result.Where(s => s.ItemName.Contains(searchString) // || s.ItemListID.Contains(searchString) // || s.ItemDescription.Contains(searchString)); } //switch (sortOrder) //{ // case "itemname_desc": // result = result.OrderByDescending(s => s.ItemName); // break; // default: // Name ascending // result = result.OrderByDescending(s => s.ItemName); // break; //} // 기본 order 처리 - ItemName으로 정렬 처리 - ToPagedList의 제약 조건 queryString = queryString.OrderBy(s => s.ItemName); int pageSize = 3; int pageNumber = (page ?? 1); //IQueryable로 할까 리포지토리 IEnumerable로 할까. // ToPagedList에 제약이 있네. IQueryable var result = queryString.ToPagedList(pageNumber, pageSize); // 데이터 복호화를 Controller에서 하는게 좋을까 View에서 하는게 좋을까. // result에 대해 복호화 작업 수행. reflection? //int i = 0; if (globalVal.CloudBreadCryptSetting == "AES256") { DecryptResult(result); //PagedList 타입 } //return View(queryString.ToPagedList(pageNumber, pageSize)); return(View(result)); }
public HttpResponseMessage Post(SelSendEmailToMemberInputParams p) { // try decrypt data if (!string.IsNullOrEmpty(p.token) && globalVal.CloudBreadCryptSetting == "AES256") { try { string decrypted = Crypto.AES_decrypt(p.token, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); p = JsonConvert.DeserializeObject <SelSendEmailToMemberInputParams>(decrypted); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Decrypt Error", ex); throw ex; } } // Get the sid or memberID of the current user. string sid = CBAuth.getMemberID(p.memberID, this.User as ClaimsPrincipal); p.memberID = sid; // check proper authentication of member who trigger this API (Admin or member with authorized) Logging.CBLoggers logMessage = new Logging.CBLoggers(); string jsonParam = JsonConvert.SerializeObject(p); HttpResponseMessage response = new HttpResponseMessage(); EncryptedData encryptedResult = new EncryptedData(); RowcountResult rowcountResult = new RowcountResult(); try { /// Database connection retry policy RetryPolicy retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(globalVal.conRetryCount, TimeSpan.FromSeconds(globalVal.conRetryFromSeconds)); using (SqlConnection connection = new SqlConnection(globalVal.DBConnectionString)) { using (SqlCommand command = new SqlCommand("uspSelSendEmailToMember", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@MemberID", SqlDbType.NVarChar, -1).Value = p.memberID; connection.OpenWithRetry(retryPolicy); using (SqlDataReader dreader = command.ExecuteReaderWithRetry(retryPolicy)) { while (dreader.Read()) { rowcountResult.result = dreader[0].ToString(); } ////////////////////////////////////////////////////////////////////////////////////// //// mail sending module - reference CloudBreadlib/BAL/SendSMTPMail //// check firewall, anti-virus and outbound traffic //// in SendEmail lib, change your mail login info //string s = SendSMTPMail.SendEmail(dreader[0].ToString(), "subject", "content"); ////////////////////////////////////////////////////////////////////////////////////// dreader.Close(); } connection.Close(); /// Encrypt the result response if (globalVal.CloudBreadCryptSetting == "AES256") { try { encryptedResult.token = Crypto.AES_encrypt(JsonConvert.SerializeObject(rowcountResult), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); response = Request.CreateResponse(HttpStatusCode.OK, encryptedResult); return(response); } catch (Exception ex) { ex = (Exception)Activator.CreateInstance(ex.GetType(), "Encrypt Error", ex); throw ex; } } response = Request.CreateResponse(HttpStatusCode.OK, rowcountResult); return(response); // or return mail send result string s } } } catch (Exception ex) { // error log logMessage.memberID = p.memberID; logMessage.Level = "ERROR"; logMessage.Logger = "CBSelSendEmailToMemberController"; logMessage.Message = jsonParam; logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }