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_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_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 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> 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);
}
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();
}
