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); }