public void Delete(User user)
{
var executor = new CommandExecutor("dbo.DeleteUser", connectionString);
executor.SetParam("@Username", user.Login, SqlDbType.NVarChar);
var result = executor.ExecuteCommand();
result.ThrowIfException();
}
public void Create(User user)
{
var executor = new CommandExecutor("dbo.CreateUser", connectionString);
executor.SetParam("@Username", user.Login, SqlDbType.NVarChar);
executor.SetParam("@Password", user.Password, SqlDbType.NVarChar);
var userType = (int) user.Type + 1;
executor.SetParam("@Usertype", userType, SqlDbType.Int);
var result = executor.ExecuteCommand();
result.ThrowIfException();
}
public void InsertUser(Model.User oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Insert Into tbl_user (Username,Fullname,Password,Role,Contact_No,Address,Added_By,Date_Added) Values ('" + oData.USERNAME + "','" + oData.FULLNAME + "','" + oData.PASSWORD + "','" + oData.ROLE + "','" + oData.CONTACT_NO + "','" + oData.ADDRESS + "','" + "Rolly" + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "')";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateUser(Model.User oData)
{
try
{
osb.ConnectionString = sConnectionString;
ddq = new DatabaseQuery.DBQuery();
ddq.ConnectionString = osb.ConnectionString;
ddq.CommandText = "Update tbl_user set Fullname = '" + oData.FULLNAME + "',Password = '******',Role = '" + oData.ROLE + "',Contact_No = '" + oData.CONTACT_NO + "',Address = '" + oData.ADDRESS + "',Added_By = '" + "Rolly" + "' where Username = '******'";
ddq.ExecuteNonQuery(CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
public UserEditorWindowViewModel(UserEditorWindow view, User user, UserRepository repository)
{
if (user == null)
{
CreateMode = true;
user = new User();
}
this.view = view;
this.repository = repository;
User = user;
if (CreateMode) return;
view.SetPasswordDots();
view.Set(User.Type);
}
public void Delete(User user)
{
var result = MessageBox.Show(
string.Format(Resources.DeleteUserConfirmatonText, user.Login),
Resources.DeleteConfirmationCaption,
MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
try
{
repository.Delete(user);
RetrieveData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void OpenEditor(User user)
{
try
{
if (user != null)
{
user = user.Clone();
}
var editor = new UserEditorWindow(user);
var result = editor.ShowDialog();
if (result.HasValue && result.Value)
{
RetrieveData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
