public IHttpActionResult PutEventoResponsable(int id, EventoResponsable eventoResponsable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != eventoResponsable.Id)
{
return(BadRequest());
}
db.Entry(eventoResponsable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EventoResponsableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult DeleteConfirmed(int id)
{
EventoResponsable eventoResponsable = db.EventoResponsable.Find(id);
db.EventoResponsable.Remove(eventoResponsable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(Evento evento, int IdListaDistribucion)
{
if (ModelState.IsValid)
{
evento.Activo = true;
db.Entry(evento).State = EntityState.Modified;
changeStatus(evento);
db.SaveChanges();
//Modify IdSubcategoria inside Ventana object
var ventana = db.Ventana.Where(v => v.IdEvento == evento.Id).FirstOrDefault();
if (ventana != null)
{
ventana.IdSubCategoria = evento.IdSubCategoria;
db.Entry(ventana).State = EntityState.Modified;
db.SaveChanges();
}
if (IdListaDistribucion != 0)
{
// Remove the old asignation
var responsables = db.EventoResponsable
.Where(d => d.IdEvento == evento.Id)
.ToList();
foreach (var responsable in responsables)
{
db.EventoResponsable.Remove(responsable);
}
//Add new asignation
var lista = db.ListaDistribucion
.Where(x => x.Id == IdListaDistribucion)
.Select(x => x.IdPersona)
.ToList();
foreach (var item in lista)
{
EventoResponsable eResponsable = new EventoResponsable();
eResponsable.IdEvento = evento.Id;
eResponsable.IdResponsable = item;
db.EventoResponsable.Add(eResponsable);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.IdAsignador = new SelectList(db.Personas.Select(x => new { Id = x.Id, Nombre = x.Nombre + " " + x.Apellido1 + " " + x.Apellido2 }).OrderBy(x => x.Nombre), "Id", "Nombre");
ViewBag.IdCategoria = new SelectList(db.Categoria.Select(x => new { Id = x.Id, Nombre = x.Nombre }).OrderBy(x => x.Nombre), "Id", "Nombre", evento.IdCategoria);
ViewBag.IdSubCategoria = new SelectList(db.SubCategoria.Select(x => new { Id = x.Id, Nombre = x.Nombre }).OrderBy(x => x.Nombre), "Id", "Nombre", evento.IdSubCategoria);
return(View(evento));
}
public ActionResult Edit([Bind(Include = "Id,IdEvento,IdResponsable")] EventoResponsable eventoResponsable)
{
if (ModelState.IsValid)
{
db.Entry(eventoResponsable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IdResponsable = new SelectList(db.Personas, "Id", "Nombre", eventoResponsable.IdResponsable);
return(View(eventoResponsable));
}
public IHttpActionResult GetEventoResponsable(int id)
{
EventoResponsable eventoResponsable = db.EventoResponsable.Find(id);
if (eventoResponsable == null)
{
return(NotFound());
}
return(Ok(eventoResponsable));
}
public IHttpActionResult PostEventoResponsable(EventoResponsable eventoResponsable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.EventoResponsable.Add(eventoResponsable);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = eventoResponsable.Id }, eventoResponsable));
}
public ActionResult Create(Evento evento, int IdOrigen, string IdResponsables)
{
if (ModelState.IsValid)
{
if (evento.Nota == null)
{
evento.Nota = " ";
}
PersonaServicio personaServicio = new PersonaServicio();
IRespuestaServicio <Persona> persona = personaServicio.GetPersona(User.Identity.GetUserId());
if (persona.EjecucionCorrecta)
{
evento.IdAsignador = persona.Respuesta.Id;
db.Evento.Add(evento);
db.SaveChanges();
}
if (IdOrigen > 0)
{
EventoOrigen eOrigen = new EventoOrigen();
eOrigen.IdEvento = evento.Id;
eOrigen.IdOrigen = IdOrigen;
db.EventoOrigen.Add(eOrigen);
db.SaveChanges();
}
if (IdResponsables != null && IdResponsables != "")
{
Char delimiter = ',';
String[] substrings = IdResponsables.Split(delimiter);
foreach (var substring in substrings)
{
if (substring != "")
{
EventoResponsable eResponsable = new EventoResponsable();
eResponsable.IdEvento = evento.Id;
eResponsable.IdResponsable = int.Parse(substring);
db.EventoResponsable.Add(eResponsable);
db.SaveChanges();
}
}
SendNotification(evento, "New Event: ");
}
return(RedirectToAction("Index"));
}
return(View(evento));
}
// GET: Operaciones/EventoResponsable/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventoResponsable eventoResponsable = db.EventoResponsable.Find(id);
if (eventoResponsable == null)
{
return(HttpNotFound());
}
return(View(eventoResponsable));
}
public IHttpActionResult DeleteEventoResponsable(int id)
{
EventoResponsable eventoResponsable = db.EventoResponsable.Find(id);
if (eventoResponsable == null)
{
return(NotFound());
}
db.EventoResponsable.Remove(eventoResponsable);
db.SaveChanges();
return(Ok(eventoResponsable));
}
// GET: Operaciones/EventoResponsable/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventoResponsable eventoResponsable = db.EventoResponsable.Find(id);
if (eventoResponsable == null)
{
return(HttpNotFound());
}
ViewBag.IdResponsable = new SelectList(db.Personas, "Id", "Nombre", eventoResponsable.IdResponsable);
return(View(eventoResponsable));
}
public ActionResult Upload(HttpPostedFileBase file)
{
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string fileContentType = file.ContentType;
byte[] fileBytes = new byte[file.ContentLength];
var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));
using (var package = new ExcelPackage(file.InputStream))
{
PersonaServicio personaServicio = new PersonaServicio();
IRespuestaServicio <Persona> persona = personaServicio.GetPersona(User.Identity.GetUserId());
var currentSheet = package.Workbook.Worksheets;
foreach (var workSheet in currentSheet)
{
var noOfCol = workSheet.Dimension.End.Column;
var noOfRow = workSheet.Dimension.End.Row;
for (var row = 2; row <= noOfRow; row++)
{
if (workSheet.Cells[row, 1].Value != null)
{
var numSubCategoria = workSheet.Cells[row, 3].Value.ToString().Trim();
var fecha = DateTime.ParseExact(workSheet.Cells[row, 2].Value.ToString().Trim(), "dd/MM/yyyy hh:mm", null);
Evento evento = new Evento();
evento.Descripcion = workSheet.Cells[row, 1].Value == null ? string.Empty : workSheet.Cells[row, 1].Value.ToString().Trim();
evento.FechaInicio = workSheet.Cells[row, 2].Value == null ? DateTime.Now : fecha;
evento.FechaFin = evento.FechaFin.AddHours(1);
evento.IdAsignador = persona.Respuesta.Id;
evento.IdCategoria = db.Categoria.Where(c => c.NombreCorto == "Ventana").Select(c => c.Id).FirstOrDefault();
evento.IdSubCategoria = db.SubCategoria.Where(c => c.NombreCorto == numSubCategoria).Select(c => c.Id).FirstOrDefault() == 0
? db.Carrier.Where(c => c.NombreCorto == "DIMS Nacional").Select(c => c.Id).FirstOrDefault()
: db.SubCategoria.Where(c => c.NombreCorto == numSubCategoria).Select(c => c.Id).FirstOrDefault();
evento.Nota = " ";
evento.Activo = true;
db.Evento.Add(evento);
db.SaveChanges();
var proveedor = workSheet.Cells[row, 4].Value.ToString().Trim();
var idSubArea = db.SubArea.Where(f => f.NombreCorto == proveedor).Select(f => f.Id).FirstOrDefault();
var listaDistribucion = db.ListaDistribucion.Where(w => (w.IdSubarea == idSubArea)).Select(w => new { IdPersona = w.IdPersona }).ToList();
if (listaDistribucion.Count > 0)
{
foreach (var item in listaDistribucion)
{
EventoResponsable eResponsable = new EventoResponsable();
eResponsable.IdEvento = evento.Id;
eResponsable.IdResponsable = item.IdPersona;
db.EventoResponsable.Add(eResponsable);
db.SaveChanges();
}
SendNotification(evento, "New Event: ");
}
}
}
break;
}
return(RedirectToAction("Index", "Evento", new { Area = "Operaciones" }));
}
}
return(View("Index"));
}
