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