public ActionResult Editar(int id)
{
List <Ent_Tda_Xstore> tdas = datOE.tiendatipo_xstore();
Session[_session_tdas_xstore] = tdas;
Session[_session_lista_articulos] = null;
Session[_session_art_excel] = null;
Session[_session_cant_art_atr] = null;
ViewBag.listCadena = tdas.Select(s => new { s.cod_cadena, s.des_cadena }).Distinct();
List <Ent_Orce_Inter_Det_Tda> _detTdas = datOE.get_lista_det_tdas(id.ToString());
var tipoTdas = tdas.Where(w => _detTdas.Select(s => s.ORC_DET_TDA).Contains(w.cod_entid)).Select(s => s.tiptda_cod).Distinct();
ViewBag.listTipoTda = tdas.Where(w => _detTdas.Select(s => s.ORC_DET_TDA_CAD).Contains(w.cod_cadena)).Select(s => new { s.tiptda_cod, s.tiptda_des }).Distinct().ToList();
ViewBag.listTdaCadena = tdas.Where(w =>
_detTdas.Select(s => s.ORC_DET_TDA_CAD).Contains(w.cod_cadena) &&
tipoTdas.Contains(w.tiptda_cod)
).Select(s => new { s.cod_entid, s.des_entid }).Distinct().ToList();
ViewBag.listAtr = datOE.get_atributos();
ViewBag.tipoTdaSelected = tipoTdas;
Ent_Orce_Inter_Cab model = new Ent_Orce_Inter_Cab();
model = ((List <Ent_Orce_Inter_Cab>)Session[_session_lista_orce]).Where(d => d.ORC_COD == id).First();
model.TIENDAS = _detTdas;
Session[_session_lista_articulos] = datOE.get_lista_det_art(model.ORC_COD.ToString());
Session[_session_atribuo_actual] = model.ORC_ATRIBUTO;
return(View(model));
}
public ActionResult Nuevo()
{
List <Ent_Tda_Xstore> tdas = datOE.tiendatipo_xstore();
Session[_session_tdas_xstore] = tdas;
ViewBag.listCadena = tdas.Select(s => new { s.cod_cadena, s.des_cadena }).Distinct();
Session[_session_lista_articulos] = null;
Session[_session_art_excel] = null;
Session[_session_cant_art_atr] = null;
// Session[_session_atribuo_actual] = null;
//ViewBag.listCadena = datOE.get_cadena();
ViewBag.listAtr = datOE.get_atributos();
ViewBag.listTipoTda = new List <Ent_Tda_Xstore>();
ViewBag.listTdaCadena = new List <Ent_Tda_Xstore>();
ViewBag.idOrce = Session[_session_ultimo_cod_orce];
Ent_Orce_Inter_Cab model = new Ent_Orce_Inter_Cab();
model.TIENDAS = new List <Ent_Orce_Inter_Det_Tda>();
return(View(model));
}
public List <Ent_Orce_Inter_Cab> get_lista_orce_exlude()
{
List <Ent_Orce_Inter_Cab> list = null;
string sqlquery = "[USP_ORCE_GET_INTERFACE_CAB]";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Orce_Inter_Cab>();
while (dr.Read())
{
Ent_Orce_Inter_Cab cab = new Ent_Orce_Inter_Cab();
cab.ORC_COD = Convert.ToInt32(dr["ORC_COD"]);
cab.ORC_DESCRIPCION = dr["ORC_DESCRIPCION"].ToString();
cab.ORC_ATRIBUTO = dr["ORC_ATRIBUTO"].ToString();
cab.ORC_ENVIADO = Convert.ToBoolean(dr["ORC_ENVIADO"]);
cab.ORC_FEC_ENV = (String.IsNullOrEmpty(dr["ORC_FEC_ENV"].ToString()) ? "" : Convert.ToDateTime(dr["ORC_FEC_ENV"]).ToString("dd-MM-yyyy HH:mm"));
cab.ORC_EST_ID = dr["ORC_EST_ID"].ToString();
cab.ORC_FECHA_ING = (String.IsNullOrEmpty(dr["ORC_FECHA_ING"].ToString()) ? "" : Convert.ToDateTime(dr["ORC_FECHA_ING"]).ToString("dd-MM-yyyy HH:mm")); //Convert.ToDateTime(dr["ORC_FECHA_ING"]);
cab.ORC_FECHA_ACT = (String.IsNullOrEmpty(dr["ORC_FECHA_ACT"].ToString()) ? "" : Convert.ToDateTime(dr["ORC_FECHA_ACT"]).ToString("dd-MM-yyyy HH:mm")); //Convert.ToDateTime(dr["ORC_FECHA_ACT"]);
cab.EST_ORC_DES = dr["Est_Orc_Des"].ToString();
list.Add(cab);
}
}
}
}
}
catch (Exception ex)
{
list = null;
}
return(list);
}
