protected void btnAddItem_Click(object sender, EventArgs e)
{
try
{
ItemBO ib = new ItemBO();
List <String> list = bl.ListItemNumber(); //check
//Check if item number already exists
if (list.Contains(txtItemNumber.Text))
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Unsuccessful! Please choose a new item number.')", true);
}
else
{
ib.ItemNumber = txtItemNumber.Text;
ib.CategoryID = int.Parse(ddlCategory.SelectedValue);
ib.ReorderLevel = Convert.ToInt32(txtReorderlevel.Text);
ib.ReorderQty = Convert.ToInt32(txtReorderQty.Text);
ib.UnitOfMeasure = txtUOM.Text;
ib.Description = txtDescription.Text;
ib.Bin = txtBin.Text;
bl.addItem(ib);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Success! Item is added.');window.location='InventoryPage.aspx';", true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
//Get all item information and category by item number
public ItemBO getItemByItemNumber(string itemNumber)
{
//Retrieve Item Object and Category Object
Item i = eiDA.getItemBYItemNumber(itemNumber);
if (i == null)
{
return(null);
}
else
{
Category c = eiDA.getCategoryBYID(i.CategoryID);
//Then assign to ItemBO object again
ItemBO itemObj = new ItemBO();
itemObj.ItemID = i.ItemID;
itemObj.ItemNumber = i.ItemNumber;
itemObj.CategoryID = i.CategoryID;
itemObj.Description = i.Description;
itemObj.InStockQty = i.InStockQty;
itemObj.ReorderLevel = i.ReorderLevel;
itemObj.ReorderQty = i.ReorderQty;
itemObj.UnitOfMeasure = i.UnitOfMeasure;
itemObj.Bin = i.Bin;
itemObj.CategoryName = c.CategoryName;
return(itemObj);
}
}
protected void spinItemTax_Load(object sender, EventArgs e)
{
ASPxSpinEdit spin = sender as ASPxSpinEdit;
ASPxCallbackPanel panel = spin.NamingContainer as ASPxCallbackPanel;
//Set data when in edit mode
if (gridviewBillItem.IsEditing && !gridviewBillItem.IsNewRowEditing && !panel.IsCallback)
{
var billItemId = (panel.NamingContainer
as DevExpress.Web.ASPxGridView.GridViewDataItemTemplateContainer).KeyValue;
object itemId = gridviewBillItem.GetRowValuesByKeyValue(billItemId, "ItemId!Key");
if (itemId == DBNull.Value)
{
return;
}
ItemBO itemBO = new ItemBO();
ItemTax itemTax = itemBO.GetCurrentVATOfItem(session, (Guid)itemId);
if (itemTax != null)
{
spin.Number = (decimal)itemTax.TaxId.Percentage;
}
else
{
spin.Number = 0;
}
}
}
public Item ConvertBO(ItemBO itemBO)
{
if (itemBO == null)
{
return(null);
}
return(new Item()
{
Id = itemBO.Id,
ItemName = itemBO.ItemName,
DangerousGoods = itemBO.DangerousGoods,
Dimension = itemBO.Dimension,
Weight = itemBO.Weight,
PackItems = itemBO.PackItemsIds?.Select(piID => new PackItem()
{
ItemId = itemBO.Id
}).ToList(),
ColliItems = itemBO.ColliItems?.Select(ciID => new ColliItem()
{
ItemId = itemBO.Id
}).ToList(),
FreightConditions = itemBO.FreightConditionIds?.Select(fcID => new ItemFreightCondition()
{
FreightConditionID = fcID,
ItemID = itemBO.Id
}).ToList()
});
}
public void save(ItemBO item)
{
String connectionstring = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Hassan\Desktop\POS-EAD-2\POS\MyDatabase.mdf;Integrated Security=True";
SqlConnection con = new SqlConnection(connectionstring);
String query = "insert into item(description,price,quantity,creationdate) values(@des,@pri,@quan,@create);";
SqlParameter p1 = new SqlParameter("des", item.Description);
SqlParameter p2 = new SqlParameter("pri", item.Price);
SqlParameter p3 = new SqlParameter("quan", item.Quantity);
SqlParameter p4 = new SqlParameter("create", item.Date);
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public void UpdatePassTest()
{
try
{
var originalItem = getItemMock();
originalItem = service.Create(originalItem);
var newItem = new ItemBO();
newItem.Id = originalItem.Id;
newItem.ItemName = originalItem.ItemName;
newItem.Dimension = originalItem.Dimension;
newItem.Weight = originalItem.Weight;
newItem.DangerousGoods = originalItem.DangerousGoods;
newItem.ItemName = "Bottle";
newItem = service.Update(newItem);
var updatedItem = service.Get(originalItem.Id);
Assert.Equal(originalItem.Id, newItem.Id);
Assert.Equal("Bottle", newItem.ItemName);
Assert.Equal(newItem.ItemName, updatedItem.ItemName);
Assert.NotEqual(originalItem.ItemName, newItem.ItemName);
}
catch (Exception e)
{
Assert.True(false, e.Message);
}
finally
{
clearDb();
}
}
public Guid InsertItem(ItemBO item)
{
try
{
string sql = "dbo.fn_insert_tms_item";
conn = new NpgsqlConnection(connString);
conn.Open();
using (var cmd = new NpgsqlCommand(sql, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("_itemid", NpgsqlTypes.NpgsqlDbType.Varchar, item.itemid);
cmd.Parameters.AddWithValue("_description", NpgsqlTypes.NpgsqlDbType.Varchar, item.description);
cmd.Parameters.AddWithValue("_itemtype", NpgsqlTypes.NpgsqlDbType.Smallint, item.itemtype);
var itemKey = cmd.ExecuteScalar();
return(Guid.Parse(itemKey.ToString()));
}
}
catch (Exception msg)
{
throw msg;
}
finally
{
conn.Close();
}
}
public ItemBO search(int id)
{
ItemBO item = new ItemBO();
FileStream fin = new FileStream("itemdata.txt", FileMode.Open);
StreamReader sr = new StreamReader(fin);
String line;
while ((line = sr.ReadLine()) != null)
{
String[] data = line.Split(';');
if (int.Parse(data[0]) == id)
{
item.Itemid = int.Parse(data[0]);
item.Description = data[1];
item.Price = double.Parse(data[2]);
item.Quantity = int.Parse(data[3]);
item.Date = data[4];
break;
}
}
sr.Close();
fin.Close();
return(item);
}
//2..Search Inventory Lists by Item Number or Description
public List <ItemBO> searchInventory(string itemNumber, string description)
{
var qry = context.Categories.Join(context.Items, r => r.CategoryID, p => p.CategoryID, (r, p) => new
{
p.ItemID, p.ItemNumber, p.CategoryID, p.Description, p.InStockQty, p.ReorderLevel, p.ReorderQty,
p.UnitOfMeasure, p.Bin, r.CategoryName
}).Where(x => (x.ItemNumber.Contains(itemNumber)) || (x.Description.Contains(description))).ToList();
List <ItemBO> blst = new List <ItemBO>();
foreach (var b in qry)
{
ItemBO obj = new ItemBO();
obj.ItemID = b.ItemID;
obj.ItemNumber = b.ItemNumber;
obj.CategoryID = b.CategoryID;
obj.Description = b.Description;
obj.InStockQty = b.InStockQty;
obj.ReorderLevel = b.ReorderLevel;
obj.ReorderQty = b.ReorderQty;
obj.UnitOfMeasure = b.UnitOfMeasure;
obj.Bin = b.Bin;
obj.CategoryName = b.CategoryName;
blst.Add(obj);
}
return(blst);
}
public static int deleteItem(ItemBO item)
{
string constr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\BCS DATA\Samester 6\C Sharp\Assingment 1\DAL\styloDatabase.mdf;Integrated Security=True";
using (DataClassesDataContext data = new DataClassesDataContext(constr))
{
var check = from a in data.Items
where a.PID == item.Pid
select a;
if (!check.Any())
{
return(3);
}
Item newItem = data.Items.SingleOrDefault(x => x.PID == item.Pid);
data.Items.DeleteOnSubmit(newItem);
try
{
data.SubmitChanges();
return(0);
}
catch (Exception e)
{
return(1);
}
}
}
public void TestGetItemById()
{
var controller = new ItemsController();
var actionResult = controller.GetItemById(1);
var contentResult = actionResult as OkNegotiatedContentResult <ShopBridge_API.Models.ItemBO>;
Assert.IsNotNull(contentResult);
Item item;
using (ShopBridgeEntities db = new ShopBridgeEntities())
{
item = db.Items.SingleOrDefault(x => x.ItemId.Equals(1));
}
ItemBO itemBO = new ItemBO
{
Name = item.Name,
Description = item.ItemDescription,
Price = item.Price.Value,
AddedOn = DateTime.Now,
ItemImage = item.ImageData
};
var product = contentResult.Content;
Assert.AreEqual(itemBO.Name, contentResult.Content.Name);
}
/// <summary>
/// Process the page data.
/// </summary>
private void ProcessForm(int itemId)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ItemBO objItemSubCategoryBO = new ItemBO(this.ObjContext);
if (itemId > 0)
{
objItemSubCategoryBO.ID = itemId;
objItemSubCategoryBO.GetObject();
}
objItemSubCategoryBO.Parent = int.Parse(this.ddlItem.SelectedValue);
objItemSubCategoryBO.Name = this.txtName.Text;
objItemSubCategoryBO.Description = this.txtDescription.Text;
if (itemId == 0)
{
objItemSubCategoryBO.Add();
}
this.ObjContext.SaveChanges();
ts.Complete();
}
}
catch (Exception ex)
{
// Log the error
//IndicoLogging.log("Error occured while Adding the Item", ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["userLoggedIn"].Equals("") || Session["login"].Equals(""))
{
Response.Redirect("~/LoggedInPage.aspx");
}
else
{
if (!IsPostBack)
{
string itemNumber = Request.QueryString["itemNumber"];
ItemBO i = sbl.getEachItem(itemNumber);
lblStock.Text = i.ItemNumber + " " + i.Description;
ddlSupplier.DataSource = sbl.getSupplierListByItemNumber(itemNumber);
ddlSupplier.DataTextField = "SupplierName";
ddlSupplier.DataValueField = "SupplierID";
ddlSupplier.DataBind();
}
}
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
}
public void modify(ItemBO item)
{
String connectionstring = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Hassan\Desktop\POS-EAD-2\POS\MyDatabase.mdf;Integrated Security=True";
SqlConnection con = new SqlConnection(connectionstring);
String query = "update item set description=@des,price=@pri,quantity=@quan,creationdate=@create from item where itemid=@itemid;";
SqlParameter p1 = new SqlParameter("des", item.Description);
SqlParameter p2 = new SqlParameter("pri", item.Price);
SqlParameter p3 = new SqlParameter("quan", item.Quantity);
SqlParameter p4 = new SqlParameter("create", item.Date);
SqlParameter p5 = new SqlParameter("itemid", item.Itemid);
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
public List <ItemBO> searchItem()
{
List <ItemBO> list = new List <ItemBO>();
FileStream fin = new FileStream("itemdata.txt", FileMode.Open);
StreamReader sr = new StreamReader(fin);
String line;
while ((line = sr.ReadLine()) != null)
{
String[] data = line.Split(';');
ItemBO itemFound = new ItemBO();
itemFound.Itemid = int.Parse(data[0]);
itemFound.Description = data[1];
itemFound.Price = double.Parse(data[2]);
itemFound.Quantity = int.Parse(data[3]);
itemFound.Date = data[4];
list.Add(itemFound);
}
sr.Close();
fin.Close();
return(list);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int itemSubCatId = int.Parse(this.hdnSelectedSubCategoryID.Value.Trim());
if (itemSubCatId > 0)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
ItemBO objSubItem = new ItemBO(this.ObjContext);
objSubItem.ID = itemSubCatId;
objSubItem.GetObject();
objSubItem.Delete();
this.ObjContext.SaveChanges();
ts.Complete();
this.PopulateDataGrid();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
//Methods
public void showItemInformation()
{
int flag = 0;
string itemNumber = Request.QueryString["itemCode"];
//Show Item Informaiton
ItemBO b = bl.getItemByItemNumberBL(itemNumber);//check
lblItemCode.Text = b.ItemNumber;
lblItemDescription.Text = b.Description;
lblBin.Text = b.Bin;
lblUOM.Text = b.UnitOfMeasure;
lblInStock.Text = b.InStockQty.ToString();
//Show Supplier Information
ItemSupplierJoinBO sObj = new ItemSupplierJoinBO();
foreach (ItemSupplierJoinBO s in bl.getItemInformation(itemNumber))
{
flag++;
if (flag == 1)
{
lblSupplier1.Text = s.SupplierName;
}
else if (flag == 2)
{
lblSupplier2.Text = s.SupplierName;
}
else if (flag == 3)
{
lblSupplier3.Text = s.SupplierName;
}
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
try
{
string itemNumber = Request.QueryString["itemNumber"];
ItemBO i = sbl.getEachItem(itemNumber);
int itemID = i.ItemID;
int supplierID = int.Parse(ddlSupplier.SelectedValue);
if (sbl.checkSupplierinPurchaseItem(supplierID, itemID))
{
int purchaseItemID = sbl.getPurchaseItem(itemNumber, itemID, supplierID);
int qty = int.Parse(txtAmount.Text);
DateTime dt = Convert.ToDateTime(txtCalendar.Text);
sbl.updatePurchaseItem(purchaseItemID, qty, dt, itemNumber);//check update and item and purchase item
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Update Successful..')", true);
Response.Redirect("~/StoreClerk/StockCard.aspx?itemCode=" + itemNumber);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Didn't buy the item from this supplier')", true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
//For Stationery Catalogue Page
//1..Get all inventory lists and show in inventory page and Stationery Catalogue Page
public List <ItemBO> getInventoryList()
{
List <ItemBO> blst = new List <ItemBO>();
//Join category table and item table and retrieve
var qry = context.Categories.Join(context.Items, r => r.CategoryID, p => p.CategoryID, (r, p) => new
{
p.ItemID,
p.ItemNumber,
p.CategoryID,
p.Description,
p.InStockQty,
p.ReorderLevel,
p.ReorderQty,
p.UnitOfMeasure,
p.Bin,
r.CategoryName
});
foreach (var b in qry)
{
ItemBO obj = new ItemBO();
obj.ItemID = b.ItemID;
obj.ItemNumber = b.ItemNumber;
obj.CategoryID = b.CategoryID;
obj.Description = b.Description;
obj.InStockQty = b.InStockQty;
obj.ReorderLevel = b.ReorderLevel;
obj.ReorderQty = b.ReorderQty;
obj.UnitOfMeasure = b.UnitOfMeasure;
obj.Bin = b.Bin;
obj.CategoryName = b.CategoryName;
blst.Add(obj);
}
return(blst);
}
public ItemBO search(int itemid)
{
ItemBO item = new ItemBO();
String connectionstring = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Hassan\Desktop\POS-EAD-2\POS\MyDatabase.mdf;Integrated Security=True";
SqlConnection con = new SqlConnection(connectionstring);
String query = "select* from item where itemid=@itemid;";
SqlParameter p1 = new SqlParameter("itemid", itemid);
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(p1);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
item.Itemid = (int)dr[0];
item.Description = (string)dr[1];
item.Price = (double)dr[2];
item.Quantity = (int)dr[3];
item.Date = (string)dr[4];
}
con.Close();
return(item);
}
public ItemBO Create(ItemBO item)
{
var Item = converter.Convert(item);
_context.Items.Add(Item);
_context.SaveChanges();
return(converter.Convert(Item));
}
public ItemBO Update(ItemBO item)
{
var updatedItem = converter.Convert(item);
_context.Entry(updatedItem).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_context.SaveChanges();
return(converter.Convert(updatedItem));
}
public IActionResult Post([FromBody] ItemBO item)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
return(Ok(facade.ItemService.Create(item)));
}
public IHttpActionResult SaveItem(ItemBO item)
{
if (item == null)
{
return(BadRequest());
}
itemBLL.SaveItem(item);
return(CreatedAtRoute("DefaultApi", new { id = item.Id }, item));
}
private void PopulateDataGrid()
{
// Hide Controls
this.dvEmptyContent.Visible = false;
this.dvDataContent.Visible = false;
this.dvNoSearchResult.Visible = false;
// Search text
string searchText = this.txtSearch.Text.ToLower().Trim();
// Populate Items
ItemBO objSubItem = new ItemBO();
// Sort by condition
int sortbyStatus = int.Parse(this.ddlSortBy.SelectedItem.Value);
if (sortbyStatus < 2)
{
//objItem.IsActive = Convert.ToBoolean(sortbyStatus);
}
List <ItemBO> lstSubItems = new List <ItemBO>();
if ((searchText != string.Empty) && (searchText != "search"))
{
lstSubItems = (from o in objSubItem.SearchObjects().ToList()
where o.Name.ToLower().Contains(searchText)
select o).ToList();
}
else
{
lstSubItems = objSubItem.SearchObjects().ToList();
}
if (lstSubItems.Count > 0)
{
this.dgItemSubCategory.AllowPaging = (lstSubItems.Count > this.dgItemSubCategory.PageSize);
this.dgItemSubCategory.DataSource = lstSubItems;
this.dgItemSubCategory.DataBind();
this.dvDataContent.Visible = true;
}
else if ((searchText != string.Empty && searchText != "search") || (sortbyStatus < 2))
{
this.lblSerchKey.Text = searchText + ((searchText != string.Empty) ? " - " : string.Empty) + "Sort by " + this.ddlSortBy.SelectedItem.Text;
this.dvDataContent.Visible = true;
this.dvNoSearchResult.Visible = true;
}
else
{
this.dvEmptyContent.Visible = true;
}
this.lblSerchKey.Text = string.Empty;
this.dgItemSubCategory.Visible = (lstSubItems.Count > 0);
}
public void save(ItemBO itemBO)
{
ItemDAL item = new ItemDAL();
DateTime thisDay = DateTime.Today;
itemBO.Date = thisDay.ToString("dd/MM/yyyy");
item.save(itemBO);
}
public ItemBO Create(ItemBO i)
{
using (var uow = facade.UnitOfWork)
{
var newItem = uow.ItemRepo.Create(conv.Convert(i));
uow.Complete();
return(conv.Convert(newItem));
}
}
public void ConvertBOToEntId()
{
var item = new ItemBO()
{
Id = 1
};
Item bo = converter.Convert(item);
Assert.AreEqual(bo.Id, 1);
}
public void save(ItemBO item)
{
FileStream fout = new FileStream("itemdata.txt", FileMode.Append);
StreamWriter sw = new StreamWriter(fout);
sw.WriteLine(item.Itemid + ";" + item.Description + ";" + item.Price + ";" + item.Quantity + ";" + item.Date);
sw.Close();
fout.Close();
}
public IHttpActionResult GetItemById(long id)
{
ItemBO item = itemBLL.GetItemById(id);
if (item == null)
{
return(BadRequest());
}
return(Ok(item));
}
