// public string anio { get; set; }
public bool checkAll(string con)
{
MessageViewModel mv = new MessageViewModel();
//string con = @"Server=LAYER-PC\TTEST; Database=SAFC_ECB; User Id=profit; Password = profit";
string sql = @"SELECT top(1) Ase_cNummov , Ase_nVoucher
FROM CNC_ASIENTO_VOUCHER
WHERE Emp_cCodigo = '003'
AND Pan_cAnio = '" + Anio +
"' AND Per_cPeriodo = '" + Periodo +
"' AND Lib_cTipoLibro = '" + Libro +
"' AND Ase_cGlosa = '" + Glosa + "'" +
" ORDER BY Ase_nVoucher desc";
try
{
Conexion cn = new Conexion(con);
SqlDataReader reader = cn.consulta3(sql);
if (reader.HasRows)
{
while (reader.Read())
{
mv.Message = "Ya existe un Asiento \n" + "Nro. Voucher: " + reader.GetSqlValue(1).ToString() + "\n" + " Descripcion: " + Glosa;
mv.Caption = "Titulo";
mv.mensajeria();
}
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
mv.Message = mv.ToStringAllExceptionDetails(e);
mv.Caption = "Error sql";
mv.mensajeria();
return(true);
}
}
public ObservableCollection <mVentas> agregarData(string data, string con, int codTienda, object sender)
{
MessageViewModel mv = new MessageViewModel();
// DataGrid dgv1 = dgVenta as DataGrid;
ComboBox cb = sender as ComboBox;
string fechaDia = cb.SelectedValue.ToString();
decimal total = 0;
string tienda;
string buscarTienda;
if (codTienda == 1)
{
tienda = "B001";
buscarTienda = "01";
}
else if (codTienda == 2)
{
tienda = "B002";
buscarTienda = "02";
}
else if (codTienda == 3)
{
tienda = "B003";
buscarTienda = "05";
}
else
{
tienda = "B004";
buscarTienda = "05";
}
string sql;
try
{
Conexion cn = new Conexion(con);
sql = @"SELECT A.NUMFACTURA AS NUMERO,0 AS total,0 as totiva,0 as totreq, 0 as baseimponibre FROM FACTURASVENTA AS A
where a.FECHAENTRADA = '" + fechaDia + "' and a.NUMSERIE = '" + tienda + "' and a.TOTALNETO = 0 ";
sql = sql + @" union
SELECT numero,total,totiva,totreq,baseimponible
from FACTURASVENTA b right outer join FACTURASVENTATOT a on a.NUMERO = b.NUMFACTURA and a.SERIE = b.NUMSERIE
where b.FECHAENTRADA = '" + fechaDia + "' and a.SERIE = '" + tienda + "' order by NUMERO";
SqlDataReader reader = cn.consulta3(sql);
if (reader.HasRows)
{
while (reader.Read())
{
venta.Add(new mVentas("12121", buscarTienda, (reader.GetInt32(0)).ToString(), Convert.ToDecimal(reader.GetValue(1)), 0)
{
cuenta = "12121", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = Convert.ToDecimal(reader.GetValue(1)), haber = 0
});
venta.Add(new mVentas("40111", buscarTienda, (reader.GetInt32(0)).ToString(), 0, Convert.ToDecimal(reader.GetValue(2)))
{
cuenta = "40111", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = 0, haber = Convert.ToDecimal(reader.GetValue(2))
});
venta.Add(new mVentas("40997", buscarTienda, (reader.GetInt32(0)).ToString(), 0, Convert.ToDecimal(reader.GetValue(3)))
{
cuenta = "40997", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = 0, haber = Convert.ToDecimal(reader.GetValue(3))
});
venta.Add(new mVentas("40111", buscarTienda, (reader.GetInt32(0)).ToString(), 0, Convert.ToDecimal(reader.GetValue(4)))
{
cuenta = "70111", serie = buscarTienda, numero = (reader.GetInt32(0)).ToString(), debe = 0, haber = Convert.ToDecimal(reader.GetValue(4))
});
}
total = venta.Sum(x => x.cuenta == "12121" ? x.debe : 0);
}
}
catch (Exception e)
{
mv.Message = mv.ToStringAllExceptionDetails(e);
mv.Caption = "Error sql";
mv.mensajeria();
}
return(venta);
}