private void ResetPassword()
{
if (ValidatePassword(tbNewPwd.Password, uvm.PasswordRules))
{
UserOrganizationDto dto = new UserOrganizationDto();
dto.User = User.Instance.UserDto;
//dto.Organization = new OrganizationDto() { Id = ApplicationViewModel.Instance.EwavSelectedDatasource.OrganizationId };
PasswordHasher ph = new PasswordHasher(ApplicationViewModel.Instance.KeyForUserPasswordSalt);
string salt = ph.CreateSalt(User.Instance.UserDto.Email);
User.Instance.UserDto.PasswordHash = ph.HashPassword(salt, tbNewPwd.Password);
User.Instance.UserDto.UserEditType = UserEditType.EditingPassword;
uvm.UpdateUser(dto);
uvm.UserUpdated += new EventHandler(uvm_UserUpdated);
// this.DialogResult = true;
spMsg_Success.Visibility = System.Windows.Visibility.Visible;
spFormatError.Visibility = System.Windows.Visibility.Collapsed;
grdPwd.Visibility = System.Windows.Visibility.Collapsed;
}
else
{
spFormatError.Visibility = System.Windows.Visibility.Visible;
spMsg.Visibility = System.Windows.Visibility.Visible;
tbErrorMsg.Text = "Password must match the Password Policy. Please try again.";
tbNewPwd.Password = "";
tbConfirmPwd.Password = "";
}
}
/// <summary>
/// Adds new org and Admin User object
/// </summary>
/// <param name="dto"></param>
public int AddOrganization(UserOrganizationDto userOrganizationDto)
{
OrganizationDto organizationDto = userOrganizationDto.Organization;
Cryptography Cryptography = new Security.Cryptography();
UserDTO userDto = userOrganizationDto.User;
if (userOrganizationDto.User == null)
{
throw new Exception("An organization cannot be added with zero users");
}
int organizationID = -1;
SqlDatabase db = new SqlDatabase(ConnectionString);
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "usp_add_organization";
command.Parameters.Add(new SqlParameter("@OrganizationName", organizationDto.Name));
command.Parameters.Add(new SqlParameter("@OrganizationDescription", ""));
command.Parameters.Add(new SqlParameter("@OrganizationKey", Cryptography.Encrypt(Guid.NewGuid().ToString())));
command.Parameters.Add(new SqlParameter("@UserId", userDto.UserID));
command.Parameters.Add(new SqlParameter("@UserNm", userDto.UserName));
command.Parameters.Add(new SqlParameter("@FirstNm", userDto.FirstName));
command.Parameters.Add(new SqlParameter("@LastNm", userDto.LastName));
command.Parameters.Add(new SqlParameter("@EmailAdd", userDto.Email));
command.Parameters.Add(new SqlParameter("@PhoneNbr", userDto.Phone));
command.Parameters.Add(new SqlParameter("@PwdHash", userDto.PasswordHash));
command.Parameters.Add(new SqlParameter("@IsExistingUser", userDto.IsExistingUser));
if (userDto.IsExistingUser)
{
command.Parameters.Add(new SqlParameter("@ResetPwd", userDto.ShouldResetPassword));
}
else
{
command.Parameters.Add(new SqlParameter("@ResetPwd", true));
}
command.Parameters.Add(new SqlParameter("@RoleId", userOrganizationDto.RoleId));
command.Parameters.Add(new SqlParameter("@IsActive", userOrganizationDto.Active));
try
{
db.ExecuteNonQuery(command);
organizationID = 1000; //success
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
return(organizationID);
}
public void UpdateUser(UserOrganizationDto dto, Action <bool, Exception> completed)
{
_updateCompleted = completed;
userCtx = new UserDomainContext();
InvokeOperation <bool> updateResults = userCtx.EditUser(dto);
updateResults.Completed += new EventHandler(updateResults_Completed);
}
public void AddUser(UserOrganizationDto dto, Action <bool, Exception> completed)
{
_addCompleted = completed;
userCtx = new UserDomainContext();
InvokeOperation <bool> addResults = userCtx.GenerateUser(dto);
addResults.Completed += new EventHandler(addResults_Completed);
}
public void Add(UserOrganizationDto dto, Action <int, Exception> completed)
{
_addCompleted = completed;
organizationCtx = new OrganizationDomainContext();
InvokeOperation <int> addResults = organizationCtx.AddOrganization(dto);
addResults.Completed += new EventHandler(addResults_Completed);
}
public bool UpdateUser(UserOrganizationDto dto)
{
UserDTO User = dto.User;
OrganizationDto Organization = dto.Organization;
using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
connection.Open();
MySqlCommand updUsercommand = connection.CreateCommand();
if (User.UserEditType == UserEditType.EditingUserInfo)
{
updUsercommand.CommandType = CommandType.StoredProcedure;
updUsercommand.CommandText = "usp_update_user";
updUsercommand.Parameters.Add("FirstName", User.FirstName);
updUsercommand.Parameters.Add("LastName", User.LastName);
updUsercommand.Parameters.Add("EmailAddressArg", User.Email);
updUsercommand.Parameters.Add("PhoneNumber", User.Phone);
updUsercommand.Parameters.Add("UserId", User.UserID);
updUsercommand.Parameters.Add("OrganizationId", dto.Organization.Id);
updUsercommand.Parameters.Add("IsUserOrgActive", dto.Active);
updUsercommand.Parameters.Add("RoleId", dto.RoleId);
string assocUsers = "";
string assocDatasources = "";
foreach (DatasourceDto item in User.DatasourceList)
{
assocUsers += string.Format("{0},", User.UserID.ToString());
assocDatasources += string.Format("{0},", item.DatasourceId.ToString());
}
updUsercommand.Parameters.Add("datasource_ids", assocDatasources);
updUsercommand.Parameters.Add("user_ids", assocUsers);
}
else
{
updUsercommand.CommandType = CommandType.StoredProcedure;
updUsercommand.CommandText = "usp_update_password";
updUsercommand.Parameters.Add("UserId", User.UserID);
updUsercommand.Parameters.Add("HashedPassword", User.PasswordHash);
}
try
{
updUsercommand.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
return(true);
}
}
public bool UpdateUser(UserOrganizationDto dto)
{
SqlDatabase db = new SqlDatabase(ConnectionString);
//SqlTransaction sqlTran = null;
//int flag = -1;
UserDTO User = dto.User;
OrganizationDto Organization = dto.Organization;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
SqlCommand updUsercommand = connection.CreateCommand();
if (User.UserEditType == UserEditType.EditingUserInfo)
{
updUsercommand.CommandType = CommandType.StoredProcedure;
updUsercommand.CommandText = "usp_update_user";
updUsercommand.Parameters.Add("FirstName", User.FirstName);
updUsercommand.Parameters.Add("LastName", User.LastName);
updUsercommand.Parameters.Add("EmailAddress", User.Email);
updUsercommand.Parameters.Add("PhoneNumber", User.Phone);
updUsercommand.Parameters.Add("UserId", User.UserID);
updUsercommand.Parameters.Add("OrganizationId", dto.Organization.Id);
updUsercommand.Parameters.Add("IsUserOrgActive", dto.Active);
updUsercommand.Parameters.Add("RoleId", dto.RoleId);
updUsercommand.Parameters.Add("@DatasourceUser", SqlDbType.Structured);
updUsercommand.Parameters["@DatasourceUser"].Direction = ParameterDirection.Input;
updUsercommand.Parameters["@DatasourceUser"].TypeName = "DatasourceUserTableType";
List <SqlDataRecord> sqlDrList = new List <SqlDataRecord>();
SqlDataRecord sqdr;
foreach (DatasourceDto item in User.DatasourceList)
{
sqdr = new SqlDataRecord(new SqlMetaData[]
{ new SqlMetaData("DatasourceID", SqlDbType.Int),
new SqlMetaData("UserID", SqlDbType.Int) });
// Set the record fields.
sqdr.SetInt32(0, item.DatasourceId);
sqdr.SetInt32(1, User.UserID);
sqlDrList.Add(sqdr);
}
if (User.DatasourceList.Count == 0)
{
updUsercommand.Parameters["@DatasourceUser"].Value = null;
}
else
{
updUsercommand.Parameters["@DatasourceUser"].Value = sqlDrList;
}
}
else
{
updUsercommand.CommandType = CommandType.StoredProcedure;
updUsercommand.CommandText = "usp_update_password";
updUsercommand.Parameters.Add("UserId", User.UserID);
updUsercommand.Parameters.Add("HashedPassword", User.PasswordHash);
}
try
{
updUsercommand.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
return(true);
}
}
public bool AddUser(UserOrganizationDto dto)
{
SqlDatabase db = new SqlDatabase(ConnectionString);
UserDTO User = dto.User;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open();
SqlCommand addUserCommand = connection.CreateCommand();
addUserCommand.CommandType = CommandType.StoredProcedure;
addUserCommand.CommandText = "usp_add_user";
addUserCommand.Parameters.Add("UserName", User.UserName);
addUserCommand.Parameters.Add("FirstName", User.FirstName);
addUserCommand.Parameters.Add("LastName", User.LastName);
addUserCommand.Parameters.Add("EmailAddress", User.Email);
addUserCommand.Parameters.Add("PhoneNumber", User.Phone);
addUserCommand.Parameters.Add("PasswordHash", User.PasswordHash);
addUserCommand.Parameters.Add("ResetPassword", User.ShouldResetPassword);
if (User.IsExistingUser)
{
addUserCommand.Parameters.Add("UsrId", User.UserID);
}
else
{
addUserCommand.Parameters.Add("UsrId", -1);
}
addUserCommand.Parameters.Add("OrganizationId", dto.Organization.Id);
addUserCommand.Parameters.Add("RoleId", dto.RoleId);
addUserCommand.Parameters.Add("Active", dto.Active);
addUserCommand.Parameters.Add("UGuid", Guid.NewGuid());
addUserCommand.Parameters.Add("@DatasourceUser", SqlDbType.Structured);
addUserCommand.Parameters["@DatasourceUser"].Direction = ParameterDirection.Input;
addUserCommand.Parameters["@DatasourceUser"].TypeName = "DatasourceUserTableType";
List <SqlDataRecord> sqlDrList = new List <SqlDataRecord>();
SqlDataRecord sqdr;
foreach (DatasourceDto item in User.DatasourceList)
{
sqdr = new SqlDataRecord(new SqlMetaData[]
{ new SqlMetaData("DatasourceID", SqlDbType.Int),
new SqlMetaData("UserID", SqlDbType.Int) });
// Set the record fields.
sqdr.SetInt32(0, item.DatasourceId);
sqdr.SetInt32(1, 0);
sqlDrList.Add(sqdr);
}
if (User.DatasourceList.Count == 0)
{
addUserCommand.Parameters["@DatasourceUser"].Value = null;
}
else
{
addUserCommand.Parameters["@DatasourceUser"].Value = sqlDrList;
}
try
{
addUserCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
return(false);
}
//try
//{
// if (!User.IsExistingUser)
// {
// addUserCommand.CommandType = CommandType.StoredProcedure;
// addUserCommand.CommandText = "usp_add_user";//TBD
// addUserCommand.Parameters.Add("UserName", User.UserName);
// addUserCommand.Parameters.Add("FirstName", User.FirstName);
// addUserCommand.Parameters.Add("LastName", User.LastName);
// //addUserCommand.Parameters.Add("OrganizationId", dto.OrganizationID);
// //addUserCommand.Parameters.Add("RoleID", dto.RoleValue);
// addUserCommand.Parameters.Add("EmailAddress", User.Email);
// addUserCommand.Parameters.Add("PhoneNumber", User.Phone);
// addUserCommand.Parameters.Add("PasswordHash", User.PasswordHash);
// addUserCommand.Parameters.Add("ResetPassword", true);
// //addUserCommand.Parameters.Add("Active", dto.IsActive);
// addUserCommand.Parameters.Add(new SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int) { Direction = ParameterDirection.Output });
// addUserCommand.ExecuteNonQuery();
// User.UserID = (int)addUserCommand.Parameters["@RETURN_VALUE"].Value;
// if (User.UserID < 0)
// {
// return false;
// }
// }
// //if (flag > -1)
// //{
// for (int i = 0; i < User.DatasourceList.Count; i++)
// {
// addDScommand = connection.CreateCommand();
// //addDScommand.Transaction = sqlTran;
// try
// {
// //flag = Convert.ToInt32(db.ExecuteScalar("usp_add_datasource", dto.UserID, dto.DatasourceList[i]));
// //if (flag < 0)
// //{
// // return false;
// //}
// addDScommand.CommandType = CommandType.StoredProcedure;
// addDScommand.CommandText = "usp_add_user_datasource";
// addDScommand.Parameters.Add("UserName", User.UserName);
// addDScommand.Parameters.Add("DatasourceName", User.DatasourceList[i].DatasourceName);
// //addDScommand.Parameters.Add(new SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int) { Direction = ParameterDirection.Output });
// addDScommand.ExecuteNonQuery();
// //flag = (int)addDScommand.Parameters["@RETURN_VALUE"].Value;
// }
// catch (SqlException sqlEx)
// {
// // sqlTran.Rollback();
// Exception duplicateException = new Exception(string.Format("SQL Exception - {0}", sqlEx.Message));
// throw duplicateException;
// }
// catch (Exception ex)
// {
// //sqlTran.Rollback();
// throw new Exception(ex.Message);
// }
// }
// //if (flag > -1)
// //{
// // // sqlTran.Commit();
// // return true;
// //}
// //}
// addUserCommand = connection.CreateCommand();
// // addUserCommand.Transaction = sqlTran;
// //updateUserCommand.CommandType = CommandType.StoredProcedure;
// //updateUserCommand.CommandText = "usp_update_user";
// //updateUserCommand.Parameters.Add(new SqlParameter("@FirstName", User.FirstName));
// //updateUserCommand.Parameters.Add(new SqlParameter("@LastName", User.LastName));
// //updateUserCommand.Parameters.Add(new SqlParameter("@OrganizationID", organizationID));
// //updateUserCommand.Parameters.Add(new SqlParameter("@RoleID", User.RoleValue));
// //updateUserCommand.Parameters.Add(new SqlParameter("@EmailAddress", User.Email));
// //updateUserCommand.Parameters.Add(new SqlParameter("@PhoneNumber", User.Phone));
// //updateUserCommand.Parameters.Add(new SqlParameter("@UserId", User.UserID));
// //updateUserCommand.Parameters.Add(new SqlParameter("@Active", User.IsActive));
// //updateUserCommand.Parameters.Add(new SqlParameter("@RETURN_VALUE", SqlDbType.Int) { Direction = ParameterDirection.Output });
// addUserCommand.CommandType = CommandType.StoredProcedure;
// addUserCommand.CommandText = "usp_add_user_organization";
// addUserCommand.Parameters.Add(new SqlParameter("@UserId", User.UserID));
// addUserCommand.Parameters.Add(new SqlParameter("@OrganizationID", dto.Organization.Id));
// addUserCommand.Parameters.Add(new SqlParameter("@RoleID", dto.RoleId));
// addUserCommand.Parameters.Add(new SqlParameter("@Active", dto.Active));
// // SqlParameter retvalUser = new SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int);
// // retvalUser.Direction = System.Data.ParameterDirection.ReturnValue;
// // addUserCommand.Parameters.Add(retvalUser);
// addUserCommand.ExecuteNonQuery();
//}
//catch (Exception e)
//{
// // sqlTran.Rollback();
// throw new Exception(e.Message);
//}
}
return(true);
//return false;
}
public bool AddUser(UserOrganizationDto dto)
{
// SqlDatabase db = new SqlDatabase(ConnectionString);
UserDTO User = dto.User;
using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
connection.Open();
MySqlCommand addUserCommand = connection.CreateCommand();
addUserCommand.CommandType = CommandType.StoredProcedure;
addUserCommand.CommandText = "usp_add_user";
addUserCommand.Parameters.Add("UserNameArg", User.UserName);
addUserCommand.Parameters.Add("FirstName", User.FirstName);
addUserCommand.Parameters.Add("LastName", User.LastName);
addUserCommand.Parameters.Add("EmailAddressArg", User.Email);
addUserCommand.Parameters.Add("PhoneNumber", User.Phone);
addUserCommand.Parameters.Add("PasswordHash", User.PasswordHash);
addUserCommand.Parameters.Add("ResetPassword", User.ShouldResetPassword);
//addUserCommand.Parameters.Add("IsExistingUser", User.IsExistingUser);
if (User.IsExistingUser)
{
addUserCommand.Parameters.Add("UsrId", User.UserID);
}
else
{
addUserCommand.Parameters.Add("UsrId", -1);
}
addUserCommand.Parameters.Add("OrganizationId", dto.Organization.Id);
addUserCommand.Parameters.Add("RoleId", dto.RoleId);
addUserCommand.Parameters.Add("Active", dto.Active);
addUserCommand.Parameters.Add("@DatasourceUser", SqlDbType.Structured);
addUserCommand.Parameters["@DatasourceUser"].Direction = ParameterDirection.Input;
try
{
addUserCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
return(false);
}
int defaultUserId = 0;
try
{
foreach (DatasourceDto item in User.DatasourceList)
{
MySqlHelper.ExecuteNonQuery(ConnectionString, "call usp_add_datasourceuser ",
new MySqlParameter[]
{
new MySqlParameter("DatasourceId", item.DatasourceId),
new MySqlParameter("UserId", defaultUserId)
});
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
return(false);
}
return(true);
}
}
/// <summary>
/// Adds new org and Admin User object
/// </summary>
/// <param name="dto"></param>
public int AddOrganization(UserOrganizationDto userOrganizationDto)
{
OrganizationDto organizationDto = userOrganizationDto.Organization;
UserDTO userDto = userOrganizationDto.User;
if (userOrganizationDto.User == null)
{
throw new Exception("An organization cannot be added with zero users");
}
int organizationID = -1;
PostgreSQLDB db = new PostgreSQLDB(ConnectionString);
NpgsqlCommand Command = new NpgsqlCommand();
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = "add_organization";
NpgsqlParameter parameter = new NpgsqlParameter("orgname", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = organizationDto.Name;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("orgdescription", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = organizationDto.Description;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("Usid", NpgsqlTypes.NpgsqlDbType.Integer);
parameter.Value = userDto.UserID;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("UserNm", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = userDto.UserName;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("FirstNm", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = userDto.FirstName;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("LastNm", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = userDto.LastName;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("EmailAdd", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = userDto.Email;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("phonenbr", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = userDto.Phone;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("PwdHash", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = userDto.PasswordHash;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("IsExistingUser", NpgsqlTypes.NpgsqlDbType.Boolean);
parameter.Value = userDto.IsExistingUser;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
if (userDto.IsExistingUser)
{
parameter = new NpgsqlParameter("ResetPwd", NpgsqlTypes.NpgsqlDbType.Boolean);
parameter.Value = userDto.ShouldResetPassword;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
}
else
{
parameter = new NpgsqlParameter("ResetPwd", NpgsqlTypes.NpgsqlDbType.Boolean);
parameter.Value = true;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
}
parameter = new NpgsqlParameter("RId", NpgsqlTypes.NpgsqlDbType.Integer);
parameter.Value = userOrganizationDto.RoleId;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("IsActive", NpgsqlTypes.NpgsqlDbType.Boolean);
parameter.Value = userOrganizationDto.Active;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
try
{
db.ExecuteNonQuery(Command);
organizationID = 1000; //success
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
return(organizationID);
}
/// <summary>
/// Handles the Click event of the btnFinish control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.RoutedEventArgs" /> instance containing the event data.</param>
private void btnFinish_Click(object sender, System.Windows.RoutedEventArgs e)
{
if (ApplicationViewModel.Instance.DemoMode)
{
DemoMode dm = new DemoMode();
dm.Show();
return;
}
Storyboard2.Begin();
tbStep1.Foreground = new SolidColorBrush(Color.FromArgb(255, 0, 0, 0));
rectStep1.Fill = new SolidColorBrush(Color.FromArgb(255, 38, 198, 48));
tbStep2.Foreground = new SolidColorBrush(Color.FromArgb(255, 122, 122, 122));
rectStep2.Fill = new SolidColorBrush(Color.FromArgb(255, 122, 122, 122));
//userDto = userDtoCopy;
//this.SelectedUserDto = new UserDTO();
if (this.SelectedUserDto == null)
{
this.SelectedUserDto = new UserDTO();
}
this.SelectedUserDto.FirstName = tbFirstName.Text;
this.SelectedUserDto.LastName = tbLastName.Text;
if (ApplicationViewModel.Instance.AuthenticationMode.ToString().ToLower() == "windows")
{
this.SelectedUserDto.Email = tbEmailAddress.Text.ToString().ToLower();
this.SelectedUserDto.UserName = tbUserID.Text.ToString().ToLower();
}
else
{
this.SelectedUserDto.Email = autoEmail.Text.ToString().ToLower();
this.SelectedUserDto.UserName = autoEmail.Text.ToLower();
}
this.SelectedUserDto.Phone = tbPhone.Text;
//this.SelectedUserDto.RoleValue = Convert.ToInt32(Enum.Parse(typeof(RolesEnum), ((ComboBoxItem)cmbRole.SelectedValue).Content.ToString(), false));
this.SelectedUserDto.UserRoleInOrganization = ((ComboBoxItem)cmbRole.SelectedItem).Content.ToString(); // cmbRole.SelectedValue.ToString();
//this.SelectedUserDto.OrganizationID = User.Instance.UserDto.OrganizationID;
this.SelectedUserDto.DatasourceList = ReadDatasourceList(this.SelectedUserDto.UserRoleInOrganization);
UserOrganizationDto dto = new UserOrganizationDto();
dto.Organization = new OrganizationDto();
dto.Organization.Active = this.SelectedOrg.Active;
dto.Organization.AdminCount = this.SelectedOrg.AdminCount;
dto.Organization.AnalystCount = this.SelectedOrg.AnalystCount;
dto.Organization.DatasourceCount = this.SelectedOrg.DatasourceCount;
dto.Organization.DatasourcesCount = this.SelectedOrg.DatasourcesCount;
dto.Organization.Description = "";
dto.Organization.Id = this.SelectedOrg.Id;
dto.Organization.Name = this.SelectedOrg.Name;
dto.Organization.SuperAdminCount = this.SelectedOrg.SuperAdminCount;
dto.Organization.TotalUserCount = this.SelectedOrg.TotalUserCount;
dto.RoleId = Convert.ToInt32(Enum.Parse(typeof(RolesEnum), ((ComboBoxItem)cmbRole.SelectedValue).Content.ToString(), false));
dto.Active = (cmbActive.SelectionBoxItem.ToString() == "Yes") ? true : false;
switch (Mode)
{
case ModeType.Add:
dto.User = this.SelectedUserDto;
uvm.AddUser(dto);
uvm.UserAdded += new EventHandler(uvm_UserAdded);
uvm.UserAddedFailed += new EventHandler(uvm_UserAddedFailed);
break;
case ModeType.Edit:
this.SelectedUserDto.UserID = this.SelectedUserDto.UserID;
this.SelectedUserDto.PasswordHash = this.SelectedUserDto.PasswordHash;
this.SelectedUserDto.UserEditType = UserEditType.EditingUserInfo;
dto.User = this.SelectedUserDto;
uvm.UpdateUser(dto);
uvm.UserUpdated += new EventHandler(uvm_UserUpdated);
break;
default:
break;
}
btnFinish.IsEnabled = false;
this.DialogResult = true;
}
// TODO: Add properties using the mvvmprop code snippet
#endregion
#region Methods
public void Add(UserOrganizationDto dto)
{
OrganizationServiceAgent osa = new OrganizationServiceAgent();
osa.Add(dto, AddCompleted);
}
public void AddUser(UserOrganizationDto dto)
{
UserServiceAgent usa = new UserServiceAgent();
usa.AddUser(dto, AddUserCompleted);
}
public void UpdateUser(UserOrganizationDto dto)
{
UserServiceAgent usa = new UserServiceAgent();
usa.UpdateUser(dto, UpdateUserCompleted);
}
/// <summary>
/// Handles the Click event of the btnSaveOrgDetails control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.RoutedEventArgs" /> instance containing the event data.</param>
private void btnSaveOrgDetails_Click(object sender, RoutedEventArgs e)
{
if (ApplicationViewModel.Instance.DemoMode)
{
DemoMode dm = new DemoMode();
dm.Show();
return;
}
if (addEditMode == Organizations.AddEditMode.Edit)
{
if (ValidateForm())
{
organizationViewModel = new OrganizationViewModel();
organizationViewModel.DtoUpdated += new EventHandler <NotificationEventArgs <Exception> >(organizationViewModel_DtoUpdated);
// OrganizationDto modelODto = organizationViewModel.OrganizationDtoList.Single(x => x.Id == this.selectedOrgID);
modelODto = this.DataContext as OrganizationDto;
modelODto.Name = tbOrganizationName.Text;
modelODto.Active = (((ComboBoxItem)cboActive.SelectedItem).Content.ToString() == "Yes") ? true : false;
organizationViewModel.Update(modelODto);
//Code to show success message on edit organization
//SucessMsg.Text = "Organization " + tbOrganizationName.Text + " has been updated.";
//imgSMsg.Visibility = System.Windows.Visibility.Visible;
//spMsg.Visibility = System.Windows.Visibility.Visible;
}
}
else
{
if (ValidateForm())
{
//string s = ((ComboBoxItem)cboActive.SelectedItem).Content.ToString();
bool IsActive = false;
if (((ComboBoxItem)cboActive.SelectedItem).Content.ToString() == "Yes")
{
IsActive = true;
}
userOrgDto = new UserOrganizationDto();
newOrganizationDto = new OrganizationDto()
{
Active = true,
Id = -1,
Name = tbOrganizationName.Text,
AdminCount = 0,
AnalystCount = 0,
DatasourceCount = 0,
DatasourcesCount = 0,
Description = null,
SuperAdminCount = 0,
TotalUserCount = 0
};
if (userDto != null)
{
newAdminDto = userDto;
}
else
{
newAdminDto = new UserDTO()
{
FirstName = tbFirstName.Text,
LastName = tbLastName.Text,
//OrganizationID = -1,
Phone = tbPhone.Text,
UserID = -1,
//UserName = autoEmail.Text, //"default user name",
//Email = autoEmail.Text,
//RoleValue = 2,
IsActive = true,
IsExistingUser = false
};
}
//newOrganizationDto.AdminList = new List<UserDTO>();
//newOrganizationDto.AdminList.Add(newAdminDto);
if (ApplicationViewModel.Instance.AuthenticationMode.ToString().ToLower() == "windows")
{
newAdminDto.Email = tbEmailAddress.Text.ToString().ToLower();
newAdminDto.UserName = tbUserId.Text.ToString().ToLower();
}
else
{
newAdminDto.Email = autoEmail.Text.ToString().ToLower();
newAdminDto.UserName = autoEmail.Text;
}
userOrgDto.Organization = newOrganizationDto;
userOrgDto.User = newAdminDto;
userOrgDto.RoleId = 2;
userOrgDto.Active = IsActive;
organizationViewModel = new OrganizationViewModel();
organizationViewModel.DtoAdded += new EventHandler <NotificationEventArgs <Exception> >(organizationViewModel_DtoAdded);
organizationViewModel.Add(userOrgDto);
//Code to show success message on add organization
//SucessMsg.Text = "Organization " + tbOrganizationName.Text + " has been added.";
//imgSMsg.Visibility = System.Windows.Visibility.Visible;
//spMsg.Visibility = System.Windows.Visibility.Visible;
//spMsg.Background = new SolidColorBrush(Color.FromArgb(255, 241, 202, 194)); //pink BK to use in case of error
//errMsg.Foreground = new SolidColorBrush(Color.FromArgb(255, 96, 25, 25)); //dark pink text color to use in case of error.
//imgerrMsg.Visibility = System.Windows.Visibility.Collapsed; // error icon
}
}
}
/// <summary>
/// Updates the user.
/// </summary>
/// <param name="dto">The dto.</param>
/// <returns></returns>
/// <exception cref="System.Exception"></exception>
public bool UpdateUser(UserOrganizationDto dto)
{
PostgreSQLDB db = new PostgreSQLDB(ConnectionString);
UserDTO User = dto.User;
NpgsqlCommand Command = new NpgsqlCommand();
NpgsqlParameter parameter = null;
if (User.UserEditType == UserEditType.EditingUserInfo)
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = "update_user";
parameter = new NpgsqlParameter("fname", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = User.FirstName;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("lname", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = User.LastName;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("emailadd", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = User.Email;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("pnumber", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = User.Phone;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("usid", NpgsqlTypes.NpgsqlDbType.Integer);
parameter.Value = User.UserID;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
//addUserCommand.Parameters.Add("UsrId", User.UserID);
parameter = new NpgsqlParameter("orid", NpgsqlTypes.NpgsqlDbType.Integer);
parameter.Value = dto.Organization.Id;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("active", NpgsqlTypes.NpgsqlDbType.Boolean);
parameter.Value = dto.Active;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("roleid", NpgsqlTypes.NpgsqlDbType.Integer);
parameter.Value = dto.RoleId;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
StringBuilder DSIds = new StringBuilder();
foreach (DatasourceDto item in User.DatasourceList)
{
DSIds.Append(item.DatasourceId);
DSIds.Append(",");
}
parameter = new NpgsqlParameter("dsids", NpgsqlTypes.NpgsqlDbType.Varchar);
if (DSIds.ToString().Contains(","))
{
parameter.Value = DSIds.ToString().Substring(0, DSIds.ToString().Length - 1);
}
else
{
parameter.Value = "";
}
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
}
else
{
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = "update_password";
parameter = new NpgsqlParameter("uid", NpgsqlTypes.NpgsqlDbType.Integer);
parameter.Value = User.UserID;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
parameter = new NpgsqlParameter("hpassword", NpgsqlTypes.NpgsqlDbType.Varchar);
parameter.Value = User.PasswordHash;
parameter.Direction = ParameterDirection.Input;
Command.Parameters.Add(parameter);
}
try
{
db.ExecuteNonQuery(Command);
}
catch (Exception ex)
{
//throw new Exception(ex.Message);
return(false);
}
return(true);
}
/// <summary>
/// Generates/Adds the organization
/// </summary>
/// <param name="dto"></param>
public int AddOrganization(UserOrganizationDto dto)
{
//return em.AddOrganization(organizationDto, userDTO);
return(em.AddOrganization(dto));
}
/// <summary>
/// Edits the user.
/// </summary>
/// <param name="dto">The dto.</param>
/// <returns></returns>
public bool EditUser(UserOrganizationDto dto)
{
return(em.EditUser(dto));
}
/// <summary>
/// Generates the user.
/// </summary>
/// <param name="dto">The dto.</param>
/// <returns></returns>
public bool GenerateUser(UserOrganizationDto dto)
{
return(em.GenerateUser(dto));
}
