public static int UpdateTwoFactor(int id, bool enableTwoFactor)
{
string sql = @"UPDATE dbo.Account
SET TwoFactor = " + Convert.ToInt32(enableTwoFactor) + " WHERE Id = " + id + " ;";
return(SqlDataAccess.UpdateData(sql));
}
public static int UpdatePassword(int id, string newPassword)
{
string sql = @"UPDATE dbo.Account
SET Password = '******' WHERE Id = " + id + " ;";
return(SqlDataAccess.UpdateData(sql));
}
public static int DeletePhoneNumber(int id)
{
string sql = @"UPDATE dbo.Account
SET PhoneNumber = NULL, TwoFactor = 0 " +
"WHERE Id = " + id + " ;";
return(SqlDataAccess.UpdateData(sql));
}
public static int UpdatePhoneNumber(int id, string phoneNumber)
{
string sql = @"UPDATE dbo.Account
SET PhoneNumber = '" + phoneNumber + "', TwoFactor = 1 " +
"WHERE Id = " + id + " ;";
return(SqlDataAccess.UpdateData(sql));
}
public static int UpdateLimit(int service_id, decimal limit)
{
ServicesModel data = new ServicesModel
{
Service_id = service_id,
Limit = limit,
};
string sql = @"UPDATE dbo.tb_services_balances_sums SET Limit=@Limit
WHERE Service_id=@Service_id ";
return(SqlDataAccess.UpdateData(sql, data));
}