public bool UpdateSchedule(Schedule objSchedule)
{
int recAffected = 0;
DBConnectionString.Schedule schedule = new DBConnectionString.Schedule();
schedule.ScheduleId = objSchedule.ScheduleId;
schedule.ScheduleName = objSchedule.ScheduleName;
schedule.Description = objSchedule.Description;
schedule.OrganizationId = objSchedule.OrganizationId;
schedule.CourseId = objSchedule.CourseId;
schedule.ClassId = objSchedule.ClassId;
schedule.SubjectId = objSchedule.SubjectId;
schedule.DepartmentId = objSchedule.DepartmentId;
schedule.ClassRoomId = objSchedule.ClassRoomId;
schedule.InsertedOn = objSchedule.InsertedOn;
schedule.InsertedBy = objSchedule.InsertedBy;
schedule.ModifiedOn = DateTime.Now;
schedule.ModifiedBy = objSchedule.ModifiedBy;
schedule.StartTime = objSchedule.StartTime;
schedule.EndTime = objSchedule.EndTime;
schedule.DayIds = objSchedule.DayIds;
recAffected = schedule.Update();
if (recAffected > 0)
{
return(true);
}
return(false);
}
public bool DeleteSchedule(long id)
{
int recAffectd = 0;
DBConnectionString.Schedule schedule = db.Query <DBConnectionString.Schedule>("select * from schedule where ScheduleId=@0", id).SingleOrDefault();
recAffectd = schedule.Delete();
if (recAffectd > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool CreateSchedule(Schedule objSchedule)
{
int recAffected = 0;
DBConnectionString.Schedule schedule = new DBConnectionString.Schedule();
schedule.ScheduleName = objSchedule.ScheduleName;
schedule.Description = objSchedule.Description;
schedule.OrganizationId = objSchedule.OrganizationId;
schedule.CourseId = objSchedule.CourseId;
schedule.ClassId = objSchedule.ClassId;
schedule.SubjectId = objSchedule.SubjectId;
schedule.DepartmentId = objSchedule.DepartmentId;
schedule.ClassRoomId = objSchedule.ClassRoomId;
schedule.InsertedOn = DateTime.Now;
schedule.InsertedBy = objSchedule.InsertedBy;
schedule.StartTime = objSchedule.StartTime;
schedule.EndTime = objSchedule.EndTime;
schedule.DayIds = objSchedule.DayIds;
recAffected = Convert.ToInt32(schedule.Insert());
if (recAffected > 0)
{
return true;
}
return false;
}
