//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(); }
public static List <Items> GetAll() { BLL.Items v = new BLL.Items(); v.LoadAll(); return(ToList(v)); }