public Anunciante getAnunciante(String Email) { string connectionString = "Server=DESKTOP-IO4T1DR\\SQLExpress; AttachDbFilename=C:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQLEXPRESS\\MSSQL\\DATA\\DivulgueAquiDB.mdf; Database=DivulgueAquiDB; Trusted_Connection = Yes;"; using (SqlConnection connection = new SqlConnection(connectionString)) { try { string cmd = "SELECT * FROM Anunciante WHERE email=@Email"; SqlCommand command = new SqlCommand(cmd, connection); command.Parameters.AddWithValue("@Email", Email); command.Connection.Open(); var reader = command.ExecuteReader(); Models.Anunciante anun = new Models.Anunciante(); if (reader.HasRows) { while (reader.Read()) { anun.NomeAnunciante = (string)reader["nomeAnunciante"]; anun.NomeComercio = (string)reader["nomeComercio"]; anun.ValorPacote = (float)reader["valorPacote"]; anun.Email = (string)reader["email"]; anun.LatLong = (string)reader["latLong "]; } } return(anun); } catch (Exception ex) { throw new Exception("Erro: " + ex.Message); } } }
public List <Models.Anunciante> teste1() { List <Models.Anunciante> lista = new List <Models.Anunciante>(); Models.Anunciante fiel = new Models.Anunciante(); fiel.LatLong = "(-12.96265216518016, -38.50096648473988)"; fiel.Email = "*****@*****.**"; fiel.NomeAnunciante = "Adenilson"; fiel.NomeComercio = "mercadinho"; lista.Add(fiel); Models.Anunciante fiel1 = new Models.Anunciante(); fiel1.Email = "*****@*****.**"; fiel1.NomeAnunciante = "Abesvaldo"; fiel1.NomeComercio = "Churros"; fiel.LatLong = "(-13.0010719, -38.530658)"; lista.Add(fiel1); Models.Anunciante fiel2 = new Models.Anunciante(); fiel2.Email = "*****@*****.**"; fiel2.NomeAnunciante = "fulano"; fiel2.NomeComercio = "1,99"; fiel.LatLong = "(-12.986687, -38.4958537)"; lista.Add(fiel2); return(lista); }
public List <Models.Anunciante> GetAnunciantes() { string connectionString = "Server=DESKTOP-IO4T1DR\\SQLExpress; AttachDbFilename=C:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQLEXPRESS\\MSSQL\\DATA\\DivulgueAquiDB.mdf; Database=DivulgueAquiDB; Trusted_Connection = Yes;"; using (SqlConnection connection = new SqlConnection(connectionString)) { try { string cmd = "SELECT nomeAnunciante, nomeComercio, email, valorPacote FROM Anunciante"; SqlCommand command = new SqlCommand(cmd, connection); command.Connection.Open(); var reader = command.ExecuteReader(); List <Models.Anunciante> lista = new List <Models.Anunciante>(); if (reader.HasRows) { while (reader.Read()) { Models.Anunciante anun = new Models.Anunciante(); anun.NomeAnunciante = (string)reader["nomeAnunciante"]; anun.NomeComercio = (string)reader["nomeComercio"]; anun.Email = (string)reader["email"]; anun.ValorPacote = (double)reader["valorPacote"]; lista.Add(anun); } return(lista); } } catch (Exception ex) { throw new Exception("Erro: " + ex.Message); } return(null); } }
public ActionResult Detalhes(Anunciante a) { string connectionString = "Server=DESKTOP-IO4T1DR\\SQLExpress; AttachDbFilename=C:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQLEXPRESS\\MSSQL\\DATA\\DivulgueAquiDB.mdf; Database=DivulgueAquiDB; Trusted_Connection = Yes;"; using (SqlConnection connection = new SqlConnection(connectionString)) { try { string cmd = "SELECT * FROM Anunciante WHERE Email=@Email"; SqlCommand command = new SqlCommand(cmd, connection); command.Connection.Open(); var reader = command.ExecuteReader(); Models.Anunciante anun = new Models.Anunciante(); if (reader.HasRows) { while (reader.Read()) { anun.NomeAnunciante = (string)reader["NomeAnunciante"]; anun.NomeComercio = (string)reader["NomeComercio"]; anun.TipoComercio = (string)reader["TipoComercio"]; anun.TipoPacote = (string)reader["TipoPacote"]; anun.IdAnunciante = (int)reader["IdAnunciante"]; anun.Email = (string)reader["Email"]; anun.Location = (string)reader["Location"]; } } return(View(anun)); } catch (Exception ex) { throw new Exception("Erro: " + ex.Message); } } }
public Anunciante teste() { List <Models.Anunciante> lista = new List <Models.Anunciante>(); Models.Anunciante fiel = new Models.Anunciante(); fiel.LatLong = "(-13.0010719, -38.530658)"; fiel.Email = "*****@*****.**"; fiel.NomeAnunciante = "Adenilson"; fiel.NomeComercio = "mercadinho"; return(fiel); }
public List <Models.Anunciante> teste() { List <Models.Anunciante> lista = new List <Models.Anunciante>(); Models.Anunciante fiel = new Models.Anunciante(); fiel.Email = "*****@*****.**"; fiel.NomeAnunciante = "Adenilson"; fiel.NomeComercio = "mercadinho"; fiel.TipoPacote = "4 ANUNCIOS"; Models.Anunciante fiel1 = new Models.Anunciante(); fiel1.Email = "*****@*****.**"; fiel1.NomeAnunciante = "Abesvaldo"; fiel1.NomeComercio = "Churros"; fiel1.TipoPacote = "9 ANUNCIOS"; lista.Add(fiel1); return(lista); }