public static bool InsertProcessInfo(PTProcessInfo info, PTDate date) { bool inserted = false; SqlCeConnection connection = null; int noOfRowAffected = 0; try { connection = Connection(); connection.Open(); var command = connection.CreateCommand(); command.CommandText = "INSERT INTO ProcessInfos (Name, ActiveTime, DateIdx) VALUES (@name, @active, @dateIdx)"; command.Parameters.Add("@name", SqlDbType.NVarChar).Value = info.name; command.Parameters.Add("@active", SqlDbType.Int).Value = info.activeTime.TotalMinutes; command.Parameters.Add("@dateIdx", SqlDbType.Int).Value = date.index; noOfRowAffected = command.ExecuteNonQuery(); if (noOfRowAffected > 0) { inserted = true; } } finally { connection.Close(); } return(inserted); }
public static bool DeleteProcessInfo(PTProcessInfo info, PTDate date) { bool deleted = false; SqlCeConnection connection = null; int noOfRowAffected = 0; try { connection = Connection(); connection.Open(); var command = connection.CreateCommand(); command.CommandText = "DELETE FROM ProcessInfos WHERE Name=@name AND DateIdx=@dateIdx"; command.Parameters.Add("@name", SqlDbType.NVarChar).Value = info.name; command.Parameters.Add("@dateIdx", SqlDbType.Int).Value = date.index; noOfRowAffected = command.ExecuteNonQuery(); if (noOfRowAffected > 0) { deleted = true; } } finally { connection.Close(); } return(deleted); }
public static PTProcessInfo GetInfoForProcessOnDate(string processName, PTDate date) { PTProcessInfo info = new PTProcessInfo(0, string.Empty, default(TimeSpan)); SqlCeConnection connection = null; try { connection = Connection(); connection.Open(); var command = connection.CreateCommand(); command.CommandText = "SELECT * FROM ProcessInfos WHERE Name=@name AND DateIdx=@dateIdx"; command.Parameters.Add("@dateIdx", SqlDbType.Int).Value = date.index; command.Parameters.Add("@name", SqlDbType.NVarChar).Value = processName; SqlCeDataReader reader = command.ExecuteReader(); if (reader.Read()) { info.index = reader.GetInt32(0); info.name = reader.GetString(1); info.activeTime = new TimeSpan(0, reader.GetInt32(2), 0); } } finally { connection.Close(); } return(info); }