public List <T_BranchBuilding> GetBuildingCode()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_BranchBuildings.ToList());
}
}
public List <T_DeviceSettingRFID> GetRFIDDevice()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_DeviceSettingRFIDs.ToList());
}
}
public List <T_Remainder> GetRemainders()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Remainders.ToList());
}
}
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 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);
}
}
//Year Level Like First Year or Second Year
public List <T_YearLevel> GetYearLevel()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_YearLevels.ToList());
}
}
public void Save(T_YearLevel value, ref string msg)
{
T_YearLevel valueupdate = new T_YearLevel();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//check data is already exist
if (Compare(value))
{
//is Save New
if (value.ID == 0)
{
dc.T_YearLevels.InsertOnSubmit(value);
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}", SystemProperties.MessageNotification.Saved, value.YearLevel, value.Active);
}
// Is Update
else
{
valueupdate = dc.T_YearLevels.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.YearLevel = value.YearLevel;
valueupdate.Active = value.Active;
valueupdate.Count = value.Count;
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}", SystemProperties.MessageNotification.Updated, valueupdate.YearLevel, valueupdate.Active);
}
dc.SubmitChanges();
}
else
{
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}", SystemProperties.MessageNotification.Exist, value.YearLevel, value.Active);
}
}
}
public bool Compare(T_Time value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Times.Where(x => x.TimeCode.ToLower() == value.TimeCode.ToLower() && x.Active == value.Active && x.TimeStart == value.TimeStart && x.TimeEnd == value.TimeEnd).FirstOrDefault() == null ? true : false);
}
}
//subject registration
public List <T_Subject> GetSubject()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Subjects.ToList());
}
}
public bool Compare(T_RoomTime value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_RoomTimes.Where(x => x.RoomCode == value.RoomCode && x.TimeCode == value.TimeCode).FirstOrDefault() == null ? true : false);
}
}
public bool Compare(T_Room value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Rooms.Where(x => x.Active == value.Active && x.RoomCode.ToLower() == value.RoomCode.ToLower() && x.RoomType == value.RoomType && x.Description == value.Description && x.BuildingCode == value.BuildingCode && x.Capacity == value.Capacity).FirstOrDefault() == null ? true : false);
}
}
public bool Compare(T_BranchBuilding value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_BranchBuildings.Where(x => x.Active == value.Active && x.Branch.ToLower() == value.Branch.ToLower() && x.BuildingCode.ToLower() == value.BuildingCode.ToLower() && x.BuildingName.ToLower() == value.BuildingName.ToLower()).FirstOrDefault() == null ? true : false);
}
}
public bool Compare(T_CourseAndSubject value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_CourseAndSubjects.Where(x => x.CourseCode == value.CourseCode && x.CourseDescription == value.CourseDescription && x.Description == value.Description && x.SubjectCode == value.SubjectCode && x.Unit == value.Unit).FirstOrDefault() == null ? true : false);
}
}
public void Save(T_BranchBuilding value, ref string msg)
{
T_BranchBuilding valueupdate = new T_BranchBuilding();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_BranchBuildings.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Branch: {1}" + Environment.NewLine + "Code: {2}" + Environment.NewLine + "Name: {3}", SystemProperties.MessageNotification.Saved, value.Branch, value.BuildingCode, value.BuildingName);
}
else
{
valueupdate = dc.T_BranchBuildings.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.BuildingCode = value.BuildingCode;
valueupdate.Branch = value.Branch;
valueupdate.BuildingName = value.BuildingName;
valueupdate.Active = value.Active;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Branch: {1}" + Environment.NewLine + "Code: {2}" + Environment.NewLine + "Name: {3}", SystemProperties.MessageNotification.Updated, valueupdate.Branch, valueupdate.BuildingCode, valueupdate.BuildingName);
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
//Course Like Bachelor of Science in Informatation Technology
public List <T_Course> GetCourse()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Courses.ToList());
}
}
public List <T_ActiveSemester> GetActiveSemester()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_ActiveSemesters.ToList());
}
}
public bool Compare(T_Course value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Courses.Where(x => x.Active == value.Active && x.Course.ToLower() == value.Course.ToLower() && x.CourseCode.ToLower() == value.CourseCode.ToLower() && x.YearMinimum == value.YearMinimum && x.YearMaximum == value.YearMaximum && x.YearLevelFromTo == value.YearLevelFromTo).FirstOrDefault() == null ? true : false);
}
}
public bool Compare(T_Subject value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Subjects.Where(x => x.Code.ToLower() == value.Code.ToLower() && x.Description.ToLower() == value.Description.ToLower() && x.Unit == value.Unit && x.Active == value.Active).FirstOrDefault() == null ? true : false);
}
}
public bool Compare(T_YearLevel value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_YearLevels.Where(x => x.Count == value.Count && x.Active == value.Active && x.YearLevel.ToLower() == value.YearLevel.ToLower()).FirstOrDefault() == null ? true : false);
}
}
public void Save(T_Subject value, ref string msg)
{
T_Subject valueupdate = new T_Subject();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_Subjects.InsertOnSubmit(value);
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Saved, value.Unit, value.Code, value.Description);
}
else
{
valueupdate = dc.T_Subjects.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.Code = value.Code;
valueupdate.Unit = value.Unit;
valueupdate.Description = value.Description;
valueupdate.Active = value.Active;
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Updated, valueupdate.Unit, valueupdate.Code, valueupdate.Description);
}
dc.SubmitChanges();
}
else
{
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Exist, value.Unit, value.Code, value.Description);
}
}
}
public bool Compare(T_ActiveSemester value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_ActiveSemesters.Where(x => x.Active == value.Active && x.DateEnd == value.DateEnd && x.DateStart == value.DateStart && x.Semester == value.Semester && x.YearSemester == value.YearSemester).FirstOrDefault() == null ? true : false);
}
}
//Application Like New Enrollment or Transferee
public List <T_Application> GetApplication()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Applications.ToList());
}
}
//Access for the system Like Admin1 or Admin2
public List <T_AccessRight> GetAccessRight()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_AccessRights.ToList());
}
}
public void Save(T_ActiveSemester value, ref string msg)
{
T_ActiveSemester valueupdate = new T_ActiveSemester();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
dc.T_ActiveSemesters.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Semester: {1}" + Environment.NewLine + "Year class: {2}", SystemProperties.MessageNotification.Saved, value.Semester, value.YearSemester);
}
else
{
valueupdate = dc.T_ActiveSemesters.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.DateEnd = value.DateEnd;
valueupdate.DateStart = value.DateStart;
valueupdate.Semester = value.Semester;
valueupdate.YearSemester = value.YearSemester;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Semester: {1}" + Environment.NewLine + "Year class: {2}", SystemProperties.MessageNotification.Saved, valueupdate.Semester, valueupdate.YearSemester);
}
dc.SubmitChanges();
}
}
public bool Save(T_RoomDevie value, ref string msg)
{
bool ret = false;
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (!string.IsNullOrWhiteSpace(value.DeviceCode))
{
if (Compare(value))
{
dc.T_RoomDevies.InsertOnSubmit(value);
dc.SubmitChanges();
//return false;
}
else
{
msg = SystemProperties.MessageNotification.Exist;
ret = true;
//return true;
}
}
//dc.SubmitChanges();
//return false;
return(ret);
}
}
//Civil Status Like Single Married
public List <T_CivilStatus> GetCivilStatus()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_CivilStatus.ToList());
}
}
public void Save(T_DeviceSettingRFID value, ref string msg)
{
//T_DeviceSettingRFID valueupdate = new T_DeviceSettingRFID();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_DeviceSettingRFIDs.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Device Name: {1}" + Environment.NewLine + "Port: {2}" + Environment.NewLine + "Baund Rate: {3}" + Environment.NewLine + "Data Bit: {4}" + Environment.NewLine + "Parity: {5}" + Environment.NewLine + "Stop Bit: {6}", SystemProperties.MessageNotification.Saved, value.DeviceName, value.Port, value.BaundRate, value.DataBit, value.Parity, value.StopBit);
}
else
{
//valueupdate = dc.T_DeviceSettingRFIDs.Where(x => x.ID == value.ID).FirstOrDefault();
var valueupdate = dc.T_DeviceSettingRFIDs.FirstOrDefault(x => x.ID == value.ID);
valueupdate.DeviceName = value.DeviceName;
valueupdate.BaundRate = value.BaundRate;
valueupdate.DataBit = value.DataBit;
valueupdate.Parity = value.Parity;;
valueupdate.Port = value.Port;
valueupdate.StopBit = value.StopBit;
valueupdate.Active = value.Active;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Device Name: {1}" + Environment.NewLine + "Port: {2}" + Environment.NewLine + "Baund Rate: {3}" + Environment.NewLine + "Data Bit: {4}" + Environment.NewLine + "Parity: {5}" + Environment.NewLine + "Stop Bit: {6}", SystemProperties.MessageNotification.Updated, value.DeviceName, value.Port, value.BaundRate, value.DataBit, value.Parity, value.StopBit);
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
public bool Compare(T_CivilStatus value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_CivilStatus.Where(x => x.Active == value.Active && x.Status.ToLower() == value.Status.ToLower()).FirstOrDefault() == null ? true : false);
}
}
public List <T_RoomDevie> GetDeviceAvailable()
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_RoomDevies.ToList());
}
}
public bool Compare(T_Semester value)
{
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
return(dc.T_Semesters.Where(x => x.Semester.ToLower() == value.Semester.ToLower()).FirstOrDefault() == null ? true : false);
}
}
