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); } }