public async Task <IActionResult> SetMeeting(Meetings model, string CommitteeID)
{
if (ModelState.IsValid)
{
model.Suggestions = new List <DatesSuggestion>();
DatesSuggestion date;
DateTime datetime;
for (int i = 0; i < 5; i++)
{
var suggestion = Request.Form["Suggestions[" + i + "]"];
if (suggestion != "")
{
datetime = Convert.ToDateTime(Request.Form["Suggestions[" + i + "]"]);
date = new DatesSuggestion()
{
Value = datetime,
};
model.Suggestions.Add(date);
}
}
model.CommitteeID = int.Parse(CommitteeID);
model.FinalDate = false;
model.OpenDate = DateTime.Today;
_context.Meetings.Add(model);
await _context.SaveChangesAsync();
Committee committee = await _context.Committees.SingleAsync(i => i.CommitteeID == model.CommitteeID);
return(RedirectToAction("ViewCommittee", new { id = committee.CommitteeID }));
}
return(View(model));
}
public async Task <IActionResult> PutMeetings(long id, [FromBody] Meetings meetings)
{
if (id != meetings.Id)
{
return(BadRequest());
}
_context.Entry(meetings).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public IActionResult Update([FromBody] Meetings model)
{
// map model to entity and set id
var meetings = _mapper.Map <Meetings>(model);
int status = 0;
try
{
if (model.Id == 0)
{
// update user
status = _meetingService.Add(meetings);
}
else
{
// update user
status = _meetingService.Update(meetings);
}
return(Ok(status));
}
catch (Exception ex)
{
// return error message if there was an exception
return(BadRequest(new { message = ex.Message }));
}
}
public List <Meeting> FindLastMeeting(Contact a, Contact b)
{
var meetings = Meetings.Where(m => m.Attendees.Contains(a) && m.Attendees.Contains(b) && m.StartTime < DateTime.Now).ToList();
var time = Meetings.Select(m => m.StartTime).Max();
return(meetings.Where(m => m.StartTime == time).ToList());
}
/// <summary>
/// Refresh today's meetings
/// </summary>
private void RefreshMeetings()
{
#if DEBUG
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
#endif
// Execute the action on the main application thread
if (System.Windows.Application.Current != null)
{
System.Windows.Application.Current.Dispatcher.Invoke(new Action(() =>
{
var selected = SelectedMeeting;
Meetings.Clear();
foreach (var client in m_meetingsBL.GetTodaysMeetings().OrderByDescending(m => m.MeetingDate))
{
Meetings.Add(client);
}
if (selected != null)
{
SelectedMeeting = Meetings.FirstOrDefault(c => c.ClientId == selected.ClientId);
}
}));
}
#if DEBUG
sw.Stop();
System.Diagnostics.Debug.WriteLine("Refresh meetings List Time: " + sw.ElapsedMilliseconds + "ms");
#endif
}
public async Task LoadAsync()
{
var lookup = await _friendLookupService.GetFrienLookupAsync();
Friends.Clear();
foreach (var item in lookup)
{
Friends.Add(new NavigationItemViewModel(
item.Id,
item.DisplayMember,
nameof(FriendDetailViewModel),
_eventAggregator));
}
lookup = await _meetingLookupService.GetMeetingLookupAsync();
Meetings.Clear();
foreach (var item in lookup)
{
Meetings.Add(new NavigationItemViewModel(
item.Id,
item.DisplayMember,
nameof(MeetingDetailViewModel),
_eventAggregator));
}
}
public int Add(Meetings meeting)
{
if (meeting == null)
{
throw new AppException("Meeting not found");
}
// update user properties if provided
if (string.IsNullOrWhiteSpace(meeting.Subject))
{
throw new AppException("Please fill subject");
}
if (string.IsNullOrWhiteSpace(meeting.Agenda))
{
throw new AppException("Please fill agenda");
}
if (string.IsNullOrWhiteSpace(meeting.MeetingTime))
{
throw new AppException("Please fill meeting date time");
}
_context.Meetings.Update(meeting);
return(_context.SaveChanges());
}
public int Update(Meetings meeting)
{
var databaseMeeting = _context.Meetings.Find(meeting.Id);
if (databaseMeeting == null)
{
throw new AppException("Meeting not found");
}
// update user properties if provided
if (!string.IsNullOrWhiteSpace(meeting.Subject))
{
databaseMeeting.Subject = meeting.Subject;
}
if (!string.IsNullOrWhiteSpace(meeting.Agenda))
{
databaseMeeting.Agenda = meeting.Agenda;
}
if (!string.IsNullOrWhiteSpace(meeting.MeetingTime))
{
databaseMeeting.MeetingTime = meeting.MeetingTime;
}
_context.Meetings.Update(databaseMeeting);
return(_context.SaveChanges());
}
internal bool AddMeeting(Meetings model)
{
bool result = false;
try
{
string query = "INSERT INTO meetings (deptid, addedby, title, date, time, place, description) VALUES(@deptid, @addedby, @title, @date, @time, @place, @description)";
SqlCommand cmd = new SqlCommand(query, Conn);
cmd.Parameters.Add(new SqlParameter("deptid", model.DeptID));
cmd.Parameters.Add(new SqlParameter("addedby", model.AddedBy));
cmd.Parameters.Add(new SqlParameter("title", model.Title));
cmd.Parameters.Add(new SqlParameter("date", model.DateOfMeeting));
cmd.Parameters.Add(new SqlParameter("time", model.TimeOfMeeting));
cmd.Parameters.Add(new SqlParameter("place", model.Place));
cmd.Parameters.Add(new SqlParameter("description", model.Description));
Conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
result = true;
}
}
catch (Exception exp)
{
}
finally
{
Conn.Close();
}
return(result);
}
public static void Map(this Meetings dbMeeting, Meetings meeting)
{
dbMeeting.Subject = meeting.Subject;
dbMeeting.Agenda = meeting.Agenda;
dbMeeting.DateOfMeeting = meeting.DateOfMeeting;
dbMeeting.Attendees = meeting.Attendees;
}
public virtual List <Company.Structures.ResponsibilitiesReport.ResponsibilitiesReportTableLine> GetResponsibilitiesReportData(IEmployee employee)
{
// HACK: Получаем отображаемое имя модуля.
var moduleGuid = new MeetingsModule().Id;
var moduleName = Sungero.Metadata.Services.MetadataSearcher.FindModuleMetadata(moduleGuid).GetDisplayName();
var modulePriority = Company.PublicConstants.ResponsibilitiesReport.MeetingsPriority;
var result = new List <Company.Structures.ResponsibilitiesReport.ResponsibilitiesReportTableLine>();
if (!Meetings.AccessRights.CanRead())
{
return(result);
}
var emplIsPresident = Meetings.GetAll(x => Equals(x.President, employee))
.Where(d => d.Status == Sungero.CoreEntities.DatabookEntry.Status.Active)
.Where(d => d.DateTime >= Calendar.Now);
result = Company.PublicFunctions.Module.AppendResponsibilitiesReportResult(result, emplIsPresident, moduleName, modulePriority,
Resources.MeetingsPresident, null);
var emplIsSecretary = Meetings.GetAll(x => Equals(x.Secretary, employee))
.Where(d => d.Status == Sungero.CoreEntities.DatabookEntry.Status.Active)
.Where(d => d.DateTime >= Calendar.Now);
result = Company.PublicFunctions.Module.AppendResponsibilitiesReportResult(result, emplIsSecretary, moduleName, modulePriority,
Resources.MeetingsSecretary, null);
return(result);
}
public async Task <IActionResult> Edit(int id, [Bind("ID,MeetingDate,Presiding,Conducting,IntermediateSong,IntermediateMusicalNumber,Speaker1,Speaker2,Speaker3,Speaker4,Speaker5,Speaker6,Speaker7,OpeningHymn,SacramentHymn,ClosingHymn,OpeningPrayer,ClosingPrayer")] Meetings meetings)
{
if (id != meetings.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(meetings);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingsExists(meetings.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(meetings));
}
public async Task LoadAsync()
{
Friends.Clear();
var lookup = await _friendLookupDataService.GetFriendLookupAsync();
foreach (var friend in lookup)
{
Friends.Add(new NavigationItemViewModel(friend.Id, friend.DisplayMember,
nameof(FriendDetailViewModel),
_eventAggregator));
}
Meetings.Clear();
lookup = await _meetingLookUpService.GetMeetingLookupAsync();
foreach (var meeting in lookup)
{
Meetings.Add(new NavigationItemViewModel(meeting.Id, meeting.DisplayMember,
nameof(MeetingDetailViewModel),
_eventAggregator));
}
}
public async Task <IActionResult> Edit(int id, [Bind("id,subject,date,UserId,AVirtual,ClientId")] Meetings meetings)
{
if (id != meetings.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(meetings);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingsExists(meetings.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientId"] = new SelectList(_context.Cliente, "id", "id", meetings.ClientId);
ViewData["UserId"] = new SelectList(_context.User, "id", "id", meetings.UserId);
return(View(meetings));
}
public async Task <ActionResult <Meetings> > PostMeetings(Meetings meetings)
{
_context.Meetings.Add(meetings);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMeetings", new { id = meetings.Id }, meetings));
}
private void Submit(object sender, RoutedEventArgs e)
{
if (IsValid() == false)
{
MessageBox.Show("Вы не заполнили все поля");
return;
}
if (_isEdit)
{
_meeting.Doctors = DoctorsCB.SelectedItem as Doctors;
_meeting.Patients = PatientsCB.SelectedItem as Patients;
_meeting.Meeting_Date = DateDP.SelectedDate;
App.Entities.SaveChanges();
App.UpdateDB();
this.Close();
}
else
{
var meeting = new Meetings();
meeting.Doctors = DoctorsCB.SelectedItem as Doctors;
meeting.Patients = PatientsCB.SelectedItem as Patients;
meeting.Meeting_Date = DateDP.SelectedDate;
App.Entities.Meetings.Add(meeting);
App.Entities.SaveChanges();
App.UpdateDB();
this.Close();
}
}
public async Task <IActionResult> Edit(int id, [Bind("MeetingId,MeetingDate,Speaker")] Meetings meetings)
{
if (id != meetings.MeetingId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(meetings);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingsExists(meetings.MeetingId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(meetings));
}
public MeetingsExtended(Meetings meeting)
{
Id = meeting.Id;
Subject = meeting.Subject;
Agenda = meeting.Agenda;
Attendees = meeting.Attendees;
DateOfMeeting = meeting.DateOfMeeting;
}
public void deleteMeetings(Meetings m)
{
using (PrioritizerUnitOfWork uow = UnitOfWork)
{
uow.Context.Meetings.DeleteObject(m);
uow.Commit();
}
}
public Meeting AddMeeting(string name, string description, List <User> members)
{
Meeting meeting = new Meeting(name, description, members, this);
Meetings.Add(meeting);
return(meeting);
}
//添加会议
public int AddMeeting(Meetings meeting)
{
using (Model1Container ef = new Model1Container())
{
ef.Meetings.AddObject(meeting);
return(ef.SaveChanges());
}
}
public void UpdateLink(Meetings m, Guid id)
{
var meeting = meetingsrepository.GetById(id);
meeting.Url = m.Url;
meetingsrepository.Update(meeting);
}
public Meeting AddMeeting(Meeting meeting)
{
meeting.Group = this;
Meetings.Add(meeting);
return(meeting);
}
public ActionResult DeleteConfirmed(int id)
{
Meetings meetings = db.Meetings.Find(id);
db.Meetings.Remove(meetings);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <MeetingModel> CreateMeeting(Meetings meetingEntity)
{
await _appDBContext.Meetings.AddAsync(meetingEntity);
var result = await _appDBContext.SaveChangesAsync();
return(await GetMeetingById(meetingEntity.MeetingId));
}
public static IMeeting GetContextMeeting()
{
if (CallContext.CalledFrom(Meetings.Info))
{
var meetingId = CallContext.GetCallerEntityId(Meetings.Info);
return(Meetings.GetAll(m => Equals(m.Id, meetingId)).SingleOrDefault());
}
return(null);
}
//删除会议
public void DeleteMeeting(string MeetingMId)
{
using (Model1Container ef = new Model1Container())
{
Meetings meeting = ef.Meetings.Where(item => item.m_id == MeetingMId).FirstOrDefault();
ef.DeleteObject(meeting);
ef.SaveChanges();
}
}
//更改会议
public int UpdateMeeting(Meetings meeting)
{
using (Model1Container ef = new Model1Container())
{
ef.Meetings.Attach(meeting);
ef.ObjectStateManager.ChangeObjectState(meeting, EntityState.Modified);
return(ef.SaveChanges());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
MeetingsBLL meetingbll = new MeetingsBLL();
string Opera = Request.QueryString["Opera"];
if (CheckValue())
{
if (Opera == "Edit")
{
string MId = Request.QueryString["MId"];
Meetings meeting = meetingbll.GetMeetingInfo(MId);
meeting.m_id = txtrank.Text;
meeting.m_name = txtTitle.Text;
meeting.pre_num = int.Parse(txtpnum.Text);
meeting.max_num = int.Parse(txtmnum.Text);
meeting.theme = txttheme.Text;
meeting.begin_date = DateTime.Parse(txtbd.Text);
meeting.end_date = DateTime.Parse(txted.Text);
meeting.m_city = txtcity.Text;
meeting.m_address = txtaddress.Text;
meeting.h_name = txthotel.Text;
if (meetingbll.UpdateMeeting(meeting) > 0)
{
Response.Write("<script>alert('修改成功!')</script>");
}
else
{
Response.Write("<script>alert('修改失败！')</script>");
}
}
else
{
Meetings meeting = new Meetings();
meeting.m_id = txtrank.Text;
meeting.m_name = txtTitle.Text;
meeting.pre_num = int.Parse(txtpnum.Text);
meeting.max_num = int.Parse(txtmnum.Text);
meeting.theme = txttheme.Text;
meeting.begin_date = DateTime.Parse(txtbd.Text);
meeting.end_date = DateTime.Parse(txted.Text);
meeting.m_city = txtcity.Text;
meeting.m_address = txtaddress.Text;
meeting.h_name = txthotel.Text;
if (meetingbll.AddMeeting(meeting) > 0)
{
Response.Write("<script>alert('增加成功!')</script>");
}
else
{
Response.Write("<script>alert('增加失败！')</script>");
}
}
}
}
public static bool Update(Meetings item)
{
var Item = db.Meetings.Find(item.ID);
Item.MeetingSubject = item.MeetingSubject;
Item.RoomID = item.RoomID;
Item.StartingTime = item.StartingTime;
Item.EndTime = item.EndTime;
return(db.SaveChanges() > 0 ? true : false);
}
