void dgUserRecord_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgUserRecord.Rows.Count > 0) { using (Maintenance _maintain = new Maintenance()) { var value = _maintain.GetSystemUser().Where(x => x.ID == Convert.ToInt64(dgUserRecord.SelectedRows[0].Cells[0].Value)).FirstOrDefault(); if (value != null) { cmbPositionID.Text = value.PositionID; txtUserID.Text = value.UserID; txtJobTitle.Text = _maintain.GetAccessRight().Where(x => x.PositionID == value.PositionID).FirstOrDefault().JobTitle; txtLastName.Text = value.LastName; txtFirstName.Text = value.FirstName; txtDisplayName.Text = value.DisplayName; txtContactNo.Text = value.ContactNo; dtStudentBday.Value = value.Bday.Value; txtRFIDNo.Text = value.RFIDNo; txtUserName.Text = value.Username; txtPassword.Text = value.Password; txtCoPassword.Text = value.Password; cbActive.Checked = value.Active.Value; btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString()); btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString()); } } } }
public bool CheckAlreadyUser(string value) { using (Maintenance _maintain = new Maintenance()) { return(_maintain.GetSystemUser().Where(x => x.PositionID == value).FirstOrDefault() == null ? true : false); } }
void GetUser() { dgUserRecord.Rows.Clear(); cmbPositionID.Items.Clear(); int i = 1; using (Maintenance _maintain = new Maintenance()) { _maintain.GetSystemUser().OrderBy(o => o.LastName).ToList().ForEach(x => { var yy = _maintain.GetAccessRight().Where(y => y.PositionID == x.PositionID).FirstOrDefault(); dgUserRecord.Rows.Add(x.ID, i, x.UserID, string.Format("{0}, {1}", x.LastName, x.FirstName), yy.JobTitle, x.Active); i++; }); _maintain.GetAccessRight().OrderBy(o => o.PositionID).ToList().ForEach(x => { cmbPositionID.Items.Add(x.PositionID); }); } ObjEnable(false); }