public bool Compare(T_AccessRight value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_AccessRights.Where(x => x.YearClass == value.YearClass && x.Semester == value.Semester && x.RoomType == value.RoomType && x.Building == value.Building && x.PositionID.ToLower() == value.PositionID.ToLower() && x.JobTitle.ToLower() == value.JobTitle.ToLower() && x.Description.ToLower() == value.Description.ToLower() && x.Active == value.Active && x.Student == value.Student && x.Instructor == value.Instructor && x.Position == value.Position && x.Users == value.Users && x.Application == value.Application && x.YearLevel == value.YearLevel && x.CivilStatus == value.CivilStatus && x.Course == value.Course && x.Subject == value.Subject && x.Room == value.Room && x.Time == value.Time && x.Display == value.Display && x.Report == value.Report && x.DeviceConfiguration == value.DeviceConfiguration).FirstOrDefault() == null ? true : false);
}
}
public void Save(T_AccessRight value, ref string msg)
{
T_AccessRight valueupdate = new T_AccessRight();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_AccessRights.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "POSITION ID: [{1}]" + Environment.NewLine + "JOB TITLE; [{2}]" + Environment.NewLine + "DESCRIPTION: [{3}]", SystemProperties.MessageNotification.Saved, value.PositionID, value.JobTitle, value.Description);
}
else
{
valueupdate = dc.T_AccessRights.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.JobTitle = value.JobTitle;
valueupdate.Description = value.Description;
valueupdate.Student = value.Student;
valueupdate.Instructor = value.Instructor;
valueupdate.Position = value.Position;
valueupdate.Users = value.Users;
valueupdate.YearLevel = value.YearLevel;
valueupdate.CivilStatus = value.CivilStatus;
valueupdate.Application = value.Application;
valueupdate.Course = value.Course;
valueupdate.Subject = value.Subject;
valueupdate.Room = value.Room;
valueupdate.Time = value.Time;
valueupdate.Display = value.Display;
valueupdate.Report = value.Report;
valueupdate.DeviceConfiguration = value.DeviceConfiguration;
valueupdate.Active = value.Active;
valueupdate.Building = value.Building;
valueupdate.RoomType = value.RoomType;
valueupdate.ViewRoom = value.ViewRoom;
valueupdate.ViewCourse = value.ViewCourse;
valueupdate.ViewInstructor = value.ViewInstructor;
valueupdate.MaintenanceMessage = value.MaintenanceMessage;
valueupdate.NotifyStudent = value.NotifyStudent;
valueupdate.SMSSettings = value.SMSSettings;
valueupdate.Semester = value.Semester;
valueupdate.YearClass = value.YearClass;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "POSITION ID: [{1}]" + Environment.NewLine + "JOB TITLE; [{2}]" + Environment.NewLine + "DESCRIPTION: [{3}]", SystemProperties.MessageNotification.Updated, valueupdate.PositionID, valueupdate.JobTitle, valueupdate.Description);
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
public void Delete(T_AccessRight value, ref string msg)
{
T_AccessRight valuedelete = new T_AccessRight();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_AccessRights.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_AccessRights.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "POSITION ID: [{1}]" + Environment.NewLine + "JOB TITLE; [{2}]" + Environment.NewLine + "DESCRIPTION: [{3}]", SystemProperties.MessageNotification.Deleted, valuedelete.PositionID, valuedelete.JobTitle, valuedelete.Description);
}
}
private T_AccessRight SetAccessRights()
{
T_AccessRight value = new T_AccessRight();
value.ID = isAdd ? 0 : Convert.ToInt64(dgAccessRightPositionRecord.SelectedRows[0].Cells[0].Value);
value.JobTitle = txtJobTitle.Text;
value.Description = txtDescription.Text;
value.Student = cbReg_Student.Checked;
value.Instructor = cbReg_Instructor.Checked;
value.Position = cbMain_Position.Checked;
value.Users = cbMain_User.Checked;
value.YearLevel = cbMain_YearLevel.Checked;
value.CivilStatus = cbMain_CivilStatus.Checked;
value.Application = cbMain_Application.Checked;
value.Course = cbMain_Course.Checked;
value.Subject = cbMain_Subject.Checked;
value.Room = cbMain_Room.Checked;
value.Time = cbMain_Time.Checked;
value.Display = cbWin_Display.Checked;
value.Report = cbWin_Report.Checked;
value.DeviceConfiguration = cbSett_DeviceConfig.Checked;
value.Active = cbActive.Checked;
value.PositionID = txtPositionID.Text;
value.RoomType = cbRoomType.Checked;
value.Building = cbBuilding.Checked;
value.ViewRoom = cbViewRoom.Checked;
value.ViewCourse = cbViewCourse.Checked;
value.ViewInstructor = cbViewInstructor.Checked;
value.MaintenanceMessage = cbMessage.Checked;
value.NotifyStudent = cbStudent.Checked;
value.SMSSettings = cbSMSSettings.Checked;
value.Semester = cbSemester.Checked;
value.YearClass = cbYearClass.Checked;
return(value);
}
