public ActionResult DeleteConfirmed(string id) { try { // Delete 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } MemberItems memberItems = db.MemberItems.Find(id); db.MemberItems.Remove(memberItems); db.SaveChanges(); // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "MemberItemsController-DeleteConfirm(id)"; logMessage.Message = string.Format("id : {0}", id); Logging.RunLog(logMessage); return(RedirectToAction("Index")); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "MemberItemsController-DeleteConfirm(id)"; logMessage.Message = string.Format("id : {0}", id); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
// POST: odata/MemberItems public IHttpActionResult Post(MemberItems memberItems) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.MemberItems.Add(memberItems); try { db.SaveChanges(); } catch (DbUpdateException) { if (MemberItemsExists(memberItems.MemberItemID)) { return(Conflict()); } else { throw; } } return(Created(memberItems)); }
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); }
private void InitListViewModel(MemberItemsViewModel viewModel, MemberItems list) { foreach (var item in viewModel.Items) { InitBaseItemViewModel(item); item.FormattedName = $"{item.LastName} {item.FirstName} {item.MiddleName}"; } }
public ActionResult DeleteConfirmed(string id) { MemberItems memberItems = db.MemberItems.Find(id); db.MemberItems.Remove(memberItems); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MemberItemID,MemberID,ItemListID,ItemCount,ItemStatus,sCol1,sCol2,sCol3,sCol4,sCol5,sCol6,sCol7,sCol8,sCol9,sCol10,HideYN,DeleteYN,CreatedAt,UpdatedAt,DataFromRegion,DataFromRegionDT")] MemberItems memberItems) { if (ModelState.IsValid) { db.Entry(memberItems).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(memberItems)); }
public ActionResult List(MemberFilterViewModel filterViewModel) { InitMemberFilterViewModel(ref filterViewModel, true); var filter = Mapper.Map <MemberFilter>(filterViewModel); MemberItems list = _memberRepository.GetMemberItems(UserContext.User.Id, UserContext.User.OrganizationId, filter); MemberItemsViewModel viewModel = Mapper.Map <MemberItemsViewModel>(list); viewModel.Filter = filterViewModel; InitListViewModel(viewModel, list); return(View(Mvc.View.Member.List, viewModel)); }
public ActionResult Create([Bind(Include = "MemberItemID,MemberID,ItemListID,ItemCount,ItemStatus,sCol1,sCol2,sCol3,sCol4,sCol5,sCol6,sCol7,sCol8,sCol9,sCol10,HideYN,DeleteYN,CreatedAt,UpdatedAt,DataFromRegion,DataFromRegionDT")] MemberItems memberItems) { try { // Create 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } if (ModelState.IsValid) { // 입력값 자동 처리 memberItems.CreatedAt = DateTimeOffset.UtcNow; memberItems.UpdatedAt = DateTimeOffset.UtcNow; // Insert : 암호화 처리 if (globalVal.CloudBreadCryptSetting == "AES256") { EncryptResult(memberItems); } db.MemberItems.Add(memberItems); // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "MemberItemsController-Create(memberItems)"; logMessage.Message = JsonConvert.SerializeObject(memberItems); Logging.RunLog(logMessage); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(memberItems)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "MemberItemsController-Create(memberItems)"; logMessage.Message = JsonConvert.SerializeObject(memberItems); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
// DELETE: odata/MemberItems(5) public IHttpActionResult Delete([FromODataUri] string key) { MemberItems memberItems = db.MemberItems.Find(key); if (memberItems == null) { return(NotFound()); } db.MemberItems.Remove(memberItems); db.SaveChanges(); return(StatusCode(HttpStatusCode.NoContent)); }
// GET: MemberItems/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MemberItems memberItems = db.MemberItems.Find(id); if (memberItems == null) { return(HttpNotFound()); } return(View(memberItems)); }
/// <summary> /// 构造函数 /// </summary> public DataAccessObject() { _entityType = typeof(T); _ORMapping = ORMappingFactory.CreateInstance(); _tableName = ORMapping.Mapping.GetTableName(EntityType.FullName); _defaultTableName = _tableName; foreach (MappingItem item in ORMapping.Mapping.GetKeyItemsThruClass(_entityType.FullName)) { KeyItems.Add(item); } foreach (MappingItem item in ORMapping.Mapping.GetMemberItemsThruClass(_entityType.FullName)) { MemberItems.Add(item); } }
// PUT: odata/MemberItems(5) public IHttpActionResult Put([FromODataUri] string key, Delta <MemberItems> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } MemberItems memberItems = db.MemberItems.Find(key); if (memberItems == null) { return(NotFound()); } patch.Put(memberItems); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MemberItemsExists(key)) { return(NotFound()); } else { throw; } } // Get the sid of the current user string sid = CBAuth.getMemberID(this.User as ClaimsPrincipal); logMsg.memberID = sid; logMsg.Level = "INFO"; logMsg.Logger = "MemberItems-PUT"; logMsg.Message = JsonConvert.SerializeObject(patch); Logging.RunLog(logMsg); return(Updated(memberItems)); }
public MemberItems DecryptResult(MemberItems result) { result.GetType().GetProperties().ToList().ForEach(p => { 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 { //Debug.WriteLine((p.GetValue(result, null) ?? "").ToString()); p.SetValue(result, Crypto.AES_decrypt((p.GetValue(result, null) ?? "").ToString(), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV), null); //Debug.WriteLine((p.GetValue(result, null) ?? "").ToString()); } }); return(result); }
//암호화 처리 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); }
// GET: MemberItems/Delete/5 public ActionResult Delete(string id) { try { // Delete 세션체크 if (!CheckSession()) { return(Redirect("/AdminLogin/Login")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MemberItems memberItems = db.MemberItems.Find(id); if (memberItems == null) { return(HttpNotFound()); } // 관리자 접근 로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "INFO"; logMessage.Logger = "MemberItemsController-Delete(id)"; logMessage.Message = string.Format("id : {0}", id); Logging.RunLog(logMessage); return(View(memberItems)); } catch (Exception ex) { //에러로그 logMessage.memberID = this.Session["AdminID"].ToString(); logMessage.Level = "ERROR"; logMessage.Logger = "MemberItemsController-Delete(id)"; logMessage.Message = string.Format("id : {0}", id); logMessage.Exception = ex.ToString(); Logging.RunLog(logMessage); throw; } }
// 복호화 수행 public MemberItems DecryptResult(MemberItems item) { try { item.MemberItemID = Crypto.AES_decrypt(item.MemberItemID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.MemberID = Crypto.AES_decrypt(item.MemberID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.Members.Name1 = Crypto.AES_decrypt(item.Members.Name1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemListID = Crypto.AES_decrypt(item.ItemListID, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemLists.ItemName = Crypto.AES_decrypt(item.ItemLists.ItemName, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemCount = Crypto.AES_decrypt(item.ItemCount, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.ItemStatus = Crypto.AES_decrypt(item.ItemStatus, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol1 = Crypto.AES_decrypt(item.sCol1, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol2 = Crypto.AES_decrypt(item.sCol2, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol3 = Crypto.AES_decrypt(item.sCol3, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol4 = Crypto.AES_decrypt(item.sCol4, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol5 = Crypto.AES_decrypt(item.sCol5, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol6 = Crypto.AES_decrypt(item.sCol6, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol7 = Crypto.AES_decrypt(item.sCol7, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol8 = Crypto.AES_decrypt(item.sCol8, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol9 = Crypto.AES_decrypt(item.sCol9, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); item.sCol10 = Crypto.AES_decrypt(item.sCol10, globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV); //result.GetType().GetProperties().ToList().ForEach(p => //{ // if (p.Name == "HideYN" || p.Name == "DeleteYN" || p.Name == "CreatedAt" || p.Name == "UpdatedAt" || p.Name == "DataFromRegion" || p.Name == "DataFromRegionDT") // 복호화 안하고 통과 시킬 녀석들 // { // // 추가 처리 // } // else // { // p.SetValue(result, Crypto.AES_decrypt((p.GetValue(result, null) ?? "").ToString(), globalVal.CloudBreadCryptKey, globalVal.CloudBreadCryptIV), null); // } //}); } catch (Exception) { throw; } return(item); }
// DELETE: odata/MemberItems(5) public IHttpActionResult Delete([FromODataUri] string key) { MemberItems memberItems = db.MemberItems.Find(key); if (memberItems == null) { return(NotFound()); } db.MemberItems.Remove(memberItems); db.SaveChanges(); // Get the sid of the current user string sid = CBAuth.getMemberID(this.User as ClaimsPrincipal); logMsg.memberID = sid; logMsg.Level = "INFO"; logMsg.Logger = "MemberItems-DELETE"; logMsg.Message = key; Logging.RunLog(logMsg); return(StatusCode(HttpStatusCode.NoContent)); }
// PUT: odata/MemberItems(5) public IHttpActionResult Put([FromODataUri] string key, Delta <MemberItems> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } MemberItems memberItems = db.MemberItems.Find(key); if (memberItems == null) { return(NotFound()); } patch.Put(memberItems); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!MemberItemsExists(key)) { return(NotFound()); } else { throw; } } return(Updated(memberItems)); }
// POST: odata/MemberItems public IHttpActionResult Post(MemberItems memberItems) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.MemberItems.Add(memberItems); try { db.SaveChanges(); } catch (DbUpdateException) { if (MemberItemsExists(memberItems.MemberItemID)) { return(Conflict()); } else { throw; } } // Get the sid of the current user string sid = CBAuth.getMemberID(this.User as ClaimsPrincipal); logMsg.memberID = sid; logMsg.Level = "INFO"; logMsg.Logger = "MemberItems-POST"; logMsg.Message = JsonConvert.SerializeObject(memberItems); Logging.RunLog(logMsg); return(Created(memberItems)); }
public void DeleteMemberItems(List <ModelsLinq.MemberSQLite> memberList) { MemberItems.RemoveRange(memberList); SaveChanges(); }
public async Task <List <ModelsLinq.MemberSQLite> > GetMemberItemsAsync() { return(await MemberItems.ToListAsync()); }
public async Task <int> SaveMemberItemAsync(ModelsLinq.MemberSQLite memberItem) { await MemberItems.AddAsync(memberItem); return(await SaveChangesAsync()); }