public GeoInfoPdv GetInfoPDV(int idPuntoDeVenta)
{
GeoInfoPdv infoPDV = null;
using (SqlConnection cn = new SqlConnection((new RepContext()).Database.Connection.ConnectionString.ToString()))
{
SqlCommand cmd = new SqlCommand("GetInfoPDV", cn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@IdPuntoDeVenta", SqlDbType.Int).Value = idPuntoDeVenta;
cn.Open();
SqlDataReader r = cmd.ExecuteReader();
if (r.HasRows && r.Read())
{
infoPDV = new GeoInfoPdv
{
BusinessName = r["RazonSocial"].ToString(),
Categorie = r["Categoria"].ToString(),
Chain = r["Cadena"].ToString(),
Direction = r["Direccion"].ToString(),
Name = r["Nombre"].ToString(),
Phone = r["Telefono"].ToString(),
PlaceID = r["PlaceID"].ToString(),
PostalCode = r["CodigoPostal"].ToString(),
Contact = r["Contacto"].ToString(),
Email = r["Email"].ToString(),
};
}
}
return(infoPDV);
}
public GeoInfoPdvVM(GeoInfoPdv m)
{
BusinessName = m.BusinessName;
Categorie = m.Categorie;
Chain = m.Chain;
Direction = m.Direction;
Name = m.Name;
Phone = m.Phone;
PostalCode = m.PostalCode;
Contact = m.Contact;
Email = m.Email;
}
