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);
}
}
void DeleteTime()
{
using (Maintenance maintain = new Maintenance())
{
T_RoomTime value = new T_RoomTime();
value.RoomCode = txtRoomCode.Text;
maintain.Delete(value);
}
}
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();
}
}
void SaveTime()
{
T_RoomTime value = new T_RoomTime();
using (Maintenance maintain = new Maintenance())
{
for (int i = 0; i <= dgTime.Rows.Count - 1; i++)
{
value.ID = Convert.ToInt64(dgTime.Rows[0].Cells[0].Value.ToString());
value.RoomCode = txtRoomCode.Text;
value.Status = Convert.ToBoolean(dgTime.Rows[i].Cells[3].Value.ToString());
value.TimeCode = dgTime.Rows[i].Cells[4].Value.ToString();
maintain.Save(value);
}
}
}
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();
}
}