I am having problems with errors in my connection class file while is breaking the rest of my website. the error message i get when i try to preview my tours.aspx page:
Compiler Error Message: CS1001: Identifier expected Line19
here is the code for my connection class file.
using System.Collections;
using System.Configuration;
using System.Data.SqlClient;
using Entities;
public static class ConnectionClass
{
private static SqlConnection conn;
private static SqlCommand command;
static ConnectionClass()
{
string connectionString = ConfigurationManager.ConnectionStrings["toursConnection"].ToString();
conn = new SqlConnection(connectionString);
command = new SqlCommand("", conn);
}
#region tours
public static tours GettoursByID(int)
{
string query = string.Format("SELECT * FROM tours WHERE id = '{0}'", id);
tours tours = null;
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string name = reader.GetString(1);
string date = reader.GetString(2);
double price = reader.GetDouble(3);
string venue = reader.GetString(4);
string country = reader.GetString(5);
string image = reader.GetString(6);
string description = reader.GetString(7);
tours = new tours(id, name, date, price, venue, country, image, description);
}
}
finally
{
conn.Close();
}
return tours;
}
public static ArrayList GettoursByType(string toursType)
{
ArrayList list = new ArrayList();
string query = string.Format("SELECT * FROM tours WHERE type LIKE '{0}'", toursType);
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
string type = reader.GetString(2);
double price = reader.GetDouble(3);
string roast = reader.GetString(4);
string country = reader.GetString(5);
string image = reader.GetString(6);
string review = reader.GetString(7);
tours tours = new tours(id, name, type, price, roast, country, image, review);
list.Add(tours);
}
}
finally
{
conn.Close();
}
return list;
}
public static void Addtours(tours tours)
{
string query = string.Format(
@"INSERT INTO tours VALUES ('{0}', '{1}', @prices, '{2}', '{3}','{4}', '{5}')",
tours.Name, tours.date, tours.venue, tours.Country, tours.Image, tours.description);
command.CommandText = query;
command.Parameters.Add(new SqlParameter("@prices", tours.Price));
try
{
conn.Open();
command.ExecuteNonQuery();
}
finally
{
conn.Close();
command.Parameters.Clear();
}
}
#endregion
#region Users
public static User LoginUser(string name, string password)
{
//Check if user exists
string query = string.Format("SELECT COUNT(*) FROM toursDB.dbo.users WHERE name = '{0}'", name);
command.CommandText = query;
try
{
conn.Open();
int amountOfUsers = (int)command.ExecuteScalar();
if (amountOfUsers == 1)
{
//User exists, check if the passwords match
query = string.Format("SELECT password FROM users WHERE name = '{0}'", name);
command.CommandText = query;
string dbPassword = command.ExecuteScalar().ToString();
if (dbPassword == password)
{
//Passwords match. Login and password data are known to us.
//Retrieve further user data from the database
query = string.Format("SELECT email, user_type FROM users WHERE name = '{0}'", name);
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
User user = null;
while (reader.Read())
{
string email = reader.GetString(0);
string type = reader.GetString(1);
user = new User(name, password, email, type);
}
return user;
}
else
{
//Passwords do not match
return null;
}
}
else
{
//User does not exist
return null;
}
}
finally
{
conn.Close();
}
}
public static string RegisterUser(User user)
{
//Check if user exists
string query = string.Format("SELECT COUNT(*) FROM users WHERE name = '{0}'", user.Name);
command.CommandText = query;
try
{
conn.Open();
int amountOfUsers = (int)command.ExecuteScalar();
if (amountOfUsers < 1)
{
//User does not exist, create a new user
query = string.Format("INSERT INTO users VALUES ('{0}', '{1}', '{2}', '{3}')", user.Name, user.Password,
user.Email, user.Type);
command.CommandText = query;
command.ExecuteNonQuery();
return "User registered!";
}
else
{
//User exists
return "A user with this name already exists";
}
}
finally
{
conn.Close();
}
}
#endregion
#region Orders
public static void AddOrder(ArrayList orders)
{
try
{
command.CommandText = @"INSERT INTO orders VALUES (@client, @productName, @amount, @price, @date, @orderSent)";
conn.Open();
foreach (Order order in orders)
{
command.Parameters.Add(new SqlParameter("@client", order.Client));
command.Parameters.Add(new SqlParameter("@productName", order.ProductName));
command.Parameters.Add(new SqlParameter("@amount", order.Amount));
command.Parameters.Add(new SqlParameter("@price", order.Price));
command.Parameters.Add(new SqlParameter("@date", order.Date));
command.Parameters.Add(new SqlParameter("@orderSent", order.OrderSent));
command.ExecuteNonQuery();
command.Parameters.Clear();
}
}
finally
{
conn.Close();
}
}
#endregion
}
<?xml version="1.0" encoding="utf-8"?>
<!--
-->
this is my web confif file <
?xml version="1.0" encoding="utf-8"?>
<!--
-->
<configuration>
<appSettings />
<connectionStrings>
<clear />
<add name="toursConnection" connectionString="Data Source=LOCALHOST\SQLEXPRESS;Initial Catalog=CoffeeDB;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="CoffeeDBConnectionString" connectionString="Data Source=LOCALHOST\SQLEXPRESS;Initial Catalog=CoffeeDB;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<!--
-->
<compilation debug="true" targetFramework="4.0">
<assemblies>
<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" />
</assemblies>
</compilation>
<!--
-->
<authentication mode="Windows" />
<!--
</customErrors>
-->
<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
<controls>
<add tagPrefix="ajaxToolkit" assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" />
</controls>
</pages>
</system.web>
<!--
-->
</configuration>
tours.aspx.cs code below
using System;
using System.Collections;
using System.Text;
using Entities;
namespace Pages
{
public partial class Pages_tours : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
FillPage();
}
private void FillPage()
{
ArrayList toursList = ConnectionClass.GettoursByType(!IsPostBack ? "%" : DropDownList1.SelectedValue);
StringBuilder sb = new StringBuilder();
foreach (tours tours in toursList)
{
sb.Append(
string.Format(
@"<table class='toursTable'>
<tr>
<th rowspan='6' width='150px'><img runat='server' src='{6}' /></th>
<th width='50px'>Name: </td>
<td>{0}</td>
</tr>
<tr>
<th>Type: </th>
<td>{1}</td>
</tr>
<tr>
<th>Price: </th>
<td>{2} $</td>
</tr>
<tr>
<th>Roast: </th>
<td>{3}</td>
</tr>
<tr>
<th>Origin: </th>
<td>{4}</td>
</tr>
<tr>
<td colspan='2'>{5}</td>
</tr>
</table>",
tours.Name, tours.Type, tours.Price, tours.Roast, tours.Country, tours.Review, tours.Image));
}
lblOuput.Text = sb.ToString();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
FillPage();
}
}
}
