public IActionResult Delete(Models.Events housing)
{
if (housing.sendEmail == true)
{
string bcc = "*****@*****.**";
string to = housing.Email.ToString();
string subject = "Sorry To Inform You";
string boby = housing.FirstName + " " + housing.LastName + "<br>" + housing.Address + "<br>" + housing.City + " " + housing.State + " " + "<br><br>" + "We're sorry to inform you overnight accommodations at Camp Chetek will not be available on " + housing.event_start.ToString("MM/dd/yyyy") + "-" + housing.event_end.ToString("MM/dd/yyyy") + " that you requested." + "<br><br>" + "Have a blessed day<br><br>" + "Danael Kluver<br>" + "Office Manager";
MailMessage mm = new MailMessage();
mm.To.Add(to);
mm.Subject = subject;
mm.Body = boby;
mm.From = new MailAddress("*****@*****.**");
mm.Bcc.Add(bcc);
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient("smtp.gmail.com");
smtp.Port = 587;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "HideMenu45");
smtp.Send(mm);
ViewBag.message = "The Mail Has Been Sent To " + housing.Email + " Successfully..!";
context.events.Remove(housing);
context.SaveChanges();
return(RedirectToAction("Dashboard", "Housing"));
}
else
{
context.events.Remove(housing);
context.SaveChanges();
return(RedirectToAction("Dashboard", "Housing"));
}
}
public JsonResult SaveEvent(Models.Events e)
{
var status = false;
using (AppDbContext dc = new AppDbContext())
{
if (e.EventID > 0)
{
var v = dc.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
dc.Events.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public ContentResult Data()
{
Models.Events data = new Models.Events();
Models.EventsTableAdapters.TableTableAdapter dataAdapter = new Models.EventsTableAdapters.TableTableAdapter();
dataAdapter.Fill(data.Table);
dataObject result = new dataObject();
foreach (var item in data.Table)
{
EventObj _eventObj = new EventObj();
_eventObj.id = item.id.ToString();
_eventObj.start_date = String.Format("{0:yyyy-MM-dd HH:mm}", item.start_date);
_eventObj.end_date = String.Format("{0:yyyy-MM-dd HH:mm}", item.end_date);
_eventObj.text = item.text;
result.data.Add(_eventObj);
}
var list = JsonConvert.SerializeObject(result, Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(Content(list, "application/json"));
}
public JsonResult SaveEvent(Models.Events e)
{
var status = false;
using (SzkolaEntities School = new SzkolaEntities())
{
if (e.EventID > 0)
{
//Update the event
var v = School.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
v.ClassID = e.ClassID;
}
}
else
{
School.Events.Add(e);
}
School.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
// GET: Event
public ActionResult Index()
{
List <Events> eventdescs = new List <Models.Events>();
Events eventdesc = new Models.Events();
eventdesc.Date = DateTime.Now;
eventdesc.EventDescription = " DescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescription";
eventdesc.EventLocation = "Bangalore";
eventdesc.EventId = 1;
eventdescs.Add(eventdesc);
eventdesc = new Models.Events();
eventdesc.Date = DateTime.Now;
eventdesc.EventDescription = " DescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescription";
eventdesc.EventLocation = "Hyderabad";
eventdesc.EventId = 2;
eventdescs.Add(eventdesc);
eventdesc = new Models.Events();
eventdesc.Date = DateTime.Now;
eventdesc.EventDescription = " DescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescription";
eventdesc.EventLocation = "Mumbai";
eventdesc.EventId = 3;
eventdescs.Add(eventdesc);
return(View(eventdescs));
return(View());
}
public JsonResult SaveEvent(Models.Events e)
{
var status = false;
using (SzkolaEntities School = new SzkolaEntities())
{
if (e.EventID > 0)
{
//Update the event
var v = School.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
v.ClassID = e.ClassID;
}
}
else
{
//var date = e.Start;
//DateTime date2 = DateTime.Parse(date.ToString("yyyy-dd-MM"));
////var date2 = date.ToString("yyyy-dd-MM");
////DateTime date2 = DateTime.Parse(date);
//var end_date = e.End;
//if (end_date == null) { end_date = null; }
//else {
// DateTime end_date2 = DateTime.Parse(end_date.Value.ToString("yyyy-dd-MM"));
//}
////var date3 = date.ToString("yyyy-dd-MM");
////DateTime nowadata = DateTime.Parse(date3);
////e.Start = date2;
//e.End = end_date;
School.Events.Add(e);
}
School.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
//gets the events/holidays and give them there colour
public List<Models.Events> GetEvents()
{
List<Models.Events> events = sql.GetEvents();
for (int i = 0; i < events.Count; i++)
{
if (events[i].Speciel)
{
events[i] = new Models.Events(events[i].Title, events[i].Desc, events[i].Start_Date, events[i].End_Date, false, "#DD1515", events[i].ID);
}
else if (bool.Parse(events[i].Colour))
{
events[i] = new Models.Events(events[i].Title, events[i].Desc, events[i].Start_Date, events[i].End_Date, false, "#AAAAAA", events[i].ID);
}
else
{
events[i] = new Models.Events(events[i].Title, events[i].Desc, events[i].Start_Date, events[i].End_Date, false, "#F1C40F", events[i].ID);
}
}
return events;
}
public EventTypes GetEventType()
{
Models.Events events = EventsContainer.Events.Where(e => e.Id == View.SelectedEventForResult).ToList()[0];
return(EventTypes.GetEventTypes(events.Type));
}
public IActionResult Edit(Models.Events housing)
{
if (ModelState.IsValid)
{
if (housing.event_id == 0)
{
housing.title = housing.FirstName + " " + housing.LastName + " | Room: " + context.Room.Find(housing.RoomsId).Name.ToString();
housing.description = housing.FirstName + " " + housing.LastName + " | Bedding: " + context.beddings.Find(housing.BeddingId).Name.ToString() + " | Number Of Guest: " + housing.NumberGuest.ToString();
context.events.Add(housing);
string bcc = "*****@*****.**";
string to = housing.Email;
string subject = "Thank You For Your Housing Request";
string boby = "Thank You " + housing.FirstName + " we will get back to you soon about staying<br><br> " + housing.event_start.ToString("MM/dd/yyyy") + "-" + housing.event_end.ToString("MM/dd/yyyy") + ". ";
MailMessage mm = new MailMessage();
mm.To.Add(to);
mm.Subject = subject;
mm.Body = boby;
mm.From = new MailAddress("*****@*****.**");
mm.Bcc.Add(bcc);
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient("smtp.gmail.com");
smtp.Port = 587;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "HideMenu45");
smtp.Send(mm);
ViewBag.message = "The Mail Has Been Sent To " + housing.Email + " Successfully..!";
}
else
{
if (housing.sendEmail == true)
{
string bcc = "*****@*****.**";
string to = housing.Email;
string subject = "Camp Chetek Booking Confirmation";
string boby = housing.FirstName + " " + housing.LastName + "<br>" + housing.Address + "<br>" + housing.City + " " + housing.State + " " + housing.Zip + "<br><br>" + "Thank You " + housing.FirstName + ", for your recent request for accommodation.<br><br>" + "Below are the details of your booking. Please take a moment to check them, and if there are any problems, please call us so we can correct our records.<br><br>" + "We look forward to welcoming you, and will do our utmost to make your stay with us an enjoyable and memorable experience.<br><br><hr>" + "Arriving: " + housing.event_start.ToString("MM/dd/yyyy") + "<br>" + "Leaving: " + housing.event_end.ToString("MM/dd/yyyy") + "<br>" + "Guests: " + housing.NumberGuest.ToString() + "<br>" + "Room: " + context.Room.Find(housing.RoomsId).Name.ToString() + "<br>" + "Bedding: " + context.beddings.Find(housing.BeddingId).Name.ToString() + "<br><hr>";
MailMessage mm = new MailMessage();
mm.To.Add(to);
mm.Subject = subject;
mm.Body = boby;
mm.From = new MailAddress("*****@*****.**");
mm.Bcc.Add(bcc);
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient("smtp.gmail.com");
smtp.Port = 587;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "HideMenu45");
smtp.Send(mm);
ViewBag.message = "The Mail Has Been Sent To " + housing.Email + " Successfully..!";
housing.title = housing.FirstName.ToUpper() + " " + housing.LastName.ToUpper() + " | Room:" + context.Room.Find(housing.RoomsId).Name.ToString();
housing.description = housing.FirstName + " " + housing.LastName + "| Bedding:" + context.beddings.Find(housing.BeddingId).Name.ToString() + " | Number Of Guest: " + housing.NumberGuest.ToString();
housing.DateUpdate = DateTime.Now.ToString();
context.events.Update(housing);
}
else
{
housing.title = housing.FirstName.ToUpper() + " " + housing.LastName.ToUpper() + " | Room:" + context.Room.Find(housing.RoomsId).Name.ToString();
housing.description = housing.FirstName + " " + housing.LastName + "| Bedding:" + context.beddings.Find(housing.BeddingId).Name.ToString() + " | Number Of Guest: " + housing.NumberGuest.ToString();
housing.DateUpdate = DateTime.Now.ToString();
context.events.Update(housing);
}
}
context.SaveChanges();
return(RedirectToAction("Dashboard", "Housing"));
}
else
{
ViewBag.Action = (housing.event_id == 0) ? "Add" : "Edit";
ViewBag.Bedding = context.beddings.OrderBy(b => b.Name).ToList();
ViewBag.Rooms = context.Room.OrderBy(p => p.Name).ToList();
ViewBag.User = context.Users.OrderBy(u => u.FirstName).ToList();
ViewBag.User = context.Users.OrderBy(u => u.LastName).ToList();
ViewBag.Reason = context.Reasons.OrderBy(r => r.Name).ToList();
return(View(housing));
}
}
