public List <Inventoryinfo> selectallInventoryinfo() { try { List <Inventoryinfo> lstiinfo = new List <Inventoryinfo>(); using (RMSDataContext db = new RMSDataContext()) { Inventoryinfo iinfo; var a = (from o in db.inventories select o).ToList(); foreach (var obj in a) { iinfo = new Inventoryinfo(); iinfo.InventoryID = obj.InventoryID; iinfo.ProductID = obj.ProductID; iinfo.UnitInStock = obj.UnitInStock; iinfo.InsertDate = obj.Inserted_date; iinfo.UpdateDate = obj.Updated_date; lstiinfo.Add(iinfo); } return(lstiinfo); } } catch (Exception ex) { return(new List <Inventoryinfo>()); } }
public void DeleteInventoryByInventoryID(Inventoryinfo inveninfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from inven in db.inventories where inven.InventoryID == inveninfo.InventoryID select inven).First(); db.inventories.DeleteOnSubmit(obj); db.SubmitChanges(); } } catch (Exception ex) { inventory i = new inventory(); } }
protected void btnSave_Click(object sender, EventArgs e) { Invertorycontroller inventoryCtlr = new Invertorycontroller(); Inventoryinfo inventoryInfo = new Inventoryinfo(); inventoryInfo.ProductID = ProductData.SelectedValue; inventoryInfo.UnitInStock = Convert.ToInt32(txtProductQtty.Text); inventoryCtlr.InsertInventory(inventoryInfo); inventoryhiscontroller invenHisCtlr = new inventoryhiscontroller(); inventory_history_info invenHisInfo = new inventory_history_info(); invenHisInfo.ProductID = ProductData.SelectedValue; invenHisInfo.Product_quantity = txtProductQtty.Text; invenHisCtlr.InsertInventory_History(invenHisInfo); SelectAllInventory(); }
public void UpdateInventoryByInventoryID(Inventoryinfo inveninfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from inven in db.inventories where inven.InventoryID == inveninfo.InventoryID select inven).First(); obj.UnitInStock = inveninfo.UnitInStock; obj.ProductID = inveninfo.ProductID; obj.Updated_date = DateTime.Now; db.SubmitChanges(); } } catch (Exception ex) { inventory inven = new inventory(); } }
public string insertinventory(Inventoryinfo inveninfo) { try { using (RMSDataContext db = new RMSDataContext()) { inventory inventbl = new inventory(); Guid iID = Guid.NewGuid(); inventbl.InventoryID = iID.ToString(); inventbl.UnitInStock = inveninfo.UnitInStock; inventbl.ProductID = inveninfo.ProductID; inventbl.Inserted_date = DateTime.UtcNow.AddMinutes(390); inventbl.Updated_date = DateTime.UtcNow.AddMinutes(390); db.inventories.InsertOnSubmit(inventbl); db.SubmitChanges(); return(iID.ToString()); } } catch (Exception ex) { return(""); } }
public void DeleteInventory(Inventoryinfo invenInfo) { invendao = new inventorydao(); invendao.DeleteInventoryByInventoryID(invenInfo); }
public void UpdateInventory(Inventoryinfo invenInfo) { invendao = new inventorydao(); invendao.UpdateInventoryByInventoryID(invenInfo); }
public string InsertInventory(Inventoryinfo invenInfo) { invendao = new inventorydao(); return(invendao.insertinventory(invenInfo)); }
protected void btnSave_Click(object sender, EventArgs e) { Productinfo prinfo = new Productinfo(); ProductController pcon = new ProductController(); prinfo.ProductName = txtProductName.Text.Trim(); prinfo.Product_description = txtDesc.Text.Trim(); prinfo.Color = txtColor.Text.Trim(); prinfo.Size = txtSize.Text.Trim(); prinfo.Manufacture_Country = txtMade.Text.Trim(); prinfo.UnitPrice = Convert.ToDecimal(txtSellPrice.Text.Trim()); prinfo.Manufacture_date = Convert.ToDateTime(txtManuDate.Text.Trim()); prinfo.Expired_date = Convert.ToDateTime(txtExpDate.Text.Trim()); prinfo.Product_Expired_date = Convert.ToDateTime(txtExpDate.Text.Trim()); prinfo.BrandID = ddlBrand.SelectedItem.Value; prinfo.CategoryID = ddlCateogry.SelectedItem.Value; prinfo.SupplierID = ddlSupplier.SelectedItem.Value; prinfo.UMID = ddlUM.SelectedItem.Value; //pcon.InsertProduct(prinfo); string productID = pcon.InsertProduct(prinfo); Inventoryinfo invinfo = new Inventoryinfo(); Invertorycontroller invCon = new Invertorycontroller(); invinfo.ProductID = productID; invinfo.UnitInStock = Convert.ToInt32(txtUnitStock.Text.Trim()); string invId = invCon.InsertInventory(invinfo); ReorderInfo rinfo = new ReorderInfo(); ReorderController rcon = new ReorderController(); rinfo.ProductID = productID; rinfo.InventoryID = invId; rinfo.ReorderUnit = txtReorder.Text.Trim(); rcon.InsertReorder(rinfo); Cell_Priceinfoinfo cinfo = new Cell_Priceinfoinfo(); Cell_PriceController ccon = new Cell_PriceController(); cinfo.Cell_Price1 = Convert.ToDecimal(txtBuyPrice.Text.Trim()); cinfo.Cell_Price2 = Convert.ToDecimal(txtSellPrice.Text.Trim()); cinfo.Product_id = productID; cinfo.UMID = ddlUM.SelectedItem.Value; ccon.InsertCell_Price(cinfo); if (fuMain.HasFile) { product_imageinfo piminfo = new product_imageinfo(); ProductImageController pimcon = new ProductImageController(); piminfo.ProductID = productID; piminfo.Images = fuMain.FileBytes; piminfo.MainPic = true; pimcon.InsertProductImage(piminfo); } if (fuLeft.HasFile) { product_imageinfo piminfo = new product_imageinfo(); ProductImageController pimcon = new ProductImageController(); piminfo.ProductID = productID; piminfo.Images = fuLeft.FileBytes; pimcon.InsertProductImage(piminfo); } if (FuBehind.HasFile) { product_imageinfo piminfo = new product_imageinfo(); ProductImageController pimcon = new ProductImageController(); piminfo.ProductID = productID; piminfo.Images = FuBehind.FileBytes; piminfo.MainPic = false; pimcon.InsertProductImage(piminfo); } if (fuRight.HasFile) { product_imageinfo piminfo = new product_imageinfo(); ProductImageController pimcon = new ProductImageController(); piminfo.ProductID = productID; piminfo.Images = fuRight.FileBytes; piminfo.MainPic = false; pimcon.InsertProductImage(piminfo); } if (fuFront.HasFile) { product_imageinfo piminfo = new product_imageinfo(); ProductImageController pimcon = new ProductImageController(); piminfo.ProductID = productID; piminfo.Images = fuFront.FileBytes; piminfo.MainPic = false; pimcon.InsertProductImage(piminfo); } if (fuBottom.HasFile) { product_imageinfo piminfo = new product_imageinfo(); ProductImageController pimcon = new ProductImageController(); piminfo.ProductID = productID; piminfo.Images = fuBottom.FileBytes; piminfo.MainPic = false; pimcon.InsertProductImage(piminfo); } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('New Product Inserted Successfully!')", true); }