private void GetPasswordWithFormat(string username, bool updateLastLoginActivityDate, out int status, out string password, out int passwordFormat, out string passwordSalt, out int failedPasswordAttemptCount, out int failedPasswordAnswerAttemptCount, out bool isApproved, out DateTime lastLoginDate, out DateTime lastActivityDate)
{
password = null;
passwordFormat = 0;
passwordSalt = null;
failedPasswordAttemptCount = 0;
failedPasswordAnswerAttemptCount = 0;
isApproved = false;
lastLoginDate = DateTime.Now;
lastActivityDate = DateTime.Now;
status = -1;
System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("aspnet_Membership_GetPasswordWithFormat");
this.database.AddInParameter(storedProcCommand, "UserName", System.Data.DbType.String, username);
this.database.AddInParameter(storedProcCommand, "UpdateLastLoginActivityDate", System.Data.DbType.Boolean, updateLastLoginActivityDate);
this.database.AddInParameter(storedProcCommand, "CurrentTime", System.Data.DbType.DateTime, DateTime.Now);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(storedProcCommand))
{
if (dataReader.Read())
{
password = dataReader.GetString(0);
passwordFormat = dataReader.GetInt32(1);
passwordSalt = dataReader.GetString(2);
failedPasswordAttemptCount = dataReader.GetInt32(3);
failedPasswordAnswerAttemptCount = dataReader.GetInt32(4);
isApproved = dataReader.GetBoolean(5);
lastLoginDate = dataReader.GetDateTime(6);
lastActivityDate = dataReader.GetDateTime(7);
status = 0;
}
}
}
public bool PreencheAtributo(System.Data.IDataReader lDataReader, int NumeroColuna, bool Atributo)
{
if ((lDataReader.IsDBNull(NumeroColuna) == true))
{
return(false);
}
else
{
return(lDataReader.GetBoolean(NumeroColuna));
}
}
public void Start(SP.ISPDatabase sharepointDatabase, SP.SPListDefinition list, UI.IProgressNotifier notifier)
{
notifier.Reset("Initializing...");
_Formatter.Initialize();
SP.SPFieldDefinitionCollection oFieldList = list.Fields;
notifier.SetProgress("Retrieving records from Sharepoint database...", 0);
System.Data.IDataReader oReader = sharepointDatabase.GetListItemsAsReader(list, true, false);
oReader.Read();
int nTotalRecords = oReader.GetInt32(0);
int nProcessedRecords = 0;
notifier.SetProgress(string.Format("{0} records retrieved. Now exporting...", nTotalRecords.ToString()), 10);
oReader.NextResult();
while (oReader.Read())
{
int nListItemID = Convert.ToInt32(oReader["ID"]);
_Formatter.BeginExportRow(nListItemID.ToString());
foreach (SP.SPFieldDefinition oField in oFieldList)
{
_Formatter.ExportField(oField.InternalName, sharepointDatabase.GetFieldText(oField, oReader));
}
if (_Formatter.SupportAttachments && oReader.GetBoolean(oReader.GetOrdinal("HasAttachments")))
{
DataTable oAttachmentList = sharepointDatabase.GetListItemAttachmentsList(list, nListItemID, true);
int nCounter = 1;
foreach (DataRow oAttachment in oAttachmentList.Rows)
{
_Formatter.ExportAttachment(nCounter, oAttachment["Folder"].ToString(), oAttachment["Filename"].ToString(), (byte[])oAttachment["Content"]);
nCounter++;
}
}
_Formatter.EndExportRow();
nProcessedRecords++;
if (nProcessedRecords % 100 == 0)
{
notifier.SetProgress(null, (short)(10 + (nProcessedRecords * 90 / nTotalRecords)));
}
}
_Formatter.Terminate();
notifier.SetComplete(null);
}
public bool GetBoolean(int i)
{
return(_innerReader.GetBoolean(i));
}
