public MasterViewModel(MasterView hotelOwnerView)
{
this.hotelOwnerView = hotelOwnerView;
Administrators = LoadAdministrators();
selectedAdministrator = new tblAdministrator();
administrator = new vwAdministrator();
}
internal tblAdministrator GetAdmin(string userName, string password)
{
using (CompanyEntities context = new CompanyEntities())
{
tblAccount account = GetAccount(userName, password);
tblAdministrator admin = (from e in context.tblAdministrators where e.AccountID == account.AccountID select e).First();
return(admin);
}
}
public AddAdministratorViewModel(AddAdministrator addAdministratorOpen)
{
account = new tblAccount();
administrator = new tblAdministrator();
genderList = new List <string> {
"M", "Z", "N", "X"
};
marrigeTypeList = service.GetAllMarrigeTypes();
AdminTypeList = service.GetAllAdminTypes();
addAdministrator = addAdministratorOpen;
}
public async Task <IHttpActionResult> Register(AdministratorViewModel model)
{
var result = new ResponseViewModel <tblAdministrator>();
if (!ModelState.IsValid)
{
var errMessage = string.Join(", ", ModelState.Values.SelectMany(v => v.Errors).Select(x => x.ErrorMessage));
result.Status = false;
result.Message = errMessage;
result.Data = null;
return(Ok(result));
}
else
{
var message = "";
var data = new tblAdministrator();
var adminController = new AdministratorController();
var createStatus = adminController.RegisterAdmin(model, out data, out message);
model.Email = "admin" + model.Email;
if (createStatus)
{
var user = new ApplicationUser()
{
UserName = model.Email, Email = model.Email
};
var response = await UserManager.CreateAsync(user, model.Password);
if (response.Succeeded)
{
result.Status = createStatus;
result.Message = "Saved data successfully.";
result.Data = data;
return(Ok(result));
}
else
{
result.Status = false;
result.Message = string.Join(", ", response.Errors);
result.Data = null;
return(Ok(result));
}
}
else
{
result.Status = false;
result.Message = message;
result.Data = null;
return(Ok(result));
}
}
}
public RegistrationAdministratorViewModel(RegistrationAdministrator reg)
{
registrationAdministrator = reg;
newUser = new tblUser();
newAdministrator = new tblAdministrator();
//gender
genderList = Service.Service.GetGenderList();
selectedGender = new tblGender();
//marriage
maritalList = Service.Service.GetMaritalStatusList();
selectedMarital = new tblMarriageStatu();
//type
selectedType = new tblAdminType();
typeList = Service.Service.GetTypeAdminList();
}
public AddNewAdministratorViewModel(AddNewAdministratorView addNewAdministratorView)
{
this.addNewAdministratorView = addNewAdministratorView;
PersonalNo = string.Empty;
Sex = string.Empty;
PlaceOfResidence = string.Empty;
MaritalStatus = string.Empty;
AdministratorTeam = string.Empty;
Username = string.Empty;
Password = string.Empty;
GivenName = string.Empty;
Surname = string.Empty;
Administrator = new tblAdministrator();
CanSave = true;
userData = new tblUserData();
}
public bool TryAddNewAdministrator(tblAdministrator administrator)
{
try
{
using (var conn = new CompanyManagementEntities())
{
conn.tblAdministrators.Add(administrator);
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool RegisterAdmin(AdministratorViewModel model, out tblAdministrator data, out string message)
{
var status = false;
data = null;
try
{
var isAny = _db.tblAdministrators.Any(d => d.Email.ToLower() == model.Email.ToLower());
if (isAny)
{
message = "This email id has been taken. Please try another email id.";
}
var admin = new tblAdministrator()
{
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
LoginId = model.Email,
Password = Security.Encrypt(model.Password, true),
IsAdmin = model.IsAdmin,
IsActive = model.IsActive,
ContactNumber = model.ContactNumber,
Created = DateTime.Now.ToUniversalTime(),
AdministratorId = model.AdministratorId,
};
_db.tblAdministrators.Add(admin);
var response = _db.SaveChanges();
if (response > 0)
{
status = true;
message = "Transaction successed.";
data = admin;
}
else
{
message = "Transaction failed.";
}
}
catch (Exception ex)
{
message = "ex: " + ex.Message.ToString();
}
return(status);
}
// POST: api/administrator
public IHttpActionResult Post([FromBody] AdministratorViewModel model)
{
try
{
if (!ModelState.IsValid)
{
var errMessage = string.Join(", ", ModelState.Values.SelectMany(v => v.Errors).Select(x => x.ErrorMessage));
return(Ok(new { status = false, data = "", message = errMessage }));
}
var isAny = _db.tblAdministrators.Any(d => d.Email.ToLower() == model.Email.ToLower());
if (isAny)
{
return(Ok(new { status = false, data = "", message = "Please try another email id." }));
}
var admin = new tblAdministrator()
{
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
LoginId = model.LoginId,
Password = Security.Encrypt(model.Password, true),
IsAdmin = model.IsAdmin,
IsActive = model.IsActive,
ContactNumber = model.ContactNumber,
Created = DateTime.Now.ToUniversalTime(),
AdministratorId = model.AdministratorId,
};
_db.tblAdministrators.Add(admin);
var response = _db.SaveChanges();
if (response > 0)
{
return(Ok(new { status = true, data = admin, message = "Transaction successed." }));
}
return(Ok(new { status = false, data = "", message = "Transaction failed." }));
}
catch (Exception ex)
{
return(Ok(new { status = false, data = "", message = "ex: " + ex.Message.ToString() }));
}
}
public ResponseViewModel <AdministratorViewModel> RegisterAdmin(AdministratorViewModel model)
{
var data = new ResponseViewModel <AdministratorViewModel>();
try
{
var isAny = _db.tblAdministrators.Any(d => d.Email.ToLower() == model.Email.ToLower());
if (isAny)
{
data.Message = "This email id has already been registered. Try another email id.";
data.Status = false;
}
else
{
var admin = new tblAdministrator()
{
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
Password = Security.Encrypt(model.Password, true),
IsAdmin = model.IsAdmin,
IsActive = model.IsActive,
ContactNumber = model.ContactNumber,
Created = DateTime.Now.ToUniversalTime(),
AdministratorId = model.AdministratorId,
};
_db.tblAdministrators.Add(admin);
var response = _db.SaveChanges();
data.Status = response > 0 ? true : false;
data.Message = response > 0 ? "success" : "failed";
}
}
catch (Exception ex)
{
data.Message = "ex: " + ex.Message.ToString();
data.Status = false;
}
return(data);
}
private void UpdateExpirationAccountDateExecute()
{
try
{
if (Administrator != null)
{
selectedAdministrator = companyDB.LoadAdministrator(administrator.AdministratorID);
UpdateExpirationAccountDateView updateExpirationAccountDateView = new UpdateExpirationAccountDateView(selectedAdministrator);
updateExpirationAccountDateView.ShowDialog();
if ((updateExpirationAccountDateView.DataContext as UpdateExpirationAccountDateViewModel).IsDateUpdated == true)
{
Administrators = LoadAdministrators();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void LogInExecute()
{
try
{
if (UserName == "WPFMaster" && Password == "WPFAccess")
{
Master master = new Master();
master.ShowDialog();
}
else if (service.IsEmployee(UserName, Password))
{
tblAccount a = service.GetAccount(UserName);
tblEmployee e = service.GetEmployee(UserName, Password);
Employee employee = new Employee(a, e);
employee.ShowDialog();
}
else if (service.IsManager(UserName, Password))
{
tblAccount a = service.GetAccount(UserName);
tblManager m = service.GetManager(userName);
Manager manager = new Manager(a, m);
manager.ShowDialog();
}
else if (service.IsAdmin(UserName, Password))
{
tblAccount a = service.GetAccount(UserName);
tblAdministrator ad = service.GetAdmin(UserName, Password);
Admin admin = new Admin(a, ad);
admin.ShowDialog();
}
else
{
MessageBox.Show("Username or password incorrect");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public bool AddAdministrator(vwAdministrator administrator)
{
try
{
using (Nedeljni_IEntities context = new Nedeljni_IEntities())
{
tblUser user = new tblUser
{
Gender = administrator.Gender,
JMBG = administrator.JMBG,
Residence = administrator.Residence,
MarriageStatus = administrator.MarriageStatus,
FirstName = administrator.FirstName,
Pasword = administrator.Pasword,
Surname = administrator.Surname,
Username = administrator.Username
};
context.tblUsers.Add(user);
context.SaveChanges();
administrator.UserID = user.UserID;
tblAdministrator newAdministrator = new tblAdministrator
{
UserID = user.UserID,
ExpirationDate = administrator.ExpirationDate,
AdministratorType = administrator.AdministratorType
};
context.tblAdministrators.Add(newAdministrator);
context.SaveChanges();
administrator.AdministratorID = newAdministrator.AdministratorID;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public bool TryUpdateAdministrator(int administratorID, tblAdministrator administrator)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var adminToUpdate = conn.tblAdministrators.FirstOrDefault(x => x.AdministratorID == administratorID);
if (adminToUpdate != null)
{
adminToUpdate.AdministratorTeam = administrator.AdministratorTeam;
adminToUpdate.ExpirationAccountDate = administrator.ExpirationAccountDate;
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Method to add an administrator
/// </summary>
/// <param name="administrator"></param>
/// <returns></returns>
public bool AddAdministrator(vwAdministrator administrator)
{
try
{
using (Nedeljni_IIEntities context = new Nedeljni_IIEntities())
{
tblUser user = new tblUser
{
Gender = administrator.Gender,
IdCard = administrator.IdCard,
DateOfBirth = administrator.DateOfBirth,
Citizenship = administrator.Citizenship,
FirstName = administrator.FirstName,
Pasword = SecurePasswordHasher.Hash(administrator.Pasword),
Surname = administrator.Surname,
Username = administrator.Username
};
context.tblUsers.Add(user);
context.SaveChanges();
administrator.UserID = user.UserID;
tblAdministrator newAdministrator = new tblAdministrator
{
UserID = user.UserID,
};
context.tblAdministrators.Add(newAdministrator);
context.SaveChanges();
administrator.AdministratorID = newAdministrator.AdministratorID;
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
private void SaveExecute(object obj)
{
try
{
currentPassword = (obj as PasswordBox).Password;
newUser.password = currentPassword;
newUser.genderId = selectedGender.genderId;
newUser.marriageStatusId = selectedMarital.marriageStatusId;
tblUser u = Service.Service.AddUser(newUser);
newAdministrator.userId = u.userId;
newAdministrator.adminTypeId = selectedType.adminTypeId;
tblAdministrator a = Service.Service.AddAdministrator(newAdministrator);
if (u != null && a != null)
{
MessageBox.Show("Administrator has been created.");
registrationAdministrator.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// Adds new account to tblAccount and adds an admin with the acount AccountID to database.
/// </summary>
/// <param name="administrator"></param>
/// <param name="marrigeType"></param>
/// <param name="adminType"></param>
internal void AddAdministrator(tblAdministrator administrator, tblAccount account, tblMarrigeStatu marrigeType, tblAdministratorType adminType)
{
using (CompanyEntities context = new CompanyEntities())
{
tblAccount newAccount = new tblAccount();
newAccount.FirstName = account.FirstName;
newAccount.LastName = account.LastName;
newAccount.JMBG = account.JMBG;
newAccount.Gender = account.Gender.ToUpper();
newAccount.City = account.City;
newAccount.MarrigeStatusID = marrigeType.MarrigeStatusID;
newAccount.UserName = account.UserName;
newAccount.Pass = account.Pass;
context.tblAccounts.Add(newAccount);
context.SaveChanges();
tblAdministrator newAdmin = new tblAdministrator();
newAdmin.AccountID = newAccount.AccountID;
newAdmin.AdministratorTypeID = adminType.AdministratorTypeID;
newAdmin.DateOfExpiry = DateTime.Today.AddDays(7);
context.tblAdministrators.Add(newAdmin);
context.SaveChanges();
}
}
public UpdateExpirationAccountDateView(tblAdministrator administrator)
{
InitializeComponent();
this.DataContext = new UpdateExpirationAccountDateViewModel(this, administrator);
}
public UpdateExpirationAccountDateViewModel(UpdateExpirationAccountDateView updateExpirationAccountDateView, tblAdministrator administrator)
{
this.updateExpirationAccountDateView = updateExpirationAccountDateView;
this.administrator = administrator;
}
public AdminViewModel(Admin adminOpen, tblAccount accountToView, tblAdministrator adminToView)
{
adminr = adminOpen;
account = accountToView;
admin = adminToView;
}
public Admin(tblAccount account, tblAdministrator admin)
{
InitializeComponent();
this.DataContext = new AdminViewModel(this, account, admin);
}
private void LoginExecute(object obj)
{
try
{
person.password = (obj as PasswordBox).Password;
tblUser user = Service.Service.GetUser(person.username, person.password);
if (user == null)
{
if (person.username == "WPFMaster" && person.password == "WPFAccess")
{
Owner owner = new Owner();
login.Close();
owner.Show();
}
else
{
MessageBox.Show("Invalid username or password.Try again");
}
}
else
{
if (Service.Service.isAdministrator(user) != null)
{
tblAdministrator a = Service.Service.isAdministrator(user);
if (a.expiryDate < DateTime.Now)
{
MessageBox.Show("The expiration date of your access has expired. Please conntact the company mannagment");
}
else
{
string type = Service.Service.TypeOfAdmin(a);
if (type == "Local")
{
LocalAdministrator la = new LocalAdministrator();
login.Close();
la.ShowDialog();
}
else if (type == "Team")
{
TeamAdministrator ta = new TeamAdministrator();
ta.ShowDialog();
}
else
{
SystemAdministrator sa = new SystemAdministrator();
login.Close();
sa.ShowDialog();
}
}
}
else if (Service.Service.isEmployee(user) != null)
{
tblEmployee e = Service.Service.isEmployee(user);
Employee employee = new Employee();
employee.Show();
}
else if (Service.Service.isManager(user) != null)
{
tblManager m = Service.Service.isManager(user);
if (m.levelOfResponsibility != null)
{
Manager manager = new Manager();
manager.Show();
}
else
{
MessageBox.Show("Please wait until the Local administrator assigns a level of responsibility");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
