public ActionResult Create(EventModel Model)
{
try
{
if (Model.EventNo == 0)
{
tblEventCalendar Events = new tblEventCalendar();
Events.CreatedBy = _session.User_Id;
Events.CreatedDate = DateTime.Now;
Events.SchoolId = _session.School_Id;
Events.EventTitle = Model.EventName;
Events.EventCategory = Model.EventCategoryId;
Events.EventDescription = Model.EventDescription;
Events.EventOrganizer = Model.EventOrganizer;
Events.FromDate = Convert.ToDateTime(Model.SFromDate);
Events.ToDate = Convert.ToDateTime(Model.SToDate);
DateTime F = DateTime.Parse(Model.SFromTime);
DateTime T = DateTime.Parse(Model.SToTime);
Events.FromTime = TimeSpan.Parse(F.ToString("HH:mm"));
Events.ToTime = TimeSpan.Parse(T.ToString("HH:mm"));
Events.IsActive = "Y";
Connection.tblEventCalendars.Add(Events);
Connection.SaveChanges();
}
else
{
tblEventCalendar Events = Connection.tblEventCalendars.SingleOrDefault(
x => x.EventNo == Model.EventNo);
Events.CreatedBy = _session.User_Id;
Events.CreatedDate = DateTime.Now;
Events.SchoolId = _session.School_Id;
Events.EventTitle = Model.EventName;
Events.EventCategory = Model.EventCategoryId;
Events.EventDescription = Model.EventDescription;
Events.EventOrganizer = Model.EventOrganizer;
Events.FromDate = Convert.ToDateTime(Model.SFromDate);
Events.ToDate = Convert.ToDateTime(Model.SToDate);
DateTime F = DateTime.Parse(Model.SFromTime);
DateTime T = DateTime.Parse(Model.SToTime);
Events.FromTime = TimeSpan.Parse(F.ToString("HH:mm"));
Events.ToTime = TimeSpan.Parse(T.ToString("HH:mm"));
Events.IsActive = "Y";
Connection.SaveChanges();
}
return(Json("Succsess", JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
var result = new { r = "E" };
Errorlog.ErrorManager.LogError("@EventController/Create", Ex);
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(EventModel Model)
{
try
{
tblEventCalendar DEvents = Connection.tblEventCalendars.Find(Model.EventNo);
Connection.tblEventCalendars.Remove(DEvents);
Connection.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception Ex)
{
Errorlog.ErrorManager.LogError("@EventController/Delete", Ex);
return(View());
}
}
public ActionResult Indexx(int txtID, string btnAgregar, string btnEditar, string btnEliminar, string txtFechaInicio, string txtFechaFin, string txtTitulo, string txtHora, string txtDescripcion, string txtColor, tblEventCalendar ev)
{
if (Request.HttpMethod == "POST")
{
if (btnAgregar == "agregar")
{
var datosevento = new tblEventCalendar
{
id_Event = txtID,
title = txtTitulo,
descripcion = txtDescripcion,
color = txtColor,
textColor = "#FFFFFF",
start = Convert.ToDateTime(txtFechaInicio + " " + txtHora),
end = Convert.ToDateTime(txtFechaFin + " " + txtHora)
};
db.tblEventCalendar.Add(datosevento);
db.SaveChanges();
/*NOTIFICACION*/
ApplicationDbContext dbs = new ApplicationDbContext();
Notifications notificacion = new Notifications();
notificacion.Module = "Eventos";
notificacion.Message = string.Format("Registro un nuevo evento");
notificacion.Date = DateTime.Now;
notificacion.Viewed = false;
notificacion.Usuario_Id = User.Identity.GetUserId();
dbs.Notification.Add(notificacion);
dbs.SaveChanges();
/*FIN NOTIFICACION*/
return(RedirectToAction("Index", "Home"));
}
else if (btnEditar == "editar")
{
var datosevento = new tblEventCalendar
{
id_Event = txtID,
title = txtTitulo,
descripcion = txtDescripcion,
color = txtColor,
textColor = "#FFFFFF",
start = Convert.ToDateTime(txtFechaInicio),
end = Convert.ToDateTime(txtFechaFin)
};
db.tblEventCalendar.Attach(datosevento);
db.Entry(datosevento).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
/*NOTIFICACION*/
ApplicationDbContext dbs = new ApplicationDbContext();
Notifications notificacion = new Notifications();
notificacion.Module = "Eventos";
notificacion.Message = string.Format("Edito un evento");
notificacion.Date = DateTime.Now;
notificacion.Viewed = false;
notificacion.Usuario_Id = User.Identity.GetUserId();
dbs.Notification.Add(notificacion);
dbs.SaveChanges();
/*FIN NOTIFICACION*/
return(RedirectToAction("Index", "Home"));
}
else if (btnEliminar == "eliminar")
{
var datosevento = new tblEventCalendar
{
id_Event = txtID,
title = txtTitulo,
descripcion = txtDescripcion,
color = txtColor,
textColor = "#FFFFFF",
start = Convert.ToDateTime(txtFechaInicio),
end = Convert.ToDateTime(txtFechaFin)
};
db.tblEventCalendar.Attach(datosevento);
db.tblEventCalendar.Remove(datosevento);
db.SaveChanges();
/*NOTIFICACION*/
ApplicationDbContext dbs = new ApplicationDbContext();
Notifications notificacion = new Notifications();
notificacion.Module = "Eventos";
notificacion.Message = string.Format("Elimino un evento");
notificacion.Date = DateTime.Now;
notificacion.Viewed = false;
notificacion.Usuario_Id = User.Identity.GetUserId();
dbs.Notification.Add(notificacion);
dbs.SaveChanges();
/*FIN NOTIFICACION*/
return(RedirectToAction("Index", "Home"));
}
}
return(RedirectToAction("Index", "Home"));
}
