public List <DTO_Manufacture> SaveManufactureById(DTO_Manufacture m)
{
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
var myManufacture = db.Manufacturers.Where(c => c.manID == m.manID).FirstOrDefault();
if (myManufacture != null)
{
myManufacture.manName = m.manName;
db.SaveChanges();
listOfLocalObjects.Add(m);
}
else
{
Manufacturer sc = new Manufacturer();
sc.manName = m.manName;
db.Manufacturers.Add(sc);
db.SaveChanges();
DTO_Manufacture d = new DTO_Manufacture();
d.manID = xx
}
return(listOfLocalObjects);
}
public List <DTO_Transaction> GetTransactions(DTO_User user)
{
List <DTO_Transaction> transactions = new List <DTO_Transaction>();
using (DB_111206_scrapEntities db = new DB_111206_scrapEntities())
{
var match = db.Users.Where(u => u.email == user.Email && u.pwd == user.Password).FirstOrDefault();
if (match != null)
{
var all_trans = match.Transactions.ToList();
{
foreach (var t in all_trans)
{
DTO_Transaction tran = new DTO_Transaction();
tran.Id = t.tranId;
tran.Price = (double)t.salePrice;
tran.DT = t.tranDate;
transactions.Add(tran);
}
}
}
}
return(transactions);
}
private void LoadParts()
{
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
var sqllist = db.Parts.ToList();
List <DTO_Part> parts = new List <DTO_Part>();
foreach (var sqlObject in sqllist)
{
DTO_Part p = new DTO_Part();
p.manID = sqlObject.manID.Value;
p.modelID = sqlObject.modelId.Value;
p.partDesc = sqlObject.partDesc;
p.partNum = sqlObject.partNum;
p.partPic = string.Format("{0}{1}", @"http://www.jerrybhill.com/scrapimages/", sqlObject.partPic);
p.partsID = sqlObject.partsID;
// Missing import object
DTO_Manufacture m = new DTO_Manufacture();
m.manID = sqlObject.manID.Value;
m.manName = sqlObject.Manufacturer.manName;
p.manufacture = m;
parts.Add(p);
}
lv.ItemsSource = parts;
}
public DTO_User VerifyUserLogin(DTO_Login uL)
{
//DB Connection
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
//get table contents
var listUsers = db.Users.ToList();
var tempUser = listUsers.Where(x => x.email == uL.Email && x.pwd == uL.Password).FirstOrDefault();
//create list to return with sql objects
DTO_User user = new DTO_User();
if (tempUser != null)
{
DTO_User verifiedUser = new DTO_User
{
id = tempUser.userID,
FirstName = tempUser.fName,
LastName = tempUser.lName,
Phone = tempUser.phone,
Password = tempUser.pwd
};
//Add user to list for returning
user = verifiedUser;
//create odbject for UserLogins
var loginItem = new Scrap_DAL.UserLogin
{
userID = tempUser.userID,
lat = Convert.ToDouble(tempUser.lat),
lon = Convert.ToDouble(tempUser.lon),
logInDateTime = DateTime.Now
};
db.UserLogins.Add(loginItem);
db.SaveChanges();
}
return(user);
}
public List <DTO_User> RegisterUser(DTO_User u)
{
//DB Connection
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
List <DTO_User> tempList = new List <DTO_User>();
tempList.Add(u);
var temp = new Scrap_DAL.User
{
//no userid because system creates it
email = u.Email,
fName = u.FirstName,
lName = u.LastName,
phone = u.Phone,
pwd = u.Password,
};
db.Users.Add(temp);
var loginItem = new Scrap_DAL.UserLogin
{
userID = temp.userID,
lat = Convert.ToSingle(temp.lat),
lon = Convert.ToSingle(temp.lon),
logInDateTime = DateTime.Now
};
db.UserLogins.Add(loginItem);
db.SaveChanges();
return(tempList);
}
public List <DTO_User> LoginUser(DTO_Login login)
{
DTO_User user = new DTO_User();
List <DTO_User> users = new List <DTO_User>();
using (DB_111206_scrapEntities db = new DB_111206_scrapEntities())
{
var match = db.Users.Where(u => u.email == login.Email && u.pwd == login.Password).FirstOrDefault();
if (match != null)
{
user.id = match.userID;
user.LastName = match.lName;
user.FirstName = match.fName;
user.Email = match.email;
user.Password = match.pwd;
user.Phone = match.phone;
users.Add(user);
UserLogin userlogin = new UserLogin();
userlogin.userID = user.id;
userlogin.lat = login.Latutude;
userlogin.lon = login.Longitude;
userlogin.logInDateTime = DateTime.Now;
db.UserLogins.Add(userlogin);
db.SaveChanges();
// email("New user login", "Hello, World!");
}
}
return(users);
}
public List <DTO_Offer> GetOffersByPartDesc(DTO_Part p)
{
//string partDesc = p.partDesc;
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
var listOffers = db.Offers.ToList();
var matches = listOffers.Where(x => x.Part.partDesc.Contains(p.Description)).ToList();
List <DTO_Offer> offers = new List <DTO_Offer>();
foreach (var offer in matches)
{
var o = new DTO_Offer
{
Id = offer.offerID,
/* Parts = offer.partsID,// partsID),
* Seller = Convert.ToInt32(offer.sellerID),
*/
Price = Convert.ToInt32(offer.price),
Ostat = Convert.ToInt32(offer.ostat),
DT = offer.offerDate
};
offers.Add(o);
}
return(offers);
}
public List <DTO_Manufacture> GetManufacturesById(DTO_Manufacture m)
{
//DB Connection
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
//get table contents
var manufacturer = db.Manufacturers.Where(x => x.manID == m.Id).FirstOrDefault();
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
DTO_Manufacture o = new DTO_Manufacture();
if (manufacturer != null)
{
o.Id = manufacturer.manID;
o.Name = manufacturer.manName;
listOfLocalObjects.Add(o);
}
else
{
//insert record
Manufacturer sc = new Manufacturer();
sc.manName = m.Name;
db.Manufacturers.Add(sc);
db.SaveChanges();
//DTO_Manufacture newMan = new Manufacturer();
}
return(listOfLocalObjects);
}
public List <DTO_Manufacture> GetManufactureById(DTO_Manufacture m)
{
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
var myManufacture = db.Manufacturers.Where(c => c.manID == m.manID).FirstOrDefault();
if (myManufacture != null)
{
DTO_Manufacture o = new DTO_Manufacture();
o.manID = myManufacture.manID;
o.manName = myManufacture.manName;
listOfLocalObjects.Add(o);
}
return(listOfLocalObjects);
}
public List <DTO_Manufacture> GetManufactures(DTO_Manufacture m)
{
//DB Connection
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
//get table contents
var listOfSQLObjects = db.Manufacturers.ToList().OrderBy(c => c.manName).ToList();
//create list to fill with sql objects
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
foreach (var sqlobj in listOfSQLObjects)
{
DTO_Manufacture o = new DTO_Manufacture();
o.Id = sqlobj.manID;
o.Name = sqlobj.manName;
listOfLocalObjects.Add(o);
}
return(listOfLocalObjects);
}
public List <DTO_Manufacture> GetManufactures()
{
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
var listOfSQLObjects = db.Manufacturers.ToList();
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
foreach (var sqlobj in listOfSQLObjects)
{
DTO_Manufacture o = new DTO_Manufacture();
o.manID = sqlobj.manID;
o.manName = sqlobj.manName;
listOfLocalObjects.Add(o);
}
return(listOfLocalObjects);
}
// m.manName = "app"
public List <DTO_Manufacture> GetManufactureByPartialName(DTO_Manufacture m)
{
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
var sqllist = db.Manufacturers.Where(c => c.manName.StartsWith(m.manName)).ToList();
foreach (var sqlobj in sqllist)
{
DTO_Manufacture o = new DTO_Manufacture();
o.manID = sqlobj.manID;
o.manName = sqlobj.manName;
listOfLocalObjects.Add(o);
}
return(listOfLocalObjects);
}
public List <DTO_Manufacture> GetManufacturesByPartial(DTO_Manufacture m)
{
//DB Connection
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
//get table contents
var manufacturer = db.Manufacturers.Where(x => x.manName.StartsWith(m.Name)).ToList();
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
foreach (var man in manufacturer)
{
DTO_Manufacture o = new DTO_Manufacture
{
Name = man.manName,
Id = man.manID
};
listOfLocalObjects.Add(o);
}
return(listOfLocalObjects);
}
private void LoadPart()
{
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
var listOfSQLObjects = db.Manufacturers.ToList();
List <DTO_Manufacture> listOfLocalObjects = new List <DTO_Manufacture>();
foreach (var sqlobj in listOfSQLObjects)
{
DTO_Manufacture o = new DTO_Manufacture();
o.manID = sqlobj.manID;
o.manName = sqlobj.manName;
listOfLocalObjects.Add(o);
}
cbMan.ItemsSource = listOfLocalObjects;
var models = db.Models.ToList();
cbModels.ItemsSource = models;
}
public List <DTO_Offer> GetOffers()
{
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
List <DTO_Offer> returnOffers = new List <DTO_Offer>();
var offersTable = db.Offers.ToList();
foreach (var o in offersTable)
{
DTO_Offer tempO = new DTO_Offer
{
DT = o.offerDate,
Id = o.offerID,
Ostat = Convert.ToInt32(o.ostat),
PartId = Convert.ToInt32(o.partsID),
Price = Convert.ToDouble(o.price),
SellerId = Convert.ToInt32(o.sellerID)
};
returnOffers.Add(tempO);
}
return(returnOffers);
}
public List <DTO_Register> RegisterUser_Bekka(DTO_Register newUser)
{
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
User user = new User();
List <DTO_Register> listOfLocalObjects = new List <DTO_Register>();
var sucessfulPassword = db.Users.Where(c => c.pwd == newUser.Password).FirstOrDefault();
if (sucessfulPassword == null)
{
user.pwd = sucessfulPassword.pwd;
user.fName = newUser.FirstName;
user.lName = newUser.LastName;
user.email = newUser.Email;
user.phone = newUser.Phone;
user.lat = newUser.Latutude;
user.lon = newUser.Longitude;
listOfLocalObjects.Add(newUser);
db.Users.Add(user);
}
return(listOfLocalObjects);
}
public List <DTO_WishListItems> GetWishListItems(DTO_User user)
{
List <DTO_WishListItems> wishList = new List <DTO_WishListItems>();
using (DB_111206_scrapEntities db = new DB_111206_scrapEntities())
{
var match = db.Users.Where(u => u.email == user.Email && u.pwd == user.Password).FirstOrDefault();
if (match != null)
{
var itemsWanted = match.wishlistItems.ToList();
foreach (var i in itemsWanted)
{
DTO_WishListItems items = new DTO_WishListItems();
i.offerID = items.Offer;
i.wilID = items.Id;
i.userID = items.User;
wishList.Add(items);
}
}
}
return(wishList);
}
public List <DTO_Offer> GetOffersByUser(DTO_User user)
{
List <DTO_Offer> offers = new List <DTO_Offer>();
using (DB_111206_scrapEntities db = new DB_111206_scrapEntities())
{
var match = db.Users.Where(u => u.email == user.Email && u.pwd == user.Password).FirstOrDefault();
if (match != null)
{
var offers_ = match.Offers.ToList();
foreach (var i in offers_)
{
DTO_Offer bid = new DTO_Offer();
i.offerID = bid.Id;
i.offerDate = bid.DT;
i.price = (decimal)bid.Price;
offers.Add(bid);
}
}
}
return(offers);
}
public List <DTO_User> GetUsers()
{
//DB Connection
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
//get table contents
var usersTable = db.Users.ToList();
//create list to fill with sql objects
List <DTO_User> users = new List <DTO_User>();
foreach (var user in usersTable)
{
DTO_User tempU = new DTO_User
{
id = user.userID,
Email = user.email,
FirstName = user.fName,
LastName = user.lName,
Password = user.pwd,
Phone = user.phone
};
users.Add(tempU);
}
return(users);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var m = cbMan.SelectedItem as DTO_Manufacture;
var model = cbModels.SelectedItem;
string pn = tbPartNumber.Text;
string pdesc = PartDesc.Text;
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
// Need to fix id's
Part sqlPart = new Part();
sqlPart.manID = m.manID;
sqlPart.modelId = 1;
sqlPart.partNum = pn;
sqlPart.partDesc = pdesc;
db.Parts.Add(sqlPart);
db.SaveChanges();
}
public List <DTO_User> GetIndUser(DTO_User u)
{
//DB Connection
DB_111206_scrapEntities db = new DB_111206_scrapEntities();
//get table contents
var userCred = db.Users.Where(x => x.userID == u.id || x.fName == u.FirstName || x.lName == u.LastName).FirstOrDefault();
//create list to fill with sql objects
List <DTO_User> user = new List <DTO_User>();
if (userCred != null)
{
DTO_User tempU = new DTO_User
{
id = userCred.userID,
Email = userCred.email,
FirstName = userCred.fName,
LastName = userCred.lName,
Password = userCred.pwd,
Phone = userCred.phone
};
user.Add(u);
}
return(user);
}
