public static void InsertInventoryClosed1()
{
using (MySqlConnection con = new MySqlConnection(DatabaseHelper.GetSQLiteConnectionString()))
{
con.Open();
string query = "";
query = $"INSERT INTO inventoryentry(ItemId, InventoryId, DateCreated, Quantity, InventoryLogEntryType) " +
$"Select ItemId, {InventoryService.GetIDinventory()}, DateCreated, Quantity, InventoryLogEntryType From inventoryentry where InventoryLogEntryType='1' and InventoryId={Int32.Parse(InventoryService.GetIDinventory()) - 1} and ItemId not in(Select ItemId From inventoryentry where InventoryLogEntryType='1' and InventoryId={InventoryService.GetIDinventory()} )";
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader dataReader = cmd.ExecuteReader();
con.Close();
}
}
public static string ApproveNewStock(string id)
{
using (MySqlConnection con = new MySqlConnection(DatabaseHelper.GetSQLiteConnectionString()))
{
con.Open();
string query = "";
query = $"Select ItemId From inventoryentry WHERE InventoryId='{InventoryService.GetIDinventory()}' and ItemId='{id}' and InventoryLogEntryType='1' limit 1";
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
string user = dataReader["ItemId"].ToString();
con.Close();
return(user);
}
con.Close();
return("0");
}
}
public static string CorrectQuantity(string id)
{
using (MySqlConnection con = new MySqlConnection(DatabaseHelper.GetSQLiteConnectionString()))
{
con.Open();
string query = "";
query = $"Select sum(round(Quantity,0)) as Quantity From inventoryentry where ItemId='{id}' and InventoryId={Int32.Parse(InventoryService.GetIDinventory()) - 1} Group by ItemId";
MySqlCommand cmd = new MySqlCommand(query, con);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
string user = dataReader["Quantity"].ToString();
return(user);
}
con.Close();
return("0");
}
}