private void acceptbtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (db.SystemSettings.Count() >= 1)
{
int numberUsers = Convert.ToInt32(userstb.Text);
ImusCityGovernmentSystem.Model.SystemSetting systemSetting = db.SystemSettings.FirstOrDefault();
systemSetting.NumberOfUser = numberUsers;
db.SaveChanges();
MessageBox.Show("System setting updated successfully!");
}
else
{
if (String.IsNullOrEmpty(userstb.Text))
{
MessageBox.Show("Please input number of users field");
}
else
{
int numberUsers = Convert.ToInt32(userstb.Text);
ImusCityGovernmentSystem.Model.SystemSetting systemSetting = new SystemSetting
{
NumberOfUser = numberUsers
};
db.SystemSettings.Add(systemSetting);
db.SaveChanges();
MessageBox.Show("System setting updated successfully!");
}
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void acceptbtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
var licenseList = from p in db.LicensingCodes
select new
{
p.LicenseId,
p.ExpirationDate,
p.SubModule,
LicenseKey = p.LicenseKey.Replace("\r\n", string.Empty)
};
if (String.IsNullOrEmpty(licensekey.Text))
{
MessageBox.Show("The license key field is empty");
return;
}
var licenseCode = licenseList.FirstOrDefault(m => m.LicenseKey == licensekey.Text);
LicensingCode license = new LicensingCode()
{
LicenseId = licenseCode.LicenseId,
LicenseKey = licenseCode.LicenseKey,
ExpirationDate = licenseCode.ExpirationDate,
SubModule = licenseCode.SubModule
};
if (license != null && license.ExpirationDate > DateTime.Now.Date && license.SubModule.Acronym == subModuleCode && license.LicenseKey == App.LicenseKey)
{
LicensingCode dbLicense = db.LicensingCodes.Find(license.LicenseId);
//license.MachineName = Environment.MachineName;
//license.UserID = App.EmployeeID;
dbLicense.ActivatedDate = DateTime.Now;
db.SaveChanges();
MessageBox.Show("License key applied");
this.Close();
}
else if (String.IsNullOrEmpty(licensekey.Text))
{
MessageBox.Show("The license key field is empty");
}
else if (license == null)
{
MessageBox.Show("Please enter a valid license key.");
}
else if (license.ExpirationDate < DateTime.Now)
{
MessageBox.Show("The license that youve entering is expired!");
}
else if (licensekey.Text != App.LicenseKey)
{
MessageBox.Show("Please enter a valid license key.");
}
else if (license.SubModule.Acronym != subModuleCode && license != null)
{
MessageBox.Show("The license that you are applying is not meant for the specified module");
}
//else if (license.LicenseKey == licensekey.Text && license.UserID == App.EmployeeID)
//{
// MessageBox.Show("This license is associated with another user");
//}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void loginbtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
try
{
if (String.IsNullOrEmpty(usernametb.Text) || String.IsNullOrEmpty(passwordpb.Password))
{
MessageBox.Show("Please input your sign-in credentials");
}
else
{
if (SystemClass.CheckConnection())
{
using (var db = new ImusCityHallEntities())
{
var passwordHasher = new Microsoft.AspNet.Identity.PasswordHasher();
string pass = "";
var asp = db.AspNetUsers.Where(m => m.UserName == usernametb.Text).FirstOrDefault();
if (asp != null)
{
pass = passwordHasher.VerifyHashedPassword(asp.PasswordHash, passwordpb.Password).ToString();
}
else
{
MessageBox.Show("Log-in failed!");
Mouse.OverrideCursor = null;
return;
}
if (pass == "Success")
{
Mouse.OverrideCursor = Cursors.Wait;
var emp = db.Employees.FirstOrDefault(m => m.EmployeeNo == usernametb.Text);
App.EmployeeID = emp.EmployeeID;
if (passwordpb.Password == "imuscitygov")
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please change your default password.");
ChangePasswordWindow password = new ChangePasswordWindow();
password.Show();
}
else if (emp.SecurityQuestionUsers.Count < 3 && emp.EmployeeNo != "123456")
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please set-up your security questions.");
SecurityQuestion secquestion = new SecurityQuestion();
secquestion.Show();
//
}
else
{
var audit = new AuditTrailModel
{
Activity = "Log-in to the system",
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MainWindow mw = new MainWindow();
mw.Password = passwordpb.Password;
mw.Show();
this.Close();
}
}
else
{
MessageBox.Show("Log-in failed!");
Mouse.OverrideCursor = null;
return;
}
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
Mouse.OverrideCursor = null;
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
using (var db = new ImusCityHallEntities())
{
QList = new List <QuestionList>();
if (!String.IsNullOrEmpty(cbSecurityQuestion1.Text) && !String.IsNullOrEmpty(txtAnswer1.Text))
{
QuestionList ql = new QuestionList();
int QuestionID1 = Convert.ToInt32(cbSecurityQuestion1.SelectedValue);
ql.EmployeeID = App.EmployeeID;
ql.QuestionID = QuestionID1;
ql.Answer = txtAnswer1.Text;
QList.Add(ql);
}
else
{
MessageBox.Show("Please answer security questions.");
return;
}
if (!String.IsNullOrEmpty(cbSecurityQuestion2.Text) && !String.IsNullOrEmpty(txtAnswer2.Text))
{
QuestionList ql = new QuestionList();
int QuestionID2 = Convert.ToInt32(cbSecurityQuestion2.SelectedValue);
ql.EmployeeID = App.EmployeeID;
ql.QuestionID = QuestionID2;
ql.Answer = txtAnswer2.Text;
QList.Add(ql);
}
else
{
MessageBox.Show("Please answer security questions.");
return;
}
if (!String.IsNullOrEmpty(cbSecurityQuestion3.Text) && !String.IsNullOrEmpty(txtAnswer3.Text))
{
QuestionList ql = new QuestionList();
int QuestionID3 = Convert.ToInt32(cbSecurityQuestion3.SelectedValue);
ql.EmployeeID = App.EmployeeID;
ql.QuestionID = QuestionID3;
ql.Answer = txtAnswer3.Text;
QList.Add(ql);
}
else
{
MessageBox.Show("Please answer security questions.");
return;
}
foreach (var x in QList)
{
SecurityQuestionUser squ = new SecurityQuestionUser();
squ.EmployeeID = x.EmployeeID;
squ.SecurityQuestionID = x.QuestionID;
squ.Answer = x.Answer;
db.SecurityQuestionUsers.Add(squ);
db.SaveChanges();
}
MessageBox.Show("Security Questions set-up succesfully!");
var audit = new AuditTrailModel
{
Activity = "User set-up security questions.",
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
this.Close();
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
public void CheckUserAccess()
{
CDS.IsEnabled = false;
EMP.IsEnabled = false;
CUST.IsEnabled = false;
DEPT.IsEnabled = false;
DIV.IsEnabled = false;
ID.IsEnabled = false;
UA.IsEnabled = false;
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
IEnumerable <SubModuleUser> submodule = db.SubModuleUsers.Where(m => m.EmployeeID == App.EmployeeID);
if (submodule.Count() >= 1)
{
foreach (var module in submodule)
{
switch (module.SubModule.Acronym)
{
case "CDS":
CDS.IsEnabled = module.SubModule.Acronym == CDS.Name ? true : false;
break;
case "EMP":
EMP.IsEnabled = module.SubModule.Acronym == EMP.Name ? true : false;
break;
case "CUST":
CUST.IsEnabled = module.SubModule.Acronym == CUST.Name ? true : false;
break;
case "DEPT":
DEPT.IsEnabled = module.SubModule.Acronym == DEPT.Name ? true : false;
break;
case "DIV":
DIV.IsEnabled = module.SubModule.Acronym == DIV.Name ? true : false;
break;
case "ID":
ID.IsEnabled = module.SubModule.Acronym == ID.Name ? true : false;
break;
case "UA":
UA.IsEnabled = module.SubModule.Acronym == UA.Name ? true : false;
break;
}
}
}
else
{
modules.IsEnabled = false;
}
Employee superAdmin = db.Employees.Find(App.EmployeeID);
AspNetUser user = db.AspNetUsers.FirstOrDefault(m => m.UserName == superAdmin.EmployeeNo);
if (user.AspNetUserRoles.FirstOrDefault().RoleId == "1")
{
SS.Visibility = Visibility.Visible;
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}