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