internal static IEnumerable <Shared.DTODefinition.IDtoObject> GetTableSalePage(int startRecord, int numRecords)
{
try
{
LinkedList <BidSoftware.Shared.DTODefinition.Sale> li = new LinkedList <BidSoftware.Shared.DTODefinition.Sale>();
BidSoftware.Shared.DTODefinition.Sale s;
using (var ctx = new SI2_Entities())
{
foreach (var sale in ctx.vSales.Where(p => (p.ROW_NR >= startRecord) && (p.ROW_NR <= startRecord + numRecords)))
{
s = new BidSoftware.Shared.DTODefinition.Sale();
s.SaleId = sale.SaleId;
s.StartDate = sale.StartDate;
s.EndDate = sale.EndDate;
s.Location = sale.Location;
s.CountryNum = Convert.ToInt32(sale.CountryNum);
s.ItemId = sale.ItemId;
s.SaleValue = sale.SaleValue;
li.AddLast(s);
}
}
return(li);
}
catch (Exception ex) { throw new DisconnectException(ex.Message, ex); }
}
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 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 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);
}
}
