public Warehouse get(int id)
{
string sql = "Select * From [Inv_Warehouse] Where ID=" + id;
DataTable dt = DataAccess.ExecuteSQLQuery(sql);
Warehouse wearhouse = new Warehouse();
wearhouse.ID = id;
wearhouse.Name = dt.Rows[0]["Name"].ToString();
wearhouse.Address = dt.Rows[0]["Address"].ToString();
wearhouse.Active = Convert.ToInt32(dt.Rows[0]["Active"].ToString());
wearhouse.StoreKeeper = Convert.ToInt32(dt.Rows[0]["StoreKeeper"].ToString());
wearhouse.CreationDate = Convert.ToDateTime(dt.Rows[0]["CreationDate"].ToString());
wearhouse.LastModifiedDate = Convert.ToDateTime(dt.Rows[0]["LastModifiedDate"].ToString());
wearhouse.OperatorID = Convert.ToInt32(dt.Rows[0]["OperatorID"].ToString());
sql = "SELECT dbo.Inv_ProductWearhous.ID, dbo.Inv_ProductWearhous.ProductID, dbo.Inv_ProductWearhous.WarehouseID, dbo.Inv_ProductWearhous.Active, dbo.Inv_ProductWearhous.Quantity, dbo.Inv_ProductWearhous.Cost, dbo.Inv_ProductWearhous.Price, dbo.Inv_ProductWearhous.Barcode, dbo.Inv_Warehouse.Name" +
" FROM dbo.Inv_ProductWearhous INNER JOIN dbo.Inv_Warehouse ON dbo.Inv_ProductWearhous.WarehouseID = dbo.Inv_Warehouse.ID" +
" WHERE (dbo.Inv_ProductWearhous.WearhouseID = " + id + ")";
DataTable dt2 = DataAccess.ExecuteSQLQuery(sql);
for (int i = 0; i < dt2.Rows.Count; i++)
{
ProductWatehouse productWatehouse = new ProductWatehouse();
productWatehouse.ID = Convert.ToInt32(dt2.Rows[i]["WearhouseID"].ToString());
productWatehouse.ProductID = Convert.ToInt32(dt2.Rows[i]["ProductID"].ToString());
productWatehouse.WarehouseID = Convert.ToInt32(dt2.Rows[i]["WarehouseID"].ToString());
productWatehouse.Active = Convert.ToInt32(dt2.Rows[i]["Active"].ToString());
productWatehouse.Quantity = Convert.ToInt32(dt2.Rows[i]["Quantity"].ToString());
productWatehouse.Cost = Convert.ToInt32(dt2.Rows[i]["Cost"].ToString());
productWatehouse.Price = Convert.ToInt32(dt2.Rows[i]["Price"].ToString());
productWatehouse.Barcode = dt2.Rows[i]["Barcode"].ToString();
wearhouse.productWatehouse.Add(productWatehouse);
}
return(wearhouse);
}
protected void btnSave_Click(object sender, EventArgs e)
{
InvProduct product = new InvProduct();
product.Name = txtName.Text;
product.SerialNumber = txtSerialNum.Text;
product.Cost = Convert.ToDouble(txtCost.Text);
product.Price = Convert.ToDouble(txtPrice.Text);
product.Barcode = txtBarcode.Text;
product.Category = Convert.ToInt32(ddlCategory.SelectedValue.ToString());
product.Active = 1;
HttpCookie myCookie = Request.Cookies["user"];
product.OperatorID = Convert.ToInt32(myCookie.Values["userid"].ToString());
product.LowQuantity = Convert.ToInt32(txtLowQuantity.Text);
DataTable dt = Session["ProductWarehouse"] as DataTable;
List <ProductWatehouse> productWarehouses = new List <ProductWatehouse>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ProductWatehouse productWarehouse = new ProductWatehouse();
productWarehouse.WarehouseID = Convert.ToInt32(dt.Rows[i]["WarehouseID"].ToString());
productWarehouse.Quantity = Convert.ToInt32(dt.Rows[i]["Quantity"].ToString());
productWarehouse.Cost = Convert.ToDouble(dt.Rows[i]["Cost"].ToString());
productWarehouse.Price = Convert.ToDouble(dt.Rows[i]["Price"].ToString());
productWarehouse.Barcode = dt.Rows[i]["Barcode"].ToString();
productWarehouse.Active = 1;
productWarehouses.Add(productWarehouse);
}
product.productWatehouse = productWarehouses;
int res = new clsProduct().insert(product);
if (res > 0)
{
Response.Redirect("~/Inventory/Products.aspx?alert=success");
}
else
{
Response.Redirect("~/Inventory/AddProduct.aspx?id=0&&alret=notpass");
}
}
public InvProduct get(int id)
{
string sql = "Select * From Inv_Products Where ID=" + id;
DataTable dt = DataAccess.ExecuteSQLQuery(sql);
InvProduct product = new InvProduct();
product.ID = id;
product.Name = dt.Rows[0]["Name"].ToString();
product.SerialNumber = dt.Rows[0]["SerialNumber"].ToString();
product.StockAmount = Convert.ToInt32(dt.Rows[0]["StockAmount"].ToString());
product.Cost = Convert.ToDouble(dt.Rows[0]["Cost"].ToString());
product.Price = Convert.ToDouble(dt.Rows[0]["Price"].ToString());
product.Barcode = dt.Rows[0]["Barcode"].ToString();;
product.Category = Convert.ToInt32(dt.Rows[0]["Category"].ToString());
product.Active = Convert.ToInt32(dt.Rows[0]["Active"].ToString());
product.CreationDate = Convert.ToDateTime(dt.Rows[0]["CreationDate"].ToString());
product.LastModifiedDate = Convert.ToDateTime(dt.Rows[0]["LastModifiedDate"].ToString());
product.OperatorID = Convert.ToInt32(dt.Rows[0]["OperatorID"].ToString());
sql = "SELECT dbo.Inv_ProductWearhous.ID, dbo.Inv_ProductWearhous.ProductID, dbo.Inv_ProductWearhous.WarehouseID, dbo.Inv_ProductWearhous.Active, dbo.Inv_ProductWearhous.Quantity, dbo.Inv_ProductWearhous.Cost, dbo.Inv_ProductWearhous.Price, dbo.Inv_ProductWearhous.Barcode, dbo.Inv_Warehouse.Name" +
" FROM dbo.Inv_ProductWearhous INNER JOIN dbo.Inv_Warehouse ON dbo.Inv_ProductWearhous.WarehouseID = dbo.Inv_Warehouse.ID" +
" WHERE (dbo.Inv_ProductWearhous.ProductID = " + id + ")";
DataTable dt2 = DataAccess.ExecuteSQLQuery(sql);
for (int i = 0; i < dt2.Rows.Count; i++)
{
ProductWatehouse productWatehouse = new ProductWatehouse();
productWatehouse.ID = Convert.ToInt32(dt2.Rows[i]["WearhouseID"].ToString());
productWatehouse.ProductID = Convert.ToInt32(dt2.Rows[i]["ProductID"].ToString());
productWatehouse.WarehouseID = Convert.ToInt32(dt2.Rows[i]["WarehouseID"].ToString());
productWatehouse.Active = Convert.ToInt32(dt2.Rows[i]["Active"].ToString());
productWatehouse.Quantity = Convert.ToInt32(dt2.Rows[i]["Quantity"].ToString());
productWatehouse.Cost = Convert.ToInt32(dt2.Rows[i]["Cost"].ToString());
productWatehouse.Price = Convert.ToInt32(dt2.Rows[i]["Price"].ToString());
productWatehouse.Barcode = dt2.Rows[i]["Barcode"].ToString();
product.productWatehouse.Add(productWatehouse);
}
return(product);
}
