public async Task <ModelResponseMessageUpdateUserRegister> ResetPasswordAsync(ModelResetPassword model) { ModelResponseMessageUpdateUserRegister resp = new ModelResponseMessageUpdateUserRegister(); resp.Status = false; if (string.IsNullOrEmpty(model.oldpassw)) { resp.Message = "กรุณาระบุรหัสผ่านเดิม"; } else if (string.IsNullOrEmpty(model.newpassw)) { resp.Message = "กรุณาระบุรหัสผ่านใหม่"; } else if (string.IsNullOrEmpty(model.confirmpassw)) { resp.Message = "กรุณายืนยันรหัสผ่าน"; } else if (model.newpassw != model.confirmpassw) { resp.Message = "รหัสผ่านใหม่ไม่ตรงกัน"; } else { resp = await _IRegisterUserRepository.ResetPasswordAsync(model); } return(resp); }
public async Task <IActionResult> UpdateUserRegisterAsync(ModelRegisterEdit model) { ModelResponseMessageUpdateUserRegister e = await _IDocMenuFService.UpdateUserRegisterAsync(model); if (e.Status) { return(Ok()); } else { return(BadRequest()); } }
public async Task <IActionResult> UpdatePermissionGroup(ModelMenuF2Edit model) { ModelResponseMessageUpdateUserRegister e = await _IDocMenuFService.UpdatePermissionGroupAsync(model); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task <ModelResponseMessageUpdateUserRegister> UpdateUserAccountAsync(ModelUpdateAccountUser model) { ModelResponseMessageUpdateUserRegister resp = new ModelResponseMessageUpdateUserRegister(); string userid = Encoding.UTF8.GetString(Convert.FromBase64String(model.registerid)); using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("sp_update_user_account", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@RegisterId", SqlDbType.VarChar, 100).Value = userid; cmd.Parameters.Add("@Email", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.email); cmd.Parameters.Add("@FirstName1", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.firstname1); cmd.Parameters.Add("@FirstName2", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.firstname2); cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.firstname); cmd.Parameters.Add("@FullName", SqlDbType.VarChar, 200).Value = ParseDataHelper.ConvertDBNull(model.fullname); cmd.Parameters.Add("@WorkPhone", SqlDbType.VarChar, 50).Value = ParseDataHelper.ConvertDBNull(model.workphone); cmd.Parameters.Add("@Mobile", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.mobile); cmd.Parameters.Add("@Fax", SqlDbType.VarChar, 20).Value = ParseDataHelper.ConvertDBNull(model.fax); cmd.Parameters.Add("@Position", SqlDbType.VarChar, 2).Value = model.position; cmd.Parameters.Add("@Faculty", SqlDbType.VarChar, 2).Value = model.faculty; cmd.Parameters.Add("@Education", SqlDbType.VarChar, 2).Value = model.education; cmd.Parameters.Add("@Note1", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.note1); cmd.Parameters.Add("@Note2", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.note2); cmd.Parameters.Add("@Note3", SqlDbType.NVarChar).Value = ParseDataHelper.ConvertDBNull(model.note3); SqlParameter rStatus = cmd.Parameters.Add("@rStatus", SqlDbType.Int); rStatus.Direction = ParameterDirection.Output; SqlParameter rMessage = cmd.Parameters.Add("@rMessage", SqlDbType.NVarChar, 500); rMessage.Direction = ParameterDirection.Output; await cmd.ExecuteNonQueryAsync(); if ((int)cmd.Parameters["@rStatus"].Value > 0) { resp.Status = true; } else { resp.Message = (string)cmd.Parameters["@rMessage"].Value; } } conn.Close(); } return(resp); }
public async Task <ModelResponseMessageUpdateUserRegister> ResetPasswordAsync(ModelResetPassword model) { ModelResponseMessageUpdateUserRegister resp = new ModelResponseMessageUpdateUserRegister(); string userid = Encoding.UTF8.GetString(Convert.FromBase64String(model.registerid)); using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("sp_reset_password", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@RegisterId", SqlDbType.VarChar, 100).Value = userid; string encrypt_old_passw = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(model.oldpassw)); cmd.Parameters.Add("@OldPassword", SqlDbType.VarChar, 100).Value = encrypt_old_passw; string encrypt_passw = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(model.newpassw)); cmd.Parameters.Add("@Password", SqlDbType.VarChar, 100).Value = encrypt_passw; SqlParameter rStatus = cmd.Parameters.Add("@rStatus", SqlDbType.Int); rStatus.Direction = ParameterDirection.Output; SqlParameter rMessage = cmd.Parameters.Add("@rMessage", SqlDbType.NVarChar, 500); rMessage.Direction = ParameterDirection.Output; await cmd.ExecuteNonQueryAsync(); if ((int)cmd.Parameters["@rStatus"].Value > 0) { resp.Status = true; } else { resp.Message = (string)cmd.Parameters["@rMessage"].Value; } } conn.Close(); } return(resp); }
public async Task <ModelResponseMessageUpdateUserRegister> UpdatePermissionGroupAsync(ModelMenuF2Edit model) { ModelResponseMessageUpdateUserRegister resp = new ModelResponseMessageUpdateUserRegister(); using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("sp_permission_group", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserGroupCode", SqlDbType.VarChar, 100).Value = model.usergroup; cmd.Parameters.Add("@MenuPageCode", SqlDbType.VarChar, 100).Value = model.menupagecode; cmd.Parameters.Add("@PmView", SqlDbType.Bit).Value = Convert.ToBoolean(model.pmview); cmd.Parameters.Add("@PmInsert", SqlDbType.Bit).Value = Convert.ToBoolean(model.pminsert); cmd.Parameters.Add("@PmUpdate", SqlDbType.Bit).Value = Convert.ToBoolean(model.pmupdate); cmd.Parameters.Add("@PmPrint", SqlDbType.Bit).Value = Convert.ToBoolean(model.pmprint); cmd.Parameters.Add("@PmAllData", SqlDbType.Bit).Value = Convert.ToBoolean(model.pmalldata); SqlParameter rStatus = cmd.Parameters.Add("@rStatus", SqlDbType.Int); rStatus.Direction = ParameterDirection.Output; SqlParameter rMessage = cmd.Parameters.Add("@rMessage", SqlDbType.NVarChar, 500); rMessage.Direction = ParameterDirection.Output; await cmd.ExecuteNonQueryAsync(); if ((int)cmd.Parameters["@rStatus"].Value > 0) { resp.Status = true; } else { resp.Message = (string)cmd.Parameters["@rMessage"].Value; } } conn.Close(); } return(resp); }
public async Task <IActionResult> ResetPassword(ModelResetPassword model) { ModelResponseMessageUpdateUserRegister e = await _IRegisterUserService.ResetPasswordAsync(model); return(Ok(e)); }