codice:
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace MyProject.UserHub
{
public partial class EditActivityAccount : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ActiveUserId"] == null)
{
Response.Redirect("../Login.aspx");
}
else
{
string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
string ActiveUserId = Session["ActiveUserId"].ToString();
using (SqlConnection conn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Locale WHERE UserId= @ActiveUserId", conn))
{
cmd.Parameters.AddWithValue("@ActiveUserId", ActiveUserId);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
r_Name.Text = reader["RefererName"].ToString();
r_Surname.Text = reader["RefererSurname"].ToString();
r_Mail.Text = reader["RefererMail"].ToString();
r_Phone.Text = reader["RefererPhone"].ToString();
r_Mobile.Text = reader["RefererMobilePhone"].ToString();
a_ActivityName.Text = reader["ActivityName"].ToString();
a_Website.Text = reader["Website"].ToString();
a_Paese.Text = reader["Paese"].ToString();
a_Cap.Text = reader["Cap"].ToString();
a_Description.Text = reader["Description"].ToString();
a_SmallDescription.Text = reader["SmallDescription"].ToString();
a_Phone.Text = reader["Phone"].ToString();
lblChiusura.Text = reader["Chiusura"].ToString();
Session["GiornoChiusura"] = reader["Chiusura"].ToString();
}
}
}
string ConnString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
using (SqlConnection chiusura = new SqlConnection(ConnString))
{
using (SqlCommand cmdChiusura = new SqlCommand("SELECT * FROM Locale WHERE UserId=@ActiveUserId", chiusura))
{
string giornoChiusura ="-->" + Session["GiornoChiusura"].ToString();
string ReplaceGiornoChiusura = giornoChiusura.Replace("-->", "");
lstChiusura.DataBind();
cmdChiusura.Parameters.AddWithValue("@ActiveUserId", ActiveUserId);
chiusura.Open();
// lstChiusura.DataSource = cmdChiusura.ExecuteReader();
// lstChiusura.DataTextField = "Chiusura";
// lstChiusura.DataValueField = "Chiusura";
// lstChiusura.DataBind();
lstChiusura.Items.Insert(0,new ListItem(giornoChiusura, ReplaceGiornoChiusura,true));
if (giornoChiusura != "-->Lunedì")
{
lstChiusura.Items.Add(new ListItem("Lunedì", "Lunedì"));
}
if (giornoChiusura != "-->Martedì")
{
lstChiusura.Items.Add(new ListItem("Martedì", "Martedì"));
}
if (giornoChiusura != "-->Mercoledì")
{
lstChiusura.Items.Add(new ListItem("Mercoledì", "Mercoledì"));
}
if (giornoChiusura != "-->Giovedì")
{
lstChiusura.Items.Add(new ListItem("Giovedì", "Giovedì"));
}
if (giornoChiusura != "-->Venerdì")
{
lstChiusura.Items.Add(new ListItem("Venerdì", "Venerdì"));
}
if (giornoChiusura != "-->Sabato")
{
lstChiusura.Items.Add(new ListItem("Sabato", "Sabato"));
}
if (giornoChiusura != "-->Domenica")
{
lstChiusura.Items.Add(new ListItem("Domenica", "Domenica"));
}
if (giornoChiusura != "-->Sempre aperto")
{
lstChiusura.Items.Add(new ListItem("Sempre aperto", "Sempre aperto"));
}
//lstChiusura.Items.Insert(1, new ListItem("Lunedì", "Lunedì"));
//lstChiusura.Items.Insert(2, new ListItem("Martedì", "Martedì"));
//lstChiusura.Items.Insert(3, new ListItem("Mercoledì", "Mercoledì"));
//lstChiusura.Items.Insert(4, new ListItem("Giovedì", "Giovedì"));
//lstChiusura.Items.Insert(5, new ListItem("Venerdì", "Venerdì"));
//lstChiusura.Items.Insert(6, new ListItem("Sabato", "Sabato"));
//lstChiusura.Items.Insert(7, new ListItem("Domenica", "Domenica"));
//lstChiusura.Items.Insert(8, new ListItem("Sempre aperto", "Sempre aperto"));
}
}
}
}
protected void btn_Update_Click(object sender, EventArgs e)
{
string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
string ActiveUserId = Session["ActiveUserId"].ToString();
string LastUpdate = DateTime.Now.ToShortTimeString();
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("UPDATE Locale SET RefererName=@RefererName, RefererSurname=@RefererSurname, RefererMail=@RefererMail, LastUpdate=@LastUpdate WHERE UserId=@ActiveUser", conn))
{
cmd.Parameters.AddWithValue("@ActiveUser", ActiveUserId);
cmd.Parameters.AddWithValue("@LastUpdate", LastUpdate);
cmd.Parameters.AddWithValue("@RefererName", r_Name.Text.ToString());
cmd.Parameters.AddWithValue("@RefererSurname", r_Surname.Text.ToString());
cmd.Parameters.AddWithValue("@RefererMail", r_Mail.Text.ToString());
conn.Open();
int updateStatus = cmd.ExecuteNonQuery();
if (updateStatus != 0)
{
Response.Write("Dati correttamente aggiornati!");
}
}
}
}
catch(Exception errCode)
{
Response.Write("Qualcosa è andato storto: " + errCode.ToString());
}
}
}
}