codice:
{
string connString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
string a_UserIP = Request.ServerVariables["REMOTE_ADDR"];
string userLoggedID = Session["ActiveUserID"].ToString();
string a_InsertDate = DateTime.Now.ToShortDateString();
string ClosingTime = a_Orario_Apertura.Text.ToString() + "-" + a_Orario_Chiusura.Text.ToString();
string a_ProfileComplete = "1";
{
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO Locale (UserId, RefererName, RefererSurname, RefererMail, RefererPhone, RefererMobilePhone, ActivityName, ActivityType, Regione, Provincia, Paese, Cap, Orario, Chiusura, Website, Phone, SmallDescription, Description, UserIP, InsertDate, FacebookPage, ActivityProfileComplete) VALUES(@UserID, @RefererName, @RefererSurname, @RefererMail, @RefererPhone, @RefererMobilePhone, @ActivityName, @ActivityType, @Regione, @Provincia, @Paese, @Cap, @Orario, @Chiusura, @Website, @Phone, @SmallDescription, @Description, @UserIP, @InsertDate, @FacebookPage, @ActivityProfileComplete)", conn))
{
foreach (ListItem item in a_ActivityType.Items)
{
if(item.Selected)
{
Session["TipoLocale"] = item.Text;
ListItem tipolocale = item;
}
}
cmd.Parameters.AddWithValue("@UserID", userLoggedID.ToString());
cmd.Parameters.AddWithValue("@RefererName", r_Name.Text.ToString());
cmd.Parameters.AddWithValue("@RefererSurname", r_Surname.Text.ToString());
cmd.Parameters.AddWithValue("@RefererMail", r_Mail.Text.ToString());
cmd.Parameters.AddWithValue("@RefererPhone", r_Phone.Text.ToString());
cmd.Parameters.AddWithValue("@RefererMobilePhone", r_MobilePhone.Text.ToString());
cmd.Parameters.AddWithValue("@ActivityName", a_ActivityName.Text.ToString());
cmd.Parameters.AddWithValue("@ActivityType", Session["TipoLocale"]);
cmd.Parameters.AddWithValue("@Regione", a_Regione.SelectedItem.Text.ToString());
cmd.Parameters.AddWithValue("@Provincia", a_Provincia.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@Paese", a_Paese.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@Cap", a_Cap.Text.ToString());
cmd.Parameters.AddWithValue("@Orario", ClosingTime.ToString());
cmd.Parameters.AddWithValue("@Chiusura", a_Chiusura.Text.ToString());
cmd.Parameters.AddWithValue("@Website", a_Website.Text.ToString());
cmd.Parameters.AddWithValue("@Phone", a_Telefono.Text.ToString());
cmd.Parameters.AddWithValue("@SmallDescription", a_SmallDescription.Text.ToString());
cmd.Parameters.AddWithValue("@Description", a_Description.Text.ToString());
cmd.Parameters.AddWithValue("@UserIP", a_UserIP.ToString());
cmd.Parameters.AddWithValue("@InsertDate", a_InsertDate);
cmd.Parameters.AddWithValue("@FacebookPage", a_FbPage.Text.ToString());
cmd.Parameters.AddWithValue("@ActivityProfileComplete", a_ProfileComplete);
conn.Open();
int queryStatus = cmd.ExecuteNonQuery();
if (queryStatus != 0)
{
Response.Write("Registrazione correttamente effettuata!");
}
else
Response.Write("Problemi nella fase di registrazione.");
}
}
}
catch (SqlException KeyAlreadyExist)
{
Response.Write("Chiave duplicata!");
}
}
}