public static bool Delete(int processId) { string sql = "DELETE FROM Transactions WHERE ProcessId = {0}"; sql = string.Format(sql, SqliteDbHelper.SQLNumber(processId)); if (string.IsNullOrEmpty(SqliteDbHelper.ExecuteQuery(sql))) { return(true); } return(false); }
public bool InsertAndUpdate() { string sql = string.Empty; Licence transaction = Licence.GetInfo(this.OldExePath); if (transaction == null) { sql = string.Format("INSERT INTO " + TABLE_NAME + " (ExePath, Type, TimeInterval,MaxTime,ConcurrentLicences,LastRunStart,LastRunEnd , Enabled) Values ({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7})", SqliteDbHelper.SQLString(this.ExePath), SqliteDbHelper.SQLString(this.Type.ToString()), SqliteDbHelper.SQLNumber(this.TimeInterval), SqliteDbHelper.SQLNumber(this.MaxTime), SqliteDbHelper.SQLNumber(this.ConcurrentLicences), SqliteDbHelper.SQLDateTime(this.LastRunStart), SqliteDbHelper.SQLDateTime(this.LastRunEnd), SqliteDbHelper.SQLBoolean(this.Enabled)); } else { this.LastRunEnd = transaction.LastRunEnd; this.LastRunStart = transaction.LastRunStart; sql = string.Format("UPDATE " + TABLE_NAME + " Set Type = {1}, TimeInterval = {2}, MaxTime ={3}, ConcurrentLicences = {4}, LastRunStart={5}, LastRunEnd={6}, Enabled = {7},ExePath = {8} WHERE ExePath = {0} ", SqliteDbHelper.SQLString(this.OldExePath), SqliteDbHelper.SQLString(this.Type.ToString()), SqliteDbHelper.SQLNumber(this.TimeInterval), SqliteDbHelper.SQLNumber(this.MaxTime), SqliteDbHelper.SQLNumber(this.ConcurrentLicences), SqliteDbHelper.SQLDateTime(this.LastRunStart), SqliteDbHelper.SQLDateTime(this.LastRunEnd), SqliteDbHelper.SQLBoolean(this.Enabled), SqliteDbHelper.SQLString(this.ExePath)); } if (string.IsNullOrEmpty(SqliteDbHelper.ExecuteQuery(sql))) { _Saved = true; _Dirty = false; } return(_Saved); }
/// <summary> /// Save the transaction, /// <para>If GUID not exists then insert new </para> /// <para> Otherwise Update existing</para> /// </summary> /// <param name="forceInsert">Insert a new transaction force fully</param> /// <returns>Return true if saved, else false</returns> public bool Save(bool forceInsert = false) { string sql = string.Empty; if (forceInsert) { sql = string.Format("INSERT INTO Transactions (Guid, ProcessId, Application, ExePath, StartedAt, EndedAt, Enabled) Values ({0}, {1}, {2}, {3}, {4}, {5}, {6})", SqliteDbHelper.SQLString(this.Guid), SqliteDbHelper.SQLNumber(this.ProcessId), SqliteDbHelper.SQLString(this.Application), SqliteDbHelper.SQLString(this.ExeName), SqliteDbHelper.SQLDateTime(this.StartedAt), SqliteDbHelper.SQLDateTime(this.EndedAt), SqliteDbHelper.SQLBoolean(this.Enabled)); } else { Transaction transaction = Transaction.Get(this.Guid); if (transaction != null) //ByJASPREET(09/jan/2015):it insert row sometime after delete by exe successfully. { sql = string.Format("UPDATE Transactions Set ProcessId = {0}, Application = {1},ExePath = {2}, StartedAt = {3}, EndedAt = {4}, Enabled = {5} where Guid = {6} ", SqliteDbHelper.SQLNumber(this.ProcessId), SqliteDbHelper.SQLString(this.Application), SqliteDbHelper.SQLString(this.ExeName), SqliteDbHelper.SQLDateTime(this.StartedAt), SqliteDbHelper.SQLDateTime(this.EndedAt), SqliteDbHelper.SQLBoolean(this.Enabled), SqliteDbHelper.SQLString(this.Guid)); } } if (string.IsNullOrEmpty(SqliteDbHelper.ExecuteQuery(sql))) { _Saved = true; _Dirty = false; } return(_Saved); }