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();
}
}
public void Save(T_InstructorInformation value, ref string msg)
{
//T_InstructorInformation valueupdate = new T_InstructorInformation();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_InstructorInformations.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Employee ID: {1}" + Environment.NewLine + "Name: {2}" + Environment.NewLine + "Contact No: {3}", SystemProperties.MessageNotification.Saved, value.EmployeeID, value.LastName + ", " + value.FirstName, value.ContactNo);
}
else
{
// valueupdate = dc.T_InstructorInformations.Where(x => x.ID == value.ID).FirstOrDefault();
var valueupdate = dc.T_InstructorInformations.FirstOrDefault(x => x.ID == value.ID);
valueupdate.EmployeeID = value.EmployeeID;
valueupdate.LastName = value.LastName;
valueupdate.FirstName = value.FirstName;
valueupdate.MiddleName = value.MiddleName;
valueupdate.ContactNo = value.ContactNo;
valueupdate.BDay = value.BDay;
valueupdate.Gender = value.Gender;
valueupdate.Address = value.Address;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Employee ID: {1}" + Environment.NewLine + "Name: {2}" + Environment.NewLine + "Contact No: {3}", SystemProperties.MessageNotification.Updated, valueupdate.EmployeeID, valueupdate.LastName + ", " + valueupdate.FirstName, valueupdate.ContactNo);
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
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 void Save(T_ScanUserLog value, bool TimeIN)
{
T_ScanUserLog valueupdate = new T_ScanUserLog();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
T_RegisteredStudentSemester values = new T_RegisteredStudentSemester();
values = dc.T_RegisteredStudentSemesters.Where(x => x.StudentID == value.StudentID && x.Day.Replace(" ", "").Replace(" ", "").Replace(" ", "").Replace(" ", "") == value.Day && x.TimeStart.Hour == UserDetail.CurrDate().Hour&& x.Semester == SystemProperties.SemesterActive.Semester && x.YearClass == SystemProperties.SemesterActive.YearSemester).FirstOrDefault();
if (TimeIN)
{
values.AlreadyIN = true;
dc.T_ScanUserLogs.InsertOnSubmit(value);
}
else
{
//Where(x => x.RoomCode == RoomCode && x.StudentID == StudID && x.TImeEnd == null && x.Day.ToLower() == Days().ToLower()).FirstOrDefault();
//valueupdate = dc.T_ScanUserLogs.Where(x => x.StudentID == value.StudentID && x.TimeIN.Value.ToShortDateString() == UserDetail.CurrDate().ToShortDateString() && x.TimeOUT==null).FirstOrDefault();
valueupdate = dc.T_ScanUserLogs.Where(x => x.RoomCode == value.RoomCode && x.StudentID == value.StudentID && x.TimeOUT == null && x.Day.ToLower() == Days().ToLower()).FirstOrDefault();
valueupdate.TimeOUT = UserDetail.CurrDate();
values.AlreadyIN = false;
}
dc.SubmitChanges();
}
}
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 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 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);
}
}
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 void SaveLog(bool TimeIN)
{
//T_SystemUserLog value = new T_SystemUserLog();
//T_SystemUserLog valueupdate = new T_SystemUserLog();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (TimeIN)
{
//value.UserID = UserInfo.UserID;
//value.UserPassword = UserInfo.Password;
//value.TimeIN = UserInfo.TimeIn;
//dc.T_SystemUserLogs.InsertOnSubmit(value);
dc.T_SystemUserLogs.InsertOnSubmit(new T_SystemUserLog()
{
UserID = UserInfo.UserID,
UserPassword = UserInfo.Password,
TimeIN = UserInfo.TimeIn
});
}
else
{
if (!string.IsNullOrWhiteSpace(UserInfo.UserID))
{
//valueupdate = dc.T_SystemUserLogs.Where(x => x.TimeIN == UserInfo.TimeIn && x.UserID == UserInfo.UserID).FirstOrDefault();
var valueupdate = dc.T_SystemUserLogs.FirstOrDefault(x => x.TimeIN == UserInfo.TimeIn && x.UserID == UserInfo.UserID);
if (valueupdate != null)
{
valueupdate.TimeOUT = CurrDate();
}
}
}
dc.SubmitChanges();
}
}
public void Save(T_NotificationSetting value, ref string msg)
{
//T_NotificationSetting valueupdate = new T_NotificationSetting();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0 && GetAPIs().ToList().Count == 0)
{
dc.T_NotificationSettings.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine +
"Site: {1}" + Environment.NewLine +
"Page: {2}" + Environment.NewLine +
"Mobile: {3}" + Environment.NewLine +
"Message: {4}",
SystemProperties.MessageNotification.Saved,
value.Site,
value.Page,
value.ParamMobileName,
value.ParamMessageName);
}
else
{
//var valueupdate = dc.T_NotificationSettings.Where(x => x.ID == value.ID).FirstOrDefault();
var valueupdate = dc.T_NotificationSettings.FirstOrDefault(x => x.ID == value.ID);
if (valueupdate != null)
{
valueupdate.Active = value.Active;
valueupdate.Page = value.Page;
valueupdate.ParamMessageName = value.ParamMessageName;
valueupdate.ParamMobileName = value.ParamMobileName;
valueupdate.Site = value.Site;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine +
"Site: {1}" + Environment.NewLine +
"Page: {2}" + Environment.NewLine +
"Mobile: {3}" + Environment.NewLine +
"Message: {4}",
SystemProperties.MessageNotification.Updated,
valueupdate.Site,
valueupdate.Page,
valueupdate.ParamMobileName,
valueupdate.ParamMessageName);
}
else
{
msg = "Not allow to add new, Please can remove site.";
}
}
}
else
{
msg = SystemProperties.MessageNotification.Exist;
}
dc.SubmitChanges();
}
}
public void Delete(T_CourseAndSubject value)
{
//T_CourseAndSubject valuedelete = new T_CourseAndSubject();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
var valuedelete = dc.T_CourseAndSubjects.Where(x => x.CourseCode == value.CourseCode && x.CourseDescription == value.CourseDescription).ToList();
dc.T_CourseAndSubjects.DeleteAllOnSubmit(valuedelete);
dc.SubmitChanges();
}
}
public void Save(T_CourseAndSubject value)
{
T_CourseAndSubject valueupdate = new T_CourseAndSubject();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
dc.T_CourseAndSubjects.InsertOnSubmit(value);
dc.SubmitChanges();
}
}
public void Delete(T_ParenstInfo value)
{
T_ParenstInfo valuedelete = new T_ParenstInfo();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_ParenstInfos.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_ParenstInfos.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
}
}
public void Delete(T_RoomTime value)
{
List <T_RoomTime> valuedelete = new List <T_RoomTime>();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_RoomTimes.Where(x => x.RoomCode == value.RoomCode).ToList();
dc.T_RoomTimes.DeleteAllOnSubmit(valuedelete);
dc.SubmitChanges();
}
}
public void Delete(T_RoomDevie value)
{
//T_RoomDevie valuedelete = new T_RoomDevie();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//valuedelete = dc.T_RoomDevies.Where(x => x.RoomCode == value.RoomCode).FirstOrDefault();
var valuedelete = dc.T_RoomDevies.FirstOrDefault(x => x.RoomCode == value.RoomCode);
dc.T_RoomDevies.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
}
}
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_DeviceSettingRFID value, ref string msg)
{
//T_DeviceSettingRFID valuedelete = new T_DeviceSettingRFID();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//var valuedelete = dc.T_DeviceSettingRFIDs.Where(x => x.ID == value.ID).FirstOrDefault();
var valuedelete = dc.T_DeviceSettingRFIDs.FirstOrDefault(x => x.ID == value.ID);
dc.T_DeviceSettingRFIDs.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
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.Deleted, valuedelete.DeviceName, valuedelete.Port, valuedelete.BaundRate, valuedelete.DataBit, valuedelete.Parity, valuedelete.StopBit);
}
}
public void Delete(T_InstructorInformation value, ref string msg)
{
//T_InstructorInformation valuedelete = new T_InstructorInformation();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//valuedelete = dc.T_InstructorInformations.Where(x => x.ID == value.ID).FirstOrDefault();
var valuedelete = dc.T_InstructorInformations.FirstOrDefault(x => x.ID == value.ID);
dc.T_InstructorInformations.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Employee ID: {1}" + Environment.NewLine + "Name: {2}" + Environment.NewLine + "Contact No: {3}", SystemProperties.MessageNotification.Deleted, valuedelete.EmployeeID, valuedelete.LastName + ", " + valuedelete.FirstName, valuedelete.ContactNo);
}
}
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);
}
}
public void Delete(T_ActiveSemester value, ref string msg)
{
T_ActiveSemester valuedelete = new T_ActiveSemester();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_ActiveSemesters.Where(x => x.ID == valuedelete.ID).FirstOrDefault();
dc.T_ActiveSemesters.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Semester: {1}" + Environment.NewLine + "Year class: {2}", SystemProperties.MessageNotification.Deleted, valuedelete.Semester, valuedelete.YearSemester);
}
}
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 Delete(T_Course value, ref string msg)
{
T_Course valuedelete = new T_Course();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_Courses.Where(x => x.ID == value.ID).FirstOrDefault();
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + "{2}" + Environment.NewLine + "{3}" + Environment.NewLine + "{4}" + Environment.NewLine + "{5}", SystemProperties.MessageNotification.Deleted, value.CourseCode, value.CourseCode, value.YearMinimum, value.YearMaximum, value.Active);
dc.T_Courses.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
}
}
public void Delete(T_Subject value, ref string msg)
{
T_Subject valuedelete = new T_Subject();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_Subjects.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_Subjects.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0} " + Environment.NewLine + Environment.NewLine + "{1}" + Environment.NewLine + " {2}" + Environment.NewLine + " {3}", SystemProperties.MessageNotification.Deleted, valuedelete.Unit, valuedelete.Code, valuedelete.Description);
}
}
public void Delete(T_StudentInformation value, ref string msg)
{
T_StudentInformation valuedelete = new T_StudentInformation();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_StudentInformations.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_StudentInformations.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Student ID: {1}" + Environment.NewLine + "Last Name: {2}" + Environment.NewLine + "Firs Name: {3}" + Environment.NewLine + "RFID No.: {4}", SystemProperties.MessageNotification.Deleted, valuedelete.StudentID, valuedelete.LastName, valuedelete.FirstName, valuedelete.RFIDNo);
}
}
public void Delete(long ID, ref string msg)
{
T_RegisteredStudentSemester valuedelete = new T_RegisteredStudentSemester();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_RegisteredStudentSemesters.Where(x => x.ID == ID).FirstOrDefault();
dc.T_RegisteredStudentSemesters.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0} : {1},{2},{3} to {4}, {5} ", SystemProperties.MessageNotification.Deleted, valuedelete.StudentID, valuedelete.SubjectCode, valuedelete.TimeStart.ToString("HH:mm:ss tt"), valuedelete.TImeEnd.ToString("HH:mm:ss tt"), valuedelete.Day);
}
}
public void Delete(T_BranchBuilding value, ref string msg)
{
T_BranchBuilding valuedelete = new T_BranchBuilding();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
valuedelete = dc.T_BranchBuildings.Where(x => x.ID == value.ID).FirstOrDefault();
dc.T_BranchBuildings.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Branch: {1}" + Environment.NewLine + "Code: {2}" + Environment.NewLine + "Name: {3}", SystemProperties.MessageNotification.Updated, valuedelete.Branch, valuedelete.BuildingCode, valuedelete.BuildingName);
}
}
public void Save(T_StudentInformation value, ref string msg)
{
T_StudentInformation valueupdate = new T_StudentInformation();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_StudentInformations.InsertOnSubmit(value);
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Student ID: {1}" + Environment.NewLine + "Last Name: {2}" + Environment.NewLine + "Firs Name: {3}" + Environment.NewLine + "RFID No.: {4}", SystemProperties.MessageNotification.Saved, value.StudentID, value.LastName, value.FirstName, value.RFIDNo);
}
else
{
valueupdate = dc.T_StudentInformations.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.StudentID = value.StudentID;
valueupdate.MotherID = value.MotherID;
valueupdate.FatherID = value.FatherID;
valueupdate.Application = value.Application;
valueupdate.LastName = value.LastName;
valueupdate.FirstName = value.FirstName;
valueupdate.MiddleName = value.MiddleName;
valueupdate.ContactNo = value.ContactNo;
valueupdate.Bday = value.Bday;
valueupdate.Gender = value.Gender;
valueupdate.RFIDNo = value.RFIDNo.Replace("\r", "");
valueupdate.Course = value.Course;
valueupdate.Address = value.Address;
valueupdate.CompletedStatus = value.CompletedStatus;
valueupdate.GraduateStatus = value.GraduateStatus;
valueupdate.EnrolledStatus = value.EnrolledStatus;
valueupdate.RFIDStatus = value.RFIDStatus;
valueupdate.ContactNoStatus = value.ContactNoStatus;
valueupdate.Active = value.Active;
valueupdate.YearLevel = value.YearLevel;
//valueupdate.DateRegistered = value.DateRegistered;
//valueupdate.DisplayName = value.DisplayName;
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Student ID: {1}" + Environment.NewLine + "Last Name: {2}" + Environment.NewLine + "Firs Name: {3}" + Environment.NewLine + "RFID No.: {4}", SystemProperties.MessageNotification.Updated, valueupdate.StudentID, valueupdate.LastName, valueupdate.FirstName, valueupdate.RFIDNo);
}
}
else
{
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine + "Student ID: {1}" + Environment.NewLine + "Last Name: {2}" + Environment.NewLine + "Firs Name: {3}" + Environment.NewLine + "RFID No.: {4}", SystemProperties.MessageNotification.Exist, value.StudentID, value.LastName, value.FirstName, value.RFIDNo);
}
dc.SubmitChanges();
}
}
public void Save(T_ParenstInfo value)
{
T_ParenstInfo valueupdate = new T_ParenstInfo();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
if (value.ID == 0)
{
dc.T_ParenstInfos.InsertOnSubmit(value);
}
else
{
valueupdate = dc.T_ParenstInfos.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.MotherID = value.MotherID;
valueupdate.FatherID = value.FatherID;
valueupdate.MomLastName = value.MomLastName;
valueupdate.MomFirstName = value.MomFirstName;
valueupdate.MomMiddleName = value.MomMiddleName;
valueupdate.MomContactNo = value.MomContactNo;
valueupdate.MomRFIDNo = value.MomRFIDNo;
valueupdate.MomCivilStatus = value.MomCivilStatus;
valueupdate.MomAddress = value.MomAddress;
valueupdate.MRFIDNo = value.MRFIDNo;
valueupdate.MContactNo = value.MContactNo;
valueupdate.MActive = value.MActive;
valueupdate.DadLastName = value.DadLastName;
valueupdate.DadFistName = value.DadFistName;
valueupdate.DadMiddleName = value.DadMiddleName;
valueupdate.DadContactNo = value.DadContactNo;
valueupdate.DadRFIDNo = value.DadRFIDNo;
valueupdate.DadCivilStatus = value.DadCivilStatus;
valueupdate.DadAddress = value.DadAddress;
valueupdate.FRFIDNo = value.FRFIDNo;
valueupdate.FContactNo = value.FContactNo;
valueupdate.FActive = value.FActive;
}
}
dc.SubmitChanges();
}
}
public void Save(T_RoomTime value)
{
T_RoomTime valueupdate = new T_RoomTime();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
if (Compare(value))
{
dc.T_RoomTimes.InsertOnSubmit(value);
}
else
{
valueupdate = dc.T_RoomTimes.Where(x => x.ID == value.ID).FirstOrDefault();
valueupdate.RoomCode = value.RoomCode;
valueupdate.TimeCode = value.TimeCode;
valueupdate.Status = value.Status;
}
dc.SubmitChanges();
}
}
public void Delete(T_NotificationSetting value, ref string msg)
{
//T_NotificationSetting valuedelete = new T_NotificationSetting();
using (AttMonSysRFIDDataContext dc = new AttMonSysRFIDDataContext(SystemConnection.ConnectionString))
{
//var valuedelete = dc.T_NotificationSettings.Where(x => x.ID == value.ID).FirstOrDefault();
var valuedelete = dc.T_NotificationSettings.FirstOrDefault(x => x.ID == value.ID);
dc.T_NotificationSettings.DeleteOnSubmit(valuedelete);
dc.SubmitChanges();
msg = string.Format("{0}" + Environment.NewLine + Environment.NewLine +
"Site: {1}" + Environment.NewLine +
"Page: {2}" + Environment.NewLine +
"Mobile: {3}" + Environment.NewLine +
"Message: {4}",
SystemProperties.MessageNotification.Deleted,
value.Site,
value.Page,
value.ParamMobileName,
value.ParamMessageName);
}
}