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