public void CreateDB()
{
var query = new SqliteQuery();
query.Type = QueryType.Create;
query.Table = "user_registration";
query.Value =
"user_id integer primary key autoincrement, user_email text, email_sent_flag text default 'y'";
using (var database = new Sqlite(_dbFile))
{
database.SetData(query);
}
query = new SqliteQuery();
query.Type = QueryType.Select;
query.Table = "user_registration";
query.Value = "count(*)";
DataTable result = null;
using (var database = new Sqlite(_dbFile))
{
result = database.GetData(query);
}
}
public static List <Transaction> Transactions()
{
using (IDbConnection cnn = new SQLiteConnection(SqliteDataAccess.LoadConnectionString()))
{
string read = SqliteQuery.Read("ViewTransaction");
var output = cnn.Query <Transaction>(read, new DynamicParameters());
return(output.ToList());
}
}
public static List <UnitProgressModel> UnitProgress()
{
using (IDbConnection cnn = new SQLiteConnection(SqliteDataAccess.LoadConnectionString()))
{
string read = SqliteQuery.Read("ViewUnitProgress");
var output = cnn.Query <UnitProgressModel>(read, new DynamicParameters());
return(output.ToList());
}
}
public static void Dropdown(DropdownModel table)
{
List <string> list = Read.Dropdown(table.NameOfTable, "Name=" + table.Name);
if (list != null)
{
return;
}
string insert = SqliteQuery.Create(table.NameOfTable, "Name");
SqliteDataAccess.ExecuteQuery(insert, table);
}
public static void Dropdown(DropdownModel table)
{
string update = SqliteQuery.Update("Dropdown", "Name", table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void Employee(EmployeeModel table)
{
string insert = SqliteQuery.Create("Employee", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
public static void User(UserModel table)
{
string Delete = SqliteQuery.Delete("User", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void BillOfMaterials(BillOfMaterialsModel table)
{
string Delete = SqliteQuery.Delete("BillOfMaterials", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void InventoryLimit(InventoryLimitModel table)
{
string Delete = SqliteQuery.Delete("InventoryLimit", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void Employee(EmployeeModel table)
{
string Delete = SqliteQuery.Delete("Employee", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void Database(DatabaseModel table)
{
string update = SqliteQuery.Update("Database", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void BillOfMaterials(BillOfMaterialsModel table)
{
string insert = SqliteQuery.Create("BillOfMaterials", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
public static void User(UserModel table)
{
string insert = SqliteQuery.Create("User", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
public static void UnitProgress(UnitProgressModel table)
{
string insert = SqliteQuery.Create("UnitProgress", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
public static void Transaction(Transaction table)
{
string insert = SqliteQuery.Create("Transaction", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
public static void InventoryLimit(InventoryLimitModel table)
{
string insert = SqliteQuery.Create("InventoryLimit", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
public static void Employee(EmployeeModel table)
{
string update = SqliteQuery.Update("Employee", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void InventoryLimit(InventoryLimitModel table)
{
string update = SqliteQuery.Update("InventoryLimit", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void Database(DatabaseModel table)
{
string Delete = SqliteQuery.Delete("Database", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void Transaction(Transaction table)
{
string update = SqliteQuery.Update("Transaction", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void Inventory(InventoryModel table)
{
string Delete = SqliteQuery.Delete("Inventory", table.ItemCode);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void BillOfMaterials(BillOfMaterialsModel table)
{
string update = SqliteQuery.Update("BillOfMaterials", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void Transaction(Transaction table)
{
string Delete = SqliteQuery.Delete("Transaction", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void UnitProgress(UnitProgressModel table)
{
string update = SqliteQuery.Update("UnitProgress", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void UnitProgress(UnitProgressModel table)
{
string Delete = SqliteQuery.Delete("UnitProgress", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void User(UserModel table)
{
string update = SqliteQuery.Update("User", table.Headers, table.ID);
SqliteDataAccess.ExecuteQuery(update, table);
}
public static void Dropdown(DropdownModel table)
{
string Delete = SqliteQuery.Delete("Dropdown", table.ID);
SqliteDataAccess.ExecuteQuery(Delete, table);
}
public static void Database(DatabaseModel table)
{
string insert = SqliteQuery.Create("Database", table.Headers);
SqliteDataAccess.ExecuteQuery(insert, table);
}
