// 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);
}
}