protected void BindData()
{
DataTable member = AdminMembers.GetMemberInfoByMemberID(_memberID);
if (member.Rows.Count > 0)
{
DataRow row = member.Rows[0];
lblMemberID.Text = row["MemberID"].ToString();
tbPassword.Text = row["Password"].ToString();
tbPasswordRe.Text = row["Password"].ToString();
tbFName.Text = row["FName"].ToString();
tbLName.Text = row["LName"].ToString();
tbKorName.Text = row["KorName"].ToString();
tbEmail.Text = row["Email"].ToString();
tbPhone.Text = row["Phone"].ToString();
tbAddress.Text = row["Address"].ToString();
tbAddress2.Text = row["Address2"].ToString();
tbCity.Text = row["City"].ToString();
tbState.Text = row["State"].ToString();
tbZip.Text = row["Zip"].ToString();
ListItem status = ddlProgressStatus.Items.FindByValue(row["ProgressStatus"].ToString());
if (status != null)
{
status.Selected = true;
}
cbActiveStatus.Checked = bool.Parse(row["ActiveStatus"].ToString());
JoinedDate.Text = DateTime.Parse(row["Joined"].ToString()).ToString("MM/dd/yyyy");
}
}
// GET: AdminMembers/Details/5
public ActionResult Details(string id)
{
try
{
// Detail 세션체크
if (!CheckSession())
{
return(Redirect("/AdminLogin/Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//테이블 조회 - 필요할 경우 조인
AdminMembers adminMembers = db.AdminMembers.Find(id);
if (adminMembers == null)
{
return(HttpNotFound());
}
//암호화 안한다
//복호화 처리
//if (globalVal.CloudBreadCryptSetting == "AES256")
//{
// DecryptResult(adminMembers); //AdminMembers 타입
//}
//UTC를 세션의 UserTimeZone으로 변환 - 안하면 UTC 그대로 보임
adminMembers.LastLoginDT = UserTime.GetUserTime(DateTime.Parse(adminMembers.LastLoginDT), Session["AdminTimeZone"].ToString()).ToString();
adminMembers.LastLogoutDT = UserTime.GetUserTime(DateTime.Parse(adminMembers.LastLogoutDT), Session["AdminTimeZone"].ToString()).ToString();
adminMembers.CreatedAt = UserTime.GetUserTime(adminMembers.CreatedAt.DateTime, Session["AdminTimeZone"].ToString());
adminMembers.UpdatedAt = UserTime.GetUserTime(adminMembers.UpdatedAt.DateTime, Session["AdminTimeZone"].ToString());
adminMembers.DataFromRegionDT = UserTime.GetUserTime(adminMembers.DataFromRegionDT.DateTime, Session["AdminTimeZone"].ToString());
// 관리자 접근 로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "INFO";
logMessage.Logger = "AdminMembersController-Details";
logMessage.Message = string.Format("id : {0}", id);
Logging.RunLog(logMessage);
return(View(adminMembers));
}
catch (Exception ex)
{
//에러로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "ERROR";
logMessage.Logger = "AdminMembersController-Details";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// POST: odata/AdminMembers
public IHttpActionResult Post(AdminMembers adminMembers)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.AdminMembers.Add(adminMembers);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (AdminMembersExists(adminMembers.AdminMemberID))
{
return(Conflict());
}
else
{
throw;
}
}
string sid = CBAuth.getMemberID(this.User as ClaimsPrincipal);
logMsg.memberID = sid;
logMsg.Level = "INFO";
logMsg.Logger = "AdminMembers-POST";
logMsg.memberID = JsonConvert.SerializeObject(adminMembers);
Logging.RunLog(logMsg);
return(Created(adminMembers));
}
// POST: odata/AdminMembers
public IHttpActionResult Post(AdminMembers adminMembers)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.AdminMembers.Add(adminMembers);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (AdminMembersExists(adminMembers.AdminMemberID))
{
return(Conflict());
}
else
{
throw;
}
}
return(Created(adminMembers));
}
public ActionResult Create([Bind(Include = "AdminMemberID,AdminMemberPWD,AdminMemberEmail,IDCreateAdminMember,AdminGroup,TimeZoneID,PINumber,Name1,Name2,Name3,DOB,LastIPaddress,LastLoginDT,LastLogoutDT,sCol1,sCol2,sCol3,sCol4,sCol5,sCol6,sCol7,sCol8,sCol9,sCol10,HideYN,DeleteYN,CreatedAt,UpdatedAt,DataFromRegion,DataFromRegionDT")] AdminMembers adminMembers)
{
try
{
// Create 세션체크
if (!CheckSession())
{
return(Redirect("/AdminLogin/Login"));
}
if (ModelState.IsValid)
{
//입력값 기본 처리
adminMembers.AdminMemberPWD = Crypto.SHA512Hash(adminMembers.AdminMemberPWD);
adminMembers.IDCreateAdminMember = this.Session["AdminID"].ToString();
adminMembers.LastIPaddress = "";
adminMembers.LastLoginDT = "1900-01-01";
adminMembers.LastLogoutDT = "1900-01-01";
adminMembers.CreatedAt = DateTimeOffset.UtcNow;
adminMembers.UpdatedAt = DateTimeOffset.UtcNow;
//adminMembers.DataFromRegionDT = DateTimeOffset.Parse("1900-01-01");
//암호화 안함
// Insert : 암호화 처리
//if (globalVal.CloudBreadCryptSetting == "AES256")
//{
// //암호화
// EncryptResult(adminMembers);
//}
db.AdminMembers.Add(adminMembers);
// 관리자 접근 로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "INFO";
logMessage.Logger = "AdminMembersController-Create(adminMembers)";
logMessage.Message = JsonConvert.SerializeObject(adminMembers);
Logging.RunLog(logMessage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adminMembers));
}
catch (Exception ex)
{
//에러로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "ERROR";
logMessage.Logger = "AdminMembersController-Create(adminMembers)";
logMessage.Message = JsonConvert.SerializeObject(adminMembers);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
public ActionResult DeleteConfirmed(string id)
{
AdminMembers adminMembers = db.AdminMembers.Find(id);
db.AdminMembers.Remove(adminMembers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,AdminMemberID,AdminMemberPWD,AdminMemberEmail,IDCreateAdminMember,AdminGroup,PINumber,Name1,Name2,Name3,DOB,LastIPaddress,LastLoginDT,LastLogoutDT,HideYN,AccountBlockYN,DeleteYN,sCol1,sCol2,sCol3,sCol4,sCol5,sCol6,sCol7,sCol8,sCol9,sCol10,Version,CreatedAt,UpdatedAt,Deleted")] AdminMembers adminMembers)
{
if (ModelState.IsValid)
{
db.Entry(adminMembers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adminMembers));
}
// GET: AdminMembers/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminMembers adminMembers = db.AdminMembers.Find(id);
if (adminMembers == null)
{
return(HttpNotFound());
}
return(View(adminMembers));
}
// DELETE: odata/AdminMembers(5)
public IHttpActionResult Delete([FromODataUri] string key)
{
AdminMembers adminMembers = db.AdminMembers.Find(key);
if (adminMembers == null)
{
return(NotFound());
}
db.AdminMembers.Remove(adminMembers);
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
// PUT: odata/AdminMembers(5)
public IHttpActionResult Put([FromODataUri] string key, Delta <AdminMembers> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
AdminMembers adminMembers = db.AdminMembers.Find(key);
if (adminMembers == null)
{
return(NotFound());
}
patch.Put(adminMembers);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AdminMembersExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
string sid = CBAuth.getMemberID(this.User as ClaimsPrincipal);
logMsg.memberID = sid;
logMsg.Level = "INFO";
logMsg.Logger = "AdminMembers-PUT";
logMsg.memberID = JsonConvert.SerializeObject(patch);
Logging.RunLog(logMsg);
return(Updated(adminMembers));
}
protected void btnDelete_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
if (AspxLB.Items.Count > 0)
{
foreach (ListEditItem item in AspxLB.Items)
{
string memberID = item.Value.ToString();
//logger.Debug("deleting memberid - "+memberID);
AdminMembers.DeleteMember(memberID);
}
}
MembersGV.Selection.IsRowSelected(0);
MembersGV.GetRow(0);
MembersGV.DataSourceID = "MembersViewSource";
//MembersGV.
MembersGV.DataBind();
}
// GET: AdminMembers/Delete/5
public ActionResult Delete(string id)
{
try
{
// Delete 세션체크
if (!CheckSession())
{
return(Redirect("/AdminLogin/Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AdminMembers adminMembers = db.AdminMembers.Find(id);
if (adminMembers == null)
{
return(HttpNotFound());
}
// 관리자 접근 로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "INFO";
logMessage.Logger = "AdminMembersController-Delete(id)";
logMessage.Message = string.Format("id : {0}", id);
Logging.RunLog(logMessage);
return(View(adminMembers));
}
catch (Exception ex)
{
//에러로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "ERROR";
logMessage.Logger = "AdminMembersController-Delete(id)";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
public ActionResult Create([Bind(Include = "Id,AdminMemberID,AdminMemberPWD,AdminMemberEmail,IDCreateAdminMember,AdminGroup,PINumber,Name1,Name2,Name3,DOB,LastIPaddress,LastLoginDT,LastLogoutDT,HideYN,AccountBlockYN,DeleteYN,sCol1,sCol2,sCol3,sCol4,sCol5,sCol6,sCol7,sCol8,sCol9,sCol10,Version,CreatedAt,UpdatedAt,Deleted")] AdminMembers adminMembers)
{
// PWD에 대해서 Hash 처리 진행
adminMembers.AdminMemberPWD = Crypto.SHA512Hash(adminMembers.AdminMemberPWD);
if (ModelState.IsValid)
{
try
{
db.AdminMembers.Add(adminMembers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
throw;
}
}
return(View(adminMembers));
}
// DELETE: odata/AdminMembers(5)
public IHttpActionResult Delete([FromODataUri] string key)
{
AdminMembers adminMembers = db.AdminMembers.Find(key);
if (adminMembers == null)
{
return(NotFound());
}
db.AdminMembers.Remove(adminMembers);
db.SaveChanges();
string sid = CBAuth.getMemberID(this.User as ClaimsPrincipal);
logMsg.memberID = sid;
logMsg.Level = "INFO";
logMsg.Logger = "AdminMembers-DELETE";
logMsg.memberID = key;
Logging.RunLog(logMsg);
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(string id)
{
try
{
// Delete 세션체크
if (!CheckSession())
{
return(Redirect("/AdminLogin/Login"));
}
AdminMembers adminMembers = db.AdminMembers.Find(id);
db.AdminMembers.Remove(adminMembers);
db.SaveChanges();
// 관리자 접근 로그
logMessage.memberID = this.Session["AdminID"].ToString();
logMessage.Level = "INFO";
logMessage.Logger = "AdminMembersController-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 = "AdminMembersController-DeleteConfirm(id)";
logMessage.Message = string.Format("id : {0}", id);
logMessage.Exception = ex.ToString();
Logging.RunLog(logMessage);
throw;
}
}
// PUT: odata/AdminMembers(5)
public IHttpActionResult Put([FromODataUri] string key, Delta <AdminMembers> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
AdminMembers adminMembers = db.AdminMembers.Find(key);
if (adminMembers == null)
{
return(NotFound());
}
patch.Put(adminMembers);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AdminMembersExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(adminMembers));
}
