private static void ConvertTimesheets(DBHelper source, DBHelper target)
{
IDictionary<int, Project> projects = Project.LoadList(source);
#region Copy Projects to cls_Project
foreach (Project project in projects.Values)
{
project.Save(target);
}
#endregion
#region Copy WeekTimeSheet to cls_TimeTrackingBlock
IDictionary<int, TTBlock> blocks = TTBlock.LoadList(source);
string ttGlobalBlockTitle = (string)target.RunTextScalar("SELECT [Title] FROM [cls_TimeTrackingBlockTypeInstance] WHERE [ProjectId] IS NULL");
foreach (TTBlock block in blocks.Values)
{
Project project = null;
if (block.ProjectId < 0)
block.Title = ttGlobalBlockTitle;
else
project = projects[block.ProjectId];
block.Save(target, project);
}
#endregion
#region Copy Timesheets to cls_TimeTrackingEntry
IDictionary<int, TTEntry> entries = TTEntry.LoadList(source);
foreach (TTEntry entry in entries.Values)
{
TTBlock block = blocks[entry.WeekTimeSheetId];
entry.BlockTypeInstanceId = block.BlockTypeInstanceId;
entry.OwnerId = block.OwnerId;
entry.ParentBlockId = block.BlockId;
entry.Save(target);
}
#endregion
target.RunSP("TimeTrackingBlockRecalculateDayAll");
target.RunText("UPDATE ActualFinances SET ObjectTypeId = 3, ObjectId = I.ProjectId FROM ActualFinances F JOIN cls_TimeTrackingBlock B ON (F.BlockId = B.TimeTrackingBlockId) JOIN cls_TimeTrackingBlockTypeInstance I ON (I.TimeTrackingBlockTypeInstanceId = B.BlockTypeInstanceId) WHERE F.BlockId IS NOT NULL AND F.ObjectTypeId = 14");
target.RunText("UPDATE cls_TimeTrackingEntry SET Rate = ISNULL(M.Rate, 0) FROM cls_TimeTrackingEntry E JOIN cls_TimeTrackingBlock B ON E.ParentBlockId = B.TimeTrackingBlockId JOIN cls_TimeTrackingBlockTypeInstance I ON E.BlockTypeInstanceId = I.TimeTrackingBlockTypeInstanceId LEFT JOIN PROJECT_MEMBERS M ON (I.ProjectId = M.ProjectId AND E.OwnerId = M.PrincipalId AND M.IsTeamMember = 1) WHERE B.AreFinancesRegistered = 1 AND E.Rate IS NULL");
target.RunSP("TimeTrackingRecalculateAllObjects");
}
protected void CopyBinaryData(DBHelper source, string sourceTableName, string sourceBinColumn, string sourceIdentityColumn, object sourceId,
DBHelper target, string targetTableName, string targetBinColumn, string targetIdentityColumn,
SqlCommand cmd, SqlParameter paramTextPtr, SqlParameter paramData, SqlParameter paramId)
{
if (source == null)
throw new ArgumentNullException("source");
if (cmd == null)
throw new ArgumentNullException("cmd");
if (paramTextPtr == null)
throw new ArgumentNullException("paramTextPtr");
if (target == null)
throw new ArgumentNullException("target");
if (paramData == null)
throw new ArgumentNullException("paramData");
object size = source.RunTextScalar(string.Format(CultureInfo.InvariantCulture, "SELECT DATALENGTH([{0}]) FROM [{1}] WHERE [{2}] = @id", sourceBinColumn, sourceTableName, sourceIdentityColumn), new SqlParameter("@id", sourceId));
if (size != null && size != DBNull.Value && (int)size > 0)
{
cmd.CommandText = string.Format(CultureInfo.InvariantCulture, "SET NOCOUNT ON UPDATE [{1}] SET [{0}] = 0x0 WHERE [{2}] = @id SELECT @ptr = TEXTPTR([{0}]) FROM [{1}] WHERE [{2}] = @id", targetBinColumn, targetTableName, targetIdentityColumn);
cmd.Parameters.Clear();
cmd.Parameters.Add(paramId);
cmd.Parameters.Add(paramTextPtr);
paramTextPtr.Direction = ParameterDirection.Output;
target.RunCmd(cmd);
cmd.CommandText = string.Format(CultureInfo.InvariantCulture, "UPDATETEXT [{0}].[{1}] @ptr 0 NULL @data", targetTableName, targetBinColumn);
cmd.Parameters.Clear();
cmd.Parameters.Add(paramData);
cmd.Parameters.Add(paramTextPtr);
paramTextPtr.Direction = ParameterDirection.Input;
using (IDataReader reader = source.RunTextDataReaderBlob(string.Format(CultureInfo.InvariantCulture, "SELECT [{0}] FROM [{1}] WHERE [{2}] = @id", sourceBinColumn, sourceTableName, sourceIdentityColumn), new SqlParameter("@id", sourceId)))
{
if (reader.Read())
{
long read, startIndex = 0;
do
{
read = reader.GetBytes(0, startIndex, _buffer, 0, _binaryBufferSize);
paramData.Size = (int)read;
target.RunCmd(cmd);
startIndex += read;
cmd.CommandText = string.Format(CultureInfo.InvariantCulture, "UPDATETEXT [{0}].[{1}] @ptr NULL NULL @data", targetTableName, targetBinColumn);
} while (read == _binaryBufferSize);
}
}
}
}
internal void LoadExtendedInfo(DBHelper dbHelper)
{
try
{
dbHelper.Database = Database;
DatabaseSize = 8 * Convert.ToInt32(dbHelper.RunTextScalar("SELECT SUM([size]) FROM [sysfiles] WHERE ([status] & 0x42) = 2"), CultureInfo.InvariantCulture) / 1024; // size in Megabytes
using (IDataReader reader = dbHelper.RunTextDataReader("SELECT [State],[Build] FROM [DatabaseVersion] WITH (NOLOCK)"))
{
reader.Read();
DatabaseState = Convert.ToInt32(reader["State"], CultureInfo.InvariantCulture);
DatabaseVersion = Convert.ToInt32(reader["Build"], CultureInfo.InvariantCulture);
}
if (DatabaseState == 6) // Ready
{
_defaultLanguage.Load(dbHelper);
InternalUsersCount = Convert.ToInt32(dbHelper.RunTextScalar("SELECT COUNT(*) FROM [USERS] WHERE [Activity]=3 AND [IsExternal]=0"), CultureInfo.InvariantCulture);
ExternalUsersCount = Convert.ToInt32(dbHelper.RunTextScalar("SELECT COUNT(*) FROM [USERS] WHERE [Activity]=3 AND [IsExternal]=1"), CultureInfo.InvariantCulture);
}
}
finally
{
dbHelper.Database = null;
}
}
public void Convert(int sourceCompanyId, int targetCompanyId)
{
bool convertAll = true;
DBHelper source = new DBHelper(_sourceConnectionString);
DBHelper target = new DBHelper(_targetConnectionString);
source.CommandTimeout = target.CommandTimeout = _sqlCommandTimeout;
#region Validate databases' versions
ValidateDatabaseVersion(source, RequiredSourceVersion, true);
ValidateDatabaseVersion(target, RequiredTargetVersion, false);
string sourcePortalDatabase = GetPortalDB(source, sourceCompanyId);
string targetPortalDatabase = GetPortalDB(target, targetCompanyId);
source.Database = sourcePortalDatabase;
target.Database = targetPortalDatabase;
ValidateDatabaseVersion(source, RequiredSourceVersion, true);
ValidateDatabaseVersion(target, RequiredTargetVersion, false);
source.Database = null;
target.Database = null;
#endregion
#region Declare variables
XmlDocument doc = new XmlDocument();
string tableName, selectCommand;
List<StringCollection> nameLists = new List<StringCollection>();
List<Hashtable> valueHashTables = new List<Hashtable>();
StringCollection namesCompanyId = new StringCollection();
StringCollection namesImGroupId = new StringCollection();
StringCollection namesUserId = new StringCollection();
StringCollection namesChatId = new StringCollection();
Hashtable valuesCompanyId = new Hashtable();
Hashtable valuesImGroupId = new Hashtable();
Hashtable valuesUserId = new Hashtable();
Hashtable valuesChatId = new Hashtable();
nameLists.Add(namesCompanyId);
nameLists.Add(namesImGroupId);
nameLists.Add(namesUserId);
nameLists.Add(namesChatId);
valueHashTables.Add(valuesCompanyId);
valueHashTables.Add(valuesImGroupId);
valueHashTables.Add(valuesUserId);
valueHashTables.Add(valuesChatId);
namesCompanyId.Add("company_id");
namesImGroupId.Add("imgroup_id");
namesImGroupId.Add("dep_imgroup_id");
namesImGroupId.Add("imgroupid");
namesUserId.Add("user_id");
namesUserId.Add("from_user_id");
namesUserId.Add("to_user_id");
namesUserId.Add("owner_id");
namesUserId.Add("cont_user_id");
namesUserId.Add("originalid");
namesChatId.Add("chat_id");
#endregion
if (convertAll)
{
#region Convert Main DB
SendProgress("*** Converting main database ***");
SendProgress("Deleting target company data");
target.RunSP("ASP_EmptyTables",
DBHelper.MP("@company_id", SqlDbType.Int, targetCompanyId),
DBHelper.MP("@delete_trial_requests", SqlDbType.Bit, true));
SendProgress("Done");
doc.Load("ConvertMain.xml");
foreach (XmlNode table in doc.SelectNodes("/tables/table"))
{
bool copyBinary = true;
{
XmlAttribute attr = table.Attributes["copyBinary"];
if (attr != null)
copyBinary = bool.Parse(attr.Value);
}
tableName = table.Attributes["name"].Value;
switch (tableName)
{
case "COMPANIES":
valuesCompanyId[sourceCompanyId] = targetCompanyId;
ArrayList skip = new ArrayList();
skip.Add("company_id");
skip.Add("domain");
skip.Add("db_name");
skip.Add("app_id");
UpdateRecord(tableName, string.Format(CultureInfo.InvariantCulture, "WHERE [company_id] = {0}", sourceCompanyId), string.Format(CultureInfo.InvariantCulture, "WHERE [company_id] = {0}", targetCompanyId), skip, source, target);
break;
case "IMGROUPS":
selectCommand = string.Format(CultureInfo.InvariantCulture, "WHERE company_id={1}", tableName, sourceCompanyId);
CopyTable(tableName, "", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, valuesImGroupId);
break;
case "USER":
selectCommand = string.Format(CultureInfo.InvariantCulture, "U JOIN IMGROUPS G ON (G.imgroup_id = U.imgroup_id) WHERE G.company_id = {1}", tableName, sourceCompanyId);
CopyTable(tableName, "U.", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, valuesUserId);
break;
case "CHATS":
selectCommand = string.Format(CultureInfo.InvariantCulture, "C JOIN [USER] U ON (U.user_id = C.owner_id) JOIN IMGROUPS G ON (G.imgroup_id = U.imgroup_id) WHERE G.company_id = {1}", tableName, sourceCompanyId);
CopyTable(tableName, "C.", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, valuesChatId);
break;
case "BINARY_DATA":
selectCommand = string.Format(CultureInfo.InvariantCulture, "WHERE [fid] IN (SELECT D2.file_id FROM [FILE] D2 JOIN [USER] U1 ON (U1.user_id = D2.from_user_id) JOIN IMGROUPS G1 ON (G1.imgroup_id = U1.imgroup_id) JOIN [USER] U2 ON (U2.user_id = D2.to_user_id) JOIN IMGROUPS G2 ON (G2.imgroup_id = U2.imgroup_id) WHERE G1.company_id = {0} AND G2.company_id = {0})", sourceCompanyId);
CopyTable(tableName, "", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, null);
break;
case "CONTACT_LIST":
selectCommand = string.Format(CultureInfo.InvariantCulture, "D2 JOIN [USER] U1 ON (U1.user_id = D2.user_id) JOIN IMGROUPS G1 ON (G1.imgroup_id = U1.imgroup_id) JOIN [USER] U2 ON (U2.user_id = D2.cont_user_id) JOIN IMGROUPS G2 ON (G2.imgroup_id = U2.imgroup_id) WHERE G1.company_id = {1} AND G2.company_id = {1}", tableName, sourceCompanyId);
CopyTable(tableName, "D2.", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, null);
break;
case "DEPENDENCES":
selectCommand = string.Format(CultureInfo.InvariantCulture, "D JOIN IMGROUPS G1 ON (G1.imgroup_id = D.imgroup_id) JOIN IMGROUPS G2 ON (G2.imgroup_id = D.DEP_IMGROUP_ID) WHERE G1.company_id = {1} AND G2.company_id = {1}", tableName, sourceCompanyId);
CopyTable(tableName, "D.", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, null);
break;
case "CHAT_USERS":
selectCommand = string.Format(CultureInfo.InvariantCulture, "D2 JOIN [USER] U1 ON (U1.user_id = D2.user_id) JOIN IMGROUPS G1 ON (G1.imgroup_id = U1.imgroup_id) JOIN [USER] U2 ON (U2.user_id = D2.from_user_id) JOIN IMGROUPS G2 ON (G2.imgroup_id = U2.imgroup_id) WHERE G1.company_id = {1} AND G2.company_id = {1}", tableName, sourceCompanyId);
CopyTable(tableName, "D2.", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, null);
break;
case "AUTH_LIST":
case "FILE":
case "USER_MESS":
selectCommand = string.Format(CultureInfo.InvariantCulture, "D2 JOIN [USER] U1 ON (U1.user_id = D2.from_user_id) JOIN IMGROUPS G1 ON (G1.imgroup_id = U1.imgroup_id) JOIN [USER] U2 ON (U2.user_id = D2.to_user_id) JOIN IMGROUPS G2 ON (G2.imgroup_id = U2.imgroup_id) WHERE G1.company_id = {1} AND G2.company_id = {1}", tableName, sourceCompanyId);
CopyTable(tableName, "D2.", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, null);
break;
case "PORTAL_SESSIONS":
case "SESSIONS":
case "STATUS_LOG":
case "CHAT_MESS":
selectCommand = string.Format(CultureInfo.InvariantCulture, "D1 JOIN [USER] U ON (U.user_id = D1.user_id) JOIN IMGROUPS G ON (G.imgroup_id = U.imgroup_id) WHERE G.company_id = {1}", tableName, sourceCompanyId);
CopyTable(tableName, "D1.", "*", selectCommand, copyBinary, source, target, nameLists, valueHashTables, false, null);
break;
}
}
SendProgress("Hashing passwords...");
HashPasswords(target, "USER", "USER_ID", "PASSWORD");
SendProgress("Done");
SendProgress("*** Done ***");
#endregion
}
#region Convert portal DB
SendProgress("*** Converting portal database ***");
source.Database = sourcePortalDatabase;
target.Database = targetPortalDatabase;
if (convertAll)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
doc.Load("ConvertPortal.xml");
XmlNodeList tablesCopy = doc.SelectNodes("/tables/table");
#region Clear tables in reversed order
ClearTables(tablesCopy, target);
#endregion
#region Load calendars for imported projects
Hashtable calendars = new Hashtable();
using (IDataReader reader = source.RunTextDataReader("SELECT CalendarId, ProjectId FROM [CALENDARS] WHERE ProjectId IS NOT NULL"))
{
while (reader.Read())
{
calendars[reader[0]] = reader[1];
}
}
#endregion
#region Copy tables
CopyPortalTables(1, 1, tablesCopy, source, target, nameLists, valueHashTables);
#endregion
#region Update ProjectId column for CALENDARS
SendProgress("Updating project calendars");
foreach (object key in calendars.Keys)
{
object projectId = calendars[key];
target.RunTextDataReader("UPDATE [CALENDARS] SET ProjectId=@pid WHERE CalendarId=@cid"
, DBHelper.MP("@pid", SqlDbType.Int, projectId)
, DBHelper.MP("@cid", SqlDbType.Int, key)
);
}
SendProgress("Done");
#endregion
#region Copy meta data
SendProgress("* Copying metadata *");
// Load meta classes
ArrayList metaClasses = MyMetaClass.LoadList(source);
StringBuilder sbMetaClassesToDelete = new StringBuilder();
// Load meta fields, create and copy tables
foreach (MyMetaClass mc in metaClasses)
{
if (mc.Name.StartsWith("ListsEx_", StringComparison.Ordinal) || mc.Name.StartsWith("ListTemplate_", StringComparison.Ordinal))
{
if(sbMetaClassesToDelete.Length > 0)
sbMetaClassesToDelete.Append(",");
sbMetaClassesToDelete.Append(mc.MetaClassId.ToString(CultureInfo.InvariantCulture));
}
else
{
mc.LoadFields(source);
SendProgress("Creating tables for MetaData class: {0}", mc.Name);
mc.CreateTables(target);
SendProgress("Done");
selectCommand = "";//string.Format("SELECT * FROM [{0}]", mc.TableName);
CopyTable(mc.TableName, "", "*", selectCommand, true, source, target, null, null, true, null);
CopyTable(mc.TableNameHistory, "", "*", selectCommand, true, source, target, null, null, true, null);
}
}
string metaClassesToDelete = sbMetaClassesToDelete.ToString();
if (!string.IsNullOrEmpty(metaClassesToDelete))
{
target.RunText(string.Concat("DELETE FROM [MetaClassMetaFieldRelation] WHERE [MetaClassId] IN (", metaClassesToDelete, ")"));
target.RunText(string.Concat("DELETE FROM [MetaClass] WHERE [MetaClassId] IN (", metaClassesToDelete, ")"));
}
string defaultLocale = (string)source.RunTextScalar("SELECT [Locale] FROM [LANGUAGES] WHERE [IsDefault] = 1");
using (DBTransaction tran = target.BeginTransaction())
{
//target.RunText("DROP TABLE [OrganizationsEx]");
//target.RunText("DROP TABLE [OrganizationsEx_History]");
Mediachase.MetaDataPlus.Configurator.MetaInstaller.RestoreFromFile(tran.SqlTran, string.Format(CultureInfo.InvariantCulture, "metadata_{0}.xml", defaultLocale));
tran.Commit();
}
SendProgress("* Done *");
#endregion
#region Copy GROUPS to cls_Principal
using (IDataReader reader = source.RunTextDataReader("SELECT [PrincipalId], [GroupName] FROM [GROUPS] WHERE [PrincipalId] > 9"))
{
while (reader.Read())
{
int principalId = (int)reader["PrincipalId"];
string groupName = reader["GroupName"].ToString();
target.RunText(
"INSERT INTO [cls_Principal] ([PrincipalId],[Card],[Name],[Activity]) VALUES (@1,N'Department',@2,3)"
, DBHelper.MP("@1", SqlDbType.Int, principalId)
, DBHelper.MP("@2", SqlDbType.NVarChar, 100, groupName)
);
}
}
#endregion
#region Copy USERS to cls_Principal
using (IDataReader reader = source.RunTextDataReader("SELECT [PrincipalId], [FirstName], [LastName], [Activity] FROM [USERS]"))
{
while (reader.Read())
{
int principalId = (int)reader["PrincipalId"];
string firstName = reader["FirstName"].ToString();
string lastName = reader["LastName"].ToString();
byte activity = (byte)reader["Activity"];
target.RunText(
"INSERT INTO [cls_Principal] ([PrincipalId],[Card],[Name],[Activity]) VALUES (@1,N'User',@2,@3)"
, DBHelper.MP("@1", SqlDbType.Int, principalId)
, DBHelper.MP("@2", SqlDbType.NVarChar, 100, lastName + ", " + firstName)
, DBHelper.MP("@3", SqlDbType.Int, activity)
);
}
}
#endregion
SendProgress("Hashing passwords...");
HashPasswords(target, "USERS", "PrincipalId", "Password");
SendProgress("Done");
// Update ExpectedAssignDate for issues
target.RunText("SET DATEFIRST 7 UPDATE [INCIDENTS] SET [ExpectedAssignDate] = [dbo].GetFinishDateByDuration(B.CalendarId, I.CreationDate, B.ExpectedAssignTime) FROM [INCIDENTS] I JOIN [IncidentBox] B ON (B.IncidentBoxId = I.IncidentBoxId)");
#region Convert timesheets
SendProgress("* Converting timesheets *");
using (DBTransaction tran = target.BeginTransaction())
{
ConvertTimesheets(source, target);
tran.Commit();
}
SendProgress("* Done *");
#endregion
}
string installationDirectoryPath = @"..\"; // TODO: get from registry
Mediachase.Ibn.GlobalContext.Current = new GlobalContext(System.IO.Path.Combine(installationDirectoryPath, @"Web\portal\Apps"));
#region Convert lists
SendProgress("* Converting lists *");
using (MD47.DataContext dataContext47 = new MD47.DataContext(string.Empty))
{
// Initialize metadata
MD47.DataContext.Current = dataContext47;
dataContext47.SqlContext.CommandTimeout = _sqlCommandTimeout;
//MD45.MetaDataContext.Current.ConnectionString = sourcePortalConnectionString;
SqlTransaction previousSourceTransaction = MD45.MetaDataContext.Current.Transaction;
SqlTransaction previousTargetTransaction = MD47.DataContext.Current.SqlContext.Transaction;
SqlTransaction previousDatabaseTransaction = Mediachase.IBN.Database.DbContext.Current.Transaction;
using (DBTransaction tranSource = source.BeginTransaction())
using (DBTransaction tran = target.BeginTransaction())
{
MD45.MetaDataContext.Current.Transaction = tranSource.SqlTran;
MD47.DataContext.Current.SqlContext.Transaction = tran.SqlTran;
Mediachase.IBN.Database.DbContext.Current.Transaction = tran.SqlTran;
try
{
ConvertLists(source, target);
tran.Commit();
}
finally
{
MD45.MetaDataContext.Current.Transaction = previousSourceTransaction;
MD47.DataContext.Current.SqlContext.Transaction = previousTargetTransaction;
Mediachase.IBN.Database.DbContext.Current.Transaction = previousDatabaseTransaction;
}
}
}
SendProgress("* Done *");
#endregion
#region Convert contacts and organizations
SendProgress("* Converting contacts and organizations *");
ClientsConverter clientsConverter = new ClientsConverter(_sqlCommandTimeout);
try
{
clientsConverter.Warning += new EventHandler<ClientsConverterEventArgs>(OnClientsConverterWarning);
clientsConverter.Convert(source, target);
}
finally
{
clientsConverter.Warning -= OnClientsConverterWarning;
}
SendProgress("* Done *");
#endregion
target.RunText("DELETE [HISTORY] WHERE [ObjectTypeId] = 21 OR [ObjectTypeId] = 22");
target.RunText("DELETE FROM [USER_SETTINGS] WHERE [Value] LIKE '%org%' OR [Value] LIKE '%vcard%' OR [Key] LIKE '%org%' OR [Key] LIKE '%vcard%'");
SendProgress("*** Done ***");
#endregion
}
public static IDictionary<int, TTEntry> LoadList(DBHelper source)
{
Dictionary<int, TTEntry> ret = new Dictionary<int, TTEntry>();
using (IDataReader reader = source.RunTextDataReader("SELECT * FROM [TIMESHEETS]"))
{
while (reader.Read())
{
TTEntry item = Load(reader);
if (!ret.ContainsKey(item._timeSheetId))
ret.Add(item._timeSheetId, item);
}
}
foreach (TTEntry entry in ret.Values)
{
string table = null;
string field = null;
switch (entry._objectTypeId)
{
case 3:
table = "PROJECTS";
field = "ProjectId";
break;
case 4:
table = "EVENTS";
field = "EventId";
break;
case 5:
table = "TASKS";
field = "TaskId";
break;
case 6:
table = "TODO";
field = "ToDoId";
break;
case 7:
table = "INCIDENTS";
field = "IncidentId";
break;
case 11:
table = "TIMESHEET_TODO";
field = "TimeSheetToDoId";
break;
case 16:
table = "DOCUMENTS";
field = "DocumentId";
break;
}
if (table != null && field != null)
{
object title = source.RunTextScalar(string.Format(CultureInfo.InvariantCulture, "SELECT [Title] FROM [{0}] WHERE [{1}] = @p1", table, field), DBHelper.MP("@p1", SqlDbType.Int, entry._objectId));
if (title != null && title != DBNull.Value)
{
entry._title = title.ToString();
}
else
{
entry._objectTypeId = -1;
entry._objectId = -1;
entry._title = string.Format(CultureInfo.InvariantCulture, "#{0}", entry._timeSheetId);
}
}
}
return ret;
}
