/// <summary>
/// To get MEETING PURPOSE
/// </summary>
/// <returns></returns>
public MeetingList getMEETINGPURPOSE()
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_NAME_MEETING";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Meeting BOobj = null;
MeetingList Listobj = new MeetingList();
while (dr.Read())
{
BOobj = new Meeting();
BOobj.MEETINGPURPOSEID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("MEETINGPURPOSEID"))));
BOobj.Meetingpurpose = dr.GetValue(dr.GetOrdinal("MEETINGPURPOSE")).ToString();
Listobj.Add(BOobj);
}
dr.Close();
return(Listobj);
}
public ActionResult List(DateTime bDate, DateTime eDate, string SearchType = "", int codeID = 0, string code = "", bool canEdit = true, string Requestor = "")
{
ViewBag.Requestor = Requestor;
ViewBag.CanEdit = canEdit;
ViewBag.BeginDate = bDate;
ViewBag.EndDate = eDate;
ViewBag.SearchType = SearchType;
ViewBag.CodeID = codeID;
ViewBag.Code = code;
ViewBag.CallerType = "";
ViewBag.MinistryID = codeID;
IEnumerable <meeting> MeetingList;
if (SearchType == "MinistrySearch")
{
MeetingList = MeetingRepository.GetMeetingByMinistry(codeID);
}
else if (SearchType == "StatusSearch")
{
MeetingList = MeetingRepository.GetMeetingByStatus(code);
}
else
{
MeetingList = MeetingRepository.GetMeetingByDateRange(bDate, eDate);
}
ViewBag.RecordCount = MeetingList.Count();
return(PartialView(MeetingList));
}
private void UpdateMeeting(MeetingList meetingList, string creatorName, string createTime)
{
var currentMeeting =
meetingList.MeetingInfos.FirstOrDefault(o => o.MeetingId == (int)AppCache.TryGet(CacheKey.MeetingId));
if (currentMeeting == null)
{
MeetingItem meetingItem = new MeetingItem()
{
LastActivityTime = DateTime.Now,
MeetingId = (int)AppCache.TryGet(CacheKey.MeetingId),
CreatorName = creatorName,
IsClose = false,
CreatorId = AppCache.TryGet(CacheKey.HostId).ToString(),
};
if (!string.IsNullOrEmpty(createTime))
{
meetingItem.CreateTime = DateTime.Parse(createTime);
}
meetingList.MeetingInfos.Add(meetingItem);
}
else
{
currentMeeting.LastActivityTime = DateTime.Now;
}
_localDataManager.SaveMeetingList(meetingList);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
System.Windows.Data.CollectionViewSource meetingViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("meetingViewSource")));
meetings = new MeetingList();
meetingViewSource.Source = meetings;
}
/// <summary>
/// Set the meeting list as desired. Do our best to be "neat" about it.
/// </summary>
/// <param name="m"></param>
private void SetMeetings(IMeetingRefExtended[] m)
{
// We need the list to be sorted by date
var sortedMeetings = m.OrderBy(s => s.StartTime);
MeetingList.MakeListLookLike(sortedMeetings,
(oItem, dItem) => oItem.Meeting.AsReferenceString() == dItem.Meeting.AsReferenceString(),
dItem => dItem
);
}
public MeetingList GetMeetingList(int Userid, int OrganizationId, int PageNo, int PageSize, string sortColumn, string sortOrder, string subTitle = "", string action = "", string date = "", string location = "")
{
MeetingList list = new MeetingList();
ObjectParameter totalRecords = new ObjectParameter("TotalRecords", typeof(int));
var data = base.RepositoryContext.SP_GetMeetingList(PageNo, PageSize, sortColumn, sortOrder, subTitle, action, date, location, OrganizationId, totalRecords).ToList();
list.MeetingListModel = Mapper.Map <List <SP_GetMeetingList_Result>, List <MeetingListModel> >(data);
list.TotalRecords = Convert.ToInt32(totalRecords.Value);
return(list);
}
public ActionResult AdminList(DateTime bDate, DateTime eDate, string SearchType = "", int codeID = 0, string code = "", string CallerType = "")
{
ViewBag.BeginDate = bDate;
ViewBag.EndDate = eDate;
ViewBag.SearchType = SearchType;
ViewBag.CodeID = codeID;
ViewBag.Code = code;
ViewBag.CallerType = CallerType;
IEnumerable <meeting> MeetingList;
ViewBag.CallerType = CallerType;
if (SearchType == "MinistrySearch")
{
MeetingList = MeetingRepository.GetMeetingByMinistry(codeID);
}
else if (SearchType == "StatusSearch")
{
MeetingList = MeetingRepository.GetMeetingByStatus(code);
}
else
{
MeetingList = MeetingRepository.GetMeetingByDateRange(bDate, eDate);
}
ViewBag.RecordCount = MeetingList.Count();
foreach (meeting m in MeetingList)
{
m.ministry = MinistryRepository.GetMinistryByID(m.ministryID);
if (m.CalendarID > 0)
{
m.calendar = CalendarRepository.GetCalendarByID(m.CalendarID);
}
if (m.DocumentID != null)
{
m.document = DocumentRepository.GetDocumentByID((int)m.DocumentID);
}
}
return(PartialView(MeetingList));
}
public ViewResult MeetingList(Guid clientCode)
{
var results = new List <Meeting>();
var sendme = new MeetingList();
SqlConnection cnn;
cnn = new SqlConnection(connectionString);
SqlCommand command;
SqlDataAdapter adapter = new SqlDataAdapter();
cnn.Open();
string query = "select * from meetings where clientCode = '" + clientCode + "'";
command = new SqlCommand(query, cnn);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//We push information from the query into a row and onto the list of rows
Meeting meet = new Meeting {
MeetingDate = reader.GetDateTime(0), MeetingPurpose = reader.GetString(1), MeetingNotes = reader.GetString(2), meetingCode = reader.GetGuid(4)
};
results.Add(meet);
}
reader.Close();
sendme.list = results;
query = "select clientLast, clientFirst from client where clientCode = '" + clientCode + "'";
command = new SqlCommand(query, cnn);
reader = command.ExecuteReader();
while (reader.Read())
{
sendme.fname = reader.GetString(1);
sendme.lname = reader.GetString(0);
sendme.clientCode = clientCode;
}
reader.Close();
cnn.Close();
return(View("MeetingList", sendme));
}
public void SaveMeetingList(MeetingList meeting)
{
try
{
if (meeting == null)
{
throw new ArgumentNullException(nameof(meeting));
}
meeting.MeetingInfos = meeting.MeetingInfos.OrderByDescending(meetingInfo => meetingInfo.LastActivityTime).Take(6).ToList();
var filePath = _dataFilePath + "/MeetingInvitationData.xml";
SerializeHelper.Serialize(meeting, typeof(MeetingList), filePath);
}
catch (Exception ex)
{
Logger.WriteErrorFmt("课堂列表文件", ex, "课堂列表文件保存异常：{0}", ex.Message);
}
}
/// <summary>
/// To Get Culture Property Meetings
/// </summary>
/// <param name="culturalPropertyID"></param>
/// <returns></returns>
public MeetingList GetCulturePropertyMeetings(int culturalPropertyID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_MEETING";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("CULTURALPROPERTYID_", culturalPropertyID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Meeting Meetingobj = null;
MeetingList Listobj = new MeetingList();
while (dr.Read())
{
Meetingobj = new Meeting();
if (!dr.IsDBNull(dr.GetOrdinal("culturalmeetid")))
{
Meetingobj.CULTURALMEETID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalmeetid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("MEETINGDATE")))
{
Meetingobj.MEETINGDATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("meetingdate")));
}
if (!dr.IsDBNull(dr.GetOrdinal("MEETINGLOCATION")))
{
Meetingobj.MEETINGLOCATION = dr.GetString(dr.GetOrdinal("meetinglocation"));
}
Meetingobj.Meetingpurpose = dr.GetString(dr.GetOrdinal("meetingpurpose"));
if (!dr.IsDBNull(dr.GetOrdinal("WITNESSNGO")))
{
Meetingobj.WITNESSNGO = dr.GetString(dr.GetOrdinal("witnessngo"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OPINIONLEADER")))
{
Meetingobj.OPINIONLEADER = dr.GetString(dr.GetOrdinal("opinionleader"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MINISTRYOFGLSD")))
{
Meetingobj.MINISTRYOFGLSD = dr.GetString(dr.GetOrdinal("ministryofglsd"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AESREP")))
{
Meetingobj.AESREP = dr.GetString(dr.GetOrdinal("aesrep"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MOUSIGNED")))
{
Meetingobj.MOUSIGNED = dr.GetString(dr.GetOrdinal("mousigned"));
}
else
{
Meetingobj.MOUSIGNED = "No";
}
Listobj.Add(Meetingobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// To Get Meeting Data
/// </summary>
/// <param name="CULTURALMEETID"></param>
/// <returns></returns>
public Meeting GetMeetingData(int CULTURALMEETID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_MEETING";//"USP_TRN_GET_DAMAGE_CROPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("M_CULTURALMEETID", CULTURALMEETID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
Meeting Meetingobj = null;
MeetingList Listobj = new MeetingList();
Meetingobj = new Meeting();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("culturalpropid")))
{
Meetingobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalpropid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("culturalmeetid")))
{
Meetingobj.CULTURALMEETID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalmeetid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("MEETINGDATE")))
{
Meetingobj.MEETINGDATE = Convert.ToDateTime(dr.GetValue(dr.GetOrdinal("MEETINGDATE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("MEETINGLOCATION")))
{
Meetingobj.MEETINGLOCATION = dr.GetString(dr.GetOrdinal("MEETINGLOCATION"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MEETINGPURPOSEID")))
{
Meetingobj.MEETINGPURPOSEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("MEETINGPURPOSEID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("WITNESSNGO")))
{
Meetingobj.WITNESSNGO = dr.GetString(dr.GetOrdinal("WITNESSNGO"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OPINIONLEADER")))
{
Meetingobj.OPINIONLEADER = dr.GetString(dr.GetOrdinal("OPINIONLEADER"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MINISTRYOFGLSD")))
{
Meetingobj.MINISTRYOFGLSD = dr.GetString(dr.GetOrdinal("MINISTRYOFGLSD"));
}
if (!dr.IsDBNull(dr.GetOrdinal("AESREP")))
{
Meetingobj.AESREP = dr.GetString(dr.GetOrdinal("AESREP"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MOUSIGNED")))
{
Meetingobj.MOUSIGNED = dr.GetString(dr.GetOrdinal("MOUSIGNED"));
}
if (!dr.IsDBNull(dr.GetOrdinal("MEETINGCOMMENTS")))
{
Meetingobj.MEETINGCOMMENTS = dr.GetString(dr.GetOrdinal("MEETINGCOMMENTS"));
}
}
dr.Close();
return(Meetingobj);
}
