public void SetUser(string u)
{
using (var eb = new EB_LoginsEntities())
{
var user = eb.Users.FirstOrDefault(x => x.Username == u);
currentUser = user;
currUser.Text = user.Username;
}
}
private void Login_Load(object sender, EventArgs e)
{
try
{
using (var x = new EB_LoginsEntities())
{
UsernameTxt.AutoCompleteCustomSource.AddRange(x.Users.Select(y => y.Username).ToArray());
}
}
catch
{
}
}
private void ConfirmBtn_Click(object sender, EventArgs e)
{
if (UsernameTxt.Text == string.Empty || PasswordTxt.Text == string.Empty)
{
MessageBox.Show("fields must not be empty!");
return;
}
using (var eb = new EB_LoginsEntities())
{
var u = eb.Users.FirstOrDefault(x => x.Username == UsernameTxt.Text);
if (u != null)
{
MessageBox.Show("Username already taken.");
return;
}
}
if (!SamePassword)
{
ActiveControl = PasswordTxt;
MessageBox.Show("Password does not match");
PasswordTxt.Clear();
ConfirmPassTxt.Clear();
return;
}
using (var a = new EB_LoginsEntities())
{
var user = new User();
user.Id = Guid.NewGuid().ToString();
user.Username = UsernameTxt.Text;
user.Password = PasswordTxt.Text;
user.AddLogin = CanAddUser.Checked;
user.Rec_Delete = CanDelete.Checked;
user.Rec_Edit = CanEdit.Checked;
user.Rec_Create = CanReg.Checked;
user.Comp_Create = Comp_Reg_cb.Checked;
user.Comp_Edit = Comp_Edit_cb.Checked;
user.IssueDocument = Issue_Doc_cb.Checked;
a.Users.Add(user);
a.SaveChanges();
}
MessageBox.Show("Successfully added");
this.Close();
}
private void ConfirmBtn_Click(object sender, EventArgs e)
{
if (!canSave())
{
return;
}
using (var eb = new EB_LoginsEntities())
{
var u = eb.Users.FirstOrDefault(x => x.Username == currentUser.Username);
if (u != null)
{
u.Password = newPassword.Text;
}
eb.SaveChanges();
MessageBox.Show("Password successfully changed.");
this.Close();
}
}
private void LoginBtn_Click(object sender, EventArgs e)
{
#region connectiontest
try
{
using (var context = new EBarangayEntities())
{
context.Database.Connection.Open();
context.Database.Connection.Close();
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
return;
}
#endregion
if (!canLogin())
{
MessageBox.Show("Invalid Login");
return;
}
using (var t = new EB_LoginsEntities())
{
var u = from user in t.Users
where user.Username == UsernameTxt.Text && user.Password == PasswordTxt.Text
select user;
if (u.Count() == 0)
{
MessageBox.Show("User Not Found");
return;
}
UserManager.instance.currentUser = u.First();
}
UserSuccessfullyAuthenticated = true;
Close();
}
