public static TableScripts SqlLiteDBInsertEmployee(Employee model)
{
TableScripts tableInsertScripts;
tableInsertScripts =
new TableScripts
{
nameTable = @"\employee.db",
script = @"insert into Employee values"
+ "(" + model.employee_id.ToString() + ",'"
+ model.employee_name + "')",
operationType = OperationType.write,
connectionProperties = new Microsoft.Data.Sqlite.SqliteConnection(@"DataSource=" + GetPathDBFile() + @"\employee.db")
};
return(tableInsertScripts);
}
public static string ExecuteQuery(TableScripts tableScripts)
{
using (var com0 = new SqliteCommand(tableScripts.script, tableScripts.connectionProperties))
{
try
{
tableScripts.connectionProperties.Open();
com0.ExecuteNonQuery();
tableScripts.connectionProperties.Close();
return(string.Empty);
}
catch (SqliteException ex)
{
SLogToFile.SaveInfoInFile("|ExecuteQuery|" + ex.Message);
return(ex.Message);
}
}
}
public static TableScripts SqlLiteDBInsertClient(Client model)
{
TableScripts tableInsertScripts;
tableInsertScripts = new TableScripts
{
nameTable = @"\client.db",
script = @"insert into Client values"
+ "(" + model.client_id.ToString() + ",'"
+ model.client_name + "','"
+ model.client_sname + "','"
+ model.client_phone + "','"
+ model.client_description + "')",
operationType = OperationType.write,
connectionProperties = new Microsoft.Data.Sqlite.SqliteConnection(@"DataSource=" + GetPathDBFile() + @"\client.db")
};
return(tableInsertScripts);
}
public static TableScripts SqlLiteDBInsertReservation(Reservation model, int client_id, int services_id, int employee_id)
{
TableScripts tableInsertScripts;
tableInsertScripts =
new TableScripts
{
nameTable = @"\reservation.db",
script = @"insert into Reservation values"
+ "(" + model.reservation_id.ToString() + ",'"
+ model.reservation_date + "','"
+ model.reservation_time + "',"
+ client_id.ToString() + ","
+ services_id.ToString() + ","
+ employee_id.ToString()
+ ")",
operationType = OperationType.write,
connectionProperties = new Microsoft.Data.Sqlite.SqliteConnection(@"DataSource=" + GetPathDBFile() + @"\reservation.db")
};
return(tableInsertScripts);
}