public ActionResult ViewScheduleMeeting(int MeetingId)
{
ScheduleMeetingModel model = noticeBoardHelper.GetScheduleMeetingDetail(MeetingId, true);
model.StrataOwners = noticeBoardHelper.GetAllStrataOwners();
return(PartialView("ViewScheduleMeeting", model));
}
public ActionResult EditScheduleMeeting(ScheduleMeetingModel model)
{
int result = 0;
string strMsg = "";
if (ModelState.IsValid)
{
if (!string.IsNullOrEmpty(model.SelectedMeetingInvite) || !string.IsNullOrEmpty(model.ScheduleMeetingInviteIds))
{
result = noticeBoardHelper.AddUpdateScheduleMeeting(model);
if (result == -1)
{
strMsg = "Schedule Meeting already exists with the same name";
}
else if (result == 1)
{
strMsg = "Schedule Meeting updated successfully.";
}
else
{
strMsg = "Schedule Meeting updation failed.";
}
}
else
{
strMsg = "Please select atleast one owner for invite.";
}
}
return(Json(new { result = result, Msg = strMsg }));
}
public ActionResult AddScheduleMeeting()
{
ScheduleMeetingModel model = new ScheduleMeetingModel();
model.StrataOwners = noticeBoardHelper.GetAllStrataOwners();
return(PartialView("AddScheduleMeeting", model));
}
public ActionResult ViewScheduleMeeting(int MeetingId)
{
ScheduleMeetingModel scheduleMeetingModel = new ScheduleMeetingModel();
if (ClientSessionData.UserClientId != 0)
{
scheduleMeetingModel = noticeBoardHelper.GetScheduleMeetingDetail(MeetingId, true);
}
return(PartialView("ViewScheduleMeeting", scheduleMeetingModel));
}
public List <ScheduleMeetingModel> GetAllScheduleMeeting(int BlockNumber, int BlockSize)
{
if (ClientSessionData.UserClientId != 0)
{
int startIndex = (BlockNumber - 1) * BlockSize;
List <ScheduleMeetingModel> scheduleMeetingModelList = new List <ScheduleMeetingModel>();
try
{
var ScheduleMeetings = _context.tblScheduleMeetings.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId && x.Status == 1).OrderByDescending(x => x.CreatedOn).ToList();
foreach (var item in ScheduleMeetings)
{
int i = 0;
ScheduleMeetingModel scheduleMeetingModel = new ScheduleMeetingModel();
scheduleMeetingModel.MeetingId = item.MeetingId;
scheduleMeetingModel.Subject = item.Subject;
scheduleMeetingModel.Message = item.Message;
scheduleMeetingModel.MeetingTime = item.MeetingDate.Value.ToString("hh:mm tt");
scheduleMeetingModel.MeetingDate = item.MeetingDate != null?item.MeetingDate.Value.ToString("dd MMM, yyyy") + ", " + scheduleMeetingModel.MeetingTime : "";
scheduleMeetingModel.CreatedOn = item.CreatedOn != null?item.CreatedOn.Value.ToString("dd MMM, yyyy") : "N/A";
if (i == 0)
{
scheduleMeetingModel.StrataOwners = this.GetAllStrataOwners();
}
scheduleMeetingModelList.Add(scheduleMeetingModel);
i++;
}
}
catch
{
}
scheduleMeetingModelList = scheduleMeetingModelList.Skip(startIndex).Take(BlockSize).ToList();
return(scheduleMeetingModelList);
}
else
{
return(null);
}
}
public int AddUpdateScheduleMeeting(ScheduleMeetingModel scheduleMeetingModel)
{
int result = 0;
try
{
tblScheduleMeeting tblScheduleMeetingDb = new tblScheduleMeeting();
tblScheduleMeetingDb.Subject = scheduleMeetingModel.Subject;
tblScheduleMeetingDb.Message = scheduleMeetingModel.Message;
tblScheduleMeetingDb.Status = 1;
tblScheduleMeetingDb.MeetingDate = Convert.ToDateTime(scheduleMeetingModel.MeetingDate);
if (scheduleMeetingModel.StartTimeAmPm == "PM")
{
if (scheduleMeetingModel.StartTimeHour != 12)
{
scheduleMeetingModel.StartTimeHour = Convert.ToInt32(scheduleMeetingModel.StartTimeHour) + 12;
}
}
else if (scheduleMeetingModel.StartTimeAmPm == "AM")
{
if (scheduleMeetingModel.StartTimeHour == 12)
{
scheduleMeetingModel.StartTimeHour = 0;
}
}
tblScheduleMeetingDb.MeetingDate = tblScheduleMeetingDb.MeetingDate.Value.AddHours(Convert.ToInt32(scheduleMeetingModel.StartTimeHour)).AddMinutes(Convert.ToInt32(scheduleMeetingModel.StartTimeMinute));
tblScheduleMeetingDb.CreatedBy = ClientSessionData.UserClientId;
tblScheduleMeetingDb.CreatedOn = DateTime.UtcNow;
tblScheduleMeetingDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress;
tblScheduleMeetingDb.ModifiedBy = ClientSessionData.UserClientId;
tblScheduleMeetingDb.ModifiedOn = DateTime.UtcNow;
tblScheduleMeetingDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
tblScheduleMeetingDb.StratasBoardId = ClientSessionData.ClientStrataBoardId;
if (scheduleMeetingModel.MeetingId > 0)
{
tblScheduleMeetingDb.MeetingId = scheduleMeetingModel.MeetingId;
_context.tblScheduleMeetings.Attach(tblScheduleMeetingDb);
_context.Entry(tblScheduleMeetingDb).Property(x => x.Subject).IsModified = true;
_context.Entry(tblScheduleMeetingDb).Property(x => x.Message).IsModified = true;
_context.Entry(tblScheduleMeetingDb).Property(x => x.MeetingDate).IsModified = true;
_context.Entry(tblScheduleMeetingDb).Property(x => x.ModifiedBy).IsModified = true;
_context.Entry(tblScheduleMeetingDb).Property(x => x.ModifiedOn).IsModified = true;
_context.Entry(tblScheduleMeetingDb).Property(x => x.ModifiedFromIP).IsModified = true;
result = _context.SaveChanges();
}
else
{
_context.tblScheduleMeetings.Add(tblScheduleMeetingDb);
result = _context.SaveChanges();
}
int MeetingId = Convert.ToInt32(tblScheduleMeetingDb.MeetingId);
if (MeetingId > 0)
{
if (!string.IsNullOrEmpty(scheduleMeetingModel.SelectedMeetingInvite))
{
if (scheduleMeetingModel.SelectedMeetingInvite != scheduleMeetingModel.ScheduleMeetingInviteIds)
{
int[] selectedMeetingInviteArray = scheduleMeetingModel.SelectedMeetingInvite.Split(",".ToCharArray()).Select(x => int.Parse(x.ToString())).ToArray();
_context.tblScheduleMeetingInvites.RemoveRange(_context.tblScheduleMeetingInvites.Where(x => x.MeetingId == MeetingId));
foreach (var item in selectedMeetingInviteArray)
{
tblScheduleMeetingInvite tblScheduleMeetingInviteDb = new tblScheduleMeetingInvite();
tblScheduleMeetingInviteDb.MeetingId = MeetingId;
tblScheduleMeetingInviteDb.UserClientId = item;
tblScheduleMeetingInviteDb.Status = 1;
_context.tblScheduleMeetingInvites.Add(tblScheduleMeetingInviteDb);
result = _context.SaveChanges();
if (result == 1)
{
string MeetingTime = tblScheduleMeetingDb.MeetingDate.Value.ToString("hh:mm tt");
scheduleMeetingModel.MeetingDate = tblScheduleMeetingDb.MeetingDate != null?tblScheduleMeetingDb.MeetingDate.Value.ToString("dd MMM yyyy") + ", " + MeetingTime : "";
EmailSender.FncSendScheduleMeetingInvite_ToStrataOwner(item, scheduleMeetingModel.MeetingDate, scheduleMeetingModel.Subject, scheduleMeetingModel.Message, ClientSessionData.ClientStrataBoardId);
}
}
}
}
}
}
catch
{
}
return(result);
}
public ScheduleMeetingModel GetScheduleMeetingDetail(int MeetingId, bool IsView)
{
if (ClientSessionData.UserClientId != 0)
{
try
{
var ScheduleMeetings = _context.tblScheduleMeetings.Where(x => x.Status == 1 && x.MeetingId == MeetingId).FirstOrDefault();
ScheduleMeetingModel scheduleMeetingModel = new ScheduleMeetingModel();
scheduleMeetingModel.MeetingId = ScheduleMeetings.MeetingId;
scheduleMeetingModel.Subject = ScheduleMeetings.Subject;
scheduleMeetingModel.Message = ScheduleMeetings.Message;
scheduleMeetingModel.StartTimeHour = ScheduleMeetings.MeetingDate.Value.Hour;
scheduleMeetingModel.CreatedOn = ScheduleMeetings.CreatedOn != null?ScheduleMeetings.CreatedOn.Value.ToString("dd MMM, yyyy") : "N/A";
if (scheduleMeetingModel.StartTimeHour == 0)
{
scheduleMeetingModel.StartTimeHour = 12;
scheduleMeetingModel.StartTimeAmPm = "AM";
}
else if (scheduleMeetingModel.StartTimeHour >= 12) //// For PM
{
if (scheduleMeetingModel.StartTimeHour > 12)
{
scheduleMeetingModel.StartTimeHour = scheduleMeetingModel.StartTimeHour - 12;
}
scheduleMeetingModel.StartTimeAmPm = "PM";
}
else //// For AM
{
scheduleMeetingModel.StartTimeAmPm = "AM";
}
scheduleMeetingModel.StartTimeMinute = Convert.ToInt32(ScheduleMeetings.MeetingDate.Value.Minute.ToString().PadLeft(2, '0'));
if (IsView)
{
string MeetingTime = ScheduleMeetings.MeetingDate.Value.ToString("hh:mm tt");
scheduleMeetingModel.MeetingDate = ScheduleMeetings.MeetingDate != null?ScheduleMeetings.MeetingDate.Value.ToString("dd MMM, yyyy") + ", " + MeetingTime : "";
}
else
{
scheduleMeetingModel.MeetingDate = ScheduleMeetings.MeetingDate != null?ScheduleMeetings.MeetingDate.Value.ToString("dd MMM yyyy") : "";
}
var ScheduleMeetinginvites = _context.tblScheduleMeetingInvites.Where(x => x.MeetingId == MeetingId && x.Status == 1).ToList();
if (ScheduleMeetinginvites != null && ScheduleMeetinginvites.Count > 0)
{
for (int i = 0; i < ScheduleMeetinginvites.Count; i++)
{
scheduleMeetingModel.ScheduleMeetingInviteIds += Convert.ToString(ScheduleMeetinginvites[i].UserClientId) + ",";
}
scheduleMeetingModel.ScheduleMeetingInviteIds = scheduleMeetingModel.ScheduleMeetingInviteIds.Remove(scheduleMeetingModel.ScheduleMeetingInviteIds.LastIndexOf(","));
}
return(scheduleMeetingModel);
}
catch
{
return(null);
}
}
else
{
return(null);
}
}