protected void btnInsert_Click(object sender, EventArgs e)
{
if (vadPassCheck.IsValid && vadAfterFour.IsValid)
{
//驗證帳號(信箱)是否已存在
var ifb = new iFoodBoxDataContext();
var uAccount = ifb.userAccounts.FirstOrDefault(m => txtAccount.Text.Equals(m.userAccount.ToString()));
if (uAccount != null)
{
lblErrorMsgEmail.Visible = true;
return;
}
//驗證電話是否已存在
ifb = new iFoodBoxDataContext();
var uData = ifb.userData.FirstOrDefault(m => txtPhone.Text.Equals(m.userPhone.ToString()));
if (uData != null)
{
lblErrorMsgPhone.Visible = true;
return;
}
//將基本資料存入
uData = new userData();
uData.userName = txtName.Text;
uData.userDate = DateTime.Parse(txtDate.Text);
if (rBtnM.Checked)//判斷性別
uData.userSex = true;
else if (rBtnF.Checked)
uData.userSex = false;
else
uData.userSex = true;
uData.userAfterFour = txtAfterFour.Text;
uData.userPhone = txtPhone.Text;
ifb = new iFoodBoxDataContext();
ifb.userData.InsertOnSubmit(uData);
ifb.SubmitChanges();
//取出userID
ifb = new iFoodBoxDataContext();
var tableUserData = from x in ifb.userData
where x.userPhone == txtPhone.Text
select x;
var userID = 0;
foreach (userData ud in tableUserData)
userID = ud.userID;
//將帳號資訊存入
uAccount = new userAccounts();
uAccount.userAccount = txtAccount.Text;
uAccount.userPassword = txtPassword.Text;
uAccount.userID = userID;
ifb = new iFoodBoxDataContext();
ifb.userAccounts.InsertOnSubmit(uAccount);
ifb.SubmitChanges();
Response.Write(" <script language=JavaScript> alert('資料新增完畢！'); </script> ");
Response.Redirect("LoginPage.aspx");
}
}
public async Task <ActionResult <userAccounts> > PostuserAccounts(userAccounts userAccounts)
{
string hashedPassword = BCrypt.Net.BCrypt.HashPassword(userAccounts.password);
userAccounts.password = hashedPassword;
_context.userAccounts.Add(userAccounts);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetuserAccounts", new { id = userAccounts.id }, userAccounts));
}
public async Task <ActionResult <userAccounts> > Login([FromBody] userAccounts userAccount)
{
var user = await _context.userAccounts.FirstOrDefaultAsync(x => x.email == userAccount.email);
if (user != null)
{
bool ifPass = BCrypt.Net.BCrypt.Verify(userAccount.password, user.password);
if (ifPass)
{
return(Ok(user));
}
}
return(NotFound());
}
protected void btnChangePass_Click(object sender, EventArgs e)
{
if (davCheckPassword.IsValid)
{
var ifb = new iFoodBoxDataContext();
var sessionAccount = new userAccounts();
sessionAccount = Session[CDkey.session_change_password] as userAccounts;
var uAccount = ifb.userAccounts.FirstOrDefault(m => sessionAccount.accountID.Equals(m.accountID.ToString()));
if (uAccount == null)
return;
uAccount.userPassword = txtPassword.Text;
ifb.SubmitChanges();
Response.Write(" <script language=JavaScript> alert('密碼修改完畢！'); </script> ");
}
Response.Redirect("LoginPage.aspx");
}
protected void btnChangePass_Click(object sender, EventArgs e)
{
if (davCheckPassword.IsValid)
{
var ifb = new iFoodBoxDataContext();
var sessionAccount = new userAccounts();
sessionAccount = Session[CDkey.session_change_password] as userAccounts;
var uAccount = ifb.userAccounts.FirstOrDefault(m => sessionAccount.accountID.Equals(m.accountID.ToString()));
if (uAccount == null)
{
return;
}
uAccount.userPassword = txtPassword.Text;
ifb.SubmitChanges();
Response.Write(" <script language=JavaScript> alert('密碼修改完畢！'); </script> ");
}
Response.Redirect("LoginPage.aspx");
}
public async Task <IActionResult> PutuserAccounts(Guid id, userAccounts userAccounts)
{
var oldUser = _context.userAccounts.FirstOrDefault(x => x.id == id);
if (id != userAccounts.id)
{
return(BadRequest());
}
if (userAccounts.password != null)
{
string hashedPassword = BCrypt.Net.BCrypt.HashPassword(userAccounts.password);
userAccounts.password = hashedPassword;
}
else
{
userAccounts.password = oldUser.password;
}
try
{
oldUser.userName = userAccounts.userName;
oldUser.email = userAccounts.email;
oldUser.password = userAccounts.password;
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!userAccountsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
partial void DeleteuserAccounts(userAccounts instance);
partial void UpdateuserAccounts(userAccounts instance);
partial void InsertuserAccounts(userAccounts instance);
protected void btnInsert_Click(object sender, EventArgs e)
{
if (vadPassCheck.IsValid && vadAfterFour.IsValid)
{
//驗證帳號(信箱)是否已存在
var ifb = new iFoodBoxDataContext();
var uAccount = ifb.userAccounts.FirstOrDefault(m => txtAccount.Text.Equals(m.userAccount.ToString()));
if (uAccount != null)
{
lblErrorMsgEmail.Visible = true;
return;
}
//驗證電話是否已存在
ifb = new iFoodBoxDataContext();
var uData = ifb.userData.FirstOrDefault(m => txtPhone.Text.Equals(m.userPhone.ToString()));
if (uData != null)
{
lblErrorMsgPhone.Visible = true;
return;
}
//將基本資料存入
uData = new userData();
uData.userName = txtName.Text;
uData.userDate = DateTime.Parse(txtDate.Text);
if (rBtnM.Checked)//判斷性別
{
uData.userSex = true;
}
else if (rBtnF.Checked)
{
uData.userSex = false;
}
else
{
uData.userSex = true;
}
uData.userAfterFour = txtAfterFour.Text;
uData.userPhone = txtPhone.Text;
ifb = new iFoodBoxDataContext();
ifb.userData.InsertOnSubmit(uData);
ifb.SubmitChanges();
//取出userID
ifb = new iFoodBoxDataContext();
var tableUserData = from x in ifb.userData
where x.userPhone == txtPhone.Text
select x;
var userID = 0;
foreach (userData ud in tableUserData)
{
userID = ud.userID;
}
//將帳號資訊存入
uAccount = new userAccounts();
uAccount.userAccount = txtAccount.Text;
uAccount.userPassword = txtPassword.Text;
uAccount.userID = userID;
ifb = new iFoodBoxDataContext();
ifb.userAccounts.InsertOnSubmit(uAccount);
ifb.SubmitChanges();
Response.Write(" <script language=JavaScript> alert('資料新增完畢！'); </script> ");
Response.Redirect("LoginPage.aspx");
}
}
