public bool agregarCargoError()
{
try
{
string sql = "INSERT INTO " +
"CARGOS_ERRORES(category,description,http_code,error_code,request_id,PK_PEDIDO) " +
"VALUES(@category,@description,@http_code,@error_code,@request_id,@PK_PEDIDO) ";
db.PreparedSQL(sql);
db.command.Parameters.AddWithValue("@category", category);
db.command.Parameters.AddWithValue("@description", description);
db.command.Parameters.AddWithValue("@http_code", http_code);
db.command.Parameters.AddWithValue("@error_code", error_code);
db.command.Parameters.AddWithValue("@request_id", request_id);
db.command.Parameters.AddWithValue("@PK_PEDIDO", PK_PEDIDO);
PK = db.executeId();
if (!string.IsNullOrEmpty(PK))
{
return(true);
}
}
catch (Exception e)
{
LogModel.registra("Error al guardar el error del cargo en la base", e.ToString() + " DATOS{category:" + category + ",description:" + description + ", http_code:" + http_code + ", error_code:" + error_code + ", request_id:" + request_id + "}");
}
return(false);
}
public bool obtenerCargoByPK()
{
try
{
string sql = "SELECT * FROM CARGOS WHERE PK_PEDIDO=@PK_PEDIDO";
db.PreparedSQL(sql);
db.command.Parameters.AddWithValue("@PK_PEDIDO", PK_PEDIDO);
ResultSet res = db.getTable();
if (res.Next())
{
PK = res.Get("PK");
ID = res.Get("ID");
AUTHORIZATION = res.Get("AUTHORIZATION1");
AMOUNT = res.GetDouble("AMOUNT");
METHOD = res.Get("METHOD");
ESTATUS = res.Get("ESTATUS");
BORRADO = res.Get("BORRADO");
FECHA_C = res.Get("FECHA_C");
return(true);
}
}
catch (Exception e)
{
LogModel.registra("Error al obtener el cargo ", e.ToString() + " DATOS{PK_PEDIDO:" + PK_PEDIDO + "}");
}
return(false);
}
public bool delete()
{
try
{
string sql = "UPDATE PEDIDOS SET BORRADO=1 WHERE PK=@PK";
db.PreparedSQL(sql);
db.command.Parameters.AddWithValue("@PK", PK);
return(db.execute());
}
catch (Exception e)
{
LogModel.registra("Error al borrar pedido", e.ToString());
}
return(false);
}
public bool agregarCargo()
{
try {
if (string.IsNullOrEmpty(ERROR_MESSAGE))
{
string sql = "INSERT INTO " +
"CARGOS(ID,AMOUNT,AUTHORIZATION1,METHOD,ESTATUS,PK_PEDIDO) " +
"VALUES(@ID,@AMOUNT,@AUTHORIZATION1,@METHOD,@ESTATUS,@PK_PEDIDO)";
db.PreparedSQL(sql);
db.command.Parameters.AddWithValue("@ID", ID);
db.command.Parameters.AddWithValue("@AUTHORIZATION1", AUTHORIZATION);
db.command.Parameters.AddWithValue("@AMOUNT", AMOUNT);
db.command.Parameters.AddWithValue("@METHOD", METHOD);
db.command.Parameters.AddWithValue("@ESTATUS", ESTATUS);
//db.command.Parameters.AddWithValue("@CURRENCY", CURRENCY);
db.command.Parameters.AddWithValue("@PK_PEDIDO", PK_PEDIDO);
//db.command.Parameters.AddWithValue("@ERROR_MESSAGE", ERROR_MESSAGE);
PK = db.executeId();
if (!string.IsNullOrEmpty(PK))
{
return(true);
}
}
else
{
string sql = "INSERT INTO " +
"CARGOS(ESTATUS,ERROR_MESSAGE) " +
"VALUES(@ESTATUS,@ERROR_MESSAGE)";
db.PreparedSQL(sql);
db.command.Parameters.AddWithValue("@ESTATUS", ESTATUS);
db.command.Parameters.AddWithValue("@ERROR_MESSAGE", ERROR_MESSAGE);
PK = db.executeId();
if (!string.IsNullOrEmpty(PK))
{
return(true);
}
}
} catch (Exception e) {
LogModel.registra("Error al guardar el cargo en la base", e.ToString() + " DATOS{ID:" + ID + ",AUTHORIZATION:" + AUTHORIZATION + ", METHOD:" + METHOD + ", STATUS:" + ESTATUS + ", PK_PEDIDO:" + PK_PEDIDO + ", ERROR_MESSAGE:" + ERROR_MESSAGE + "}");
}
return(false);
}
public bool setEstatus()
{
try
{
string sql = "UPDATE PEDIDOS SET PK_ESTATUS=@PK_ESTATUS WHERE PK=@PK";
db.PreparedSQL(sql);
db.command.Parameters.AddWithValue("@PK", PK);
db.command.Parameters.AddWithValue("@PK_ESTATUS", PK_ESTATUS);
return(db.execute());
}
catch (Exception e)
{
LogModel.registra("Error al actualizar estatus", e.ToString());
}
return(false);
}
public bool pagar()
{
try
{
ClientesModel cliente = new ClientesModel();
cliente.PK = PK_CLIENTE;
cliente.getClienteByPk();
if (!String.IsNullOrEmpty(cliente.OPENID))
{
if (Resources.DEVELOP.ToUpper().Equals("TRUE"))
{
api = new OpenpayAPI(Resources.SK_OPEN_PAY_DEV, Resources.ID_OPEN_PAY_DEV, false);
}
else
{
api = new OpenpayAPI(Resources.SK_OPEN_PAY, Resources.ID_OPEN_PAY, true);
}
ChargeRequest request = new ChargeRequest();
Customer customer = new Customer();
customer.Name = cliente.NOMBRE;
customer.LastName = cliente.APELLIDOS;
customer.PhoneNumber = cliente.TELEFONO;
customer.Email = cliente.CORREO;
request.Method = "card";
request.SourceId = SOURCE_ID;
request.Amount = new Decimal(TOTAL);
request.Currency = "MXN";
request.Description = "Pedido polar " + PK;
request.OrderId = PK;
request.DeviceSessionId = DEVICE_SESSION_ID;
//request.Customer = customer;>>>>>>>>>>>>
request.Cvv2 = CVV2;
try
{
Charge charge = api.ChargeService.Create(cliente.OPENID, request);
cargo = new CargosModel();
cargo.ID = charge.Id;
cargo.AUTHORIZATION = charge.Authorization;
cargo.AMOUNT = (double)charge.Amount;
cargo.METHOD = charge.Method;
cargo.ESTATUS = charge.Status;
cargo.PK_PEDIDO = PK;
cargo.ERROR_MESSAGE = charge.ErrorMessage;
cargo.agregarCargo();
if (cargo.ESTATUS.Equals("completed"))
{
return(true);
}
else
{
ERROR = charge.ErrorMessage;
delete();
}
}
catch (OpenpayException e) {
LogModel.registra("Error al pagar", e.ToString());
CargosErroresModel aux1 = new CargosErroresModel();
aux1.category = e.Category;
aux1.description = e.Description;
aux1.http_code = e.HResult;
aux1.request_id = e.RequestId;
aux1.PK_PEDIDO = PK;
aux1.agregarCargoError();
ERROR = ErroresOpenPayModel.error(e.ErrorCode);
delete();
}
catch (Exception ex) {
LogModel.registra("Error al pagar", ex.ToString());
ERROR = ex.Message;
delete();
}
}
}
catch (Exception e)
{
LogModel.registra("Error al pagar", e.ToString());
ERROR = e.Message;
}
return(false);
}
