public bool Compare(T_SystemUser value) { using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString)) { return(dc.T_SystemUsers.Where(x => x.UserID == value.UserID && x.Username == value.Username && x.Password == value.Password && x.EncryptedPassword == value.EncryptedPassword && x.FirstName == value.FirstName && x.LastName == value.LastName && x.ContactNo == value.ContactNo && x.RFIDNo == value.RFIDNo && x.RFIDStatus == value.RFIDStatus && x.Active == value.Active && x.PositionID == value.PositionID).FirstOrDefault() == null ? true : false); } }
public bool Login(T_SystemUser Users, ref string msg) { //T_SystemUser _users = new T_SystemUser(); using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString)) { //_users = dc.T_SystemUsers.Where(x => x.Active == true && x.EncryptedPassword == Users.EncryptedPassword && x.Username == Users.Username && x.Active==true).FirstOrDefault(); var _users = dc.T_SystemUsers.FirstOrDefault(x => x.Active.Value && x.EncryptedPassword == Users.EncryptedPassword && x.Username == Users.Username); if (_users != null) { UserInfo.UserID = _users.UserID; UserInfo.UserName = _users.Username; UserInfo.Password = _users.Password; UserInfo.EncryptedPassword = _users.EncryptedPassword; UserInfo.PositionID = _users.PositionID; //UserInfo.UserTheme=_users.us UserInfo.FirstName = _users.FirstName; UserInfo.LastName = _users.LastName; UserInfo.CompleteName = string.Format("{0}, {1}", _users.LastName, _users.FirstName); UserInfo.DisplayName = _users.DisplayName; UserInfo.TimeIn = CurrDate(); //var accessRight = GetAccessRight().Where(x => x.Active == true && x.PositionID == _users.PositionID).FirstOrDefault(); var accessRight = GetAccessRight().FirstOrDefault(x => x.Active.Value && x.PositionID == _users.PositionID); SystemSetup.SystemName = "Attendance Monitoring System with RFID and Message Notification"; UserInfo.JobTitle = accessRight.JobTitle; SystemProperties.AccessRight.Application = accessRight.Application.Value; SystemProperties.AccessRight.Student = accessRight.Student.Value; SystemProperties.AccessRight.Instructor = accessRight.Instructor.Value; SystemProperties.AccessRight.Position = accessRight.Position.Value; SystemProperties.AccessRight.User = accessRight.Users.Value; SystemProperties.AccessRight.YearLevel = accessRight.YearLevel.Value; SystemProperties.AccessRight.Course = accessRight.Course.Value; SystemProperties.AccessRight.Subject = accessRight.Course.Value; SystemProperties.AccessRight.Room = accessRight.Room.Value; SystemProperties.AccessRight.Time = accessRight.Time.Value; SystemProperties.AccessRight.Display = accessRight.Display.Value; SystemProperties.AccessRight.Report = accessRight.Report.Value; SystemProperties.AccessRight.CivilStatus = accessRight.CivilStatus.Value; SystemProperties.AccessRight.DeviceConfiguration = accessRight.DeviceConfiguration.Value; SystemProperties.AccessRight.RoomType = accessRight.RoomType.Value; SystemProperties.AccessRight.Building = accessRight.Building.Value; SystemProperties.AccessRight.ViewRoom = accessRight.ViewRoom.Value; SystemProperties.AccessRight.ViewCourse = accessRight.ViewCourse.Value; SystemProperties.AccessRight.ViewInstructor = accessRight.ViewInstructor.Value; SystemProperties.AccessRight.NotifyStudent = accessRight.NotifyStudent.Value; SystemProperties.AccessRight.MaintenanceMessage = accessRight.MaintenanceMessage.Value; SystemProperties.AccessRight.SMSSettings = accessRight.SMSSettings.Value; SystemProperties.AccessRight.Semester = accessRight.Semester.Value; SystemProperties.AccessRight.YearClass = accessRight.YearClass.Value; SaveLog(true); msg = string.Format("Welcome for {0} " + Environment.NewLine + "{1}" + Environment.NewLine + "{2}", SystemSetup.SystemName, UserInfo.CompleteName, UserInfo.JobTitle); return(true); } else { msg = string.Format("Your input is invalid {0}", SystemSetup.SystemName); return(false); } } }
public void Delete(T_SystemUser value, ref string msg) { T_SystemUser valuedelete = new T_SystemUser(); using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString)) { valuedelete = dc.T_SystemUsers.Where(x => x.ID == value.ID).FirstOrDefault(); dc.T_SystemUsers.DeleteOnSubmit(valuedelete); dc.SubmitChanges(); msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "USER ID: [{1}]" + Environment.NewLine + "POSITION ID; [{2}]" + Environment.NewLine + "USERNAME: [{3}]" + Environment.NewLine + "NAME: [{4}, {5}]", SystemProperties.MessageNotification.Deleted, valuedelete.UserID, valuedelete.PositionID, valuedelete.Username, valuedelete.LastName, valuedelete.FirstName); } }
public void Login() { T_SystemUser user = new T_SystemUser(); using (UserDetail _userdetails = new UserDetail()) { if (!string.IsNullOrWhiteSpace(txtUsername.Text) && !string.IsNullOrWhiteSpace(txtPassword.Text)) { user.Username = txtUsername.Text; user.EncryptedPassword = EncryptedPassword; if (_userdetails.Login(user, ref ReturnMsg)) { pnlLogin.Hide(); SystemProperties.ShowMessage.MessageInformation(ReturnMsg, "Login"); GetAccessRight(true); tsOffline.Text = "Online"; tsOffline.ForeColor = Color.Green; tsUser.Text = !string.IsNullOrWhiteSpace(UserInfo.DisplayName)?UserInfo.DisplayName:UserInfo.CompleteName; tsTimeIN.Text = UserInfo.TimeIn.ToString("MMM. dd, yyyy | HH:mm:ss tt"); tsPosition.Text = UserInfo.JobTitle; mtLogin.Enabled = !(mtLogout.Enabled = true); using (GetAPI getapi = new GetAPI()) { getapi.CheckInternetConnection(); } GetActiveSemester(); } else { foreach (Form frm in this.MdiChildren) { if (!frm.Focused) { frm.Close(); } } tsOffline.ForeColor = Color.Red; tsOffline.Text = "Offline"; tsUser.Text = ""; tsTimeIN.Text = ""; tsPosition.Text = ""; pnlLogin.Show(); GetAccessRight(false); mtLogin.Enabled = !(mtLogout.Enabled = false); SystemProperties.ShowMessage.MessageError(ReturnMsg, "Login"); } } else { SystemProperties.ShowMessage.MessageError(string.Format("Please check your input below " + Environment.NewLine + Environment.NewLine + "Username" + Environment.NewLine + "Password"), SystemSetup.SystemName); } } }
public void Save(T_SystemUser value, ref string msg) { T_SystemUser valueupdate = new T_SystemUser(); using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString)) { if (Compare(value)) { if (value.ID == 0) { dc.T_SystemUsers.InsertOnSubmit(value); msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "USER ID: [{1}]" + Environment.NewLine + "POSITION ID; [{2}]" + Environment.NewLine + "USERNAME: [{3}]" + Environment.NewLine + "NAME: [{4}, {5}]", SystemProperties.MessageNotification.Saved, value.UserID, value.PositionID, value.Username, value.LastName, value.FirstName); } else { valueupdate = dc.T_SystemUsers.Where(x => x.ID == value.ID).FirstOrDefault(); valueupdate.Password = value.Password; valueupdate.EncryptedPassword = value.EncryptedPassword; valueupdate.DisplayName = value.DisplayName; valueupdate.LastName = value.LastName; valueupdate.FirstName = value.FirstName; valueupdate.PathImage = value.PathImage; valueupdate.Bday = value.Bday; valueupdate.ContactNo = value.ContactNo; valueupdate.PositionID = value.PositionID; valueupdate.Theme = value.Theme; valueupdate.Active = value.Active; valueupdate.Username = value.Username; valueupdate.RFIDStatus = value.RFIDStatus; valueupdate.RFIDNo = value.RFIDNo; msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "USER ID: [{1}]" + Environment.NewLine + "POSITION ID; [{2}]" + Environment.NewLine + "USERNAME: [{3}]" + Environment.NewLine + "NAME: [{4}, {5}]", SystemProperties.MessageNotification.Updated, valueupdate.UserID, valueupdate.PositionID, valueupdate.Username, valueupdate.LastName, valueupdate.FirstName); } dc.SubmitChanges(); } else { msg = SystemProperties.MessageNotification.Exist; } } }
void Save() { if (SystemProperties.ShowMessage.MessageQuestion(SystemProperties.MessageNotification.YouWantToSave, "User registration") == DialogResult.Yes) { if (CheckEmptyField()) { T_SystemUser user = new T_SystemUser(); user.ID = isAdd ? 0 : Convert.ToInt64(dgUserRecord.SelectedRows[0].Cells[0].Value.ToString()); user.UserID = txtUserID.Text; user.Password = txtPassword.Text; user.EncryptedPassword = EncryptedPassword; user.DisplayName = txtDisplayName.Text; user.LastName = txtLastName.Text; user.FirstName = txtFirstName.Text; user.PathImage = ""; user.Bday = dtStudentBday.Value; user.ContactNo = txtContactNo.Text; user.PositionID = cmbPositionID.Text; user.Theme = ""; user.Active = cbActive.Checked; user.Username = txtUserName.Text; user.RFIDStatus = cbRFID.Checked; user.RFIDNo = txtRFIDNo.Text; using (Maintenance _maintain = new Maintenance()) { _maintain.Save(user, ref MsgReturned); SystemProperties.ShowMessage.MessageInformation(MsgReturned, "User registration"); lblMessage.Text = ""; } GetUser(); SystemProperties.Cleared(this, false, true, true); } else { SystemProperties.ShowMessage.MessageError(string.Format("{0}" + Environment.NewLine + Environment.NewLine + "POSITION ID" + Environment.NewLine + "USER ID" + Environment.NewLine + "LASTNAME" + Environment.NewLine + "FIRSTNAME" + Environment.NewLine + "USERNAME AND PASSWORD", SystemProperties.MessageNotification.CheckInput), "User registration"); } } }
void Delete() { if (SystemProperties.ShowMessage.MessageQuestion(SystemProperties.MessageNotification.YouWantToDelete, "User registration") == DialogResult.Yes) { if (CheckEmptyField()) { T_SystemUser user = new T_SystemUser(); using (Maintenance _maintain = new Maintenance()) { user.ID = Convert.ToInt64(dgUserRecord.SelectedRows[0].Cells[0].Value.ToString()); _maintain.Delete(user, ref MsgReturned); SystemProperties.ShowMessage.MessageWarning(MsgReturned, "User registration"); GetUser(); SystemProperties.Cleared(this, false, true, true); lblMessage.Text = ""; } } else { SystemProperties.ShowMessage.MessageError(SystemProperties.MessageNotification.SelectFirst + "delete", "User registration"); } } }