public void DeleteGoodInfo(string shopId, string goodId)
{
using (IDbContextTransaction transaction = Database.BeginTransaction(IsolationLevel.ReadCommitted))
{
try
{
var basicInfo = CurrentDbSet.FirstOrDefault(g => g.ShopId == shopId && g.Id == goodId);
CurrentDbSet.Remove(basicInfo);
var extensionsInfo = goodInfoExtensionsDbSet.FirstOrDefault(g => g.ShopId == shopId && g.GoodInfoId == goodId);
goodInfoExtensionsDbSet.Remove(extensionsInfo);
var skuList = goodInfoSKUDbSet.Where(sku => sku.ShopId == shopId || sku.GoodInfoId == goodId).ToList();
goodInfoSKUDbSet.RemoveRange(skuList);
SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
}
/// <summary>
/// GetById
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Vendor GetById(long id)
{
return(CurrentDbSet.FirstOrDefault(x => x.Id == id));
}
/// <summary>
/// Returns the default genre.
/// </summary>
/// <returns>
/// The default genre.
/// </returns>
public Genre GetDefaultGenre()
{
return(CurrentDbSet.FirstOrDefault());
}
public T GetFirst()
{
return(CurrentDbSet.FirstOrDefault());
}
/// <summary>
/// Returns the default price level.
/// </summary>
/// <returns>
/// The default price level.
/// </returns>
public PriceLevel GetDefaultPriceLevel()
{
return(CurrentDbSet.FirstOrDefault());
}
/// <summary>
/// Returns the default currency.
/// </summary>
/// <returns>
/// Default currency.
/// </returns>
public Currency GetDefaultCurrency()
{
return(CurrentDbSet.FirstOrDefault());
}