public ActionResult getUpExtender_NC(Ent_Extender_NC _Ent) { bool Result = false; string Estado = string.Empty; JsonResponse objResult = new JsonResponse(); try { Result = datGuia.UpExtender_NC(_Ent, ref Estado); if (Result) { objResult.Success = true; objResult.Message = "La nueva fecha se actualizo correctamente."; } else { objResult.Success = false; objResult.Message = Estado; } } catch (Exception ex) { objResult.Success = false; objResult.Message = "Error al actualizar"; } var JSON = JsonConvert.SerializeObject(objResult); return(Json(JSON, JsonRequestBehavior.AllowGet)); }
public ActionResult Extender_NC_XCenter() { Ent_Usuario _usuario = (Ent_Usuario)Session[Ent_Constantes.NameSessionUser]; string actionName = this.ControllerContext.RouteData.GetRequiredString("action"); string controllerName = this.ControllerContext.RouteData.GetRequiredString("controller"); string return_view = actionName + "|" + controllerName; if (_usuario == null) { return(RedirectToAction("Login", "Control", new { returnUrl = return_view })); } else { Ent_Extender_NC entExtender_NC = new Ent_Extender_NC(); ViewBag.entExtender_NC = entExtender_NC; List <Ent_ListaTienda> tiendas = new List <Ent_ListaTienda>(); tiendas.Add(new Ent_ListaTienda() { cod_entid = "-1", des_entid = "SELECCIONE" }); ViewBag.tienda = tiendas.Concat(dat_lista_tienda.get_tienda("PE", "1")); return(View()); } }
///Listado de tabla detalle anterior //public string listarStr_Detalle(string cod_tda,DateTime fecha_des) //{ // string strJson = ""; // try // { // SqlConnection cn = new SqlConnection(Ent_Conexion.conexion); // cn.Open(); // SqlCommand oComando = new SqlCommand("USP_XSTORE_GET_DOCUMENTO_DET", cn); // oComando.CommandType = CommandType.StoredProcedure; // oComando.Parameters.AddWithValue("@COD_ENTID", cod_tda); // oComando.Parameters.AddWithValue("@FECHA", fecha_des); // SqlDataReader oReader = oComando.ExecuteReader(CommandBehavior.SingleResult); // DataTable dataTable = new DataTable("row"); // dataTable.Load(oReader); // strJson = JsonConvert.SerializeObject(dataTable, Formatting.Indented); // strJson = strJson.Replace(Environment.NewLine, ""); // cn.Close(); // } // catch (Exception ex) // { // return strJson; // } // return strJson; //} //gft public List <Ent_Extender_NC> LisXCenter_NC(Ent_Extender_NC ent) { List <Ent_Extender_NC> Listar = new List <Ent_Extender_NC>(); string sqlquery = "[USP_XCENTER_GET_NOTAS_CREDITO]"; try { using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion)) { cn.Open(); using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TIENDA", DbType.String).Value = ent.Tienda; cmd.Parameters.AddWithValue("@NUM_DOC", DbType.String).Value = ent.Num_Doc; cmd.Parameters.AddWithValue("@FECHA_INI", DbType.DateTime).Value = ent.FechaInicio; cmd.Parameters.AddWithValue("@FECHA_FIN", DbType.DateTime).Value = ent.FechaFin; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); da.Fill(dt); Listar = new List <Ent_Extender_NC>(); Listar = (from DataRow fila in dt.Rows select new Ent_Extender_NC() { Serial_Nbr = (fila["Serial_Nbr"] is DBNull) ? string.Empty : (string)(fila["Serial_Nbr"]), Organization_Id = (fila["Organization_Id"] is DBNull) ? (int?)null : Convert.ToInt32(fila["Organization_Id"]), Rtl_Loc_Id = (fila["Rtl_Loc_Id"] is DBNull) ? (int?)null : Convert.ToInt32(fila["Rtl_Loc_Id"]), Wkstn_Id = (fila["Wkstn_Id"] is DBNull) ? (int?)null : Convert.ToInt32(fila["Wkstn_Id"]), Trans_Seq = (fila["Trans_Seq"] is DBNull) ? (int?)null : Convert.ToInt32(fila["Trans_Seq"]), String_Value = (fila["String_Value"] is DBNull) ? string.Empty : (string)(fila["String_Value"]), Business_Date = (fila["Business_Date"] is DBNull) ? (DateTime?)null : Convert.ToDateTime(fila["Business_Date"]), Expr_Date = (fila["Expr_Date"] is DBNull) ? (DateTime?)null : Convert.ToDateTime(fila["Expr_Date"]) } ).ToList(); } } } } catch (Exception ex) { throw new Exception(ex.Message); } return(Listar); }
public bool UpExtender_NC(Ent_Extender_NC ent, ref string Estado) { bool result = false; string sqlquery = "USP_XCENTER_EXTENDER_NOTAS_CREDITO"; SqlConnection cn = null; SqlCommand cmd = null; try { cn = new SqlConnection(Ent_Conexion.conexion); if (cn.State == 0) { cn.Open(); } cmd = new SqlCommand(sqlquery, cn); cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TIENDA", ent.Rtl_Loc_Id); cmd.Parameters.AddWithValue("@NUM_NC", ent.String_Value); cmd.Parameters.AddWithValue("@FEC_NC", ent.Business_Date); cmd.Parameters.AddWithValue("@NEW_FECHA", ent.New_Expr_Date); cmd.Parameters.Add("@ESTADO", SqlDbType.VarChar, 30); cmd.Parameters["@ESTADO"].Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); Estado = cmd.Parameters["@ESTADO"].Value.ToString(); result = true; } catch (Exception exc) { result = false; } if (cn.State == ConnectionState.Open) { cn.Close(); } return(result); }
public JsonResult getLisXCenter_NC(Ent_jQueryDataTableParams param, string FechaInicio, string FechaFin, string Tienda, string Num_Doc, bool isOkUpdate) { Ent_Extender_NC _ent = new Ent_Extender_NC(); _ent.Tienda = Tienda; _ent.Num_Doc = Num_Doc; _ent.FechaInicio = DateTime.Parse(FechaInicio); _ent.FechaFin = DateTime.Parse(FechaFin); if (isOkUpdate) { Session[_session_LisXCenter_NC] = datGuia.LisXCenter_NC(_ent).ToList(); } /*verificar si esta null*/ if (Session[_session_LisXCenter_NC] == null) { List <Ent_Extender_NC> ListarXCenter_NC = new List <Ent_Extender_NC>(); Session[_session_LisXCenter_NC] = ListarXCenter_NC; } IQueryable <Ent_Extender_NC> entDocTrans = ((List <Ent_Extender_NC>)(Session[_session_LisXCenter_NC])).AsQueryable(); //Manejador de filtros int totalCount = entDocTrans.Count(); IEnumerable <Ent_Extender_NC> filteredMembers = entDocTrans; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = entDocTrans .Where(m => m.Serial_Nbr.ToUpper().Contains(param.sSearch.ToUpper()) || m.String_Value.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de ordene var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); if (param.iSortingCols > 0) { if (Request["sSortDir_0"].ToString() == "asc") { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderBy(o => o.Serial_Nbr); break; case 1: filteredMembers = filteredMembers.OrderBy(o => o.Organization_Id); break; case 2: filteredMembers = filteredMembers.OrderBy(o => o.Rtl_Loc_Id); break; case 3: filteredMembers = filteredMembers.OrderBy(o => o.Wkstn_Id); break; case 4: filteredMembers = filteredMembers.OrderBy(o => o.Trans_Seq); break; case 5: filteredMembers = filteredMembers.OrderBy(o => o.String_Value); break; case 6: filteredMembers = filteredMembers.OrderBy(o => o.Business_Date); break; case 7: filteredMembers = filteredMembers.OrderBy(o => o.Expr_Date); break; } } else { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderByDescending(o => o.Serial_Nbr); break; case 1: filteredMembers = filteredMembers.OrderByDescending(o => o.Organization_Id); break; case 2: filteredMembers = filteredMembers.OrderByDescending(o => o.Rtl_Loc_Id); break; case 3: filteredMembers = filteredMembers.OrderByDescending(o => o.Wkstn_Id); break; case 4: filteredMembers = filteredMembers.OrderByDescending(o => o.Trans_Seq); break; case 5: filteredMembers = filteredMembers.OrderByDescending(o => o.String_Value); break; case 6: filteredMembers = filteredMembers.OrderByDescending(o => o.Business_Date); break; case 7: filteredMembers = filteredMembers.OrderByDescending(o => o.Expr_Date); break; } } } var Result = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = Result }, JsonRequestBehavior.AllowGet)); }