internal static void AddSaleRecord(Shared.DTODefinition.IDtoObject record)
{
using (var ctx = new SI2_Entities())
{
BidSoftware.Shared.DTODefinition.Sale rec = (BidSoftware.Shared.DTODefinition.Sale)record;
ctx.sp_addSale(rec.ItemId, rec.SaleValue, rec.StartDate, rec.EndDate, rec.Location, rec.CountryNum);
}
}
internal static void DeleteSaleRecord(Shared.DTODefinition.IDtoObject record)
{
using (var ctx = new SI2_Entities())
{
BidSoftware.Shared.DTODefinition.Sale s = (BidSoftware.Shared.DTODefinition.Sale)record;
ctx.sp_deleteAuctionSale(s.SaleId);
}
}
internal static void DeleteItemRecord(Shared.DTODefinition.IDtoObject record)
{
using (var ctx = new SI2_Entities())
{
BidSoftware.Shared.DTODefinition.Item i = (BidSoftware.Shared.DTODefinition.Item)record;
ctx.sp_deleteItem(i.ItemId);
}
}
internal static void AddItemRecord(Shared.DTODefinition.IDtoObject record)
{
using (var ctx = new SI2_Entities())
{
BidSoftware.Shared.DTODefinition.Item rec = (BidSoftware.Shared.DTODefinition.Item)record;
ctx.sp_addItem(rec.Description, rec.ItemConditionId, rec.UserEmail);
}
}
internal static void UpdateSaleRecord(Shared.DTODefinition.IDtoObject record)
{
BidSoftware.Shared.DTODefinition.Sale s = (BidSoftware.Shared.DTODefinition.Sale)record;
using (var ctx = new SI2_Entities())
{
s = (BidSoftware.Shared.DTODefinition.Sale)record;
ctx.sp_editSale(s.SaleId, s.SaleValue, s.StartDate, s.EndDate, s.Location, s.CountryNum, s.ItemId);
}
}
internal static void UpdateAuctionRecord(Shared.DTODefinition.IDtoObject record)
{
BidSoftware.Shared.DTODefinition.Auction a = (BidSoftware.Shared.DTODefinition.Auction)record;
using (var ctx = new SI2_Entities())
{
a = (BidSoftware.Shared.DTODefinition.Auction)record;
ctx.sp_editAuctionSale(a.SaleId, a.SaleValue, a.StartDate, a.EndDate, a.Location, a.MinIncrement, a.ItemId, a.CountryNum);
}
}
internal static void UpdateItemRecord(Shared.DTODefinition.IDtoObject record)
{
BidSoftware.Shared.DTODefinition.Item i = (BidSoftware.Shared.DTODefinition.Item)record;
using (var ctx = new SI2_Entities())
{
i = (BidSoftware.Shared.DTODefinition.Item)record;
ctx.sp_editItem(i.ItemId, i.Description, i.ItemConditionId, i.UserEmail);
}
}
