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 IEnumerable <Shared.DTODefinition.IDtoObject> GetTableAuctionPage(int startRecord, int numRecords)
{
try
{
LinkedList <BidSoftware.Shared.DTODefinition.Auction> li = new LinkedList <BidSoftware.Shared.DTODefinition.Auction>();
BidSoftware.Shared.DTODefinition.Auction auc;
using (var ctx = new SI2_Entities())
{
foreach (var auction in ctx.vAuctions.Where(p => (p.ROW_NR >= startRecord) && (p.ROW_NR <= startRecord + numRecords)))
{
auc = new BidSoftware.Shared.DTODefinition.Auction();
auc.SaleId = auction.SaleId;
auc.StartDate = auction.StartDate;
auc.EndDate = auction.EndDate;
auc.Location = auction.Location;
auc.ItemId = auction.ItemId;
auc.SaleValue = auction.SaleValue;
auc.MinIncrement = auction.MinIncrement;
li.AddLast(auc);
}
}
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 AddUserRecord(IDtoObject record)
{
using (var ctx = new SI2_Entities())
{
BidSoftware.Shared.DTODefinition.User rec = (BidSoftware.Shared.DTODefinition.User)record;
ctx.sp_addUser(rec.Email, rec.Name, rec.Address, rec.Password, rec.CountryNum);
}
}
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 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 DeleteUserRecord(IDtoObject record)
{
using (var ctx = new SI2_Entities())
{
BidSoftware.Shared.DTODefinition.User u = (BidSoftware.Shared.DTODefinition.User)record;
ctx.sp_deleteUser(u.Email);
}
}
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);
}
}
internal static void UpdateUserRecord(IDtoObject record)
{
BidSoftware.Shared.DTODefinition.User u = (BidSoftware.Shared.DTODefinition.User)record;
using (var ctx = new SI2_Entities())
{
u = (BidSoftware.Shared.DTODefinition.User)record;
ctx.sp_editUser(u.Email, u.Name, u.Address, u.Password, u.CountryNum);
}
}
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 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 IDtoObject GetUserRecord(object[] keys)
{
Shared.DTODefinition.User user;
using (var ctx = new SI2_Entities())
{
user = new Shared.DTODefinition.User();
String email = (String)keys[0];
var auxuser = ctx.vUsers.Where(p => p.Email == email).SingleOrDefault();
user.Email = auxuser.Email;
user.Address = auxuser.Address;
user.CountryNum = auxuser.CountryNum;
user.Name = auxuser.Name;
user.Password = ConvertUtils.GetByteString((byte[])auxuser.Password);
}
return(user);
}
internal static Shared.DTODefinition.IDtoObject GetItemRecord(object[] keys)
{
Shared.DTODefinition.Item item;
using (var ctx = new SI2_Entities())
{
item = new Shared.DTODefinition.Item();
int itemid = (int)keys[0];
var auxitem = ctx.vItems.Where(p => p.ItemId == itemid).SingleOrDefault();
item.ItemId = auxitem.ItemId;
item.Description = auxitem.Description;
item.ItemConditionId = auxitem.ItemConditionId;
item.UserEmail = auxitem.UserEmail;
}
return(item);
}
internal static Shared.DTODefinition.IDtoObject GetBidRecord(object[] keys)
{
Shared.DTODefinition.Bid bid;
using (var ctx = new SI2_Entities())
{
bid = new Shared.DTODefinition.Bid();
int bidid = (int)keys[0];
var auxbid = ctx.Bids.Where(p => p.BidId == bidid).SingleOrDefault();
bid.BidId = auxbid.BidId;
bid.Deleted = auxbid.Deleted;
bid.SaleId = auxbid.SaleId;
bid.Stamp = auxbid.Stamp;
bid.UserEmail = auxbid.UserEmail;
bid.Value = auxbid.Value;
}
return(bid);
}
internal static Shared.DTODefinition.IDtoObject GetSaleRecord(object[] keys)
{
Shared.DTODefinition.Sale sale;
using (var ctx = new SI2_Entities())
{
sale = new Shared.DTODefinition.Sale();
int saleid = (int)keys[0];
var auxsale = ctx.vSales.Where(p => p.SaleId == saleid).SingleOrDefault();
sale.SaleId = auxsale.SaleId;
sale.StartDate = auxsale.StartDate;
sale.EndDate = auxsale.EndDate;
sale.Location = auxsale.Location;
sale.CountryNum = Convert.ToInt32(auxsale.CountryNum);
sale.ItemId = auxsale.ItemId;
sale.SaleValue = auxsale.SaleValue;
}
return(sale);
}
internal static Shared.DTODefinition.IDtoObject GetAuctionRecord(object[] keys)
{
Shared.DTODefinition.Auction auction;
using (var ctx = new SI2_Entities())
{
auction = new Shared.DTODefinition.Auction();
int auctionid = (int)keys[0];
var auxauction = ctx.vAuctions.Where(p => p.SaleId == auctionid).SingleOrDefault();
auction.SaleId = auxauction.SaleId;
auction.StartDate = auxauction.StartDate;
auction.EndDate = auxauction.EndDate;
auction.Location = auxauction.Location;
auction.ItemId = auxauction.ItemId;
auction.SaleValue = auxauction.SaleValue;
auction.MinIncrement = auxauction.MinIncrement;
}
return(auction);
}
internal static IEnumerable <Shared.DTODefinition.IDtoObject> GetTableItemPage(int startRecord, int numRecords)
{
try
{
int idx = 0;
LinkedList <BidSoftware.Shared.DTODefinition.Item> li = new LinkedList <BidSoftware.Shared.DTODefinition.Item>();
using (var ctx = new SI2_Entities())
{
foreach (var item in ctx.vItems.Where(p => (p.ROW_NR >= startRecord) && (p.ROW_NR <= startRecord + numRecords)))
{
BidSoftware.Shared.DTODefinition.Item it = new BidSoftware.Shared.DTODefinition.Item();
it.ItemId = item.ItemId;
it.Description = item.Description;
it.ItemConditionId = item.ItemConditionId;
it.UserEmail = item.UserEmail;
li.AddLast(it);
}
}
return(li);
}
catch (Exception ex) { throw new DisconnectException(ex.Message, ex); }
}
public static IEnumerable <IDtoObject> GetTableUserPage(int startRecord, int numRecords)
{
try
{
LinkedList <BidSoftware.Shared.DTODefinition.User> li = new LinkedList <BidSoftware.Shared.DTODefinition.User>();
BidSoftware.Shared.DTODefinition.User u;
using (var ctx = new SI2_Entities())
{
foreach (var user in ctx.vUsers.Where(p => (p.ROW_NR >= startRecord) && (p.ROW_NR <= startRecord + numRecords)))
{
u = new BidSoftware.Shared.DTODefinition.User();
u.Address = user.Address;
u.CountryNum = user.CountryNum;
u.Email = user.Email;
u.Name = user.Name;
u.Password = ConvertUtils.GetByteString((byte[])user.Password);
li.AddLast(u);
}
}
return(li);
}
catch (Exception ex) { throw new DisconnectException(ex.Message, ex); }
}
internal static IEnumerable <Shared.DTODefinition.IDtoObject> GetTableBidPage(int startRecord, int numRecords)
{
try
{
LinkedList <BidSoftware.Shared.DTODefinition.Bid> li = new LinkedList <BidSoftware.Shared.DTODefinition.Bid>();
BidSoftware.Shared.DTODefinition.Bid b;
using (var ctx = new SI2_Entities())
{
foreach (var bid in ctx.vBids.Where(p => (p.ROW_NR >= startRecord) && (p.ROW_NR <= startRecord + numRecords)))
{
b = new BidSoftware.Shared.DTODefinition.Bid();
b.BidId = bid.BidId;
b.Deleted = bid.Deleted;
b.SaleId = bid.SaleId;
b.Stamp = b.Stamp;
b.UserEmail = b.UserEmail;
b.Value = b.Value;
li.AddLast(b);
}
}
return(li);
}
catch (Exception ex) { throw new DisconnectException(ex.Message, ex); }
}
