public bool createOrUpdateMmodel(OInv.Common.Entities.Model model)
{
try
{
using (var db = new MainDatabaseEntities())
{
if (model.ModelId == 0)
{
// db.Models.Add(new Model { Model_Id = model.ModelId, Model_Name = model.ModelName ,Model_SKU=model.ModelName, Model_Type=model.ModelType,Model_SubType=model.ModelSubType});
db.SaveChanges();
}
else
{
Model manu = db.Models.Where(x => x.Model_Id == model.ModelId).FirstOrDefault();
manu.Model_Name = model.ModelName;
manu.Model_SKU = model.ModelSKU;
manu.Model_Type = model.ModelSubTypeId;
manu.Model_SubType = model.ModelSubTypeId;
db.SaveChanges();
}
return(true);
}
}
catch
{
return(false);
}
}
public bool createOrUpdateManufaturer(OInv.Common.Entities.Manufature manufacture)
{
try {
using (var db = new MainDatabaseEntities())
{
if (manufacture.ManufactureId == 0)
{
db.Manufatures.Add(new Manufature {
Manufacture_Id = manufacture.ManufactureId, Manufacture_Name = manufacture.ManufactureName
});
db.SaveChanges();
}
else
{
Manufature manu = db.Manufatures.Where(x => x.Manufacture_Id == manufacture.ManufactureId).FirstOrDefault();
manu.Manufacture_Name = manufacture.ManufactureName;
db.SaveChanges();
}
return(true);
}
}
catch
{
return(false);
}
}
public IEnumerable <OInv.Common.Entities.Model> getAllModels()
{
using (var db = new MainDatabaseEntities())
{
var models = db.Models.ToList();
var result = new List <OInv.Common.Entities.Model>();
foreach (Model model in models)
{
result.Add(new OInv.Common.Entities.Model()
{
ModelId = model.Model_Id,
ModelName = model.Model_Name,
ModelManufaturer = (model.Manufature == null) ? null : new OInv.Common.Entities.Manufature {
ManufactureId = model.Manufature.Manufacture_Id, ManufactureName = model.Manufature.Manufacture_Name
},
ModelSKU = model.Model_SKU,
ModelSubType = (model.ProductSubType == null)? null : new OInv.Common.Entities.ProductSubType {
ProductSubTypeId = model.ProductSubType.ProductSubType_Id, ProductSubTypeName = model.ProductSubType.ProductSubType_Name
},
ModelType = (model.ProductType == null) ? null : new OInv.Common.Entities.ProductType {
ProductTypeId = model.ProductType.ProductType_Id, ProductTypeName = model.ProductType.ProductType_Name
},
ModelManufaturerId = model.Model_Manufaturer,
ModelSubTypeId = model.Model_SubType,
ModelTypeId = model.Model_Type,
});
}
return(result);
}
}
public bool createOrUpdateLocation(OInv.Common.Entities.Location location)
{
try
{
using (var db = new MainDatabaseEntities())
{
if (location.LocationId == 0)
{
db.Locations.Add(new Location {
Location_Id = location.LocationId, Location_Description = location.LocationDescription, Location_Code = location.LocationCode
});
db.SaveChanges();
}
else
{
Location manu = db.Locations.Where(x => x.Location_Id == location.LocationId).FirstOrDefault();
manu.Location_Description = location.LocationDescription;
manu.Location_Code = location.LocationCode;
db.SaveChanges();
}
return(true);
}
}
catch
{
return(false);
}
}
public IEnumerable <OInv.Common.Entities.Location> getAllLocations()
{
using (var db = new MainDatabaseEntities())
{
var locations = db.Locations.ToList();
var result = new List <OInv.Common.Entities.Location>();
foreach (Location location in locations)
{
result.Add(new OInv.Common.Entities.Location()
{
LocationId = location.Location_Id, LocationCode = location.Location_Code, LocationDescription = location.Location_Description
});
}
return(result);
}
}
public IEnumerable <OInv.Common.Entities.ProductSubType> getSubTypesByProductUd(int productTypeId)
{
using (var db = new MainDatabaseEntities())
{
var productSubTypes = db.ProductSubTypes.Where(x => x.ProductSubType_MainType == productTypeId).ToList();
var result = new List <OInv.Common.Entities.ProductSubType>();
foreach (ProductSubType productSubType in productSubTypes)
{
result.Add(new OInv.Common.Entities.ProductSubType()
{
ProductSubTypeId = productSubType.ProductSubType_Id, ProductSubTypeName = productSubType.ProductSubType_Name
});
}
return(result);
}
}
public IEnumerable <OInv.Common.Entities.Manufature> getAllManufatures()
{
using (var db = new MainDatabaseEntities())
{
var manufatures = db.Manufatures.ToList();
var result = new List <OInv.Common.Entities.Manufature>();
foreach (Manufature manufature in manufatures)
{
result.Add(new OInv.Common.Entities.Manufature()
{
ManufactureId = manufature.Manufacture_Id, ManufactureName = manufature.Manufacture_Name
});
}
return(result);
}
}