public ActionResult ListarNotasdeDetalle(int nvNumero)
{
try
{
NotadeVentaCabeceraModels NVC = new NotadeVentaCabeceraModels();
List <NotadeVentaCabeceraModels> NVCL = new List <NotadeVentaCabeceraModels>();
NotaDeVentaDetalleModels NVD = new NotaDeVentaDetalleModels();
List <NotaDeVentaDetalleModels> NVDL = new List <NotaDeVentaDetalleModels>();
NVC.NVNumero = nvNumero;
NVD.NVNumero = nvNumero;
var listaNVD = ReporteDAO.ListarNotaDetalle(NVD);
if (listaNVD != null)
{
NVDL = listaNVD;
}
ViewBag.NVDL = NVDL;
return(View());
}
catch (Exception ex)
{
return(View(ex.Message));
}
}
public List <NotaDeVentaDetalleModels> DatosCorreoVend(int NvNUmero)
{
var DatosUser = new List <NotaDeVentaDetalleModels>();
var data = new DBConector().EjecutarProcedimientoAlmacenado("SP_GET_DatosCorreoVend", new System.Collections.Hashtable()
{
{ "NvNumero", NvNUmero }
});
if (data.Rows.Count > 0)
{
for (var i = 0; i < data.Rows.Count; i++)
{
var validador = new object();
var resultadoListado = new NotaDeVentaDetalleModels();
validador = data.Rows[i].Field <object>("email");
resultadoListado.EmailVend = validador != null ? data.Rows[i].Field <string>("email") : "NO ASIGNADO";
validador = data.Rows[i].Field <object>("ContrasenaCorreo");
resultadoListado.PassCorreo = validador != null ? data.Rows[i].Field <string>("ContrasenaCorreo") : "NO ASIGNADO";
DatosUser.Add(resultadoListado);
}
}
return(DatosUser);
}
public void Detallenv(string CodProd, string DetProd, double nvCant, string CodUMed, double nvPrecio, string CodLista,
double nvSubTotal, double nvTotLinea, int NVNumero, double nvLinea, DateTime nvFecCompr)
{
double porcentajefinal = 0;
double descuento = 0;
if (nvTotLinea != nvSubTotal)
{
porcentajefinal = 100 - ((nvTotLinea * 100) / nvSubTotal);
descuento = nvSubTotal - nvTotLinea;
}
#region "NVD"
var NVD = new NotaDeVentaDetalleModels
{
CodProd = CodProd,
NVNumero = NVNumero,
nvLinea = nvLinea,
nvCorrela = 0,
nvFecCompr = nvFecCompr,
nvCant = nvCant,
nvPrecio = nvPrecio,
nvEquiv = 1,
nvSubTotal = nvSubTotal,
nvDPorcDesc01 = porcentajefinal,
nvDDescto01 = descuento,
nvDPorcDesc02 = 0,
nvDDescto02 = 0,
nvDPorcDesc03 = 0,
nvDDescto03 = 0,
nvDPorcDesc04 = 0,
nvDDescto04 = 0,
nvDPorcDesc05 = 0,
nvDDescto05 = 0,
nvTotDesc = 0,
nvTotLinea = nvTotLinea,
nvCantDesp = 0,
nvCantProd = 0,
nvCantFact = 0,
nvCantDevuelto = 0,
nvCantNC = 0,
nvCantBoleta = 0,
nvCantOC = 0,
DetProd = DetProd,
CheckeoMovporAlarmaVtas = "N",
KIT = "",
CodPromocion = 0,
CodUMed = CodUMed,
CantUVta = nvCant,
Partida = "",
Pieza = ""
};
#endregion
List <NotaDeVentaDetalleModels> nv = NotaDeVentaDAO.DetalleNV(NVD);
}
public static List <NotaDeVentaDetalleModels> DetalleNV(NotaDeVentaDetalleModels NVD)
{
try
{
using (DataContext dc = new DataContext(catalogo, "FR_AgregarNVDetalle", CommandType.StoredProcedure))
{
dc.parameters.AddWithValue("NVNumero", NVD.NVNumero);
dc.parameters.AddWithValue("nvLinea", NVD.nvLinea);
dc.parameters.AddWithValue("nvCorrela", NVD.nvCorrela);
dc.parameters.AddWithValue("nvFecCompr", NVD.nvFecCompr);
dc.parameters.AddWithValue("CodProd", NVD.CodProd);
dc.parameters.AddWithValue("nvCant", NVD.nvCant);
dc.parameters.AddWithValue("nvPrecio", NVD.nvPrecio);
dc.parameters.AddWithValue("nvEquiv", NVD.nvEquiv);
dc.parameters.AddWithValue("nvSubTotal", NVD.nvSubTotal);
dc.parameters.AddWithValue("nvDPorcDesc01", NVD.nvDPorcDesc01);
dc.parameters.AddWithValue("nvDDescto01", NVD.nvDDescto01);
dc.parameters.AddWithValue("nvDPorcDesc02", NVD.nvDPorcDesc02);
dc.parameters.AddWithValue("nvDDescto02", NVD.nvDDescto02);
dc.parameters.AddWithValue("nvDPorcDesc03", NVD.nvDPorcDesc03);
dc.parameters.AddWithValue("nvDDescto03", NVD.nvDDescto03);
dc.parameters.AddWithValue("nvDPorcDesc04", NVD.nvDPorcDesc04);
dc.parameters.AddWithValue("nvDDescto04", NVD.nvDDescto04);
dc.parameters.AddWithValue("nvDPorcDesc05", NVD.nvDPorcDesc05);
dc.parameters.AddWithValue("nvDDescto05", NVD.nvDDescto05);
dc.parameters.AddWithValue("nvTotDesc", NVD.nvTotDesc);
dc.parameters.AddWithValue("nvTotLinea", NVD.nvTotLinea);
dc.parameters.AddWithValue("nvCantDesp", NVD.nvCantDesp);
dc.parameters.AddWithValue("nvCantProd", NVD.nvCantProd);
dc.parameters.AddWithValue("nvCantFact", NVD.nvCantFact);
dc.parameters.AddWithValue("nvCantDevuelto", NVD.nvCantDevuelto);
dc.parameters.AddWithValue("nvCantNC", NVD.nvCantNC);
dc.parameters.AddWithValue("nvCantBoleta", NVD.nvCantBoleta);
dc.parameters.AddWithValue("nvCantOC", NVD.nvCantOC);
dc.parameters.AddWithValue("DetProd", NVD.DetProd);
dc.parameters.AddWithValue("CheckeoMovporAlarmaVtas", NVD.CheckeoMovporAlarmaVtas);
dc.parameters.AddWithValue("KIT", NVD.KIT);
dc.parameters.AddWithValue("CodPromocion", NVD.CodPromocion);
dc.parameters.AddWithValue("CodUMed", NVD.CodUMed);
dc.parameters.AddWithValue("CantUVta", NVD.CantUVta);
dc.parameters.AddWithValue("Partida", NVD.Partida);
dc.parameters.AddWithValue("Pieza", NVD.Pieza);
return(dc.executeQuery <NotaDeVentaDetalleModels>());
}
}
catch (Exception ex)
{
string error = ex.ToString();
return(null);
}
}
public static List <NotaDeVentaDetalleModels> ListarNotaDetalle(NotaDeVentaDetalleModels nw)
{
try
{
using (DataContext dc = new DataContext(catalogo, "FR_ListarNVDetalleStock", CommandType.StoredProcedure))
{
dc.parameters.AddWithValue("nvNumero", nw.NVNumero);
return(dc.executeQuery <NotaDeVentaDetalleModels>());
}
}
catch (Exception ex)
{
string error = ex.ToString();
return(null);
}
}
public ActionResult VerDetalleNV(int nvNumero)
{
try
{
NotadeVentaCabeceraModels NVC = new NotadeVentaCabeceraModels();
List <NotadeVentaCabeceraModels> NVCL = new List <NotadeVentaCabeceraModels>();
NotaDeVentaDetalleModels NVD = new NotaDeVentaDetalleModels();
List <NotaDeVentaDetalleModels> NVDL = new List <NotaDeVentaDetalleModels>();
NVC.NVNumero = nvNumero;
NVD.NVNumero = nvNumero;
var nvc = ReporteDAO.BuscarNVC(NVC);
if (nvc != null)
{
NVCL = nvc;
}
else
{
ViewBag.mensaje = 1;
ViewBag.NVnum = nvNumero;
return(View());
}
ViewBag.cabecera = NVCL;
var nvd = ReporteDAO.BuscarNVD(NVD);
if (nvd != null)
{
NVDL = nvd;
}
ViewBag.detalle = NVDL;
return(View());
}
catch (Exception ex)
{
return(View(ex.Message));
}
}
