public static string[] liquidation(string _co, string _ordersChain, Transporters_Guides shipping, string _newStatus, Decimal _varpercepcion)
{
string[] resultDoc = new string[2];
return(resultDoc);
//string sqlCommand = "logistica.sp_createliquidation";
//try
//{
// //
// Database db = DatabaseFactory.CreateDatabase(_conn);
// DbCommand dbCommandWrapper = db.GetStoredProcCommand(sqlCommand);
// // Comenzar una transaccion y si todo resulta bien cerrarla realizando los cambios en la base de datos
// using (DbConnection connection = db.CreateConnection())
// {
// connection.Open();
// DbTransaction transaction = connection.BeginTransaction();
// try
// {
// /*PARAMETERS*/
// dbCommandWrapper = db.GetStoredProcCommand(sqlCommand, _co, _ordersChain, 0, _newStatus, _varpercepcion);
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// resultDoc[0] = db.GetParameterValue(dbCommandWrapper, "p_lhv_liquidation_no").ToString();
// //** Quitar cuando el sistema funcione con los cambios en la tabla transporters_guides
// if (shipping._configShipping)
// {
// /* Solo para cuando este activo la nueva creacion de guias*/
// // Registro info destinatario
// sqlCommand = "logistica.sp_addguide_shipping";
// //
// dbCommandWrapper = db.GetStoredProcCommand(sqlCommand, _co, 12, DBNull.Value, shipping._tgn_transport, shipping._tgv_name_cust, shipping._tgv_phone_cust,
// shipping._tgv_movil_cust, shipping._tgv_shipp_add, shipping._tgv_shipp_block, shipping._tgv_city, shipping._tgv_depto, resultDoc[0]);
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// }
// // Commit the transaction.
// transaction.Commit();
// }
// catch (Exception ex)
// {
// // Roll back the transaction.
// transaction.Rollback();
// resultDoc[0] = "-1";
// resultDoc[1] = ex.Message;//"-1";
// //return ex.Message;
// }
// connection.Close();
// }
//}
//catch (Exception ex)
//{
// resultDoc[0] = "-1";
// resultDoc[1] = ex.Message;
//}
//return resultDoc;
}
//
public static string[] saveOrder_And_Liquidation_POS_BL(string _co, decimal _idCust, string _reference, decimal _discCommPctg,
decimal _discCommValue, string _shipTo, string _specialInstr, List <Order_Dtl> _itemsDetail,
Transporters_Guides shipping, string _newStatus, string varNumTarjeta, string varNumVoucher,
decimal varMonto, decimal usuCre, String TipoPago, decimal _varpercepcion, string listdoc)
{
string[] resultDoc = new string[3];
return(resultDoc);
//try
//{
// Database db = DatabaseFactory.CreateDatabase(_conn);
// //string resultDoc = "";
// string sqlCommand = "logistica.sp_add_order_hdr";
// DbCommand dbCommandWrapper = db.GetStoredProcCommand(sqlCommand);
// // Recoleccion de la informacion necesaria para crear el registro de la cabecera del pedido
// db.AddInParameter(dbCommandWrapper, "p_ohv_co", DbType.String, _co);
// // Output parameters specify the size of the return data.
// db.AddOutParameter(dbCommandWrapper, "p_ohv_order_no", DbType.String, 12);
// // Id del promotor
// db.AddInParameter(dbCommandWrapper, "p_ohn_customer_id", DbType.Decimal, _idCust);
// db.AddInParameter(dbCommandWrapper, "p_ohv_reference", DbType.String, _reference);
// db.AddInParameter(dbCommandWrapper, "p_ohn_disc_comm_pctg", DbType.Decimal, _discCommPctg);
// db.AddInParameter(dbCommandWrapper, "p_ohn_disc_comm_value", DbType.Decimal, _discCommValue);
// db.AddInParameter(dbCommandWrapper, "p_ohv_ship_to", DbType.String, _shipTo);
// db.AddInParameter(dbCommandWrapper, "p_ohv_special_instr", DbType.String, _specialInstr);
// db.AddInParameter(dbCommandWrapper, "p_ohv_Percepcion", DbType.Decimal, _varpercepcion);
// // Comenzar una transaccion y si todo resulta bien cerrarla realizando los cambios en la base de datos
// using (DbConnection connection = db.CreateConnection())
// {
// connection.Open();
// DbTransaction transaction = connection.BeginTransaction();
// try
// {
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// resultDoc[0] = (string)db.GetParameterValue(dbCommandWrapper, "p_ohv_order_no");
// int i = 1;
// // Recorrer todas las lineas adicionAQUARELLAs al detalle
// foreach (Order_Dtl item in _itemsDetail)
// {
// sqlCommand = "logistica.sp_add_order_dtl";
// dbCommandWrapper = db.GetStoredProcCommand(sqlCommand,
// _co,
// resultDoc[0],
// i,// Linea
// item._code,
// item._size,
// item._qty,
// item._qtyCancel,
// item._dsctoPerc,// % de descuento
// item._dscto,// Valor de descuento
// item._commissionPctg,// % de comision
// item._commission//valor de comision
// );
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// i++;
// }
// //-- liquidation
// sqlCommand = "FINANCIERA.sp_POS_automatic_clear_UNICA";
// dbCommandWrapper = db.GetStoredProcCommand(sqlCommand, _co, resultDoc[0], 0, _newStatus, varNumTarjeta, varNumVoucher, varMonto, TipoPago, usuCre, _varpercepcion, listdoc);
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// resultDoc[1] = db.GetParameterValue(dbCommandWrapper, "p_lhv_liquidation_no").ToString();
// //** Quitar cuando el sistema funcione con los cambios en la tabla transporters_guides
// if (shipping._configShipping)
// {
// /* Solo para cuando este activo la nueva creacion de guias*/
// // Registro info destinatario
// sqlCommand = "logistica.sp_addguide_shipping";
// //
// dbCommandWrapper = db.GetStoredProcCommand(sqlCommand, _co, 12, DBNull.Value, shipping._tgn_transport, shipping._tgv_name_cust, shipping._tgv_phone_cust,
// shipping._tgv_movil_cust, shipping._tgv_shipp_add, shipping._tgv_shipp_block, shipping._tgv_city, shipping._tgv_depto, resultDoc[1]);
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// }
// // Commit the transaction.
// transaction.Commit();
// }
// catch (Exception ex)
// {
// // Roll back the transaction.
// transaction.Rollback();
// resultDoc[0] = "-1";
// resultDoc[1] = "-1";
// resultDoc[2] = ex.Message;//"-1";
// //return ex.Message;
// }
// connection.Close();
// }
//}
//catch (Exception ex)
//{
// resultDoc[0] = "-1";
// resultDoc[1] = "-1";
// resultDoc[2] = ex.Message;
//}
//return resultDoc;
}
//
//vamos a pagar un pedido con pago POS
public static string[] saveOrder_And_ped_POS_BL(string _co, decimal _idCust, string _reference, decimal _discCommPctg,
decimal _discCommValue, string _shipTo, string _specialInstr, List <Order_Dtl> _itemsDetail,
Transporters_Guides shipping, string _newStatus, string varNumTarjeta, string varNumVoucher,
decimal varMonto, decimal usuCre, String TipoPago, decimal _varpercepcion, string listdoc, string vped)
{
string[] resultDoc = new string[3];
return(resultDoc);
//try
//{
// Database db = DatabaseFactory.CreateDatabase(_conn);
// //string resultDoc = "";
// string sqlCommand = "FINANCIERA.sp_POS_automatic_clear_UNICA";
// DbCommand dbCommandWrapper = db.GetStoredProcCommand(sqlCommand);
// resultDoc[0] = vped;
// // Comenzar una transaccion y si todo resulta bien cerrarla realizando los cambios en la base de datos
// using (DbConnection connection = db.CreateConnection())
// {
// connection.Open();
// DbTransaction transaction = connection.BeginTransaction();
// try
// {
// //-- liquidation
// dbCommandWrapper = db.GetStoredProcCommand(sqlCommand, _co, resultDoc[0], 0, _newStatus, varNumTarjeta, varNumVoucher, varMonto, TipoPago, usuCre, _varpercepcion, listdoc);
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// resultDoc[1] = db.GetParameterValue(dbCommandWrapper, "p_lhv_liquidation_no").ToString();
// //** Quitar cuando el sistema funcione con los cambios en la tabla transporters_guides
// if (shipping._configShipping)
// {
// /* Solo para cuando este activo la nueva creacion de guias*/
// // Registro info destinatario
// sqlCommand = "logistica.sp_addguide_shipping";
// //
// dbCommandWrapper = db.GetStoredProcCommand(sqlCommand, _co, 12, DBNull.Value, shipping._tgn_transport, shipping._tgv_name_cust, shipping._tgv_phone_cust,
// shipping._tgv_movil_cust, shipping._tgv_shipp_add, shipping._tgv_shipp_block, shipping._tgv_city, shipping._tgv_depto, resultDoc[1]);
// db.ExecuteNonQuery(dbCommandWrapper, transaction);
// }
// // Commit the transaction.
// transaction.Commit();
// }
// catch (Exception ex)
// {
// // Roll back the transaction.
// transaction.Rollback();
// resultDoc[0] = "-1";
// resultDoc[1] = "-1";
// resultDoc[2] = ex.Message;//"-1";
// //return ex.Message;
// }
// connection.Close();
// }
//}
//catch (Exception ex)
//{
// resultDoc[0] = "-1";
// resultDoc[1] = "-1";
// resultDoc[2] = ex.Message;
//}
//return resultDoc;
}
