public bool GetUserById(string requestUserId)
{
var dataSet = InfraDal.ExecuteQuery(Connection,
"SELECT ACTIVE FROM USERS WHERE USER_ID ='" + requestUserId + "'");
var data = dataSet.Tables[0].Rows[0][0];
return(Convert.ToBoolean(data));
}
public void DestroyUserDummyData(params string[] ids)
{
var query = new StringBuilder();
query.Append("DELETE FROM ").Append("USERS ").Append("WHERE USERS.USER_ID IN (");
foreach (var id in ids)
{
query.Append("'").Append(id).Append("'").Append(",");
}
query.Length--;
query.Append(")");
var queryStr = query.ToString();
InfraDal.ExecuteQuery(Connection, query.ToString());
}