public int GetOrduserCount()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Orduser.Count());
}
}
public int GetAgendaCount()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.agenda.Count());
}
}
//查看普通用户具体信息
public Orduser GetOrduserInfo(int OrduserID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Orduser.Where(item => item.id == OrduserID).FirstOrDefault());
}
}
public int GetMeetingCount()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Meeting.Count());
}
}
public int GetDepartmentCount()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Department.Count());
}
}
//查看某个部门下的所有会议信息
public List <Meeting> GetDept_MeetingInfo(string DeptID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Meeting.Where(item => item.dept_id == DeptID).ToList());
}
}
//查看子管理员具体信息
public Admin GetAdminInfo(int AdminID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Admin.Where(item => item.id == AdminID).FirstOrDefault());
}
}
//查看部门具体信息
public Department GetDepartmentInfo(string DepartmentID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Department.Where(item => item.dept_id == DepartmentID).FirstOrDefault());
}
}
//查看宾馆具体信息
public Hotel GetHotelInfo(string HotelID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Hotel.Where(item => item.h_name == HotelID).FirstOrDefault());
}
}
//查看会议具体信息
public Meeting GetMeetingInfo(int MeetingID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Meeting.Where(item => item.m_id == MeetingID).FirstOrDefault());
}
}
public int GetAdminCount()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.Admin.Count());
}
}
//查看日程具体信息
public agenda GetAgendaInfo(int agendanumber)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
return(ef.agenda.Where(item => item.agenda_number == agendanumber).FirstOrDefault());
}
}
//添加会议
public int AddMeeting(Meeting meeting)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.Meeting.AddObject(meeting);
return(ef.SaveChanges());
}
}
//增加子管理员
public int AddAdmin(Admin admin)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.Admin.AddObject(admin);
return(ef.SaveChanges());
}
}
//查看普通用户
public List <Orduser> GetAllOrduserList()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <Orduser> result = ef.Orduser.ToList();
return(result.OrderByDescending(item => item.id).ToList());
}
}
//增加普通用户
public int AddOrduser(Orduser ord)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.Orduser.AddObject(ord);
return(ef.SaveChanges());
}
}
//查看宾馆
public List <Hotel> GetAllHotelList()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <Hotel> result = ef.Hotel.ToList();
return(result.OrderByDescending(item => item.h_name).ToList());
}
}
//增加宾馆
public int AddHotel(Hotel hotel)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.Hotel.AddObject(hotel);
return(ef.SaveChanges());
}
}
//查看子管理员属于的部门
public string GetDeptIDfromAdminID(int AdminID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
Admin result = ef.Admin.Where(item => item.id == AdminID).FirstOrDefault();
return(result.dept_id);
}
}
//查看会议
public List <Meeting> GetAllMeetingList()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <Meeting> result = ef.Meeting.ToList();
return(result.OrderByDescending(item => item.m_id).ToList());
}
}
//查看与会人员
public List <attend> GetAttendList(int MeetingID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <attend> result = ef.attend.Where(item => item.m_id == MeetingID).ToList();
return(result.OrderByDescending(item => item.m_id).ToList());
}
}
//查看日程
public List <agenda> GetAgendaList(int MID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <agenda> result = ef.agenda.Where(item => item.m_id == MID).ToList();
return(result.OrderByDescending(item => item.m_id).ToList());
}
}
//查看子管理员
public List <Admin> GetAllAdminList()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <Admin> result = ef.Admin.ToList();
return(result.OrderByDescending(item => item.id).ToList());
}
}
//添加与会人员
public int AddAttend(attend attend)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.attend.AddObject(attend);
return(ef.SaveChanges());
}
}
//增加部门
public string AddDepartment(Department dept)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.Department.AddObject(dept);
return(ef.SaveChanges().ToString());
}
}
//添加日程
public int AddAgenda(agenda agenda)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.agenda.AddObject(agenda);
return(ef.SaveChanges());
}
}
//添加陪同人员
public int AddAccompany(accompany accompany)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.accompany.AddObject(accompany);
return(ef.SaveChanges());
}
}
//查看部门
public List <Department> GetAllDepartmentList()
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <Department> result = ef.Department.ToList();
return(result.OrderByDescending(item => item.dept_id).ToList());
}
}
//查看与会人员具体信息
public attend GetAttendInfo(int AttendID, int MeetingID)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
List <attend> result = ef.attend.Where(item => item.participator_id == AttendID).ToList();
return(result.Where(item => item.m_id == MeetingID).FirstOrDefault());
}
}
//更改日程
public int UpdateAgenda(agenda agenda)
{
using (MeetingModelContainer ef = new MeetingModelContainer())
{
ef.agenda.Attach(agenda);
ef.ObjectStateManager.ChangeObjectState(agenda, System.Data.Entity.EntityState.Modified);
return(ef.SaveChanges());
}
}
