public List <hd_ordenes> ValidarOrdenes(DataTable dt) { List <hd_ordenes> listaordenes = db.hd_ordenes.Take(5000).ToList(); List <hd_ordenes> listaAgregar = new List <hd_ordenes>(); foreach (DataRow row in dt.Rows) { string orden = row[2].ToString().Trim().ToUpper(); if (listaordenes.Where(x => x.NumeroOrden.Equals(orden)).FirstOrDefault() == null) { if (listaAgregar.Where(x => x.NumeroOrden == orden).FirstOrDefault() == null) { hd_ordenes ordenes = new hd_ordenes(); ordenes.NumeroOrden = orden; ordenes.OracleID = row[3].ToString().Trim().ToUpper(); ordenes.Guia = row[4].ToString().Trim().ToUpper(); ordenes.Paquetes = 1; ordenes.FechaAlta = DateTime.Now; ordenes.Pickers_Id = 1; ordenes.Auditores_Id = 1; ordenes.hd_statusorden_Id = 1; ordenes.hd_statusquickship_Id = 1; ordenes.Empleados_Id = 1; listaAgregar.Add(ordenes); } } } db.hd_ordenes.AddRange(listaAgregar); db.SaveChanges(); return(listaAgregar); }
public ActionResult ObtenerOrdenes() { 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 orden = Request.Form.GetValues("columns[0][search][value]").FirstOrDefault(); int PageSize = Length != null?Convert.ToInt32(Length) : 0; int Skip = Start != null?Convert.ToInt32(Start) : 0; int TotalRecords = 0; List <hd_ordenes> lista = new List <hd_ordenes>(); using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionGlobal"].ToString())) { con.Open(); string sql = "exec SP_Ordenes_Index @orden"; var query = new SqlCommand(sql, con); if (orden != "") { query.Parameters.AddWithValue("@orden", orden); } else { query.Parameters.AddWithValue("@orden", DBNull.Value); } using (var dr = query.ExecuteReader()) { while (dr.Read()) { // facturas var ordenesTemp = new hd_ordenes(); ordenesTemp.Id = Convert.ToInt32(dr["Id"]); ordenesTemp.NumeroOrden = dr["NumeroOrden"].ToString(); ordenesTemp.Guia = dr["Guia"].ToString(); ordenesTemp.OracleID = dr["OracleID"].ToString(); ordenesTemp.Paquetes = Convert.ToInt32(dr["Paquetes"]); ordenesTemp.status = dr["Descripcion"].ToString(); lista.Add(ordenesTemp); } } } if (!(string.IsNullOrEmpty(SortColumn) && string.IsNullOrEmpty(SortColumnDir))) { lista = lista.OrderBy(SortColumn + " " + SortColumnDir).ToList(); } TotalRecords = lista.ToList().Count(); var NewItems = lista.Skip(Skip).Take(PageSize == -1 ? TotalRecords : PageSize).ToList(); return(Json(new { draw = Draw, recordsFiltered = TotalRecords, recordsTotal = TotalRecords, data = NewItems }, JsonRequestBehavior.AllowGet)); } catch (Exception) { throw; } }