public IActionResult PutMeeting([FromRoute] int id, [FromBody] MeetingVM meetingVM)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != meetingVM.MeetCode)
{
return(BadRequest());
}
try
{
this.meetingService.Update(this.mapper, meetingVM);
}
catch (DbUpdateConcurrencyException)
{
if (!MeetingExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
//to update the data from edit Meeting Form
public bool UpdateMeetingDetails(int id, MeetingVM meeting)
{
try
{
bool status = false;
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
var meetingEntity = dc.Meetings.FirstOrDefault(a => a.MeetingId == id);
if (meetingEntity == null)
{
return(status);
}
else
{
#region//updating schedule for specific record
var scheduleEntity = dc.Schedules.FirstOrDefault(a => a.ScheduleId == meetingEntity.ScheduleId);
scheduleEntity.StartTime = meeting.StartTime;
scheduleEntity.EndTime = meeting.EndTime;
scheduleEntity.RoomId = meeting.RoomId;
dc.SaveChanges();
#endregion
#region//updating meeting for specific record
meetingEntity.MeetingName = meeting.MeetingName;
meetingEntity.Agenda = meeting.Agenda;
//for updating meeting schedule Id is not require cause it is already present in database
//for updating meeting User Id is not require cause it is already present in database.()
meetingEntity.UpdatedAt = DateTime.Now;
dc.SaveChanges();
#endregion
#region//updating meeting attendance for specific record
var meetingAttendeeIdObject = dc.MeetingsAttendees.Where(a => a.MeetingId == id).ToList();
foreach (var item in meetingAttendeeIdObject)
{
dc.MeetingsAttendees.Remove(item);
dc.SaveChanges();
}
foreach (int userid in meeting.MeetingAttendeeId)
{
MeetingsAttendee attendee = new MeetingsAttendee();
attendee.MeetingId = id;
attendee.UserId = userid;
dc.MeetingsAttendees.Add(attendee);
dc.SaveChanges();
}
#endregion
status = true;
}
}
return(status);
}
catch (Exception)
{
return(false);
}
}
public void Update(IMapper mapper, MeetingVM meetingVM)
{
var meeting = mapper.Map <Meeting>(meetingVM);
meeting.State = this.context.States.Find(meetingVM.StateCode);
meeting.Venue = this.context.Venues.Find(meetingVM.VenueCode);
this.context.Entry(meeting).State = EntityState.Modified;
this.context.SaveChangesAsync();
}
public async Task Add(IMapper mapper, MeetingVM meetingVM)
{
var meeting = mapper.Map <Meeting>(meetingVM);
meeting.State = this.context.States.Find(meetingVM.StateCode);
meeting.Venue = this.context.Venues.Find(meetingVM.VenueCode);
this.context.Meetings.Add(meeting);
await this.context.SaveChangesAsync();
}
public async Task <IActionResult> PostMeeting([FromBody] MeetingVM meetingVM)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
await this.meetingService.Add(this.mapper, meetingVM);
return(CreatedAtAction("GetMeeting", new { id = meetingVM.MeetCode }, meetingVM));
}
//to insert the data from create Meeting form
public bool InsertMeetingDetails(MeetingVM meeting)
{
try
{
bool status = false;
using (TrainingAppEntities1 dc = new TrainingAppEntities1())
{
#region//Creating new schedule record
Schedule schedule = new Schedule();
schedule.StartTime = meeting.StartTime;
schedule.EndTime = meeting.EndTime;
schedule.RoomId = meeting.RoomId;
var obj = dc.Schedules.Add(schedule);
dc.SaveChanges();
#endregion
#region//Creating new meeting record
Meeting meetin = new Meeting();
meetin.MeetingName = meeting.MeetingName;
meetin.Agenda = meeting.Agenda;
meetin.ScheduleId = obj.ScheduleId;
meetin.UserId = meetin.UserId;
meetin.CreatedAt = meetin.CreatedAt;
meetin.UpdatedAt = meetin.UpdatedAt;
var obj1 = dc.Meetings.Add(meetin);
dc.SaveChanges();
#endregion
#region//inserting attendeesId's(user's) into meetingattendee's table
foreach (int userid in meeting.MeetingAttendeeId)
{
MeetingsAttendee attendee = new MeetingsAttendee();
attendee.MeetingId = obj1.MeetingId;
attendee.UserId = userid;
dc.MeetingsAttendees.Add(attendee);
dc.SaveChanges();
}
#endregion
status = true;
}
return(status);
}
catch (Exception)
{
return(false);
}
}
public MeetingVM Add(MeetingVM meetingVM)
{
var meeting = new Meeting()
{
MeetingAgenda = meetingVM.MeetingAgenda,
Subject = meetingVM.Subject,
MeetingDateTime = meetingVM.MeetingDateTime,
Attendees = meetingVM.Attendees.Select(a => new MeetingAttendee()
{
AttendeeID = a.ID
}).ToList()
};
_meetingRepo.Create(meeting);
meetingVM.ID = meeting.ID;
return(meetingVM);
}
public HttpResponseMessage Put(int id, MeetingVM meeting)
{
try
{
bool status = meetingInfo.UpdateMeetingDetails(id, meeting);
if (status)
{
return(Request.CreateResponse(HttpStatusCode.OK, "The meeting is updated successfully"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Meeting's ID = " + id.ToString() + " not found to update"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public HttpResponseMessage Post(MeetingVM meeting)
{
try
{
int userId = int.Parse((GetClaims.GetClaimsType(ActionContext.Request.Headers.Authorization.Parameter)).FindFirst(ClaimTypes.NameIdentifier).Value);
meeting.UserId = userId;
bool status = meetingInfo.InsertMeetingDetails(meeting);
if (status)
{
var message = Request.CreateResponse(HttpStatusCode.Created, "New meeting is created successfully");
return(message);
}
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "cannot insert meeting details(check the data)"));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult Update(MeetingVM Meeting)
{
var newid = Int32.Parse(Meeting.MeetingID);
using (MeetingOrganizerEntities db = new MeetingOrganizerEntities())
{
var model = db.Meeting.FirstOrDefault(x => x.MeetingID == newid);
model.MeetingSubject = Meeting.MeetingSubject;
model.StartingTime = TimeSpan.Parse(Meeting.StartingTime);
model.EndingTime = TimeSpan.Parse(Meeting.StartingTime);
model.Date = Convert.ToDateTime(Meeting.Date);
model.Participants = Meeting.Participants;
db.SaveChanges();
return(Redirect("/Home/Index"));
}
}
public MeetingVM Update(MeetingVM meetingVM)
{
var meeting = _meetingRepo.GetAll().FirstOrDefault(m => m.ID == meetingVM.ID);
if (meeting != null)
{
var attendees = _meetAttendeeRepo.GetAll().Where(ma => ma.MeetingID == meeting.ID).ToList();
if (attendees != null && attendees.Count > 0)
{
foreach (var attendee in attendees)
{
_meetAttendeeRepo.Delete(attendee.ID);
}
}
meeting.Subject = meetingVM.Subject;
meeting.MeetingAgenda = meetingVM.MeetingAgenda;
meeting.MeetingDateTime = meetingVM.MeetingDateTime;
meeting.Attendees = null;
_meetingRepo.Update(meeting);
if (meetingVM.Attendees != null && meetingVM.Attendees.Count > 0)
{
foreach (var attendeeVM in meetingVM.Attendees)
{
var attendee = new MeetingAttendee()
{
AttendeeID = attendeeVM.ID,
MeetingID = meeting.ID
};
_meetAttendeeRepo.Create(attendee);
}
}
return(meetingVM);
}
return(null);
}
public ActionResult NewMeeting(MeetingVM model)
{
if (ModelState.IsValid)
{
Meeting m = new Meeting();
m.MeetingSubject = model.MeetingSubject;
m.Date = Convert.ToDateTime(model.Date);
m.StartingTime = TimeSpan.Parse(model.StartingTime);
m.EndingTime = TimeSpan.Parse(model.EndingTime);
m.Participants = model.Participants;
using (MeetingOrganizerEntities db = new MeetingOrganizerEntities())
{
db.Meeting.Add(m);
db.SaveChanges();
}
}
return(Redirect("/Home/Index"));
}
public async Task <IActionResult> CreateBoardMeeting(MeetingVM VM)
{
int IsAttchInserted = -1;
string strMessage = "incorrect inputs provided.";
SAPEntity.Instance.InitializeCompany();
if (SAPEntity.Company.Connected)
{
ActivitiesService oActSrv = (ActivitiesService)SAPEntity.Company.GetCompanyService().GetBusinessService(ServiceTypes.ActivitiesService);
Activity oAct = (Activity)oActSrv.GetDataInterface(ActivitiesServiceDataInterfaces.asActivity);
ActivityParams oParams;
oAct.CardCode = VM.cardcode;
oAct.Activity = BoActivities.cn_Task;
oAct.ActivityType = 2;
if (VM.cntctcode > 0)
{
oAct.ContactPersonCode = VM.cntctcode;
}
DateTime StartDate = DateTime.ParseExact(VM.str_startdate, "dd/MM/yyyy", null);
DateTime CloseDate = DateTime.ParseExact(VM.str_enddate, "dd/MM/yyyy", null);
oAct.ActivityDate = StartDate;
oAct.Duration = (CloseDate - StartDate).TotalDays;
oAct.DurationType = BoDurations.du_Days;
if (!String.IsNullOrEmpty(VM.time))
{
oAct.UserFields.Item("U_Time").Value = VM.time;
}
if (VM.assignesto.HasValue && VM.assignesto.Value > 0)
{
oAct.HandledBy = VM.assignesto.Value;
}
oAct.Notes = VM.notes;
oAct.Details = VM.details;
if (VM.files != null && VM.files.Count() > 0)
{
SAPbobsCOM.Attachments2 SAPAttachment = (SAPbobsCOM.Attachments2)SAPEntity.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oAttachments2);
foreach (var FL in VM.files)
{
if (!string.IsNullOrEmpty(FL))
{
SAPAttachment.Lines.SetCurrentLine((SAPAttachment.Lines.Count) - 1);
string FileName = System.IO.Path.GetFileName(FL);
string FileExt = System.IO.Path.GetExtension(FileName);
FileExt = FileExt.Replace('.', ' ').Trim();
SAPAttachment.Lines.SourcePath = @"H:\Upload";
SAPAttachment.Lines.FileName = FileName;
SAPAttachment.Lines.FileExtension = Path.GetExtension(FileExt);
SAPAttachment.Lines.Add();
}
}
if (VM.files.Count() > 0)
{
IsAttchInserted = SAPAttachment.Add();
if (IsAttchInserted == 0)
{
string ObjCode;
SAPEntity.Company.GetNewObjectCode(out ObjCode);
oAct.AttachmentEntry = Convert.ToInt32(ObjCode);
}
else
{
strMessage = SAPEntity.Company.GetLastErrorDescription();
}
}
}
oParams = oActSrv.AddActivity(oAct);
long singleActCode = oParams.ActivityCode;
if (singleActCode > 0)
{
return(StatusCode(201));
}
}
return(BadRequest("incorrect inputs provided."));
}
