/// <summary>
/// Retreive leads data
/// </summary>
/// <returns>List of Leads</returns>
public static List<Prospect> GetLeads()
{
var db = new MQ163DataContext();
var prospects = from x in db.Prospects
where x.IsCustomer == false
select x;
return prospects.ToList();
}
/// <summary>
/// Retreive Customer data
/// </summary>
/// <returns>List of Customers</returns>
public static List <Prospect> GetCustomers()
{
var db = new MQ163DataContext();
var prospects = from x in db.Prospects
where x.IsCustomer == true
select x;
return(prospects.ToList());
}
/// <summary>
/// Create lead reord using given information
/// </summary>
/// <param name="fullName">lead name</param>
/// <returns>true if succeded</returns>
public static bool CreateLead(string fullName)
{
var db = new MQ163DataContext();
var prospects = from x in db.Prospects
orderby x.Id descending
select x;
int newId = (prospects != null && prospects.Count() > 0)? prospects.First().Id : 0;
var newLead = new Prospect{
Id = newId + 1,
FullName = fullName,
email = @" ",
IsCustomer = false,
Features = " ",
Car=" "
};
db.Prospects.InsertOnSubmit(newLead);
db.SubmitChanges();
return true;
}
/// <summary>
/// Create lead reord using given information
/// </summary>
/// <param name="fullName">lead name</param>
/// <returns>true if succeded</returns>
public static bool CreateLead(string fullName)
{
var db = new MQ163DataContext();
var prospects = from x in db.Prospects
orderby x.Id descending
select x;
int newId = (prospects != null && prospects.Count() > 0)? prospects.First().Id : 0;
var newLead = new Prospect {
Id = newId + 1,
FullName = fullName,
email = @" ",
IsCustomer = false,
Features = " ",
Car = " "
};
db.Prospects.InsertOnSubmit(newLead);
db.SubmitChanges();
return(true);
}
/// <summary>
/// Retreive Offers information
/// </summary>
/// <returns>List of Offers data</returns>
public static List<MerchandizeOffer> GetOffers()
{
var db = new MQ163DataContext();
return db.MerchandizeOffers.ToList();
}
/// <summary>
/// Retreive Offers information
/// </summary>
/// <returns>List of Offers data</returns>
public static List <MerchandizeOffer> GetOffers()
{
var db = new MQ163DataContext();
return(db.MerchandizeOffers.ToList());
}
