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