/*
* public static List<DetalleDocumento> GetDetalleFromMove(int moveId)
* {
* List<DetalleDocumento> DetallesToRetrieve = new List<DetalleDocumento>();
*
* MySqlConnection connection = null;
*
* connection = new MySqlConnection(ConnectionConfig.connectionString);
* Console.WriteLine(ConnectionConfig.connectionString);
* MySqlCommand command = connection.CreateCommand();
* command.CommandText = "SELECT " +
* "it_tdetamove.Move_Deta_ITEM_ID, " +
* "it_titem.ITEM_Sale_Price, " +
* "it_titem.ITEM_Description, " +
* "it_tdetamove.Move_Deta_price, " +
* "it_tdetamove.Move_Deta_price, " +
* "it_tdetamove.Move_Deta_Q, " +
* "it_tunit.UNIT_Name, " +
* //"# Cosas para sacar el descuento " +
* "it_tdetamove.On_Sale, " +
* "it_tdetamove.Discount_Code, " +
* "it_tdetamove.Move_REG_price, " +
* //"# it_tdetamove.Move_Deta_price - it_tdetamove.Move_REG_price " +
* "it_tdetamove.Move_Deta_Tax_Value, " +
* "it_tdetamove.Move_Deta_Tax2_Value, " +
* "(it_tdetamove.Move_Deta_Q * it_titem.ITEM_Sale_Price) AS 'Total', " +
* "(it_tdetamove.Move_Deta_Q * it_titem.ITEM_Sale_Price) -it_tdetamove.Move_Deta_Tax_Value-it_tdetamove.Move_Deta_Tax2_Value AS 'Suma' " +
* "FROM it_tdetamove " +
* "INNER JOIN it_titem ON it_tdetamove.Move_Deta_ITEM_ID = it_titem.ITEM_ID " +
* "INNER JOIN it_tunit ON it_tunit.UNIT_ID = it_titem.ITEM_Unit_ID " +
* "WHERE it_tdetamove.modi = 0 " +
* "AND it_tdetamove.Subitem_of = 0 " +
* "AND it_tdetamove.Move_Deta_Move_ID = " + moveId + ";";
* MySqlDataReader Reader;
* Console.WriteLine(command.CommandText);
* connection.Open();
* Reader = command.ExecuteReader();
* int i = 0;
* while (Reader.Read())
* {
* string Move_Deta_ID = Reader.GetString("Move_Deta_ITEM_ID");
* string Descripcion = Reader.GetString("ITEM_Description");
* decimal PrecioUnitario = Reader.GetInt32("Move_Deta_price");
* decimal PrecioReferencial = Reader.GetInt32("Move_Deta_price");
* decimal Cantidad = Reader.GetInt32("Move_Deta_Q");
* string UnidadMedida = Reader.GetString("UNIT_Name");
* //AQUI CALCULA
* decimal Descuento = Reader.GetInt32("Move_Deta_Q");
*
* decimal Impuesto = Reader.GetInt32("Move_Deta_Tax_Value");
* decimal OtroImpuesto = Reader.GetInt32("Move_Deta_Tax2_Value");
* decimal TotalVenta = Reader.GetInt32("Total");
* decimal Suma = Reader.GetInt32("Suma");
*
* DetalleDocumento deta = new DetalleDocumento()
* {
* Id = i++,
* CodigoItem = Move_Deta_ID,
* Descripcion = Descripcion,
* PrecioUnitario = PrecioUnitario,
* PrecioReferencial = PrecioReferencial,
* TipoPrecio = "01: Precio unitario Incluye IGV",
* Cantidad = Cantidad,
*
* UnidadMedida = UnidadMedida,
* Descuento = Descuento,
* Impuesto = Impuesto, //IGV
* TipoImpuesto = "10: Gravado - Operación Onerosa",
* //ImpuestoSelectivo = 1.0m, //ISC
* OtroImpuesto = OtroImpuesto, // RC
* TotalVenta = TotalVenta,
* Suma = Suma, // precio unitario * cantidad
* };
* DetallesToRetrieve.Add(deta);
* }
*
* Reader.Close();
*
* return DetallesToRetrieve;
* }*/
public static DetasPlusTaxes GetDETFromMove(int moveId)
{
DetasPlusTaxes detasPlusTaxes = new DetasPlusTaxes();
List <DET> DetallesToRetrieve = new List <DET>();
decimal grabadas = 0.0m;
decimal nograbadas = 0.0m;
decimal exoneradas = 0.0m;
decimal gratuitas = 0.0m;
MySqlConnection connection = null;
connection = new MySqlConnection(ConnectionConfig.connectionString);
Console.WriteLine(ConnectionConfig.connectionString);
MySqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT " +
"it_tdetamove.Move_Deta_ITEM_ID, " +
"it_titem.ITEM_Sale_Price, " +
"it_titem.ITEM_Description, " +
"it_tdetamove.Move_Deta_price, " +
"it_tdetamove.Move_Deta_price, " +
"it_tdetamove.Move_Deta_Q, " +
"it_tunit.UNIT_Name, " +
//"# Cosas para sacar el descuento " +
"it_tdetamove.On_Sale, " +
"it_tdetamove.Discount_Code, " +
"it_tdetamove.Move_REG_price, " +
"it_tdetamove.Discount_Code, " +
"it_tcategory.TAXPERC, " +
"it_tcategory.TAXPERC2, " +
"it_tcategory.TAXPERC3," +
//"# it_tdetamove.Move_Deta_price - it_tdetamove.Move_REG_price " +
"it_tdetamove.Move_Deta_Tax_Value, " +
"it_tdetamove.Move_Deta_Tax2_Value, " +
"(it_tdetamove.Move_Deta_Q * it_titem.ITEM_Sale_Price) AS 'Total', " +
"(it_tdetamove.Move_Deta_Q * it_titem.ITEM_Sale_Price) -it_tdetamove.Move_Deta_Tax_Value-it_tdetamove.Move_Deta_Tax2_Value AS 'Suma' " +
"FROM it_tdetamove " +
"INNER JOIN it_titem ON it_tdetamove.Move_Deta_ITEM_ID = it_titem.ITEM_ID " +
"INNER JOIN it_tunit ON it_tunit.UNIT_ID = it_titem.ITEM_Unit_ID " +
"INNER JOIN it_tcategory ON it_tcategory.Cate_ID = it_titem.ITEM_Cate_ID " +
"WHERE it_tdetamove.modi = 0 " +
"AND it_tdetamove.Subitem_of = 0 " +
"AND it_tdetamove.Move_Deta_Move_ID = " + moveId + ";";
MySqlDataReader Reader;
Console.WriteLine(command.CommandText);
connection.Open();
Reader = command.ExecuteReader();
int i = 0;
while (Reader.Read())
{
string Move_Deta_ID = Reader.GetString("Move_Deta_ITEM_ID");
string Descripcion = Reader.GetString("ITEM_Description");
decimal PrecioUnitario = Reader.GetInt32("Move_Deta_price");
decimal PrecioReferencial = Reader.GetInt32("Move_Deta_price");
decimal Cantidad = Reader.GetInt32("Move_Deta_Q");
string UnidadMedida = Reader.GetString("UNIT_Name");
//AQUI CALCULA
decimal Descuento = Reader.GetInt32("Move_Deta_Q");
string DiscountCode = HelpersDatabase.GetString(Reader, "Discount_Code");
decimal Impuesto = Reader.GetInt32("Move_Deta_Tax_Value");
decimal OtroImpuesto = Reader.GetInt32("Move_Deta_Tax2_Value");
decimal TotalVenta = Reader.GetInt32("Total");
decimal Suma = Reader.GetInt32("Suma");
decimal TAX1 = HelpersDatabase.GetDecimal(Reader, "TAXPERC");
decimal TAX2 = HelpersDatabase.GetDecimal(Reader, "TAXPERC2");
decimal TAX3 = HelpersDatabase.GetDecimal(Reader, "TAXPERC3");
if (!string.IsNullOrEmpty(DiscountCode))
{
if (CheckDicountCode(DiscountCode))
{
gratuitas = TotalVenta;
}
}
else if (TAX1 == 0.0m)
{
grabadas = TotalVenta;
}
else
{
nograbadas = TotalVenta;
}/*
* else if (TAX3 == 0.0m)
* {
* exoneradas++;
* }*/
DET dET = new DET()
{
numeroItem = i++.ToString(),
codigoProducto = Move_Deta_ID,
descripcionProducto = Descripcion,
cantidadItems = Cantidad.ToString(),
unidad = UnidadMedida,
valorUnitario = PrecioUnitario.ToString(),
precioVentaUnitario = PrecioUnitario.ToString(),
totalImpuestos = new List <TotalImpuesto>()
{
new TotalImpuesto()
{
idImpuesto = "1000", montoImpuesto = Impuesto.ToString(), tipoAfectacion = "10"
}, //IGV
new TotalImpuesto()
{
idImpuesto = "2000", montoImpuesto = OtroImpuesto.ToString(), tipoAfectacion = "10"
}, //RC
},
valorVenta = TotalVenta.ToString(),
};
DetallesToRetrieve.Add(dET);
}
Reader.Close();
detasPlusTaxes = new DetasPlusTaxes()
{
grabadas = grabadas,
gratuitas = gratuitas,
exoneradas = exoneradas,
nograbada = nograbadas,
DET = DetallesToRetrieve
};
return(detasPlusTaxes);
}
public static void GetDocumentoFromMove(int moveId)
{
MySqlConnection connection = null;
connection = new MySqlConnection(ConnectionConfig.connectionString);
Console.WriteLine(ConnectionConfig.connectionString);
MySqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT " +
"it_tmove.Docu_type_ID AS 'TipoDocumento', " +
//Receptor
"fl_tcustomer.TaxExemptNo, " +
"fl_tcustomer.SS_NO, " +
"idtypes.Codigo AS 'Tipo_Doc_Receptor', " +
"Company_Name, " +
"Cust_name, " +
"it_tmove.Move_wic_Value, " +
"it_tmove.Money_Conv, " +
"it_tmove.Ticket_count AS 'IdDocumento', " +
"it_tmove.Move_Date AS 'FechaEmision', " +
"SUM(it_tdetamove.Move_Deta_Tax_Value) AS 'TotalIgv', " +
"SUM(it_tdetamove.Move_Deta_Tax2_Value) AS 'TotalIsc', " +
"SUM((it_tdetamove.Move_Deta_Q * it_tdetamove.Move_Deta_price)) AS 'TotalVenta' " +
"FROM it_tmove " +
"LEFT JOIN fl_tcustomer ON it_tmove.Cust_Id = fl_tcustomer.Cust_ID " +
"INNER JOIN it_tdetamove ON it_tdetamove.Move_Deta_Move_ID = it_tmove.Move_ID " +
"LEFT JOIN idtypes ON idtypes.TYPE_ID = fl_tcustomer.IDType " +
"WHERE it_tmove.Move_ID = " + moveId + " " +
"GROUP BY NULL;";
MySqlDataReader Reader;
Console.WriteLine(command.CommandText);
connection.Open();
Reader = command.ExecuteReader();
int i = 0;
while (Reader.Read())
{
string TipoDocumento = HelpersDatabase.GetString(Reader, "TipoDocumento");
string TaxExemptNo = HelpersDatabase.GetString(Reader, "TaxExemptNo");
string SS_NO = HelpersDatabase.GetString(Reader, "SS_NO");
string Tipo_Doc_Receptor = HelpersDatabase.GetString(Reader, "Tipo_Doc_Receptor");
string Company_Name = HelpersDatabase.GetString(Reader, "Company_Name");
string Cust_name = HelpersDatabase.GetString(Reader, "Cust_name");
decimal PrecioUnitario = HelpersDatabase.GetInt(Reader, "Move_wic_Value");
decimal Money_Conv = HelpersDatabase.GetInt(Reader, "Money_Conv");
string IdDocumento = HelpersDatabase.GetString(Reader, "IdDocumento");
string FechaEmision = HelpersDatabase.GetDate(Reader, "FechaEmision");
string HoraEmision = HelpersDatabase.GetTime(Reader, "FechaEmision");
decimal TotalIgv = Reader.GetInt32("TotalIgv");
decimal TotalIsc = Reader.GetInt32("TotalIsc");
decimal TotalVenta = Reader.GetInt32("TotalVenta");
string NombreLegal;
string NroDocumento;
DetasPlusTaxes detasPlusTaxes = GetDETFromMove(moveId);
if (string.IsNullOrEmpty(Company_Name) && string.IsNullOrEmpty(TaxExemptNo))
{
NombreLegal = Cust_name;
NroDocumento = SS_NO;
}
else
{
NombreLegal = Company_Name;
NroDocumento = TaxExemptNo;
}
string Moneda;
if (PrecioUnitario == 0 && Money_Conv == 0)
{
Moneda = "PEN";
}
else
{
Moneda = "USD";
}
IDE iDE = new IDE()
{
numeracion = IdDocumento,
fechaEmision = FechaEmision,
horaEmision = HoraEmision,
codTipoDocumento = TipoDocumento,
tipoMoneda = Moneda,
//numeroOrdenCompra = "",
//fechaVencimiento = "",
};
EMI eMI = new EMI()
{
//codigoPais = "",
//correoElectronico = "",
tipoDocId = "6",//falta
departamento = Settings.Default.emDepartamento,
direccion = Settings.Default.emDireccion,
distrito = Settings.Default.emDistrito,
nombreComercial = Settings.Default.emNombreComercial,
numeroDocId = Settings.Default.emRUC,
provincia = Settings.Default.emProvincia,
razonSocial = Settings.Default.emNombreLegal,
//telefono = "",
ubigeo = Settings.Default.emUbigeo,
urbanizacion = Settings.Default.emUrbanizacion,
};
DRF dRF = new DRF()
{
numeroDocRelacionado = "",
tipoDocRelacionado = "",
};
CAB cAB = new CAB()
{
gravadas = new Gravadas()
{
codigo = "1002",
totalVentas = ""
},
inafectas = new Inafectas()
{
codigo = "1004",
totalVentas = ""
},
importeTotal = TotalVenta.ToString(),
leyenda = new List <Leyenda>()
{
new Leyenda()
{
codigo = "1000",
descripcion = Conversores.NumeroALetras(TotalVenta)
}
},
tipoOperacion = "01",
totalImpuestos = new List <TotalImpuesto>()
{
new TotalImpuesto()
{
idImpuesto = "1000", montoImpuesto = TotalIgv.ToString()
}, //IGV
new TotalImpuesto()
{
idImpuesto = "2000", montoImpuesto = TotalIsc.ToString()
} //ISC
}
};
REC rEC = new REC()
{
//codigoPais = "",
//correoElectronico = "",
//departamento = "",
//direccion = "",
//distrito = "",
numeroDocId = NroDocumento,
//provincia = "",
razonSocial = NombreLegal,
//telefono = "",
tipoDocId = Tipo_Doc_Receptor,
};
//GetDETFromMove(moveId),
string output;
if (TipoDocumento == "1")
{
Factura fac = new Factura()
{
IDE = iDE,
EMI = eMI,
REC = rEC,
//DRF = ,
CAB = cAB,
DET = GetDETFromMove(moveId).DET,
//ADI
};
output = JsonConvert.SerializeObject(fac,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore
});
}
else
{
Boleta bol = new Boleta()
{
IDE = iDE,
EMI = eMI,
REC = rEC,
//DRF = ,
CAB = cAB,
DET = GetDETFromMove(moveId).DET,
//ADI
};
output = JsonConvert.SerializeObject(bol,
new JsonSerializerSettings
{
NullValueHandling = NullValueHandling.Ignore,
});
}
Console.WriteLine(output);
}
Reader.Close();
}
