מתכונת 4 במדעי המחשב - תכנות באינטרנט 899372

msg.InnerHtml = "Hello " + userName;

SELECT title, releaseYear
FROM Movies
WHERE (genre = 'קומדיה' OR genre = 'אנימציה') AND minutes < 100;

<table border = '1'><tr><th>%</th><th>2</th><th>3</th><th>4</th><th>5</th></tr><tr><th>6</th><td>V</td><td>V</td><td>2</td><td>1</td></tr><tr><th>7</th><td>1</td><td>1</td><td>3</td><td>2</td></tr><tr><th>8</th><td>V</td><td>2</td><td>V</td><td>3</td></tr><tr><th>9</th><td>1</td><td>V</td><td>1</td><td>4</td></tr><tr><th>10</th><td>V</td><td>1</td><td>2</td><td>V</td></tr></table>

function isStrongPassword()
{
  var x = document.getElementById("pass").value;
  var digits = 0;
  var upper = 0;
  if (x.length < 8)
     return false;
  for (var i=0; i<x.length; i++)
  {
     var c = x.charAt(i);
     if (c >= '0' && c <= '9')
        digits++;
     if (c >= 'A' && c <= 'Z')
        upper++;
  }
  return digits >= 2 && upper >= 1;
}

protected void Page_Load(object sender, EventArgs e)
{
    int visits = (int)Session["visits"];
    int months = (int)Session["months"];

    if (visits >= 20)
    {
        Session["track"] = "gold";
        Response.Redirect("vip.aspx");
    }
    else if (visits >= 8 || months > 12)
    {
        Session["track"] = "silver";
        Response.Redirect("bonus.aspx");
    }
    else
    {
        Session["track"] = "regular";
        Response.Redirect("plans.aspx");
    }
}

protected void Page_Load(object sender, EventArgs e)
{
    int visits = (int)Session["visits"];
    int months = (int)Session["months"];

    if (visits >= 20)
    {
        Session["track"] = "gold";
        Response.Redirect("vip.aspx");
    }
    else if (visits >= 8 || months > 12)
    {
        Session["track"] = "silver";
        Response.Redirect("bonus.aspx");
    }
    else
    {
        Session["track"] = "regular";
        Response.Redirect("plans.aspx");
    }
}

// פעולת עזר: מחזירה את הספרה הגדולה ביותר במספר חיובי
public int MaxDigit(int num)
{
    int max = num % 10;
    while (num > 0)
    {
        if (num % 10 > max)
            max = num % 10;
        num = num / 10;
    }
    return max;
}

// פעולת עזר: מחזירה את הספרה הקטנה ביותר במספר חיובי
public int MinDigit(int num)
{
    int min = num % 10;
    while (num > 0)
    {
        if (num % 10 < min)
            min = num % 10;
        num = num / 10;
    }
    return min;
}

public bool IsBridge(int num1, int num2)
{
    return MaxDigit(num1) == MinDigit(num2) || MaxDigit(num2) == MinDigit(num1);
}

// פעולת עזר: מחזירה את הספרה הגדולה ביותר במספר חיובי
public int MaxDigit(int num)
{
    int max = num % 10;
    while (num > 0)
    {
        if (num % 10 > max)
            max = num % 10;
        num = num / 10;
    }
    return max;
}

// פעולת עזר: מחזירה את הספרה הקטנה ביותר במספר חיובי
public int MinDigit(int num)
{
    int min = num % 10;
    while (num > 0)
    {
        if (num % 10 < min)
            min = num % 10;
        num = num / 10;
    }
    return min;
}

public bool IsBridge(int num1, int num2)
{
    return MaxDigit(num1) == MinDigit(num2) || MaxDigit(num2) == MinDigit(num1);
}

SELECT title
FROM BooksTable
WHERE copies - borrowed < 2
   OR year < 1950 OR year > 2000
   OR author = 'נועה שחר';

bool exists = false;
foreach (DataRow r in ds.Tables[0].Rows)
{
    if (r["email"].ToString() == email)
        exists = true;
}
if (exists)
{
    Response.Write("כתובת זו כבר רשומה");
}
else
{
    DataRow row = ds.Tables[0].NewRow();
    row["email"] = email;
    row["fullName"] = fullName;
    ds.Tables[0].Rows.Add(row);
    Response.Write("נרשמת בהצלחה");
}

protected void Subscribe(string connectionString)
{
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand command = new SqlCommand();
    command.CommandText = "Select * From subscribers";
    command.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(command);
    SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
    DataSet ds = new DataSet();
    adapter.Fill(ds);
    string email = Request.Form["email"];
    string fullName = Request.Form["fullName"];

    // ---- הקוד החסר ----
    bool exists = false;
    foreach (DataRow r in ds.Tables[0].Rows)
    {
        if (r["email"].ToString() == email)
            exists = true;
    }
    if (exists)
    {
        Response.Write("כתובת זו כבר רשומה");
    }
    else
    {
        DataRow row = ds.Tables[0].NewRow();
        row["email"] = email;
        row["fullName"] = fullName;
        ds.Tables[0].Rows.Add(row);
        Response.Write("נרשמת בהצלחה");
    }
    // --------------------

    adapter.Update(ds);
    connection.Close();
}

protected void showEmployees(string connectionString)
{
    string resultStr = "";
    DataSet ds = new DataSet();
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "SELECT * FROM EmployeesTable WHERE department = 'מכירות' OR years >= 10";
    cmd.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    adapter.Fill(ds);
    connection.Close();
    resultStr += "<table dir=rtl><tr><th>שם</th><th>מחלקה</th><th>ותק</th></tr>";

    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        resultStr += "<tr>";
        resultStr += "<td>" + dr["name"] + "</td>";
        resultStr += "<td>" + dr["department"] + "</td>";
        resultStr += "<td>" + dr["years"] + "</td>";
        resultStr += "</tr>";
    }
    resultStr += "</table>";
    Response.Write(resultStr);
}

protected void showEmployees(string connectionString)
{
    string resultStr = "";
    DataSet ds = new DataSet();
    SqlConnection connection = new SqlConnection(connectionString);
    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "SELECT * FROM EmployeesTable WHERE department = 'מכירות' OR years >= 10";
    cmd.Connection = connection;
    connection.Open();
    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
    adapter.Fill(ds);
    connection.Close();
    resultStr += "<table dir=rtl><tr><th>שם</th><th>מחלקה</th><th>ותק</th></tr>";

    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        resultStr += "<tr>";
        resultStr += "<td>" + dr["name"] + "</td>";
        resultStr += "<td>" + dr["department"] + "</td>";
        resultStr += "<td>" + dr["years"] + "</td>";
        resultStr += "</tr>";
    }
    resultStr += "</table>";
    Response.Write(resultStr);
}