/// Author: Josephine Monteza
/// Date Created: 03/Nov/2015
/// Description: Get all Immigartion Users with alternate email to reset pwd
private void AddEditImmigrationOfficers()
{
DataTable dtUser = null;
DataTable dt = null;
string sMsg = "";
try
{
CheckBox lChkSelect;
Label lAlternateEmail;
Label lUserName;
Label lLastName;
Label lFirstName;
//Label lMiddleName;
Label lEmail;
string sAlternateEmail;
string sUserName;
string sPassword;
string sLastName;
string sFirstName;
//string sMiddleName;
string sEmail;
dt = new DataTable();
DataColumn col = new DataColumn("UserName", typeof(string));
dt.Columns.Add(col);
DataRow row = dt.NewRow();
if (uoUserList.Items.Count > 0)
{
for (int i = 0; i < uoUserList.Items.Count; i++)
{
lChkSelect = (CheckBox)uoUserList.Items[i].FindControl("uoCheckBoxSelect");
if (lChkSelect.Checked)
{
lUserName = (Label)uoUserList.Items[i].FindControl("uoLblUName");
lAlternateEmail = (Label)uoUserList.Items[i].FindControl("uoLabelAltEmail");
lLastName = (Label)uoUserList.Items[i].FindControl("uoLabelLName");
lFirstName = (Label)uoUserList.Items[i].FindControl("uoLabelFName");
lEmail = (Label)uoUserList.Items[i].FindControl("uoLabelEmail");
sUserName = lUserName.Text;
sAlternateEmail = lAlternateEmail.Text;
sLastName = lLastName.Text;
sFirstName = lFirstName.Text;
// sMiddleName = "";
sEmail = lEmail.Text;
MembershipUser mUser = Membership.GetUser(sUserName);
if (mUser.IsLockedOut)
{
mUser.UnlockUser();
}
sPassword = mUser.ResetPassword();
mUser.ChangePassword(sPassword, uoTextBoxNewPassword.Text);
mUser.LastActivityDate = DateTime.Now.AddMinutes(-Membership.UserIsOnlineTimeWindow);
Membership.UpdateUser(mUser);
UserAccountBLL.LDAPImmigrationUpdate(sUserName, sEmail, sAlternateEmail, false);
//Add/modify from LDAP
sMsg = sMsg + "\n" + MUser.AddEditUserFromLDAP(sUserName, sFirstName, sLastName, sEmail, sPassword, "", sEmail);
MUser.ChangePasswordInLDAP(sUserName, uoTextBoxNewPassword.Text);
//remove this since they want Michael Jaworski to send the email manually to the users
//UserAccountBLL.EmailUserPassword(sUserName, sPassword, sAlternateEmail);
row = dt.NewRow();
row[col] = sUserName;
dt.Rows.Add(row);
}
}
}
//extract the list instead
dtUser = UserAccountBLL.GetImmigrationUsersToExtract(TravelMartVariable.RoleImmigration, true, uoTextBoxNewPassword.Text, dt);
if (dtUser != null)
{
if (dtUser.Rows.Count > 0)
{
CreateFile(dtUser);
}
else
{
sMsg = "No User Updated";
}
}
else
{
sMsg = "No User Updated.";
}
AlertMessage("Information: " + sMsg);
}
catch (Exception ex)
{
AlertMessage(ex.Message);
}
finally
{
if (dtUser != null)
{
dtUser.Dispose();
}
if (dt != null)
{
dt.Dispose();
}
}
}
/// Author: Josephine Monteza
/// Date Created: 03/Nov/2015
/// Description: Get all Immigartion Users with alternate email to reset pwd
private void AddEditImmigrationOfficers()
{
DataTable dtUser = null;
DataTable dt = null;
string sMsg = "";
try
{
DateTime dtFrom = GlobalCode.Field2DateTime(uoTextBoxFrom.Text);
DateTime dtTo = GlobalCode.Field2DateTime(uoTextBoxTo.Text);
List <UserList_LDAP> list = UserAccountBLL.GetUserList(dtFrom, dtTo, TravelMartVariable.RoleImmigration, true, false, "");
string sAlternateEmail;
string sUserName;
string sPassword;
string sLastName;
string sFirstName;
string sMiddleName;
string sEmail;
dt = new DataTable();
DataColumn col = new DataColumn("UserName", typeof(string));
dt.Columns.Add(col);
DataRow row = dt.NewRow();
for (int i = 0; i < list.Count; i++)
{
sUserName = list[i].UserName;
sAlternateEmail = list[i].AlternateEmail;
sLastName = list[i].LastName;
sFirstName = list[i].FirstName;
sMiddleName = list[i].MiddleName;
sEmail = list[i].Email;
MembershipUser mUser = Membership.GetUser(sUserName);
if (mUser.IsLockedOut)
{
mUser.UnlockUser();
}
sPassword = mUser.ResetPassword();
mUser.ChangePassword(sPassword, uoTextBoxNewPassword.Text);
mUser.LastActivityDate = DateTime.Now.AddMinutes(-Membership.UserIsOnlineTimeWindow);
Membership.UpdateUser(mUser);
//Add/modify from LDAP
sMsg = sMsg + "\n" + MUser.AddEditUserFromLDAP(sUserName, sFirstName, sLastName, sEmail, sPassword, "", sEmail);
MUser.ChangePasswordInLDAP(sUserName, uoTextBoxNewPassword.Text);
//remove this since they want Michael Jaworski to send the email manually to the users
//UserAccountBLL.EmailUserPassword(sUserName, sPassword, sAlternateEmail);
row = dt.NewRow();
row[col] = sUserName;
dt.Rows.Add(row);
}
//extract the list instead
dtUser = UserAccountBLL.GetImmigrationUsersToExtract(TravelMartVariable.RoleImmigration, true, uoTextBoxNewPassword.Text, dt);
if (dtUser != null)
{
if (dtUser.Rows.Count > 0)
{
CreateFile(dtUser);
}
else
{
sMsg = "No User Updated";
}
}
AlertMessage("Information: " + sMsg);
}
catch (Exception ex)
{
AlertMessage(ex.Message);
}
finally
{
if (dtUser != null)
{
dtUser.Dispose();
}
if (dt != null)
{
dt.Dispose();
}
}
}
