public ActionResult FinalizarSondeo()
{
try
{
string encuestador = User.Identity.Name;
int ultimo = db.SONDEO.Where(a => a.ID_USUARIO == encuestador).OrderByDescending(x => x.ID_LOCAL).First().ID_SONDEO;
bool estado = db.SONDEO.Where(a => a.ID_SONDEO == ultimo).First().FINALIZADO;
if (!estado)
{
SONDEO sONDEO = db.SONDEO.Find(ultimo);
sONDEO.FINALIZADO = true;
db.Entry(sONDEO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Missondeos"));
}
else
{
}
}
catch (Exception)
{
ModelState.AddModelError("", "Algo salio mal, intente nuevamente");
return(View());
}
return(View());
}
public ActionResult Create([Bind(Include = "ID_SONDEO,ID_LOCAL,FECHA,DESCRIPCION,FINALIZADO,ID_USUARIO")] SONDEO sONDEO)
{
if (ModelState.IsValid)
{
try
{
string logeado = User.Identity.Name.ToString();
string u = db.AspNetUsers.First(a => a.UserName == logeado).Id;
int local = db.LOCALIZACION.Where(a => a.CreadoPor == u).OrderByDescending(x => x.ID_LOCAL).First().ID_LOCAL;
sONDEO.ID_USUARIO = logeado;
sONDEO.FECHA = DateTime.Today;
sONDEO.ID_LOCAL = local;
db.SONDEO.Add(sONDEO);
db.SaveChanges();
return(RedirectToAction("../Productos/Index"));
}
catch (Exception ex)
{
if (sONDEO.ID_LOCAL <= 0)
{
ModelState.AddModelError("", "Algo salio mal, intente nuevamente");
return(RedirectToAction("../Localizaciones/Create"));
}
else
{
ModelState.AddModelError("", "Algo salio mal, intente nuevamente");
return(View(sONDEO));
}
}
}
ViewBag.ID_LOCAL = new SelectList(db.LOCALIZACION, "ID_LOCAL", "LOCALIDAD", sONDEO.ID_LOCAL);
return(View(sONDEO));
}
public ActionResult Edit([Bind(Include = "ID_SONDEO,ID_LOCAL,FECHA,DESCRIPCION,FINALIZADO,ID_USUARIO")] SONDEO sONDEO)
{
if (ModelState.IsValid)
{
db.Entry(sONDEO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_LOCAL = new SelectList(db.LOCALIZACION, "ID_LOCAL", "LOCALIDAD", sONDEO.ID_LOCAL);
return(View(sONDEO));
}
// GET: Sondeos/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SONDEO sONDEO = db.SONDEO.Find(id);
if (sONDEO == null)
{
return(HttpNotFound());
}
return(View(sONDEO));
}
public ActionResult DeleteConfirmed(int id)
{
var p = db.PRODUCTO.Where(a => a.ID_SONDEO == id);
foreach (PRODUCTO item in p)
{
db.PRODUCTO.Remove(item);
}
SONDEO sONDEO = db.SONDEO.Find(id);
db.SONDEO.Remove(sONDEO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Sondeos/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SONDEO sONDEO = db.SONDEO.Find(id);
if (sONDEO == null)
{
return(HttpNotFound());
}
ViewBag.ID_LOCAL = new SelectList(db.LOCALIZACION, "ID_LOCAL", "LOCALIDAD", sONDEO.ID_LOCAL);
return(View(sONDEO));
}
