public List<UserWorkspace> getWorkspaceList() { List<UserWorkspace> workspaces; try { var workspaceInsertQuery = Resource.ResourceManager.GetString("userworkspaces_select"); sql_con = new SQLiteConnection(Common.localDatabasePath, true); sql_cmd = new SQLiteCommand(workspaceInsertQuery, sql_con); sql_con.Open(); SQLiteDataReader reader = sql_cmd.ExecuteReader(); workspaces = new List<UserWorkspace>(); while (reader.Read()) { UserWorkspace ws = new UserWorkspace(); ws.WorkspaceId = StringUtils.ConvertFromDBVal<string>(reader["id"]); ws.Name = StringUtils.ConvertFromDBVal<string>(reader["name"]); ws.Description = StringUtils.ConvertFromDBVal<string>(reader["description"]); ws.EnterpriseId = StringUtils.ConvertFromDBVal<string>(reader["enterpriseId"]); ws.ModifiedDate = StringUtils.ConvertFromDBVal<string>(reader["modifiedDate"]); ws.CreatedDate = StringUtils.ConvertFromDBVal<string>(reader["createdDate"]); ws.SequenceNumber = StringUtils.ConvertFromDBVal<Int64>(reader["sequenceNumber"]); workspaces.Add(ws); } } catch (SQLiteException e) { throw e; } finally { sql_con.Close(); } return workspaces; }
public void saveWorkspace(UserWorkspace workspace) { try { var workspaceInsertQuery = Resource.ResourceManager.GetString("userworkspaces_insert"); sql_con = new SQLiteConnection(Common.localDatabasePath, true); sql_cmd = new SQLiteCommand(workspaceInsertQuery, sql_con); sql_cmd.Parameters.Add("@id", DbType.String); sql_cmd.Parameters["@id"].Value = workspace.id; sql_cmd.Parameters.Add("@name", DbType.String); sql_cmd.Parameters["@name"].Value = workspace.name; sql_cmd.Parameters.Add("@enterpriseId", DbType.String); sql_cmd.Parameters["@enterpriseId"].Value = workspace.enterpriseId; sql_cmd.Parameters.Add("@sequenceNumber", DbType.Int16); sql_cmd.Parameters["@sequenceNumber"].Value = workspace.sequenceNumber; sql_cmd.Parameters.Add("@description", DbType.String); sql_cmd.Parameters["@description"].Value = workspace.description; sql_cmd.Parameters.Add("@createdDate", DbType.String); sql_cmd.Parameters["@createdDate"].Value = workspace.createdDate; sql_cmd.Parameters.Add("@modifiedDate", DbType.String); sql_cmd.Parameters["@modifiedDate"].Value = workspace.modifiedDate; sql_con.Open(); sql_cmd.ExecuteNonQuery(); } catch (SQLiteException e) { throw e; } finally { sql_con.Close(); } }
public List<UserWorkspace> getWorkspaceNames() { List<UserWorkspace> workspaces; try { var workspaceInsertQuery = "select * from userworkspaces"; sql_con = new SQLiteConnection(Common.localDatabasePath, true); sql_cmd = new SQLiteCommand(workspaceInsertQuery, sql_con); sql_con.Open(); SQLiteDataReader reader = sql_cmd.ExecuteReader(); workspaces = new List<UserWorkspace>(); while (reader.Read()) { UserWorkspace ws = new UserWorkspace(); ws.WorkspaceId = StringUtils.ConvertFromDBVal<string>(reader["id"]); ws.Name = StringUtils.ConvertFromDBVal<string>(reader["name"]); workspaces.Add(ws); } } catch (SQLiteException e) { throw e; } finally { sql_con.Close(); } return workspaces; }
public UserWorkspace getByName(String workspaceName) { UserWorkspace ws; try { var workspaceInsertQuery = "select * from userworkspaces where name=@workspaceName"; sql_con = new SQLiteConnection(Common.localDatabasePath, true); sql_cmd = new SQLiteCommand(workspaceInsertQuery, sql_con); sql_cmd.Parameters.Add("@workspaceName", DbType.String); sql_cmd.Parameters["@workspaceName"].Value = workspaceName; sql_con.Open(); SQLiteDataReader reader = sql_cmd.ExecuteReader(); ws = new UserWorkspace(); // this will have only one record as the names should be unique while (reader.Read()) { ws.WorkspaceId = StringUtils.ConvertFromDBVal<string>(reader["id"]); ws.Name = StringUtils.ConvertFromDBVal<string>(reader["name"]); ws.Description = StringUtils.ConvertFromDBVal<string>(reader["description"]); ws.EnterpriseId = StringUtils.ConvertFromDBVal<string>(reader["enterpriseId"]); ws.ModifiedDate = StringUtils.ConvertFromDBVal<string>(reader["modifiedDate"]); ws.CreatedDate = StringUtils.ConvertFromDBVal<string>(reader["createdDate"]); ws.SequenceNumber = StringUtils.ConvertFromDBVal<Int64>(reader["sequenceNumber"]); } } catch (SQLiteException e) { throw e; } finally { sql_con.Close(); } return ws; }