public async Task <IActionResult> changePFromDefault(DefaultPass data) { int result = await userData.ChangePassword(data); if (result > 0) { return(Ok(result)); } return(BadRequest()); }
public async Task <int> ChangePassword(DefaultPass data) { string sql = @"UPDATE UserAccount SET Password = @Pass,IsPasswordDefault = @Default WHERE Username = @Uname"; var p = new DynamicParameters(); p.Add("@Pass", data.RepeatPassword); p.Add("@Default", "False"); p.Add("@Uname", data.Username); int affectedRows = await db.SaveData(sql, p); return(affectedRows); }