public ActionResult Delete(int CalendarID)
{
ViewBag.CalendarID = CalendarID;
calendar calendar = CalendarRepository.GetCalendarByID(CalendarID);
return(PartialView(calendar));
}
public ActionResult Create(meeting meeting, string CallerType = "")
{
meeting mtg = db.meetings.FirstOrDefault(e => e.meetingID == meeting.meetingID && e.Title == meeting.Title);
if (mtg != null)
{
TempData["Message2"] = "Meeting already exist";
return(PartialView(meeting));
}
try
{
//if (budget.Comment == null) { budget.Comment = ""; }
constant cont = ConstantRepository.GetConstantListByCategory("Ministry Activity").FirstOrDefault(e => e.ConstantName == "Ministry Meeting");
//set meeting on calendar
calendar cal = new calendar();
cal.ministryID = meeting.ministryID;
cal.EventType = cont.constantID;
cal.CalendarDate = meeting.meetingDate;
cal.StartTime = meeting.StartTime;
cal.EndTime = meeting.EndTime;
cal.Location = meeting.meetingVenue;
cal.Title = meeting.Title;
cal.Conductor = meeting.Conductor;
cal.PublicAccess = false;
cal.Description = "";
cal.EnteredBy = User.Identity.Name.ToString();
cal.DateEntered = System.DateTime.Today;
cal.Status = "Active";
db.calendars.Add(cal);
db.SaveChanges();
CalendarRepository.AddRecord(cal);
meeting.CalendarID = cal.calendarID;
if (ModelState.IsValid)
{
db.meetings.Add(meeting);
db.SaveChanges();
MeetingRepository.AddRecord(meeting);
TempData["Message2"] = "Meeting created successfully.";
GetData(meeting.ministryID);
if (CallerType == "Ministry")
{
return(RedirectToAction("Create", new { MinistryID = meeting.ministryID, CallerType = "Ministry" }));
}
else
{
return(RedirectToAction("Create"));
}
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error adding meeting record";
}
GetData(meeting.ministryID);
return(PartialView(meeting));
}
public ActionResult bindCalender()
{
int uid = Convert.ToInt32(Session["UserID"].ToString());
int roleid = Convert.ToInt32(Session["UserTypeID"].ToString());
string calenderdata = "";
List <calendar> calendarList = new List <calendar>();
if (roleid == 4)
{
Student datset = entities.Students.Where(f => f.UserID == uid).FirstOrDefault();
List <Enrolment> enrolmentlist = entities.Enrolments.Where(f => f.StudentID == datset.StudentID).ToList();
for (int i = 0; i < enrolmentlist.Count; i++)
{
calendar calendar = new calendar();
calendar.BatchID = enrolmentlist[i].Lessonbatch.LessonBatchID;
calendar.UserName = datset.User.FirstName + " " + datset.User.LastName;
calendar.Day = enrolmentlist[i].Lessonbatch.BatchDate.Day.ToString();
calendar.Month = enrolmentlist[i].Lessonbatch.BatchDate.Month.ToString();
calendar.Year = enrolmentlist[i].Lessonbatch.BatchDate.Year.ToString();
calendar.StartTimeHour = enrolmentlist[i].Lessonbatch.StartTime.Hours.ToString();
calendar.StartTimeMin = enrolmentlist[i].Lessonbatch.StartTime.Minutes.ToString();
calendar.Event = enrolmentlist[i].Lessonbatch.Name.ToString();
calendarList.Add(calendar);
}
}
if (roleid == 3)
{
Tutor datset = entities.Tutors.Where(f => f.UserID == uid).FirstOrDefault();
List <Lessonbatch> lessonbatchlist = entities.Lessonbatches.Where(f => f.TutorID == datset.TutorID).ToList();
for (int i = 0; i < lessonbatchlist.Count; i++)
{
calendar calendar = new calendar();
calendar.BatchID = lessonbatchlist[i].LessonBatchID;
calendar.UserName = datset.User.FirstName + " " + datset.User.LastName;
calendar.Day = lessonbatchlist[i].BatchDate.Day.ToString();
calendar.Month = lessonbatchlist[i].BatchDate.Month.ToString();
calendar.Year = lessonbatchlist[i].BatchDate.Year.ToString();
calendar.StartTimeHour = lessonbatchlist[i].StartTime.Hours.ToString();
calendar.StartTimeMin = lessonbatchlist[i].StartTime.Minutes.ToString();
calendar.Event = lessonbatchlist[i].Name.ToString();
calendarList.Add(calendar);
}
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
calenderdata = serializer.Serialize(calendarList);
return(new JsonResult
{
Data = new
{
success = true,
data = calenderdata
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public MainWindow()
{
InitializeComponent();
vm = new MyViewModel(new Model.MyModel());
this.DataContext = vm;
calendar cal = new calendar(vm);
mainG.Children.Add(cal);
}
public ActionResult DisplayCalendar(int calendarID)
{
calendar cal = CalendarRepository.GetCalendarByID(calendarID);
cal.ministry = MinistryRepository.GetMinistryByID(cal.ministryID);
if (cal.DocumentID != null)
{
cal.document = DocumentRepository.GetDocumentByID((int)cal.DocumentID);
}
return(PartialView(cal));
}
protected void deleteCalendarExecute_Click(object sender, EventArgs e)
{
calendar dc = new calendar();
dc.overallID = "deleteCalender";
dc.calenderName = deleteCalendarName.SelectedItem.ToString();
dc.userName = Session["username"].ToString();
deleteCalendar delete = new deleteCalendar();
delete.dc(dc);
}
public String cc(calendar e)
{
encryption crypt = new encryption();
connection conn = new connection();
String jsonstring = JsonConvert.SerializeObject(e);
String output = crypt.EncryptDecrypt(jsonstring);
String reply = conn.connect(output);
return(reply);
}
public ActionResult Edit(int CalendarID, DateTime ReturnBeginDate, DateTime ReturnEndDate, string ReturnMethod = "", string ReturnSearchType = "", int ReturnCodeID = 0, string ReturnCodeName = "", string ReturnCallerType = "")
{
ViewBag.ReturnMethod = ReturnMethod;
ViewBag.ReturnBeginDate = ReturnBeginDate;
ViewBag.ReturnEndDate = ReturnEndDate;
ViewBag.ReturnSearchType = ReturnSearchType;
ViewBag.ReturnCodeID = ReturnCodeID;
ViewBag.ReturnCodeName = ReturnCodeName;
ViewBag.ReturnCallerType = ReturnCallerType;
calendar calendar = CalendarRepository.GetCalendarByID(CalendarID);
GetData(calendar.ministryID);
ViewBag.StartTime = calendar.StartTime;
ViewBag.EndTime = calendar.EndTime;
return(PartialView(calendar));
}
public ActionResult Create(programevent programevent)
{
int ministryID = GoalRepository.GetGoalByID(programevent.goalID).ministryID;
constant cont = ConstantRepository.GetConstantListByCategory("Ministry Activity").FirstOrDefault(e => e.ConstantName == "Program/Event");
try
{
//set meeting on calendar
calendar cal = new calendar();
cal.ministryID = ministryID;
cal.EventType = cont.constantID;
cal.CalendarDate = programevent.C_When;
cal.StartTime = programevent.BeginTime;
cal.EndTime = programevent.EndTime;
cal.Location = programevent.C_Where;
cal.Title = programevent.Title;
cal.Conductor = MemberRepository.GetMemberByID(programevent.C_Who).FullNameTitle;
cal.PublicAccess = true;
cal.Description = "";
cal.EnteredBy = User.Identity.Name.ToString();
cal.DateEntered = System.DateTime.Today;
cal.Status = "Active";
db.calendars.Add(cal);
db.SaveChanges();
CalendarRepository.AddRecord(cal);
programevent.CalendarID = cal.calendarID;
if (ModelState.IsValid)
{
db.programevents.Add(programevent);
db.SaveChanges();
ProgramEventRepository.AddRecord(programevent);
TempData["Message2"] = "Event added successfully.";
GetData(ministryID);
return(RedirectToAction("Create", new { GoalID = programevent.goalID }));
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error adding event";
}
GetData(ministryID);
return(PartialView(programevent));
}
public String dc(String userID)
{
calendar e = new calendar();
encryption crypt = new encryption();
connection conn = new connection();
e.overallID = "getCalender";
e.userName = userID;
String jsonstring = JsonConvert.SerializeObject(e);
String output = crypt.EncryptDecrypt(jsonstring);
String reply = conn.connect(output);
return(reply);
}
public ActionResult DeleteConfirmed(int MeetingID, DateTime ReturnBeginDate, DateTime ReturnEndDate, string ReturnSearchType = "", int ReturnCodeID = 0, string ReturnCode = "", string ReturnCallerType = "", string ReturnMethod = "")
{
try
{
meeting meeting = MeetingRepository.GetMeetingByID(MeetingID);
calendar cal = CalendarRepository.GetCalendarByID(meeting.CalendarID);
//delete meeting agendas
IEnumerable <meetingagenda> agenda = MeetingAgendaRepository.GetAgendaByMeeting(MeetingID);
if (agenda.Count() > 0)
{
foreach (var a in agenda)
{
MeetingAgendaRepository.DeleteRecord(a);
}
}
//delete meeting attendees
if (cal != null)
{
IEnumerable <attendance> attendance = AttendanceRepository.GetAttendanceByCalendar(cal.calendarID);
if (attendance.Count() > 0)
{
foreach (var a in attendance)
{
AttendanceRepository.DeleteRecord(a);
}
}
//delete meeting from calendar
CalendarRepository.DeleteRecord(cal);
}
MeetingRepository.DeleteRecord(meeting);
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error deleting meeting record.");
}
if (ReturnMethod == "AdminList")
{
return(RedirectToAction("AdminList", new { bDate = ReturnBeginDate, eDate = ReturnEndDate, SearchType = ReturnSearchType, codeID = ReturnCodeID, code = ReturnCode, CallerType = ReturnCallerType }));
}
else
{
return(RedirectToAction("List", new { bDate = ReturnBeginDate, eDate = ReturnEndDate, SearchType = ReturnSearchType, codeID = ReturnCodeID, code = ReturnCode }));
}
}
protected void createCalendar(object sender, EventArgs e)
{
calendar cal = new calendar();
cal.overallID = "createCalender";
cal.calenderName = createCalendarName.Text;
cal.userName = Session["username"].ToString();
if (createCalendarSharedYes.Checked == true)
{
cal.publicOrPrivate = 1;
cal.sharedto = createCalendarSharedUser.Text;
}
else
{
cal.publicOrPrivate = 0; cal.sharedto = " ";
}
createCalendar CC = new createCalendar();
CC.cc(cal);
}
public ActionResult Save(int?id, DateTime date, string details, bool holiday)
{
calendar entry;
if (id.HasValue)
{
entry = db.calendars.Single(x => x.id == id);
}
else
{
entry = new calendar();
db.calendars.InsertOnSubmit(entry);
}
entry.date = date;
entry.details = details;
entry.isHoliday = holiday;
db.SubmitChanges();
return(Json("Entry updated successfully".ToJsonOKMessage()));
}
public ActionResult DisplayBannerCalendarEvent(int calendarID)
{
calendar c = CalendarRepository.GetCalendarByID(calendarID);
if (c.DocumentID != null)
{
c.document = DocumentRepository.GetDocumentByID((int)c.DocumentID);
}
c.picture = PictureRepository.GetPictureByID((int)c.PictureID);
int year = DateTime.Now.Year;
string bDateString = "1/1/" + year.ToString();
DateTime bDate = Convert.ToDateTime(bDateString).Date;
ViewBag.CalendarBeginDate = bDate;
string eDateString = "12/31/" + year.ToString();
DateTime eDate = Convert.ToDateTime(eDateString).Date;
ViewBag.CalendarEndDate = eDate;
return(View(c));
}
public ActionResult PopulateDatabase()
{
var calendar = new Calendar();
var entries = calendar.GetCalendarFromExcel();
foreach (var entry in entries)
{
var date = new DateTime(entry.year, entry.month, entry.day);
var isholiday = entry.holiday;
foreach (var c_entry in entry.entry)
{
var c = new calendar();
c.date = date;
c.isHoliday = isholiday;
c.details = c_entry;
db.calendars.InsertOnSubmit(c);
}
}
db.SubmitChanges();
return(Content(""));
}
public ActionResult DeleteConfirmed(int CalendarID, DateTime ReturnBeginDate, DateTime ReturnEndDate, string ReturnSearchType = "", int ReturnCodeID = 0, string ReturnCodeName = "", string ReturnCallerType = "", string ReturnMethod = "")
{
calendar calendar = CalendarRepository.GetCalendarByID(CalendarID);
if (calendar.PictureID != null)
{
picture pic = PictureRepository.GetPictureByID((int)calendar.PictureID);
PictureRepository.DeleteRecord(pic);
}
CalendarRepository.DeleteRecord(calendar);
TempData["Message2"] = string.Format("Calendar record deleted successfully.");
if (ReturnMethod == "Ministry")
{
return(RedirectToAction("Details", new { ministryID = calendar.ministryID, CallerType = "Ministry" }));
}
else if (calendar.ReturnMethod == "AdminList")
{
return(RedirectToAction("ListAdmin", new { bDate = ReturnBeginDate, eDate = ReturnEndDate, SearchType = ReturnSearchType, codeID = ReturnCodeID, codeName = ReturnCodeName, CallerType = ReturnCallerType }));
}
else
{
return(RedirectToAction("Details", new { }));
}
}
public ActionResult Create(calendar calendar, string CallerType = "")
{
try
{
if (ModelState.IsValid)
{
db.calendars.Add(calendar);
db.SaveChanges();
TempData["Message2"] = "New calendar record added.";
GetData();
if (CallerType == "Ministry")
{
return(RedirectToAction("Details", new { ministryID = calendar.ministryID, CallerType = "Ministry" }));
}
if (CallerType == "Officer")
{
DateTime aDate = DateTime.Now.Date;
ViewBag.BeginDate = aDate.ToShortDateString();
ViewBag.EndDate = aDate.AddDays(30);
return(RedirectToAction("List", new { bDate = @ViewBag.BeginDate, eDate = @ViewBag.EndDate, codeID = calendar.ministryID, SearchCode = "Ministry" }));
}
else
{
return(RedirectToAction("Details", new { }));
}
}
}
catch (Exception ex)
{
TempData["Message2"] = "Error adding record to calendar";
}
GetData();
return(PartialView(calendar));
}
public ActionResult UpdateFixedBanner(string Description)
{
calendar c = CalendarRepository.GetCalendarByDescription(Description);
return(RedirectToAction("Edit", new { calendarID = c.calendarID, ReturnBeginDate = DateTime.Today.Date, ReturnEndDate = DateTime.Today.Date, ReturnCallerType = "FixedBanner" }));
}
public bool EditCalenadr(calendar Calendar)
{
throw new NotImplementedException();
}
public calendar GetCalendarByID(int calendarID)
{
record = myRecords.FirstOrDefault(e => e.calendarID == calendarID);
return(record);
}
public ActionResult Edit(calendar calendar)
{
string ReturnUrl = Request.UrlReferrer.ToString();
try
{
if (ModelState.IsValid)
{
picture pic = new picture();
foreach (var image in calendar.files)
{
if (image != null)
{
pic.ImageMimeType = image.ContentType;
pic.ImageData = new byte[image.ContentLength];
image.InputStream.Read(pic.ImageData, 0, image.ContentLength);
pic.ministryID = 0;
pic.PictureDate = System.DateTime.Today;
pic.Status = "Active";
pic.Description = string.Format("Picture:{0}", calendar.Title);
pic.DateEntered = System.DateTime.Today;
pic.EnteredBy = User.Identity.Name.ToString();
db.pictures.Add(pic);
db.SaveChanges();
PictureRepository.AddRecord(pic);
calendar.PictureID = pic.pictureID;
}
}
if (calendar.Conductor == null)
{
calendar.Conductor = "";
}
if (calendar.Description == null)
{
calendar.Description = "";
}
db.Entry(calendar).State = EntityState.Modified;
db.SaveChanges();
TempData["Message2"] = string.Format("Calendar record update successfully.");
/*
* if (calendar.ReturnMethod == "Ministry")
* {
* // return RedirectToAction("Details", new { ministryID = calendar.ministryID, CallerType = "Ministry" });
* }
* else if (calendar.ReturnMethod == "AdminList")
* {
* return RedirectToAction("ListAdmin", new { bDate = calendar.ReturnBeginDate, eDate = calendar.ReturnEndDate, SearchType = calendar.ReturnSearchType, codeID = calendar.ReturnCodeID, codeName = calendar.ReturnCodeName, CallerType = calendar.ReturnCallerType });
* }
* else
* {
* return RedirectToAction("Details", new { });
* }
*/
return(Redirect(ReturnUrl));
}
}
catch (Exception ex)
{
TempData["Message2"] = string.Format("Error editing {0} record.", calendar.Title);
}
GetData(calendar.ministryID);
return(PartialView(calendar));
}
public int AddCalendar(calendar Calendar)
{
throw new NotImplementedException();
}
public ActionResult GetMinistryPage2(int ministryID = 0, int CalendarBannerID = 0)
{
ViewBag.BannerEvent = null;
ViewBag.isCalendarBannerEvent = false;
if (CalendarBannerID > 0)
{
ViewBag.isCalendarBannerEvent = true;
calendar c = CalendarRepository.GetCalendarByID(CalendarBannerID);
if (c.DocumentID != null)
{
c.document = DocumentRepository.GetDocumentByID((int)c.DocumentID);
}
c.picture = PictureRepository.GetPictureByID((int)c.PictureID);
ViewBag.BannerEvent = c;
ministryID = c.ministryID;
}
ministry ministry;
if (ministryID == 0)
{
ministry = MinistryRepository.GetMainChurchMinistry();
}
else
{
ministry = MinistryRepository.GetMinistryByID(ministryID);
}
ViewBag.MinistryID = ministry.ministryID;
DateTime beginDate = DateTime.Now;
DateTime endDate = beginDate.AddDays(60);
IEnumerable <calendar> currentCalendar = CalendarRepository.GetCalendarByMinistryDate(ministryID, beginDate, endDate);
foreach (calendar m in currentCalendar)
{
m.ministry = MinistryRepository.GetMinistryByID(m.ministryID);
}
ViewBag.CurrentCalendar = currentCalendar;
GetData();
IEnumerable <announcement> announcements = AnnouncementRepository.GetAnnouncementByMinistry(ministryID, beginDate, endDate);
ViewBag.Announcements = announcements;
IEnumerable <document> documents = DocumentRepository.GetDocumentByMinistry(ministryID);
ViewBag.Document = documents;
IEnumerable <listtable> tables = ListTableRepository.GetListByMinistry(ministryID);
ViewBag.Tables = tables;
//banner
ViewBag.BannerID = null;
if (ministry.PictureID != null)
{
picture banner = PictureRepository.GetPictureByID((int)ministry.PictureID);
ViewBag.BannerID = banner.pictureID;
}
else
{
picture banner = PictureRepository.GetMinistryDefaultBanner();
ViewBag.BannerID = banner.pictureID;
}
//pictures
IEnumerable <picture> pictures = PictureRepository.GetPictureByMinistry(ministryID).Take(30);
ViewBag.Pictures = pictures;
//videos
IEnumerable <video> videos = VideoRepository.GetVideoByMinistry(ministryID, beginDate, endDate);
ViewBag.Videos = videos;
if (ministry.PageStyleID != 0)
{
ministry.PageStyle = ConstantRepository.GetConstantID((int)ministry.PageStyleID).Value2;
}
//calendar dates
int year = DateTime.Now.Year;
string bDateString = "1/1/" + year.ToString();
DateTime bDate = Convert.ToDateTime(bDateString).Date;
ViewBag.CalendarBeginDate = bDate;
string eDateString = "12/31/" + year.ToString();
DateTime eDate = Convert.ToDateTime(eDateString).Date;
ViewBag.CalendarEndDate = eDate;
//announcement dates
DateTime AnnEndDate = DateTime.Now;
DateTime AnnBeginDate = beginDate.AddDays(-90);
ViewBag.AnnouncementBeginDate = AnnBeginDate;
ViewBag.AnnouncementEndDate = AnnEndDate;
IEnumerable <announcement> AnnouncementList = AnnouncementRepository.GetAnnouncementByMinistry(ministryID, AnnBeginDate, AnnEndDate);
ViewBag.AnnouncementRecordCount = AnnouncementList.Count();
//ministry tables
IEnumerable <listtable> ListTable = ListTableRepository.GetListByMinistry(ministryID);
ViewBag.TableRecordCount = ListTable.Count();
ViewBag.Tables = ListTable;
ViewBag.IsRental = false;
if (ministry.CodeDesc == "Rental")
{
ViewBag.IsRental = true;
}
return(View(ministry));
}
