public ProductInventoryDetails Details(Int64 ProductID) { try { System.Data.DataTable dt = ListAsDataTable(ProductID, "InventoryID", SortOption.Ascending); ProductInventoryDetails Details = new ProductInventoryDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.InventoryID = Int64.Parse(dr["InventoryID"].ToString()); Details.ProductID = Int64.Parse(dr["ProductID"].ToString()); Details.ProductCode = "" + dr["ProductCode"].ToString(); Details.VariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString()); Details.VariationMatrixDescription = "" + dr["VariationMatrixDescription"].ToString(); Details.ProductUnitID = Int32.Parse(dr["ProductUnitID"].ToString()); Details.UnitName = "" + dr["UnitName"].ToString(); Details.Quantity = Int32.Parse(dr["Quantity"].ToString()); Details.MinThreshold = Int32.Parse(dr["MinThreshold"].ToString()); Details.MaxThreshold = Int32.Parse(dr["MaxThreshold"].ToString()); } return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(ProductInventoryDetails Details) { try { string SQL = "UPDATE tblInventory SET " + "ProductID = @ProductID, " + "Quantity = @Quantity, " + "ProductUnitID = @ProductUnitID, " + "MinThreshold = @MinThreshold, " + "MaxThreshold = @MaxThreshold " + "WHERE InventoryID = @InventoryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID", MySqlDbType.Int32); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmQuantity = new MySqlParameter("@Quantity", MySqlDbType.Int32); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID", MySqlDbType.Int32); prmProductUnitID.Value = Details.ProductUnitID; cmd.Parameters.Add(prmProductUnitID); MySqlParameter prmMinThreshold = new MySqlParameter("@MinThreshold", MySqlDbType.Int32); prmMinThreshold.Value = Details.MinThreshold; cmd.Parameters.Add(prmMinThreshold); MySqlParameter prmMaxThreshold = new MySqlParameter("@MaxThreshold", MySqlDbType.Int32); prmMaxThreshold.Value = Details.MaxThreshold; cmd.Parameters.Add(prmMaxThreshold); MySqlParameter prmInventoryID = new MySqlParameter("@InventoryID", MySqlDbType.Int32); prmInventoryID.Value = Details.InventoryID; cmd.Parameters.Add(prmInventoryID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }
public Int64 Insert(ProductInventoryDetails Details) { try { string SQL = "INSERT INTO tblInventory (" + "ProductID, " + "VariationMatrixID, " + "ProductUnitID, " + "Quantity, " + "MinThreshold" + ")VALUES (" + "@ProductID, " + "@VariationMatrixID, " + "@ProductUnitID, " + "@Quantity, " + "@MinThreshold, " + "@MaxThreshold);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID", MySqlDbType.Int32); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID", MySqlDbType.Int16); prmVariationMatrixID.Value = Details.VariationMatrixID; cmd.Parameters.Add(prmVariationMatrixID); MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID", MySqlDbType.Int16); prmProductUnitID.Value = Details.ProductUnitID; cmd.Parameters.Add(prmProductUnitID); MySqlParameter prmQuantity = new MySqlParameter("@Quantity", MySqlDbType.Int32); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmMinThreshold = new MySqlParameter("@MinThreshold", MySqlDbType.Int32); prmMinThreshold.Value = Details.MinThreshold; cmd.Parameters.Add(prmMinThreshold); MySqlParameter prmMaxThreshold = new MySqlParameter("@MaxThreshold", MySqlDbType.Int32); prmMaxThreshold.Value = Details.MaxThreshold; cmd.Parameters.Add(prmMaxThreshold); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(ProductInventoryDetails Details) { try { string SQL = "INSERT INTO tblInventory (" + "ProductID, " + "VariationMatrixID, " + "ProductUnitID, " + "Quantity, " + "MinThreshold" + ")VALUES (" + "@ProductID, " + "@VariationMatrixID, " + "@ProductUnitID, " + "@Quantity, " + "@MinThreshold, " + "@MaxThreshold);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int32); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID",MySqlDbType.Int16); prmVariationMatrixID.Value = Details.VariationMatrixID; cmd.Parameters.Add(prmVariationMatrixID); MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID",MySqlDbType.Int16); prmProductUnitID.Value = Details.ProductUnitID; cmd.Parameters.Add(prmProductUnitID); MySqlParameter prmQuantity = new MySqlParameter("@Quantity",MySqlDbType.Int32); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmMinThreshold = new MySqlParameter("@MinThreshold",MySqlDbType.Int32); prmMinThreshold.Value = Details.MinThreshold; cmd.Parameters.Add(prmMinThreshold); MySqlParameter prmMaxThreshold = new MySqlParameter("@MaxThreshold",MySqlDbType.Int32); prmMaxThreshold.Value = Details.MaxThreshold; cmd.Parameters.Add(prmMaxThreshold); base.ExecuteNonQuery(cmd); SQL = "SELECT LAST_INSERT_ID();"; cmd.Parameters.Clear(); cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductInventoryDetails Details(Int64 ProductID) { try { System.Data.DataTable dt = ListAsDataTable(ProductID, "InventoryID", SortOption.Ascending); ProductInventoryDetails Details = new ProductInventoryDetails(); foreach (System.Data.DataRow dr in dt.Rows) { Details.InventoryID = Int64.Parse(dr["InventoryID"].ToString()); Details.ProductID = Int64.Parse(dr["ProductID"].ToString()); Details.ProductCode = "" + dr["ProductCode"].ToString(); Details.VariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString()); Details.VariationMatrixDescription = "" + dr["VariationMatrixDescription"].ToString(); Details.ProductUnitID = Int32.Parse(dr["ProductUnitID"].ToString()); Details.UnitName = "" + dr["UnitName"].ToString(); Details.Quantity = Int32.Parse(dr["Quantity"].ToString()); Details.MinThreshold = Int32.Parse(dr["MinThreshold"].ToString()); Details.MaxThreshold = Int32.Parse(dr["MaxThreshold"].ToString()); } return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(ProductInventoryDetails Details) { try { string SQL= "UPDATE tblInventory SET " + "ProductID = @ProductID, " + "Quantity = @Quantity, " + "ProductUnitID = @ProductUnitID, " + "MinThreshold = @MinThreshold, " + "MaxThreshold = @MaxThreshold " + "WHERE InventoryID = @InventoryID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int32); prmProductID.Value = Details.ProductID; cmd.Parameters.Add(prmProductID); MySqlParameter prmQuantity = new MySqlParameter("@Quantity",MySqlDbType.Int32); prmQuantity.Value = Details.Quantity; cmd.Parameters.Add(prmQuantity); MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID",MySqlDbType.Int32); prmProductUnitID.Value = Details.ProductUnitID; cmd.Parameters.Add(prmProductUnitID); MySqlParameter prmMinThreshold = new MySqlParameter("@MinThreshold",MySqlDbType.Int32); prmMinThreshold.Value = Details.MinThreshold; cmd.Parameters.Add(prmMinThreshold); MySqlParameter prmMaxThreshold = new MySqlParameter("@MaxThreshold",MySqlDbType.Int32); prmMaxThreshold.Value = Details.MaxThreshold; cmd.Parameters.Add(prmMaxThreshold); MySqlParameter prmInventoryID = new MySqlParameter("@InventoryID",MySqlDbType.Int32); prmInventoryID.Value = Details.InventoryID; cmd.Parameters.Add(prmInventoryID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { { } throw base.ThrowException(ex); } }