public JsonResult SaveMealChart(List <MealList> mealList) { ItemGateway itemGateway = new ItemGateway(); itemGateway.saveMealList(mealList); return(Json("success", JsonRequestBehavior.AllowGet)); }
public JsonResult getBajarListByMemberId(string date, Guid memberId) { ItemGateway itemGateway = new ItemGateway(); var bajarlist = itemGateway.getBajarListBymemberId(date, memberId); return(Json(bajarlist, JsonRequestBehavior.AllowGet)); }
public List <ItemsModel> itemlistBoxData() { ItemGateway itemGateway = new ItemGateway(); List <ItemsModel> itemslist = null; ItemListBox.Items.Clear(); if (companyListBox.SelectedValue == null && catagoryListBox.SelectedValue != null) { int id = Convert.ToInt32(catagoryListBox.SelectedValue); itemslist = itemGateway.GetItemsByCatagoryID(id); return(itemslist); } if (companyListBox.SelectedValue != null && catagoryListBox.SelectedValue != null) { int catagoryid = Convert.ToInt32(catagoryListBox.SelectedValue); int companyid = Convert.ToInt32(companyListBox.SelectedValue); itemslist = itemGateway.GetItemsByCompanyandCatagoryID(catagoryid, companyid); return(itemslist); } if (catagoryListBox.SelectedValue == null && companyListBox.SelectedValue != null) { int companyid = Convert.ToInt32(companyListBox.SelectedValue); itemslist = itemGateway.GetItemsByCompanyID(companyid); return(itemslist); } return(itemslist); }
public JsonResult getAllMealChatList() { ItemGateway itemGateway = new ItemGateway(); var list = itemGateway.getAllMealList(); return(Json(list, JsonRequestBehavior.AllowGet)); }
private void ItemListBox_SelectionChangeCommitted(object sender, EventArgs e) { ItemGateway itemGateway = new ItemGateway(); int id = Convert.ToInt32(ItemListBox.SelectedValue); if (ItemListBox.SelectedValue != null) { ItemsModel itemsModel = itemGateway.GetItemsByID(id); { outItemIdHidden.Text = itemsModel.Id.ToString(); priceTextBox.Text = itemsModel.Price.ToString(); availAbleQuatityTextBox.Text = itemsModel.StockAQ.ToString(); // Create Empty Value outQuantityTextBox.Text = String.Empty; discountPercentTextBox.Text = String.Empty; discountPriceTexBox.Text = String.Empty; netBillTexBox.Text = String.Empty; vatPercentTextBox.Text = String.Empty; vatPriceTextBox.Text = String.Empty; } } }
public JsonResult saveBajarList(List <BajarList> itemlist) { ItemGateway itemGateway = new ItemGateway(); itemGateway.saveBajarList(itemlist); return(Json("Succesfuly Added the List", JsonRequestBehavior.AllowGet)); }
public JsonResult getMember() { ItemGateway itemgateway = new ItemGateway(); var memberList = itemgateway.getAllMember(); return(Json(memberList, JsonRequestBehavior.AllowGet)); }
public string Update(int itemId, int quantity) { int rowAffect = ItemGateway.Update(itemId, quantity); if (rowAffect > 0) { return("Save Successful"); } else { return("Save Failed"); } }
} // property Recipes public FittingBase(long itemID) { ID = itemID; if (ID > 0) { Fitting itemRecord = ItemGateway.FittingGetByID(itemID); Name = itemRecord.displayName; Description = itemRecord.displayDescription; } // if (ID > 0) else { Name = "n/a"; Description = "n/a"; } } // constructor
} // property Recipes public BlueprintBase(long itemID) { ID = itemID; if (ID > 0) { Structure itemRecord = ItemGateway.BlueprintGetByID(itemID); Name = itemRecord.displayName; IsHousingStructure = itemRecord.isHousingStructure > 0; IsSiegingUnit = itemRecord.isSiegingUnit > 0; } // if (ID > 0) else { Name = "n/a"; } } // constructor
public ItemStackInfo(long itemID) { Item_Stackable stackObject = ItemGateway.ItemStackInfoGetByItemID(itemID); if (stackObject == null) { IsStackable = false; DefaultStackSize = 0; MaxStackSize = 0; } else { IsStackable = true; DefaultStackSize = (long)stackObject.defaultStackSize; MaxStackSize = (long)stackObject.maxStackSize; } } // constructor
private void itemDeleteButton_Click(object sender, EventArgs e) { if (!CN.IsMatch(itemNameTextBox.Text.Trim()) || !Nu.IsMatch(itemPriceTextBox.Text.Trim())) { cMessageBox.Information("Please Select al Least One Item Two Delete"); } else { if (cMessageBox.Quiestion("Are sure to delete this?")) { string id = itemsIdHidden.Text.Trim(); ItemGateway itemGateway = new ItemGateway(); itemGateway.DeleteItem(id); ItemSetup_Load(sender, e); } } }
// Action code goes here public string StockOutByType(string Type) { ItemGateway stockOutGateway = new ItemGateway(); foreach (StockOutModel stockOut in listofStockOut) { StockOutModel stockOutModel = new StockOutModel(); stockOutModel.Quantity = stockOut.Quantity; stockOutModel.ItemId = stockOut.ItemId; stockOutModel.Type = Type; stockOutModel.Price = stockOut.Price; stockOutModel.Date = stockOut.Date; stockOutGateway.StockOut(stockOutModel); stockOutGateway.UpdateAfterStockOut(stockOut); } return("Stock Out Successfully by : " + Type); }
public JsonResult BajarListView() { ItemListView itemlistview = new ItemListView(); List <CategoryInfo> categoris = new List <CategoryInfo>(); ItemGateway itemGateway = new ItemGateway(); var categoryList = itemGateway.GetCategory(); foreach (Category1 category in categoryList) { CategoryInfo categoryInfo = new CategoryInfo(); categoryInfo.ItemList = itemGateway.getItemList(category.Id); categoryInfo.CategoryName = category.Name; categoris.Add(categoryInfo); } itemlistview.CategoryList = categoris; return(Json(itemlistview, JsonRequestBehavior.AllowGet)); }
public ItemPowerSource(long itemID) { Item_Power_Source powerSource = ItemGateway.PowerSourceInfoGetByItemID(itemID); Item_Stores_Power powerStorage = ItemGateway.PowerStorageInfoGetByItemID(itemID); if (powerSource == null || powerStorage == null) { StoresPower = false; PowerIndex = 0; MaxStorage = 0; } else { StoresPower = true; PowerIndex = powerSource.powerIndex; MaxStorage = powerStorage.maxStorage; } } // constructor
public string Save(Item item) { if (ItemGateway.IsItemExist(item.Name, item.CompanyId, item.CategoryId)) { return("Item Is Already Exists."); } else { int rowAffect = ItemGateway.Save(item); if (rowAffect > 0) { return("Save Successful"); } else { return("Save Failed"); } } }
private void itemUpdateButton_Click(object sender, EventArgs e) { if (CN.IsMatch(itemNameTextBox.Text.Trim()) || Nu.IsMatch(itemPriceTextBox.Text.Trim())) { ItemGateway itemGateway = new ItemGateway(); ItemsModel itemsModel = new ItemsModel(); itemsModel.Name = itemNameTextBox.Text.Trim(); itemsModel.Price = Convert.ToDecimal(itemPriceTextBox.Text.Trim()); itemsModel.Id = Convert.ToInt32(itemsIdHidden.Text.Trim()); int rowAffect = itemGateway.UpdateItem(itemsModel); if (rowAffect > 0) { cMessageBox.Success("Items Name and Price Updated"); ItemSetup_Load(sender, e); } else { cMessageBox.Failed("Failed to Update"); } } }
private void ItemListBox_SelectionChangeCommitted(object sender, EventArgs e) { itemIdHidden.Text = ""; priceTextBox.Text = ""; availAbleQuatityTextBox.Text = null; ItemGateway itemGateway = new ItemGateway(); int id = Convert.ToInt32(ItemListBox.SelectedValue); if (ItemListBox.SelectedValue != null) { ItemsModel itemsModel = itemGateway.GetItemsByID(id); { itemIdHidden.Text = itemsModel.Id.ToString(); priceTextBox.Text = itemsModel.Price.ToString(); availAbleQuatityTextBox.Text = itemsModel.StockAQ.ToString(); int quantity = Convert.ToInt32(availAbleQuatityTextBox.Text); int price = Convert.ToInt32(priceTextBox.Text); int totaprice = quantity * price; totalPriceTextBox.Text = totaprice.ToString(); } } }
private void stockinButton_Click(object sender, EventArgs e) { if (!inte.IsMatch(stockInQuatityTextBox.Text.Trim()) || catagoryListBox.SelectedValue == null || companyListBox.SelectedValue == null || ItemListBox.SelectedValue == null) { messageBox.Information("Please Make Sure That Your input is Correct!"); } else { ItemGateway itemGateway = new ItemGateway(); ItemsModel itemStockin = new ItemsModel(); try { itemStockin.Id = Convert.ToInt32(itemIdHidden.Text); itemStockin.StockAQ = Convert.ToInt32(stockInQuatityTextBox.Text); int rowAffect = itemGateway.StockIn(itemStockin); if (rowAffect > 0) { messageBox.Success("Stock In Successfull"); StockIn_Load(sender, e); } else { messageBox.Failed("Faild to Stock In, Pleasy Try Again"); StockIn_Load(sender, e); } } catch (Exception) { messageBox.Failed("Something went wrong"); } } }
public async Task Can_Create_Update_Delete_Find_Item() { ItemGateway gateway = new ItemGateway(TestHelpers.ConnectionString); string itemName = TestHelpers.RandomTestName(); int unitPrice = 1025; var itemResult = await gateway.AddItem(itemName, unitPrice); Assert.That(itemResult.Status, Is.EqualTo(Status.Created)); int itemId = itemResult.Content; Result <Item> item; { item = await gateway.FindItemById(itemId); CheckItem(item, itemName, unitPrice); } { itemName = TestHelpers.RandomTestName(); unitPrice = 525; await gateway.UpdateItem(itemId, itemName, unitPrice); item = await gateway.FindItemById(itemId); CheckItem(item, itemName, unitPrice); } { int row = await gateway.DeleteItem(itemId); Assert.That(row, Is.EqualTo(1)); item = await gateway.FindItemById(itemId); Assert.That(item.Status, Is.EqualTo(Status.NotFound)); } }
public void ShowList() { ItemGateway itemGateway = new ItemGateway(); List <ItemsModel> itemslist = null; itemsGridview.Rows.Clear(); itemslist = itemGateway.GetAllItems(); if (itemslist != null) { itemsGridview.ColumnCount = 7; itemsGridview.Columns[0].Name = "SL"; itemsGridview.Columns[0].Width = 60; itemsGridview.Columns[1].Name = "Category"; itemsGridview.Columns[1].Width = 60; itemsGridview.Columns[2].Name = "Company"; itemsGridview.Columns[2].Width = 60; itemsGridview.Columns[3].Name = "Items Name"; itemsGridview.Columns[3].Width = 100; itemsGridview.Columns[4].Name = "Price"; itemsGridview.Columns[4].Width = 100; itemsGridview.Columns[5].Name = "Av. Quantity"; itemsGridview.Columns[5].Width = 100; itemsGridview.Columns[6].Name = "Total Price"; itemsGridview.Columns[6].Width = 100; int rn = 0; foreach (ItemsModel items in itemslist) { int inc = itemslist.Count; if (inc > rn) { rn++; } itemsGridview.Rows.Add(rn, items.Catagory, items.Company, items.Name, items.Price, items.StockAQ, items.Price * items.StockAQ); } } }
public Item GetItemById(int id) { return(ItemGateway.GetItemById(id)); }
public ItemManager() { itemGateway = new ItemGateway(); companyGateway = new CompanyGateway(); categoryGateway = new CategoryGateway(); }
public ItemController(ItemGateway itemGateway) { _itemGateway = itemGateway; }
protected void Page_Load(object sender, EventArgs e) { rpt_Fittings.DataSource = ItemGateway.GetAllFittings(); rpt_Fittings.DataBind(); } // method Page_Load
protected void Page_Load(object sender, EventArgs e) { rpt_Blueprints.DataSource = ItemGateway.GetAllBlueprints(); rpt_Blueprints.DataBind(); } // method Page_Load
public ItemManager() { ItemGateway = new ItemGateway(); }
public ItemController(ItemGateway gateway) => Gateway = gateway;
public List <Item> GetItemsByCompanyCategory(int companyId, int categoryId) { return(ItemGateway.GetItemsByCompanyCategory(companyId, categoryId)); }
public ItemManager() { itemGateway = new ItemGateway(); stockInGateway = new StockInGateway(); }