public void RemoveType(Good good, TypeT type, bool isSaveNow = false)
{
try
{
if (good == null || good.Id == 0)
{
return;
}
if (type == null || type.Id == 0)
{
return;
}
var dbtype =
Db.Set <GoodType>().Single(it => it.TypeId == type.Id && it.GoodId == good.Id);
Db.Set <GoodType>().Remove(dbtype);
if (isSaveNow)
{
Db.SaveChanges();
}
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
}
public void AddType(Good good, TypeT type, bool isSaveNow = false)
{
try
{
if (good == null || good.Id == 0)
{
throw new ArgumentException("No good provided.");
}
if (type == null || type.Id == 0)
{
throw new ArgumentException("No type provided.");
}
Db.Set <GoodType>().Add(new GoodType
{
TypeId = type.Id,
GoodId = good.Id
});
if (isSaveNow)
{
Db.SaveChanges();
}
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
}
public void RemoveType(Good good, TypeT type, bool isSaveNow = false)
{
throw new NotImplementedException();
}
internal static void PopulateDefaultStoreDataCtx(DbContext db)
{
try
{
var store = new odec.Server.Model.Store.Store
{
Code = "Store1",
Name = "Store",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <odec.Server.Model.Store.Store>().Add(store);
var noScale = new Scale
{
Code = "NOSCALE",
Name = "Not Selected",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Scale>().Add(noScale);
var noSize = new Size
{
Code = "NOSIZE",
Name = "Not Selected",
DateCreated = DateTime.Now,
IsActive = true,
Scale = noScale
};
db.Set <Size>().Add(noSize);
var good = GenerateGood("TestGoodPopulated", noSize);
var good2 = GenerateGood("TestGoodPopulated2", noSize);
var good3 = GenerateGood("TestGoodPopulated3", noSize);
db.Set <Good>().Add(good);
db.Set <Good>().Add(good2);
db.Set <Good>().Add(good3);
db.SaveChanges();
db.Set <RelativeGood>().Add(new RelativeGood
{
GoodId = good.Id,
RelativeGoodId = good2.Id
});
db.Set <RelativeGood>().Add(new RelativeGood
{
GoodId = good.Id,
RelativeGoodId = good3.Id
});
db.Set <StoreGood>().Add(new StoreGood
{
GoodId = good.Id,
StoreId = store.Id,
Articul = good.Articul,
StoreQuantity = 1
});
db.Set <StoreGood>().Add(new StoreGood
{
GoodId = good2.Id,
StoreId = store.Id,
Articul = good2.Articul,
StoreQuantity = 1
});
db.Set <StoreGood>().Add(new StoreGood
{
GoodId = good3.Id,
StoreId = store.Id,
Articul = good3.Articul,
StoreQuantity = 1
});
var designer1 = new Designer
{
Code = "D&G",
Name = "Dolche and Gabbana",
DateCreated = DateTime.Now,
IsActive = true,
};
var designer2 = new Designer
{
Code = "SCALA",
Name = "Scala",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Designer>().Add(designer1);
db.Set <GoodDesigner>().Add(new GoodDesigner
{
GoodId = good.Id,
DesignerId = designer1.Id
});
db.Set <Designer>().Add(designer2);
db.Set <GoodDesigner>().Add(new GoodDesigner
{
GoodId = good.Id,
DesignerId = designer2.Id
});
var typeHat = new Type
{
Code = "T1",
Name = "Hat",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Type>().Add(typeHat);
db.Set <GoodType>().Add(new GoodType
{
GoodId = good.Id,
TypeId = typeHat.Id
});
var typeTrousers = new Type
{
Code = "T2",
Name = "trousers",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Type>().Add(typeTrousers);
db.Set <GoodType>().Add(new GoodType
{
GoodId = good.Id,
TypeId = typeTrousers.Id
});
var category1 = new Category
{
Code = "C1",
Name = "C1",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Category>().Add(category1);
db.Set <GoodCategory>().Add(new GoodCategory
{
GoodId = good.Id,
CategoryId = category1.Id
});
var category2 = new Category
{
Code = "C2",
Name = "C2",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Category>().Add(category2);
db.Set <GoodCategory>().Add(new GoodCategory
{
GoodId = good.Id,
CategoryId = category2.Id
});
var iron = new Material
{
Code = "I",
Name = "Iron",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Material>().Add(iron);
db.Set <GoodMaterial>().Add(new GoodMaterial
{
GoodId = good.Id,
MaterialId = iron.Id
});
var wood = new Material
{
Code = "W",
Name = "Wood",
DateCreated = DateTime.Now,
IsActive = true,
};
db.Set <Material>().Add(iron);
db.Set <GoodMaterial>().Add(new GoodMaterial
{
GoodId = good.Id,
MaterialId = wood.Id
});
var img1 = GenerateAttachment();
db.Set <Attachment>().Add(img1);
db.Set <GoodImage>().Add(new GoodImage
{
GoodId = good.Id,
ImageId = img1.Id,
IsMain = true
});
var img2 = GenerateAttachment();
db.Set <GoodImage>().Add(new GoodImage
{
GoodId = good.Id,
ImageId = img2.Id,
IsMain = false
});
db.Set <Attachment>().Add(img2);
var img3 = GenerateAttachment();
db.Set <Attachment>().Add(img3);
db.Set <GoodImage>().Add(new GoodImage
{
GoodId = good.Id,
ImageId = img3.Id,
IsMain = false
});
var red = new Color
{
Code = "RED",
Name = "Red",
DateCreated = DateTime.Now,
IsActive = true,
A = 1,
B = 0,
R = 255,
G = 0
};
db.Set <Color>().Add(red);
db.Set <GoodColor>().Add(new GoodColor
{
GoodId = good.Id,
ColorId = red.Id
});
var green = new Color
{
Code = "GREEN",
Name = "Green",
DateCreated = DateTime.Now,
IsActive = true,
A = 1,
B = 0,
R = 0,
G = 255
};
db.Set <Color>().Add(green);
db.Set <GoodColor>().Add(new GoodColor
{
GoodId = good.Id,
ColorId = green.Id
});
var blue = new Color
{
Code = "BLUE",
Name = "Blue",
DateCreated = DateTime.Now,
IsActive = true,
A = 1,
B = 255,
R = 0,
G = 0
};
db.Set <Color>().Add(blue);
db.Set <GoodColor>().Add(new GoodColor
{
GoodId = good.Id,
ColorId = blue.Id
});
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
