public List <inventory_history_info> selectalliinventoryhis() { try { List <inventory_history_info> listinventoryhis = new List <inventory_history_info>(); { using (RMSDataContext db = new RMSDataContext()) { inventory_history_info inventoryhis; var a = (from o in db.inventory_histories select o).ToList(); foreach (var obj in a) { inventoryhis = new inventory_history_info(); inventoryhis.InventoryID = obj.InventoryID; inventoryhis.ProductID = obj.ProductID; inventoryhis.Product_quantity = obj.Product_quantity; inventoryhis.Inserted_date = DateTime.Parse(obj.Inserted_date); listinventoryhis.Add(inventoryhis); } return(listinventoryhis); } } } catch (Exception ex) { return(new List <inventory_history_info>()); } }
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 DeleteInventoryHistoryByID(inventory_history_info inven_hisinfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from inven_his in db.inventory_histories where inven_his.InventoryID == inven_hisinfo.InventoryID select inven_his).First(); db.inventory_histories.DeleteOnSubmit(obj); db.SubmitChanges(); } } catch (Exception ex) { inventory_history i = new inventory_history(); } }
public void UpdateInventoryHistoryByID(inventory_history_info inven_hisinfo) { try { using (RMSDataContext db = new RMSDataContext()) { var obj = (from invenHis in db.inventory_histories where invenHis.InventoryID == inven_hisinfo.InventoryID select invenHis).First(); obj.ProductID = inven_hisinfo.ProductID; obj.Product_quantity = inven_hisinfo.Product_quantity; db.SubmitChanges(); } } catch (Exception ex) { inventory_history invenHis = new inventory_history(); } }
public void InsertInventoryHistory(inventory_history_info invenHis) { try { using (RMSDataContext db = new RMSDataContext()) { inventory_history tbl = new inventory_history(); tbl.ProductID = invenHis.ProductID; tbl.Product_quantity = invenHis.Product_quantity; //tbl.Inserted_date = DateTime.Now; db.inventory_histories.InsertOnSubmit(tbl); db.SubmitChanges(); } } catch (Exception ex) { inventory_history inven = new inventory_history(); } }
public void DeleteInventory_History(inventory_history_info invenInfo) { invenhisdao.DeleteInventoryHistoryByID(invenInfo); }
public void UpdateInventory_History(inventory_history_info invenInfo) { invenhisdao.UpdateInventoryHistoryByID(invenInfo); }
public void InsertInventory_History(inventory_history_info invenInfo) { invenhisdao.InsertInventoryHistory(invenInfo); }