public void nombreDominio(Models.LandingPage formData)
{
try
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkuviConnect"].ConnectionString;
SqlConnection cnn = new SqlConnection(connectionString);
SqlCommand com = new SqlCommand("addName2", cnn);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@udominiopage", formData.Dominio_Page);
com.Parameters.AddWithValue("@uramo", formData.Ramo);
com.Parameters.AddWithValue("@uplantilla", formData.Plantilla);
com.Parameters.AddWithValue("@ucolor", formData.Color);
com.Parameters.AddWithValue("@uimagen", formData.Imagen);
com.Parameters.AddWithValue("@utituloprofesional", formData.Titulo_Profesional);
cnn.Open();
com.ExecuteNonQuery();
cnn.Close();
}
catch (Exception e)
{
System.Console.WriteLine(e.Message);
}
}
public void clearAseguradoras(Models.LandingPage formData)
{
try
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkuviConnect"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
string commandText = "DECLARE @id INT Select @id = A.ID_Page from AgenteSLandingP A WHERE SubDominio_Page LIKE '%" + formData.Dominio_Page + "%' UPDATE LandingPage2 SET Aseguradora_1 = NULL, Aseguradora_2 = NULL, Aseguradora_3 = NULL, Aseguradora_4 = NULL, Aseguradora_5 = NULL, Aseguradora_6 = NULL, Aseguradora_7 = NULL WHERE ID_Page = @id AND Ramo LIKE '%" + formData.Ramo + "%'";
SqlCommand cmd = new SqlCommand(commandText, conn);
System.Diagnostics.Debug.WriteLine(commandText);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
System.Console.WriteLine(e.Message);
}
}
public void addMSec(Models.LandingPage formData)
{
try
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkuviConnect"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
string commandText = " DECLARE @id INT Select @id = A.ID_Page from AgenteSLandingP A WHERE SubDominio_Page LIKE '%" + formData.Dominio_Page + "%' UPDATE LandingPage2 SET Mensaje_2 ='" + formData.Mensaje_2 + "' WHERE Ramo LIKE '%" + formData.Ramo + "%' and ID_Page = @id";
SqlCommand cmd = new SqlCommand(commandText, conn);
System.Diagnostics.Debug.WriteLine(commandText);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
System.Console.WriteLine(e.Message);
}
}
public void addAgente(Models.LandingPage formData)
{
try
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UkuviConnect"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand com = new SqlCommand("crearAgente", conn);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@udominio", formData.Dominio_Page);
conn.Open();
com.ExecuteNonQuery();
conn.Close();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message + " This is the error");
}
}
