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();
}
