// Read
public static List <ComponentShoe> Select()
{
using (var db = new MouldEntities())
{
return(db.ComponentShoes.ToList());
}
}
public static List <Mold> Select()
{
using (var db = new MouldEntities())
{
return(db.Molds.ToList());
}
}
// Read
public static List <Order> Select()
{
using (var db = new MouldEntities())
{
return(db.Orders.ToList());
}
}
// Read
public static List <OffDay_Supplier_Mapping> Select()
{
using (var db = new MouldEntities())
{
return(db.OffDay_Supplier_Mappings.ToList());
}
}
// Read
public static List <OffDay> Select()
{
using (var db = new MouldEntities())
{
return(db.OffDays.ToList());
}
}
// Read
public static List <SizeRun> Select()
{
using (var db = new MouldEntities())
{
return(db.SizeRuns.ToList());
}
}
// Delete
public static void Delete(int ID)
{
using (var db = new MouldEntities())
{
var canDelete = db.ComponentShoes.SingleOrDefault(s => s.ComponentID == ID);
if (canDelete != null)
{
db.ComponentShoes.Remove(canDelete);
db.SaveChanges();
}
}
}
// Create
public static void Insert(ComponentShoe model)
{
using (var db = new MouldEntities())
{
var canInsert = db.ComponentShoes.SingleOrDefault(s => s.ComponentID == model.ComponentID && s.ComponentName.Equals(model.ComponentName));
if (canInsert == null)
{
db.ComponentShoes.Add(model);
db.SaveChanges();
}
}
}
// Delete
public static void Delete(int ID)
{
using (var db = new MouldEntities())
{
var canDelete = db.OffDay_Supplier_Mappings.SingleOrDefault(s => s.ID == ID);
if (canDelete != null)
{
db.OffDay_Supplier_Mappings.Remove(canDelete);
db.SaveChanges();
}
}
}
// Create
public static void Insert(OffDay_Supplier_Mapping model)
{
using (var db = new MouldEntities())
{
var canInsert = db.OffDay_Supplier_Mappings.SingleOrDefault(s => s.ID == model.ID && s.OffDayID == model.OffDayID && s.SupplierID == model.SupplierID);
if (canInsert == null)
{
db.OffDay_Supplier_Mappings.Add(model);
db.SaveChanges();
}
}
}
// Delete
public static void Delete(SizeRun model)
{
using (var db = new MouldEntities())
{
var canDelete = db.SizeRuns.SingleOrDefault(s => s.OutsoleCode == model.OutsoleCode && s.SizeNo == model.SizeNo);
if (canDelete != null)
{
db.SizeRuns.Remove(canDelete);
db.SaveChanges();
}
}
}
// Create
public static void Insert(Order model)
{
using (var db = new MouldEntities())
{
var canInsert = db.Orders.SingleOrDefault(s => s.OrderID == model.OrderID && s.OutsoleCode.Equals(model.OutsoleCode) && s.ShoeName.Equals(model.ShoeName));
if (canInsert == null)
{
db.Orders.Add(model);
db.SaveChanges();
}
}
}
// Update
public static void Update(SizeRun model)
{
using (var db = new MouldEntities())
{
var canUpdate = db.SizeRuns.SingleOrDefault(w => w.OutsoleCode == model.OutsoleCode && w.SizeNo == w.SizeNo);
if (canUpdate != null)
{
canUpdate.Quantity = model.Quantity;
db.SaveChanges();
}
}
}
// Update
public static void Update(OffDay_Supplier_Mapping model)
{
using (var db = new MouldEntities())
{
var canUpdate = db.OffDay_Supplier_Mappings.SingleOrDefault(s => s.ID == model.ID);
if (canUpdate != null)
{
canUpdate.OffDayID = model.OffDayID;
canUpdate.SupplierID = model.SupplierID;
db.SaveChanges();
}
}
}
// Update
public static void Update(OffDay model)
{
using (var db = new MouldEntities())
{
var canUpdate = db.OffDays.SingleOrDefault(s => s.OffDayID == model.OffDayID);
if (canUpdate != null)
{
canUpdate.OffDate = model.OffDate;
canUpdate.Description = model.Description;
db.SaveChanges();
}
}
}
// Create
public static void Insert(OffDay model)
{
using (var db = new MouldEntities())
{
var canInsert = db.OffDays.Where(w => w.OffDate.Value.Year == model.OffDate.Value.Year &&
w.OffDate.Value.Month == model.OffDate.Value.Month &&
w.OffDate.Value.Day == model.OffDate.Value.Day).ToList();
if (canInsert.Count() == 0)
{
db.OffDays.Add(model);
db.SaveChanges();
}
}
}
// Update
public static void Update(ComponentShoe model)
{
using (var db = new MouldEntities())
{
var canUpdate = db.ComponentShoes.SingleOrDefault(s => s.ComponentID == model.ComponentID);
if (canUpdate != null)
{
canUpdate.ComponentName = model.ComponentName;
canUpdate.Description = model.Description;
canUpdate.ModifiedTime = DateTime.Now;
db.SaveChanges();
}
}
}
// Update
public static void Update(Supplier model)
{
using (var db = new MouldEntities())
{
var canUpdate = db.Suppliers.SingleOrDefault(s => s.SupplierID == model.SupplierID);
if (canUpdate != null)
{
canUpdate.SupplierName = model.SupplierName;
canUpdate.Description = model.Description;
canUpdate.ModifiedTime = DateTime.Now;
db.SaveChanges();
}
}
}
// Create
public static void Insert(SizeRun model)
{
using (var db = new MouldEntities())
{
var canInsert = db.SizeRuns.SingleOrDefault(w => w.OutsoleCode == model.OutsoleCode && w.SizeNo == model.SizeNo);
if (canInsert == null)
{
db.SizeRuns.Add(model);
db.SaveChanges();
}
else
{
canInsert.Quantity = model.Quantity;
canInsert.ModifiedTiime = DateTime.Now;
db.SaveChanges();
}
}
}
// Delete
public static void Delete(int ID)
{
using (var db = new MouldEntities())
{
var canDelete = db.Suppliers.SingleOrDefault(s => s.SupplierID == ID);
if (canDelete != null)
{
db.Suppliers.Remove(canDelete);
db.SaveChanges();
}
var supplierHasOffDayList = db.OffDay_Supplier_Mappings.Where(w => w.SupplierID == ID).ToList();
foreach (var removeOffDay in supplierHasOffDayList)
{
db.OffDay_Supplier_Mappings.Remove(removeOffDay);
db.SaveChanges();
}
}
}
// Update
public static void Update(Order model)
{
using (var db = new MouldEntities())
{
var canUpdate = db.Orders.SingleOrDefault(s => s.OrderID == model.OrderID);
if (canUpdate != null)
{
canUpdate.OutsoleCode = model.OutsoleCode;
canUpdate.Article = model.Article;
canUpdate.ShoeName = model.ShoeName;
canUpdate.CSD = model.CSD;
canUpdate.Quantity = model.Quantity;
canUpdate.IsEnable = model.IsEnable;
canUpdate.ModifiedTime = DateTime.Now;
db.SaveChanges();
}
}
}
// Delete
public static void Delete(int ID)
{
using (var db = new MouldEntities())
{
var canDelete = db.OffDays.SingleOrDefault(s => s.OffDayID == ID);
if (canDelete != null)
{
db.OffDays.Remove(canDelete);
db.SaveChanges();
}
var offDayMappingDeleteList = db.OffDay_Supplier_Mappings.Where(w => w.OffDayID == ID).ToList();
foreach (var offDayMappingDelete in offDayMappingDeleteList)
{
db.OffDay_Supplier_Mappings.Remove(offDayMappingDelete);
db.SaveChanges();
}
}
}
