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