public bool Delete(int schedulesId)
{
bool result = true;
result = new TB_SCHEDULE_DETAILSSql().DeleteByField("ScheduleDetailScheduleId", schedulesId);
if (result)
{
result = new TB_SCHEDULESSql().Delete(schedulesId);
}
return(result);
}
public bool CheckRoomClass(string roomId, string timeStart, string timeEnd, string dayOfWeek, string dayOfWeek2, string timeStart2, string timeEnd2)
{
bool check = false;
List <TB_SCHEDULE_DETAILS> list = new TB_SCHEDULE_DETAILSSql().FilterByField("ScheduleDetailRoomClass", roomId);
if (list.Count == 0)
{
check = true;
}
else
{
if (string.IsNullOrEmpty(dayOfWeek2))
{
var a = list.Where(x => x.ScheduleDetailDayOfWeek.Equals(dayOfWeek)).ToList();
if (a.Count == 0)
{
check = true;
}
else
{
var b = a.Where(x => x.ScheduleDetailTimeFrom.Hours == Int32.Parse(timeStart)).ToList();
if (b.Count == 0)
{
check = true;
}
}
}
else
{
var a = list.Where(x => x.ScheduleDetailDayOfWeek.Equals(dayOfWeek)).ToList();
var a1 = list.Where(x => x.ScheduleDetailDayOfWeek.Equals(dayOfWeek2)).ToList();
if (a.Count == 0 && a1.Count == 0)
{
check = true;
}
else
{
var b = a.Where(x => x.ScheduleDetailTimeFrom.Hours == Int32.Parse(timeStart)).ToList();
var b1 = a.Where(x => x.ScheduleDetailTimeFrom.Hours == Int32.Parse(timeStart2)).ToList();
if (b.Count == 0 && b.Count == 0)
{
check = true;
}
}
}
}
return(check);
}