public static void SaveListOrder(string[] ids)
{
UK_Film_Location_Class.UKFilmLocation objUKFilmLocation = new UK_Film_Location_Class.UKFilmLocation();
MySqlConnection DBConnection;
MySqlCommand DBCommand;
DBConnection = new MySqlConnection(objUKFilmLocation.DBConnect);
DBCommand = DBConnection.CreateCommand();
for (int i = 0; i < ids.Length; i++)
{
DBConnection.Open();
// Update Record
DBCommand.CommandText = "update LocationImages set ImageOrder = " + i + " where Image = '" + ids[i] + "';";
DBCommand.ExecuteNonQuery();
DBConnection.Close();
}
DBConnection.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
UK_Film_Location_Class.UKFilmLocation objUKFilmLocation = new UK_Film_Location_Class.UKFilmLocation();
// Check if user logged in?
HttpCookie myTestCookie = new HttpCookie("UKFilmLocation");
myTestCookie = Request.Cookies["UKFilmLocation"];
MySqlConnection DBConnection;
MySqlCommand DBCommand;
MySqlDataReader DBResult;
// Read the cookie information and display it.
if (myTestCookie != null)
{
// Check details against DB
DBConnection = new MySqlConnection(objUKFilmLocation.DBConnect);
DBCommand = DBConnection.CreateCommand();
DBConnection.Open();
DBCommand.CommandText = "select count(*) as numrecs from Contacts where ContactID = '" + myTestCookie.Value + "';";
DBResult = DBCommand.ExecuteReader();
int NoRecs = 0;
if (DBResult.Read())
{
NoRecs = Convert.ToInt32(DBResult["numrecs"].ToString());
}
DBResult.Close();
DBConnection.Close();
DBConnection.Open();
DBCommand.CommandText = "select * from UserDetails where Email = '" + myTestCookie.Value + "';";
DBResult = DBCommand.ExecuteReader();
if (DBResult.Read())
{
// UserLabel.Text = DBResult["FirstName"].ToString() + " " + DBResult["LastName"].ToString();
}
DBResult.Close();
DBConnection.Close();
DBConnection.Dispose();
if (NoRecs == 0)
{
// Create cookie and proceed
DateTime now = DateTime.Now;
// Set the cookie value.
myTestCookie.Value = "";
// Set the cookie expiration date.
myTestCookie.Expires = now.AddDays(-1);
// Add the cookie.
Response.Cookies.Add(myTestCookie);
}
}
}