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