protected void Page_Init(object sender, EventArgs e)
{
checkGetParams();
Computer computer = Computer.GetComputer(Int32.Parse(Request.QueryString["productID"]));
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
var query = from cp in db.ComputerParts
from p in db.Parts
where cp.ComputerID == computer.ComputerID && p.PartID == cp.PartID && cp.Standard == true
select p;
Dictionary <string, int> dict = new Dictionary <string, int>();
foreach (linq_to_sql.Part part in query)
{
dict[part.Type] = part.PartID;
}
computer.setPartIDs(dict["CPU"], dict["RAM"], dict["Hard Drive"], dict["Display"], dict["Operating System"]);
setCpuList(computer);
setRamList(computer);
setHardDriveList(computer);
setDisplayList(computer);
setOsList(computer);
BrandLabel.Text = computer.Brand;
NameLabel.Text = computer.Name;
PriceLabel.Text = computer.GetPriceStr();
ProductImage.ImageUrl = computer.ImagePath;
this.computer = computer;
}
public IEnumerable <Computer> GetComputers()
{
List <Computer> computerList = new List <Computer>();
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
string category = Request.QueryString["category"];
var query = from c in db.Computers
where String.Equals(c.Type, category)
select c;
foreach (linq_to_sql.Computer dbComputer in query)
{
Computer computer = Computer.GetComputer(dbComputer.ComputerID);
Dictionary <string, int> dict = new Dictionary <string, int>();
var q2 = from p in db.Parts
from cp in db.ComputerParts
where p.PartID == cp.PartID && cp.ComputerID == computer.ComputerID && cp.Standard == true
select p;
foreach (linq_to_sql.Part part in q2)
{
dict[part.Type] = part.PartID;
}
computer.setPartIDs(dict["CPU"], dict["RAM"], dict["Hard Drive"], dict["Display"], dict["Operating System"]);
computerList.Add(computer);
}
SessionData data = (SessionData)Session["data"];
var computers =
from c in computerList
where data.LabelList.Contains(c.Label) && data.BrandList.Contains(c.Brand)
select c;
return(computers);
}
protected void UserExists(object source, ServerValidateEventArgs args)
{
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
var query = from a in db.Auths
where String.Equals(a.Username, Username.Text)
select a;
args.IsValid = !query.Any();
}
private List <string> getBrandList()
{
string category = Request.QueryString["category"];
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
var query = from c in db.Computers
where c.Type == category
select c.Brand;
return(query.ToList());
}
public static Computer GetComputer(int computerID)
{
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
var query = from c in db.Computers
where c.ComputerID == computerID
select c;
if (query.Count() == 0)
{
throw new Exception("Could not find computerID");
}
linq_to_sql.Computer dbComputer = query.First();
return(new Computer(dbComputer.ComputerID, dbComputer.Name, dbComputer.Brand, dbComputer.Type, dbComputer.Label, dbComputer.ImagePath));
}
public static Part GetPart(int partID)
{
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
var query = from p in db.Parts
where p.PartID == partID
select p;
if (query.Count() == 0)
{
throw new Exception("Could not find computerID");
}
linq_to_sql.Part dbPart = query.First();
double price = (dbPart.Price.HasValue) ? dbPart.Price.Value : 0;
return(new Part(dbPart.PartID, dbPart.Name, price, dbPart.Brand, dbPart.Type));
}
private void setOsList(Computer computer)
{
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
var query = from p in db.Parts
from cp in db.ComputerParts
where cp.ComputerID == computer.ComputerID && cp.PartID == p.PartID && String.Equals(p.Type, "Operating System")
select p.PartID;
List <Part> partList = new List <Part>();
foreach (int id in query.ToList())
{
partList.Add(Part.GetPart(id));
}
setList(computer.GetOs(), OsDropDown, partList);
}
protected void Signup_Click(object sender, EventArgs e)
{
Validate();
if (IsValid)
{
linq_to_sql.Auth auth = new linq_to_sql.Auth
{
Username = Username.Text,
Password = Password.Text,
Email = Email.Text
};
linq_to_sql.DataClasses1DataContext db = new linq_to_sql.DataClasses1DataContext();
db.Auths.InsertOnSubmit(auth);
db.SubmitChanges();
Session["username"] = Username.Text;
Response.Redirect("Default.aspx");
}
}
