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());
}
}
}
}
void LoadSelectedOne(long ID)
{
if (dgEmployeeRecord.Rows.Count > 0)
{
using (Instructor prof = new Instructor())
{
var value = prof.GetInstructor().Where(x => x.ID == ID).FirstOrDefault();
if (value != null)
{
txtEmployeeAddress.Text = value.Address;
txtEmployeeFirstName.Text = value.FirstName;
txtEmployeeID.Text = value.EmployeeID;
txtEmployeeLastName.Text = value.LastName;
txtEmployeeMiddleName.Text = value.MiddleName;
txtInstructorContactNo.Text = value.ContactNo;
btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
if (value.Gender.ToLower() == "male")
{
rbEmployeeMale.Checked = true;
rbEmployeeFemale.Checked = false;
}
else
{
rbEmployeeMale.Checked = false;
rbEmployeeFemale.Checked = true;
}
SaveImage(false);
}
}
}
}
void dgRoom_CellClick(object sender, DataGridViewCellEventArgs e)
{
SystemProperties.Cleared(this, false, true, true);
if (dgRoom.Rows.Count > 0)
{
using (Maintenance _maintain = new Maintenance())
{
var value = _maintain.GetRoom().Where(x => x.ID == Convert.ToInt64(dgRoom.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
cmbRoomType.Text = value.RoomType;
txtRoomCode.Text = value.RoomCode;
txtDescription.Text = value.Description;
cmbBuildingCode.Text = value.BuildingCode;
txtLocationAddress.Text = _maintain.GetBuildingCode().Where(x => x.BuildingCode == value.BuildingCode).FirstOrDefault().BuildingName;
txtCapacity.Value = value.Capacity.Value;
cbActive.Checked = value.Active.Value;
LoadTime(value.RoomCode);
btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
GetRoomDevice(value.RoomCode);
}
}
}
}
void btnAdd_Click(object sender, EventArgs e)
{
isCancel = false;
ObjEnable(true);
btnDelete = SystemProperties.BtnProperties(btnDelete, false, Imagename.Delete.ToString(), Imagename._delete.ToString());
isAdd = true;
Cleared(this, true);
}
void ObjEnable(bool enable)
{
btnAdd = SystemProperties.BtnProperties(btnAdd, !enable, Imagename.Add.ToString(), Imagename._add.ToString());
btnEdit = SystemProperties.BtnProperties(btnEdit, false, Imagename.Edit.ToString(), Imagename._edit.ToString());
btnSave = SystemProperties.BtnProperties(btnSave, enable, Imagename.Save.ToString(), Imagename._save.ToString());
btnDelete = SystemProperties.BtnProperties(btnDelete, enable, Imagename.Delete.ToString(), Imagename._delete.ToString());
btnCancel = SystemProperties.BtnProperties(btnCancel, enable, Imagename.Cancel.ToString(), Imagename._cancel.ToString());
}
void btnAdd_Click(object sender, EventArgs e)
{
ObjEnable(true);
btnDelete = SystemProperties.BtnProperties(btnDelete, false, Imagename.Delete.ToString(), Imagename._delete.ToString());
isAdd = true;
SystemProperties.Cleared(this, true, true, true);
MsgReturned = "";
}
void btnAdd_Click(object sender, EventArgs e)
{
ObjEnable(true);
btnDelete = SystemProperties.BtnProperties(btnDelete, false, Imagename.Delete.ToString(), Imagename._delete.ToString());
isAdd = true;
SystemProperties.Cleared(this, true, true, true);
txtJobTitle.ReadOnly = true;
lblMessage.Text = "";
}
void btnAdd_Click(object sender, EventArgs e)
{
ObjEnable(true);
btnDelete = SystemProperties.BtnProperties(btnDelete, false, Imagename.Delete.ToString(), Imagename._delete.ToString());
isAdd = true;
SystemProperties.Cleared(this, true, true, true);
SystemProperties.Cleared(Mother, true, true, true);
SystemProperties.Cleared(Father, true, true, true);
MsgReturned = "";
AutoScanTimer.Start();
txtSearch.ReadOnly = false;
}
void dgSemester_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (Maintenance _maintain = new Maintenance())
{
var value = _maintain.GetSemester().Where(x => x.ID == Convert.ToInt64(dgSemester.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
txtSemester.Text = value.Semester;
btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
}
}
}
void btnAdd_Click(object sender, EventArgs e)
{
ObjEnable(true);
btnDelete = SystemProperties.BtnProperties(btnDelete, false, Imagename.Delete.ToString(), Imagename._delete.ToString());
isAdd = true;
SystemProperties.Cleared(this, true, true, true);
MsgReturned = "";
//dgRoom.Enabled = true;
dgTime.Enabled = true;
LoadTime();
txtDeviceDescription.ReadOnly = true;
dgDeviceRecord.Enabled = true;
}
void dgYearLevel_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (Maintenance _maintain = new Maintenance())
{
var value = _maintain.GetYearLevel().Where(x => x.ID == Convert.ToInt64(dgYearLevel.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
txtYearLevel.Text = value.YearLevel;
cbActive.Checked = value.Active.Value;
txtCount.Value = value.Count.Value;
btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
}
}
}
void txtPositionID_Leave(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtPositionID.Text) && isAdd)
{
if (GetAccessRight(txtPositionID.Text))
{
SystemProperties.ShowMessage.MessageError(SystemProperties.MessageNotification.Exist, "Position access right");
btnSave = SystemProperties.BtnProperties(btnSave, false, Imagename.Save.ToString(), Imagename._save.ToString());
}
else
{
btnSave = SystemProperties.BtnProperties(btnSave, true, Imagename.Save.ToString(), Imagename._save.ToString());
}
}
}
void dgSMS_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (GetAPI api = new GetAPI())
{
var value = api.GetAPIs().Where(x => x.ID == Convert.ToInt64(dgSMS.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
txtSite.Text = value.Site;
txtPage.Text = value.Page;
txtMobile.Text = value.ParamMobileName;
txtMessage.Text = value.ParamMessageName;
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());
}
}
}
private bool ComparePassword(string Password, string CoPassowrd)
{
if (!string.IsNullOrWhiteSpace(txtUserName.Text))
{
if (!string.IsNullOrWhiteSpace(txtPassword.Text) && !string.IsNullOrWhiteSpace(txtCoPassword.Text))
{
if (Password == CoPassowrd)
{
btnSave = SystemProperties.BtnProperties(btnSave, true, Imagename.Save.ToString(), Imagename._save.ToString());
lblMessage.ForeColor = Color.DimGray;
lblMessage.Text = "";
return(true);
}
else
{
btnSave = SystemProperties.BtnProperties(btnSave, false, Imagename.Save.ToString(), Imagename._save.ToString());
lblMessage.ForeColor = Color.Red;
lblMessage.Text = SystemProperties.MessageNotification.PasswordNotMatch;
return(false);
}
}
else
{
btnSave = SystemProperties.BtnProperties(btnSave, false, Imagename.Save.ToString(), Imagename._save.ToString());
lblMessage.ForeColor = Color.Red;
lblMessage.Text = string.Format("{0} for Password or Co-Passoword", SystemProperties.MessageNotification.CheckInput);
return(false);
}
}
else if (string.IsNullOrWhiteSpace(txtUserName.Text) && string.IsNullOrWhiteSpace(txtPassword.Text) && string.IsNullOrWhiteSpace(txtCoPassword.Text))
{
btnSave = SystemProperties.BtnProperties(btnSave, false, Imagename.Save.ToString(), Imagename._save.ToString());
lblMessage.ForeColor = Color.Red;
lblMessage.Text = string.Format("{0} for Username and Password or Co-Passoword", SystemProperties.MessageNotification.CheckInput);
return(false);
}
else
{
btnSave = SystemProperties.BtnProperties(btnSave, false, Imagename.Save.ToString(), Imagename._save.ToString());
lblMessage.ForeColor = Color.Red;
lblMessage.Text = string.Format("{0} for Username", SystemProperties.MessageNotification.CheckInput);
return(false);
}
}
void dgSMS_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgSMS.Rows.Count > 0)
{
using (SMSNotification notify = new SMSNotification())
{
var value = notify.GetSMS().Where(x => x.ID == Convert.ToInt64(dgSMS.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
txtCode.Text = value.Code;
txtMessage.Text = value.MessageAlert;
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());
}
}
}
}
void dgSubject_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgSubject.Rows.Count > 0)
{
using (Maintenance _maintain = new Maintenance())
{
var value = _maintain.GetSubject().Where(x => x.ID == Convert.ToInt64(dgSubject.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
txtCode.Text = value.Code;
txtDescription.Text = value.Description;
txtUnit.Value = Convert.ToDecimal(value.Unit.ToString());
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());
}
}
}
}
void dgDevice_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (DeviceModule device = new DeviceModule())
{
var value = device.GetRFIDDevice().Where(x => x.ID == Convert.ToInt64(dgDevice.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
txtName.Text = value.DeviceName;
txtBaundRate.Text = value.BaundRate.ToString();
txtComPort.Text = value.Port;
txtDataBits.Text = value.DataBit.ToString();
cmbParity.Text = value.Parity;
cmbStopBits.Text = value.StopBit;
cbActive.Checked = value.Active.Value;
btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
}
}
}
void dgYearClass_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgYearClass.Rows.Count > 0)
{
using (Maintenance _maintain = new Maintenance())
{
var value = _maintain.GetActiveSemester().Where(x => x.ID == Convert.ToInt64(dgYearClass.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
txtYearClass.Text = value.YearSemester;
dtDateStart.Value = value.DateStart.Value;
dtDateEnd.Value = value.DateEnd.Value;
cmbSemester.Text = value.Semester;
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());
}
}
}
}
void dgAccessRightPositionRecord_Click(object sender, EventArgs e)
{
using (Maintenance _maintain = new Maintenance())
{
var value = _maintain.GetAccessRight().Where(x => x.ID == Convert.ToInt64(dgAccessRightPositionRecord.SelectedRows[0].Cells[0].Value.ToString())).FirstOrDefault();
if (value != null)
{
txtPositionID.Text = value.PositionID;
txtJobTitle.Text = value.JobTitle;
txtDescription.Text = value.Description;
cbActive.Checked = value.Active.Value;
cbReg_Student.Checked = value.Student.Value;
cbReg_Instructor.Checked = value.Instructor.Value;
cbMain_Position.Checked = value.Position.Value;
cbMain_User.Checked = value.Users.Value;
cbMain_YearLevel.Checked = value.YearLevel.Value;
cbMain_CivilStatus.Checked = value.CivilStatus.Value;
cbMain_Course.Checked = value.Course.Value;
cbMain_Subject.Checked = value.Subject.Value;
cbMain_Room.Checked = value.Room.Value;
cbMain_Time.Checked = value.Time.Value;
cbMain_Application.Checked = value.Application.Value;
cbWin_Display.Checked = value.Display.Value;
cbWin_Report.Checked = value.Display.Value;
cbSett_DeviceConfig.Checked = value.DeviceConfiguration.Value;
cbRoomType.Checked = value.RoomType.Value;
cbBuilding.Checked = value.Building.Value;
cbViewRoom.Checked = value.ViewRoom.Value;
cbViewCourse.Checked = value.ViewCourse.Value;
cbViewInstructor.Checked = value.ViewInstructor.Value;
cbMessage.Checked = value.MaintenanceMessage.Value;
cbStudent.Checked = value.NotifyStudent.Value;
cbSMSSettings.Checked = value.SMSSettings.Value;
cbSemester.Checked = value.Semester.Value;
cbYearClass.Checked = value.YearClass.Value;
btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
}
}
}
void dgCourseProgram_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgCourseProgram.Rows.Count > 0)
{
using (Maintenance _maintain = new Maintenance())
{
var value = _maintain.GetCourse().Where(x => x.ID == Convert.ToInt64(dgCourseProgram.SelectedRows[0].Cells[0].Value)).FirstOrDefault();
if (value != null)
{
cmbMin.Text = value.YearMinimum.Value.ToString();
cmbMax.Text = value.YearMaximum.Value.ToString();
txtFromTo.Text = value.YearLevelFromTo;
txtCode.Text = value.CourseCode;
txtCourse.Text = value.Description;
txtDescription.Text = value.Description;
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());
}
}
}
}
void ObjEnable(bool enable)
{
btnAdd = SystemProperties.BtnProperties(btnAdd, !enable, Imagename.Add.ToString(), Imagename._add.ToString());
btnSave = SystemProperties.BtnProperties(btnSave, enable, Imagename.Save.ToString(), Imagename._save.ToString());
btnCancel = SystemProperties.BtnProperties(btnCancel, enable, Imagename.Cancel.ToString(), Imagename._cancel.ToString());
}
void LoadSelectedOne(long ID)
{
using (Students std = new Students())
{
//Convert.ToInt64(dgStudentRecord.SelectedRows[0].Cells[0].Value.ToString())
var value = std.GetStudentInfo().Where(x => x.ID == ID).FirstOrDefault();
if (value != null)
{
btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString());
btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString());
txtStudentID.Text = value.StudentID;
MotherID = value.MotherID; // = isAdd ? txtStudentID.Text + "-M" : MotherID;
FaterID = value.FatherID; // = isAdd ? txtStudentID.Text + "-F" : FaterID;
cmbApplication.Text = value.Application;
txtStudentLastName.Text = value.LastName;
txtStudentFirstName.Text = value.FirstName;
txtStudentMiddleName.Text = value.MiddleName;
txtStudentContactNo.Text = value.ContactNo;
dtStudentBday.Value = value.Bday;
cmbYearLevel.Text = value.YearLevel;
SaveImage(false);
if (value.Gender.ToLower() == "male")
{
rbStudentMale.Checked = true;
rbStudentFemale.Checked = false;
}
else
{
rbStudentMale.Checked = false;
rbStudentFemale.Checked = true;
}
txtStudentRFIDNo.Text = value.RFIDNo;
cmbStudentCourse.Text = value.Course;
txtStudentAddress.Text = value.Address;
cbCompleted.Checked = value.CompletedStatus.Value;
cbGraduated.Checked = value.GraduateStatus.Value;
cbEnrolled.Checked = value.EnrolledStatus.Value;
cbRFIDstd.Checked = value.RFIDStatus.Value;
cbContactNoStd.Checked = value.ContactNoStatus.Value;
cbActiveStd.Checked = value.Active.Value;
}
}
using (Parents parent = new Parents())
{
var value = parent.GetParentsInfo().Where(x => x.StudentID == dgStudentRecord.SelectedRows[0].Cells[2].Value.ToString()).FirstOrDefault();
if (value != null)
{
ParentsID = value.ID;
txtFatherAddress.Text = value.DadAddress;
cmbFatherCivilStatus.Text = value.DadCivilStatus;
txtFatherContactNo.Text = value.DadContactNo;
txtFatherFirstName.Text = value.DadFistName;
txtFatherLastName.Text = value.DadLastName;
txtFatherMiddleName.Text = value.DadMiddleName;
txtFatherRFIDNo.Text = value.DadRFIDNo;
cbRFIDDads.Checked = value.FRFIDNo.Value;
cbContactDads.Checked = value.FContactNo.Value;
cbActiveDads.Checked = value.FActive.Value;
txtMotherLastName.Text = value.MomLastName;
txtMotherFirstName.Text = value.MomFirstName;
txtMotherMiddleName.Text = value.MomMiddleName;
txtMotherContactNo.Text = value.MomContactNo;
txtMotherRFIDNo.Text = value.MomRFIDNo;
cmbMotherCivilStatus.Text = value.MomCivilStatus;
txtMotherAddress.Text = value.MomAddress;
cbRFIDMoms.Checked = value.MRFIDNo.Value;
cbContactMoms.Checked = value.MContactNo.Value;
cbActiveMoms.Checked = value.MActive.Value;
}
}
}
