//public static List<string> getItemInfoById(int itemId) {
// List<string> list = new List<string>();
// Entity.Items items = new BLL.Items().GetSingleItem(itemId);
// list.Add(items.getItemID().ToString());
// list.Add(items.getProductID().ToString());
// list.Add(items.getBrandID().ToString());
// list.Add(items.getName());
// list.Add(items.getAgoraPrice());
// list.Add(items.getSeckillPrice().ToString());
// list.Add(items.getMemberPrice().ToString());
// list.Add(items.getVipPrice());
// list.Add(items.getArea());
// list.Add(items.getDetails());
// list.Add(items.getDays());
// list.Add(items.getHours());
// list.Add(items.getMinutes());
// list.Add(items.getSeconds());
// list.Add(items.getIsSecondKill());
// return list;
//}
//public static List<string> getAllItemsInfoWithImages()
//{
// List<string> list = new List<string>();
// DataSet ds = new BLL.PicturesItem().GetImageWithItems();
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// list.Add(dr[0].ToString());//Images.ItemID
// list.Add(dr[1].ToString());//dbo.Images.ImageID
// list.Add(dr[2].ToString());//dbo.Images.SmallImg
// list.Add(dr[3].ToString());//dbo.Images.BigImg
// list.Add(dr[4].ToString());//dbo.Images.Alt
// list.Add(dr[5].ToString());//dbo.ItemsAllWithNoImg.BID
// list.Add(dr[6].ToString());//dbo.ItemsAllWithNoImg.BrandName
// // list.Add(dr[7].ToString());//dbo.ItemsAllWithNoImg.ProductID
// //list.Add(dr[8].ToString());//dbo.ItemsAllWithNoImg.ItemID AS IID
// //list.Add(dr[9].ToString());//dbo.ItemsAllWithNoImg.AgoraPrice
// //list.Add(dr[10].ToString());//dbo.ItemsAllWithNoImg.Area
// //list.Add(dr[11].ToString());//dbo.ItemsAllWithNoImg.PName
// //list.Add(dr[12].ToString());//dbo.ItemsAllWithNoImg.PID
// //list.Add(dr[13].ToString());//dbo.ItemsAllWithNoImg.ItemName
// //list.Add(dr[14].ToString());//dbo.ItemsAllWithNoImg.CName
// //list.Add(dr[15].ToString());//dbo.ItemsAllWithNoImg.Hours
// //list.Add(dr[16].ToString());//dbo.ItemsAllWithNoImg.Days
// //list.Add(dr[17].ToString());//dbo.ItemsAllWithNoImg.SeckillPrice
// //list.Add(dr[18].ToString());//dbo.ItemsAllWithNoImg.IsSecondKill
// //list.Add(dr[19].ToString());// dbo.ItemsAllWithNoImg.Seconds,
// //list.Add(dr[20].ToString());// dbo.ItemsAllWithNoImg.Minutes,
// //list.Add(dr[21].ToString());//dbo.ItemsAllWithNoImg.Details,
// //list.Add(dr[22].ToString());//dbo.ItemsAllWithNoImg.MemberPrice,
// //list.Add(dr[23].ToString());//dbo.ItemsAllWithNoImg.VipPrice,
// //list.Add(dr[24].ToString());//dbo.ItemsAllWithNoImg.CategoryID,
// //list.Add(dr[25].ToString()); //dbo.ItemsAllWithNoImg.Fresh
// }
// return list;
//}
public static List <string> getItemsWithNoImgByItemID(int itemID)
{
List <string> list = new List <string>();
DataSet ds = new BLL.Items().GetItemByAllWithNoImgByItemID(itemID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(dr[0].ToString()); //BID,
list.Add(dr[1].ToString()); //ProductID,
list.Add(dr[2].ToString()); //ItemID,
list.Add(dr[3].ToString()); //VipPrice,
list.Add(dr[4].ToString()); //MemberPrice,
list.Add(dr[5].ToString()); //Details,
list.Add(dr[6].ToString()); //Minutes
list.Add(dr[7].ToString()); //Seconds,
list.Add(dr[8].ToString()); //AgoraPrice,
list.Add(dr[9].ToString()); //Area,
list.Add(dr[10].ToString()); //SeckillPrice,
list.Add(dr[11].ToString()); //Days
list.Add(dr[12].ToString()); //Hours,
list.Add(dr[13].ToString()); //CategoryID,
list.Add(dr[14].ToString()); //PName,
list.Add(dr[15].ToString()); //PID,
list.Add(dr[16].ToString()); //CName,
list.Add(dr[17].ToString()); //ItemName,
list.Add(dr[18].ToString()); //BrandName,
list.Add(dr[19].ToString()); //Fresh,
list.Add(dr[20].ToString()); //IsSecondKill
}
return(list);
}
//public static List<string> getItemInfoById(int itemId) {
// List<string> list = new List<string>();
// Entity.Items items = new BLL.Items().GetSingleItem(itemId);
// list.Add(items.getItemID().ToString());
// list.Add(items.getProductID().ToString());
// list.Add(items.getBrandID().ToString());
// list.Add(items.getName());
// list.Add(items.getAgoraPrice());
// list.Add(items.getSeckillPrice().ToString());
// list.Add(items.getMemberPrice().ToString());
// list.Add(items.getVipPrice());
// list.Add(items.getArea());
// list.Add(items.getDetails());
// list.Add(items.getDays());
// list.Add(items.getHours());
// list.Add(items.getMinutes());
// list.Add(items.getSeconds());
// list.Add(items.getIsSecondKill());
// return list;
//}
//public static List<string> getAllItemsInfoWithImages()
//{
// List<string> list = new List<string>();
// DataSet ds = new BLL.PicturesItem().GetImageWithItems();
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// list.Add(dr[0].ToString());//Images.ItemID
// list.Add(dr[1].ToString());//dbo.Images.ImageID
// list.Add(dr[2].ToString());//dbo.Images.SmallImg
// list.Add(dr[3].ToString());//dbo.Images.BigImg
// list.Add(dr[4].ToString());//dbo.Images.Alt
// list.Add(dr[5].ToString());//dbo.ItemsAllWithNoImg.BID
// list.Add(dr[6].ToString());//dbo.ItemsAllWithNoImg.BrandName
// // list.Add(dr[7].ToString());//dbo.ItemsAllWithNoImg.ProductID
// //list.Add(dr[8].ToString());//dbo.ItemsAllWithNoImg.ItemID AS IID
// //list.Add(dr[9].ToString());//dbo.ItemsAllWithNoImg.AgoraPrice
// //list.Add(dr[10].ToString());//dbo.ItemsAllWithNoImg.Area
// //list.Add(dr[11].ToString());//dbo.ItemsAllWithNoImg.PName
// //list.Add(dr[12].ToString());//dbo.ItemsAllWithNoImg.PID
// //list.Add(dr[13].ToString());//dbo.ItemsAllWithNoImg.ItemName
// //list.Add(dr[14].ToString());//dbo.ItemsAllWithNoImg.CName
// //list.Add(dr[15].ToString());//dbo.ItemsAllWithNoImg.Hours
// //list.Add(dr[16].ToString());//dbo.ItemsAllWithNoImg.Days
// //list.Add(dr[17].ToString());//dbo.ItemsAllWithNoImg.SeckillPrice
// //list.Add(dr[18].ToString());//dbo.ItemsAllWithNoImg.IsSecondKill
// //list.Add(dr[19].ToString());// dbo.ItemsAllWithNoImg.Seconds,
// //list.Add(dr[20].ToString());// dbo.ItemsAllWithNoImg.Minutes,
// //list.Add(dr[21].ToString());//dbo.ItemsAllWithNoImg.Details,
// //list.Add(dr[22].ToString());//dbo.ItemsAllWithNoImg.MemberPrice,
// //list.Add(dr[23].ToString());//dbo.ItemsAllWithNoImg.VipPrice,
// //list.Add(dr[24].ToString());//dbo.ItemsAllWithNoImg.CategoryID,
// //list.Add(dr[25].ToString()); //dbo.ItemsAllWithNoImg.Fresh
// }
// return list;
//}
public static List<string> getItemsWithNoImgByItemID(int itemID)
{
List<string> list = new List<string>();
DataSet ds = new BLL.Items().GetItemByAllWithNoImgByItemID(itemID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
list.Add(dr[0].ToString());//BID,
list.Add(dr[1].ToString());//ProductID,
list.Add(dr[2].ToString());//ItemID,
list.Add(dr[3].ToString());//VipPrice,
list.Add(dr[4].ToString());//MemberPrice,
list.Add(dr[5].ToString());//Details,
list.Add(dr[6].ToString());//Minutes
list.Add(dr[7].ToString());//Seconds,
list.Add(dr[8].ToString());//AgoraPrice,
list.Add(dr[9].ToString());//Area,
list.Add(dr[10].ToString());//SeckillPrice,
list.Add(dr[11].ToString());//Days
list.Add(dr[12].ToString());//Hours,
list.Add(dr[13].ToString());//CategoryID,
list.Add(dr[14].ToString());//PName,
list.Add(dr[15].ToString());//PID,
list.Add(dr[16].ToString());//CName,
list.Add(dr[17].ToString());//ItemName,
list.Add(dr[18].ToString());//BrandName,
list.Add(dr[19].ToString());//Fresh,
list.Add(dr[20].ToString());//IsSecondKill
}
return list;
}
public async Task <IHttpActionResult> Get()
{
var bll = new BLL.Items();
var result = await bll.GetAsync();
return(Ok <IEnumerable <Entities.Item> >(result));
}
public async Task <IHttpActionResult> Add(Entities.Item Item)
{
Item.Code = 0; // enforce NEW item
var bll = new BLL.Items();
return(Ok <int>(await bll.SaveAsync(Item)));
}
public HomeController(BLL.ActiveAuctions bllActiveAuctions, BLL.Events bllEvents, BLL.Items bllItems, BLL.BidHistories bllBidHistories, BLL.Users bllUsers, BLL.Withdraws bllWithdraws)
{
_bllActiveAuctions = bllActiveAuctions;
_bllEvents = bllEvents;
_bllItems = bllItems;
_bllBidHistories = bllBidHistories;
_bllUsers = bllUsers;
_bllWithdraws = bllWithdraws;
}
public static void DeleteList(List <int> list)
{
BLL.Items bv = new BLL.Items();
foreach (int v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v);
// if the entry doesn't exist, create it
if (bv.RowCount > 0)
{
bv.MarkAsDeleted();
bv.Save();
}
// populate the contents of v on the to the database list
}
}
public static void SaveList(List<HCMIS.Desktop.DirectoryServices.Items> list)
{
bool isNew = false;
BLL.Items bv = new BLL.Items();
foreach (HCMIS.Desktop.DirectoryServices.Items v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v.ID.Value);
// if the entry doesn't exist, create it
if (bv.RowCount == 0)
{
isNew = true;
bv.AddNew();
bv.IsFree = true;
}
// populate the contents of v on the to the database list
if (v.ID.HasValue)
bv.ID = v.ID.Value;
if (v.StockCode != "" && v.StockCode != null)
bv.StockCode = v.StockCode;
if (v.Strength != "" && v.Strength != null)
bv.Strength = v.Strength;
else
bv.SetColumnNull("Strength");
if (v.DosageFormID.HasValue)
bv.DosageFormID = v.DosageFormID.Value;
else
bv.SetColumnNull("DosageFormID");
if (v.UnitID.HasValue)
bv.UnitID = v.UnitID.Value;
if (v.VEN.HasValue)
bv.VEN = v.VEN.Value;
else
bv.VEN = 1;
if (v.ABC.HasValue)
bv.ABC = v.ABC.Value;
else
bv.ABC = 1;
if (v.QtyPerPack.HasValue)
bv.Cost = v.QtyPerPack.Value;
if (v.EDL.HasValue)
bv.EDL = v.EDL.Value;
if (v.Pediatric.HasValue)
bv.Pediatric = v.Pediatric.Value;
if (v.IINID.HasValue)
bv.IINID = v.IINID.Value;
if (v.NeedExpiryBatch.HasValue)
{
bv.NeedExpiryBatch = v.NeedExpiryBatch.Value;
}
else
{
bv.NeedExpiryBatch = false;
}
if (v.Code != "" && v.Code != null)
bv.Code = v.Code;
if (v.StockCodeDACA != "" && v.StockCodeDACA != null)
bv.StockCodeDACA = v.StockCodeDACA;
if (v.NearExpiryTrigger.HasValue)
bv.NearExpiryTrigger = v.NearExpiryTrigger.Value;
if (v.StorageTypeID.HasValue && isNew)
bv.StorageTypeID = v.StorageTypeID.Value;
if (v.IsStackStored.HasValue && isNew)
bv.IsStackStored = v.IsStackStored.Value;
bv.Save();
}
}
public static List<Items> GetAll()
{
BLL.Items v = new BLL.Items();
v.LoadAll();
return ToList(v);
}
public static void DeleteList(List<int> list)
{
BLL.Items bv = new BLL.Items();
foreach (int v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v);
// if the entry doesn't exist, create it
if (bv.RowCount > 0)
{
bv.MarkAsDeleted();
bv.Save();
}
// populate the contents of v on the to the database list
}
}
public async Task <IHttpActionResult> Update(int Code)
{
var bll = new BLL.Items();
return(Ok <bool>(await bll.DeleteAsync(Code)));
}
public async Task <IHttpActionResult> Update(Entities.Item Item)
{
var bll = new BLL.Items();
return(Ok <int>(await bll.SaveAsync(Item)));
}
public static List <Items> ToList(BLL.Items v)
{
List <Items> list = new List <Items>();
while (!v.EOF)
{
Items t = new Items();
if (!v.IsColumnNull("ID"))
{
t.ID = v.ID;
}
if (!v.IsColumnNull("StockCode"))
{
t.StockCode = v.StockCode;
}
if (!v.IsColumnNull("Strength"))
{
t.Strength = v.Strength;
}
if (!v.IsColumnNull("DosageFormID"))
{
t.DosageFormID = v.DosageFormID;
}
if (!v.IsColumnNull("UnitID"))
{
t.UnitID = v.UnitID;
}
if (!v.IsColumnNull("VEN"))
{
t.VEN = v.VEN;
}
if (!v.IsColumnNull("ABC"))
{
t.ABC = v.ABC;
}
if (!v.IsColumnNull("Cost"))
{
t.Cost = v.Cost;
}
if (!v.IsColumnNull("EDL"))
{
t.EDL = v.EDL;
}
if (!v.IsColumnNull("Pediatric"))
{
t.Pediatric = v.Pediatric;
}
if (!v.IsColumnNull("IINID"))
{
t.IINID = v.IINID;
}
if (!v.IsColumnNull("NeedExpiryBatch"))
{
t.NeedExpiryBatch = v.NeedExpiryBatch;
}
if (!v.IsColumnNull("Code"))
{
t.Code = v.Code;
}
if (!v.IsColumnNull("StockCodeDACA"))
{
t.StockCodeDACA = v.StockCodeDACA;
}
if (!v.IsColumnNull("NearExpiryTrigger"))
{
t.NearExpiryTrigger = v.NearExpiryTrigger;
}
if (!v.IsColumnNull("StorageTypeID"))
{
t.StorageTypeID = v.StorageTypeID;
}
if (!v.IsColumnNull("IsStackStored"))
{
t.IsStackStored = v.IsStackStored;
}
list.Add(t);
v.MoveNext();
}
return(list);
}
public EventController(BLL.Events bllEvents, BLL.Items bllItems, BLL.AuctionData bllAuctionData)
{
_bllEvents = bllEvents;
_bllItems = bllItems;
_bllAuctionData = bllAuctionData;
}
public ItemController(BLL.Items bllItems)
{
_bllItems = bllItems;
}
public static void SaveList(List <HCMIS.Desktop.DirectoryServices.Items> list)
{
bool isNew = false;
BLL.Items bv = new BLL.Items();
foreach (HCMIS.Desktop.DirectoryServices.Items v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v.ID.Value);
// if the entry doesn't exist, create it
if (bv.RowCount == 0)
{
isNew = true;
bv.AddNew();
bv.IsFree = true;
}
// populate the contents of v on the to the database list
if (v.ID.HasValue)
{
bv.ID = v.ID.Value;
}
if (v.StockCode != "" && v.StockCode != null)
{
bv.StockCode = v.StockCode;
}
if (v.Strength != "" && v.Strength != null)
{
bv.Strength = v.Strength;
}
else
{
bv.SetColumnNull("Strength");
}
if (v.DosageFormID.HasValue)
{
bv.DosageFormID = v.DosageFormID.Value;
}
else
{
bv.SetColumnNull("DosageFormID");
}
if (v.UnitID.HasValue)
{
bv.UnitID = v.UnitID.Value;
}
if (v.VEN.HasValue)
{
bv.VEN = v.VEN.Value;
}
else
{
bv.VEN = 1;
}
if (v.ABC.HasValue)
{
bv.ABC = v.ABC.Value;
}
else
{
bv.ABC = 1;
}
if (v.QtyPerPack.HasValue)
{
bv.Cost = v.QtyPerPack.Value;
}
if (v.EDL.HasValue)
{
bv.EDL = v.EDL.Value;
}
if (v.Pediatric.HasValue)
{
bv.Pediatric = v.Pediatric.Value;
}
if (v.IINID.HasValue)
{
bv.IINID = v.IINID.Value;
}
if (v.NeedExpiryBatch.HasValue)
{
bv.NeedExpiryBatch = v.NeedExpiryBatch.Value;
}
else
{
bv.NeedExpiryBatch = false;
}
if (v.Code != "" && v.Code != null)
{
bv.Code = v.Code;
}
if (v.StockCodeDACA != "" && v.StockCodeDACA != null)
{
bv.StockCodeDACA = v.StockCodeDACA;
}
if (v.NearExpiryTrigger.HasValue)
{
bv.NearExpiryTrigger = v.NearExpiryTrigger.Value;
}
if (v.StorageTypeID.HasValue && isNew)
{
bv.StorageTypeID = v.StorageTypeID.Value;
}
if (v.IsStackStored.HasValue && isNew)
{
bv.IsStackStored = v.IsStackStored.Value;
}
bv.Save();
}
}
private void ItemCleaning_Load(object sender, EventArgs e)
{
BLL.Items itm = new BLL.Items();
grdItems.DataSource = itm.GetAllItem();
}
private void ItemCleaning_Load(object sender, EventArgs e)
{
BLL.Items itm = new BLL.Items();
grdItems.DataSource = itm.GetAllItem();
}
public static List <Items> GetAll()
{
BLL.Items v = new BLL.Items();
v.LoadAll();
return(ToList(v));
}
