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