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