public static string BuildDealerUrl(Dealer dealer, Catalog catalog)
{
var url = string.Empty;
if (Convert.ToInt32(catalog.CatalogYear) < 2015 || catalog.Brand == "Lincoln")
{
url = string.Format(@"http://www.mybrochureorder.com/qr/?model={0}&year={1}&brand={2}&dealerid={3}&zip={4}",
catalog.ShortName, catalog.CatalogYear, catalog.Brand, dealer.DealerPa, dealer.DealerZip);
}
else if (Convert.ToInt32(catalog.CatalogYear) >= 2015 && catalog.Brand == "Ford")
{
url = string.Format(@"http://fbqr.co/{0}{1}", catalog.QRCodeName, dealer.DealerPa);
}
return url;
}
public bool SearchDealer(string id)
{
con = new SqlConnection(Connection);
cmd = new SqlCommand();
cmd.CommandText = string.Format("Select * from profile where Userid='{0}'", id);
cmd.Connection = con;
con.Open();
cmd.Connection = con;
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
if (reader.Read())
{
if (string.IsNullOrWhiteSpace(reader[6].ToString()) && string.IsNullOrWhiteSpace(reader[5].ToString()))
{
if (reader[7].ToString() == "Customer")
{
return(false);
}
dealer = new Dealer(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), 0, 0, reader[7].ToString(), reader[8].ToString(), reader[9].ToString());
//start from here...
//start from here.
}
else if (string.IsNullOrWhiteSpace(reader[6].ToString()))
{
if (reader[7].ToString() == "Customer")
{
return(false);
}
dealer = new Dealer(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), Double.Parse(reader[5].ToString()), 0, reader[7].ToString(), reader[8].ToString(), reader[9].ToString());
//start from here...
//start from here.
}
else if (string.IsNullOrWhiteSpace(reader[5].ToString()))
{
if (reader[7].ToString() == "Customer")
{
return(false);
}
dealer = new Dealer(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), 0, Double.Parse(reader[6].ToString()), reader[7].ToString(), reader[8].ToString(), reader[9].ToString());
//start from here...
//start from here.
}
else
{
if (reader[7].ToString() == "Customer")
{
return(false);
}
dealer = new Dealer(reader[0].ToString(), reader[1].ToString(), reader[2].ToString(), reader[3].ToString(), reader[4].ToString(), Double.Parse(reader[5].ToString()), Double.Parse(reader[6].ToString()), reader[7].ToString(), reader[8].ToString(), reader[9].ToString());
//start from here...
}
return(true);
}
else
{
return(false);
}
con.Close();
}