// Método añadir guía a hoja de ruta public ActionResult AddGuiaHR(int?idNumeroGuias) { if (Session["Login"] == null) { return(RedirectToAction("Login", "Home")); } else { if (idNumeroGuias == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } guias guias = db.guias.Find(idNumeroGuias); if (guias == null) { return(HttpNotFound()); } int id = Convert.ToInt32(TempData["id"]); guias.idHojaRuta = id; db.SaveChanges(); TempData["Alerta"] = "Asignar Guia"; TempData["id"] = id; return(RedirectToAction("Index")); } }
public ActionResult DeleteConfirmed(int id) { guias guias = db.guias.Find(id); db.guias.Remove(guias); db.SaveChanges(); return(RedirectToAction("Index")); }
public JsonResult GuardarGuiaInDatabase(GuiasViewModel model) { var result = false; try { guias g = db.guias.Where(x => x.numeroGuia == model.numeroGuia).SingleOrDefault(); string value = string.Empty; if (g != null) { guias gui = db.guias.SingleOrDefault(s => s.numeroGuia == model.numeroGuia); gui.numeroGuia = model.numeroGuia; gui.rut = model.rut; gui.nombre = model.nombre; gui.ciudad = model.ciudad; gui.direccion = model.direccion; gui.telefono = model.telefono; gui.idHojaRuta = model.idHojaRuta; if (model.observacion == null) { model.observacion = "Sin Comentarios"; } gui.observacion = model.observacion; gui.estado = "Pendiente"; db.SaveChanges(); result = true; } else { guias gui = new guias(); gui.numeroGuia = model.numeroGuia; gui.rut = model.rut; gui.nombre = model.nombre; gui.ciudad = model.ciudad; gui.direccion = model.direccion; gui.telefono = model.telefono; gui.fechaIngreso = DateTime.Now; if (model.observacion == null) { model.observacion = "Sin Comentarios"; } gui.observacion = model.observacion; gui.estado = "pendiente"; gui.idHojaRuta = 2; db.guias.Add(gui); db.SaveChanges(); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult GetGuiaByNumeroGuia(int numeroGuia) { guias model = db.guias.Where(x => x.numeroGuia == numeroGuia).SingleOrDefault(); string value = string.Empty; value = JsonConvert.SerializeObject(model, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "id,Guia,Ordenes_Id")] guias guias) { if (ModelState.IsValid) { db.Entry(guias).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Ordenes_Id = new SelectList(db.ordenes, "id", "Orden", guias.Ordenes_Id); return(View(guias)); }
public ActionResult Create([Bind(Include = "id,Guia,Ordenes_Id")] guias guias) { if (ModelState.IsValid) { db.guias.Add(guias); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Ordenes_Id = new SelectList(db.ordenes, "id", "Orden", guias.Ordenes_Id); return(View(guias)); }
public JsonResult BorrarRegistroGuias(int numeroGuia) { bool result = false; guias gui = db.guias.SingleOrDefault(x => x.estado == "pendiente" && x.numeroGuia == numeroGuia); if (gui != null) { gui.estado = "nose"; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(int id) { if (Session["Login"] == null) { return(RedirectToAction("Login", "Home")); } else { guias guias = db.guias.Find(id); db.guias.Remove(guias); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } guias guias = db.guias.Find(id); if (guias == null) { return(HttpNotFound()); } return(View(guias)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } guias guias = db.guias.Find(id); if (guias == null) { return(HttpNotFound()); } ViewBag.Ordenes_Id = new SelectList(db.ordenes, "id", "Orden", guias.Ordenes_Id); return(View(guias)); }
// GET: guias/Details/5 public ActionResult Details(int?id) { if (Session["Login"] == null) { return(RedirectToAction("Login", "Home")); } else { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } guias guias = db.guias.Find(id); if (guias == null) { return(HttpNotFound()); } return(View(guias)); } }
public ActionResult Edit([Bind(Include = "idHojaRuta")] guias guias) { if (Session["Login"] == null) { return(RedirectToAction("Login", "Home")); } else { if (ModelState.IsValid) { int id = Convert.ToInt32(TempData["id"]); guias.idHojaRuta = id; db.Entry(guias).State = EntityState.Modified; db.SaveChanges(); TempData["id"] = id; return(RedirectToAction("Index")); } ViewBag.idHojaRuta = new SelectList(db.hojaRuta, "idHojaRuta", "patente", guias.idHojaRuta); return(View(guias)); } }
public ActionResult Create([Bind(Include = "numeroGuia,rut,nombre,direccion,telefono,ciudad,observacion")] guias guias) { if (Session["Login"] == null) { return(RedirectToAction("Login", "Home")); } else { if (ModelState.IsValid) { guias.idHojaRuta = 2; guias.fechaIngreso = DateTime.Now; guias.estado = "Pendiente"; db.guias.Add(guias); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idHojaRuta = new SelectList(db.hojaRuta, "idHojaRuta", "patente", guias.idHojaRuta); return(View(guias)); } }
public ActionResult ObtenerGuias() { try { var Draw = Request.Form.GetValues("draw").FirstOrDefault(); var Start = Request.Form.GetValues("start").FirstOrDefault(); var Length = Request.Form.GetValues("length").FirstOrDefault(); var SortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault(); var SortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); var guia = Request.Form.GetValues("columns[0][search][value]").FirstOrDefault(); var orden = Request.Form.GetValues("columns[1][search][value]").FirstOrDefault(); int PageSize = Length != null?Convert.ToInt32(Length) : 0; int Skip = Start != null?Convert.ToInt32(Start) : 0; int TotalRecords = 0; List <guias> listaGuias = new List <guias>(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { con.Open(); string sql = "exec SP_Guias_ParametrosOpcionales @orden, @guia"; var query = new SqlCommand(sql, con); if (guia != "") { query.Parameters.AddWithValue("@guia", guia); } else { query.Parameters.AddWithValue("@guia", DBNull.Value); } if (orden != "") { query.Parameters.AddWithValue("@orden", orden); } else { query.Parameters.AddWithValue("@orden", DBNull.Value); } using (var dr = query.ExecuteReader()) { while (dr.Read()) { // facturas var guias = new guias(); guias.id = Convert.ToInt32(dr["id"]); guias.Guia = dr["Guia"].ToString(); guias.Orden = dr["Orden"].ToString(); listaGuias.Add(guias); } } } if (!(string.IsNullOrEmpty(SortColumn) && string.IsNullOrEmpty(SortColumnDir))) { listaGuias = listaGuias.OrderBy(SortColumn + " " + SortColumnDir).ToList(); } TotalRecords = listaGuias.ToList().Count(); var NewItems = listaGuias.Skip(Skip).Take(PageSize == -1 ? TotalRecords : PageSize).ToList(); return(Json(new { draw = Draw, recordsFiltered = TotalRecords, recordsTotal = TotalRecords, data = NewItems }, JsonRequestBehavior.AllowGet)); } catch (Exception _ex) { Console.WriteLine(_ex.Message.ToString()); return(null); } }