public Process UpdateProcess(Process process)
{
using (SQLiteConnection conn = new SQLiteConnection(UrlBuilder.ToString()))
{
conn.Open();
if(process == null)
throw new NoNullAllowedException("Process can't be null");
StringBuilder sb = new StringBuilder();
sb.Append(Update);
sb.Append(ProcessTable);
sb.Append(Set);
sb.Append("WebId=@webId, AccountId=@accountId, Name=@name, UpdatedAt=@updatedAt");
sb.Append(Where);
sb.Append("Id= " + process.Id);
sb.Append(End);
var command = new SQLiteCommand(sb.ToString(), conn);
command.Parameters.Add(new SQLiteParameter("@webId", process.WebId));
command.Parameters.Add(new SQLiteParameter("@accountId", process.AccountId));
command.Parameters.Add(new SQLiteParameter("@name", process.Name));
command.Parameters.Add(new SQLiteParameter("@updatedAt", DateTime.Now));
Console.WriteLine(sb.ToString());
command.ExecuteNonQuery();
}
return GetProcessById(process.Id);
}
public Process SaveProcess(Process process)
{
using (SQLiteConnection conn = new SQLiteConnection(UrlBuilder.ToString()))
{
conn.Open();
if (process == null)
throw new NoNullAllowedException("Process object can't be null");
/*if (process.AccountId <= 0)
throw new ArgumentException("AccountId needs to be specified.");*/
StringBuilder sb = new StringBuilder();
Console.WriteLine("Saving a Process");
sb.Append(InsertInto);
sb.Append(ProcessTable);
sb.Append("(AccountId, Name, CreatedAt, UpdatedAt)");
sb.Append(Values);
sb.Append("(@accountid, @name, @createdAt, @updatedAt)");
sb.Append(End);
var command = new SQLiteCommand(sb.ToString(), conn);
command.Parameters.Add(new SQLiteParameter("@accountid", process.AccountId));
command.Parameters.Add(new SQLiteParameter("@name", process.Name));
command.Parameters.Add(new SQLiteParameter("@createdAt", DateTime.Now));
command.Parameters.Add(new SQLiteParameter("@updatedAt", DateTime.Now));
Console.WriteLine(sb.ToString());
command.ExecuteNonQuery();
}
Console.WriteLine("Done writing Process");
var savedProcess = GetProcesses().First(p => p.AccountId == process.AccountId && p.Name == process.Name);
return savedProcess;
}
