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 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);
}
}
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);
}
}
private T_ActiveSemester SetSemester()
{
T_ActiveSemester valueRet = new T_ActiveSemester();
valueRet.ID = isAdd ? 0 : Convert.ToInt64(dgYearClass.SelectedRows[0].Cells[0].Value.ToString());
valueRet.DateEnd = dtDateEnd.Value;
valueRet.DateStart = dtDateStart.Value;
valueRet.Semester = cmbSemester.Text;
valueRet.YearSemester = txtYearClass.Text;
valueRet.Active = CheckActiveSemester() >= 1?false: cbActive.Checked;
return(valueRet);
}
