public List <Specialist> Obtener() { SqlConnection con = new SqlConnection(Resource.CadenaConexion); con.Open(); List <Specialist> lista = new List <Specialist>(); try { DocumentTypeManager documentTypeManager = new DocumentTypeManager(); string sql = "select Id,Login,Names,LastNames," + "Email,CompanyName,ServiceDescription," + "DocumentTypeId,PhoneNumber," + "Facebook,Website,Address,Reference,Latitude," + "Longitude,Accredited,Membership,Rate," + "Online,State from Specialists"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { Specialist spe = new Specialist(); spe.id = reader.GetInt32(0); spe.login = reader.GetString(1); spe.name = reader.GetString(2); spe.lastName = reader.GetString(3); spe.email = reader.GetString(4); spe.companyName = reader.GetString(5); spe.serviceDescription = reader.GetString(6); spe.document = documentTypeManager.Obtener(reader.GetInt32(7)); spe.phoneNumber = reader.GetString(8); spe.facebook = reader.GetString(9); spe.webSite = reader.GetString(10); spe.address = reader.GetString(11); spe.reference = reader.GetString(12); spe.latitude = reader.GetDecimal(13); spe.longitude = reader.GetDecimal(14); spe.acredited = reader.GetBoolean(15); spe.memberShip = reader.GetBoolean(16); spe.rate = reader.GetDecimal(17); spe.online = reader.GetBoolean(18); spe.state = reader.GetBoolean(19); lista.Add(spe); } reader.Close(); } catch (Exception e) { System.Console.WriteLine(e); } if (con.State == System.Data.ConnectionState.Open) { con.Close(); } return(lista); }
public Specialist Obtener(int id) { DocumentTypeManager documentTypeManager = new DocumentTypeManager(); Specialist spe = null; SqlConnection con = new SqlConnection(Resource.CadenaConexion); con.Open(); string sql = "select Id,Login,Password,Names,LastNames," + "Email,CompanyName,ServiceDescription," + "DocumentTypeId,PhoneNumber," + "Facebook,Website,Address,Reference,Latitude," + "Longitude,Accredited,Membership,Rate," + "Online,State from Specialists where Id = @idSpecialist"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@idSpecialist", System.Data.SqlDbType.NVarChar).Value = id; SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (reader.Read()) { spe = new Specialist(); spe.id = reader.GetInt32(0); spe.login = reader.GetString(1); spe.password = reader.GetString(2); spe.name = reader.GetString(3); spe.lastName = reader.GetString(4); spe.email = reader.GetString(5); spe.companyName = reader.GetString(6); spe.serviceDescription = reader.GetString(7); spe.document = documentTypeManager.Obtener(reader.GetInt32(8)); spe.phoneNumber = reader.GetString(9); spe.facebook = reader.GetString(10); spe.webSite = reader.GetString(11); spe.address = reader.GetString(12); spe.reference = reader.GetString(13); spe.latitude = reader.GetDecimal(14); spe.longitude = reader.GetDecimal(15); spe.acredited = reader.GetBoolean(16); spe.memberShip = reader.GetBoolean(17); spe.rate = reader.GetDecimal(18); spe.online = reader.GetBoolean(19); spe.state = reader.GetBoolean(20); } reader.Close(); if (con.State == System.Data.ConnectionState.Open) { con.Close(); } return(spe); }
public List <Customer> Obtener() { SqlConnection con = new SqlConnection(Resource.CadenaConexion); con.Open(); List <Customer> lista = new List <Customer>(); try { DocumentTypeManager documentTypeManager = new DocumentTypeManager(); string sql = "Select Id,Login,Names,LastNames,Email," + "DocumentTypeId,PhoneNumber,Address," + "Reference,Latitude,Longitude,Rate," + "Online,State from Customers"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (reader.Read()) { Customer spe = new Customer(); spe.id = reader.GetInt32(0); spe.login = reader.GetString(1); spe.name = reader.GetString(2); spe.lastName = reader.GetString(3); spe.email = reader.GetString(4); spe.document = documentTypeManager.Obtener(reader.GetInt32(5)); spe.phoneNumber = reader.GetString(6); spe.address = reader.GetString(7); spe.reference = reader.GetString(8); spe.latitude = reader.GetDecimal(9); spe.longitude = reader.GetDecimal(10); spe.rate = reader.GetDecimal(11); spe.online = reader.GetBoolean(12); spe.state = reader.GetBoolean(13); lista.Add(spe); } reader.Close(); } catch (Exception e) { System.Console.WriteLine(e); } if (con.State == System.Data.ConnectionState.Open) { con.Close(); } return(lista); }
public Customer Obtener(int id) { DocumentTypeManager documentTypeManager = new DocumentTypeManager(); Customer spe = null; SqlConnection con = new SqlConnection(Resource.CadenaConexion); con.Open(); string sql = "Select Id,Login,Password,Names,LastNames,Email," + "DocumentTypeId,PhoneNumber,Address," + "Reference,Latitude,Longitude,Rate," + "Online,State from Customers where Id = @idClient"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.Add("@idClient", System.Data.SqlDbType.NVarChar).Value = id; SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (reader.Read()) { spe = new Customer(); spe.id = reader.GetInt32(0); spe.login = reader.GetString(1); spe.password = reader.GetString(2); spe.name = reader.GetString(3); spe.lastName = reader.GetString(4); spe.email = reader.GetString(5); spe.document = documentTypeManager.Obtener(reader.GetInt32(6)); spe.phoneNumber = reader.GetString(7); spe.address = reader.GetString(8); spe.reference = reader.GetString(9); spe.latitude = reader.GetDecimal(10); spe.longitude = reader.GetDecimal(11); spe.rate = reader.GetDecimal(12); spe.online = reader.GetBoolean(13); spe.state = reader.GetBoolean(14); } reader.Close(); if (con.State == System.Data.ConnectionState.Open) { con.Close(); } return(spe); }