/// 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(); } } }