private DataCardModel SetProperties() { var dataCard = new DataCardModel(); if (Lbl_Id.Text.Length > 0) { dataCard.Id = Convert.ToInt32(Lbl_Id.Text); } dataCard.Imei = Txt_Imei.Text; dataCard.SerBr = Txt_SerBr.Text; return(dataCard); }
internal bool Insert(DataCardModel dataCard) { var insert = "INSERT INTO dataCards(imei, serBr, korisnikId, ažurirano) " + "VALUES(?,?,?,?);"; var conn = new OleDbConnection(db.connString); var cmd = new OleDbCommand(insert, conn); cmd.Parameters.AddWithValue("@imei", dataCard.Imei); cmd.Parameters.AddWithValue("@serBr", dataCard.SerBr); cmd.Parameters.AddWithValue("@korisnikId", dataCard.KorisnikId); cmd.Parameters.AddWithValue("@ažurirano", dataCard.Ažurirano); return(db.ExcecuteNonQuery(cmd, conn)); }
internal bool Update(DataCardModel dataCard) { var update = "UPDATE dataCards SET imei=?, serBr=?, korisnikId=?, ažurirano=? " + "WHERE id=?;"; var conn = new OleDbConnection(db.connString); var cmd = new OleDbCommand(update, conn); cmd.Parameters.AddWithValue("@imei", dataCard.Imei); cmd.Parameters.AddWithValue("@serBr", dataCard.SerBr); cmd.Parameters.AddWithValue("@korisnikId", dataCard.KorisnikId); cmd.Parameters.AddWithValue("@ažurirano", dataCard.Ažurirano); cmd.Parameters.AddWithValue("@id", dataCard.Id); return(db.ExcecuteNonQuery(cmd, conn)); }
public override void OnNavigatingTo(NavigationParameters parameters) { card = parameters.GetValue <DataCardModel>(string.Empty); VPCRequest conn = new VPCRequest(); conn.AddDigitalOrderField("vpc_Version", SADM.Settings.AppConfiguration.Values.vpc_Version); conn.AddDigitalOrderField("vpc_Command", SADM.Settings.AppConfiguration.Values.vpc_Command); conn.AddDigitalOrderField("vpc_AccessCode", SADM.Settings.AppConfiguration.Values.vpc_AccessCode); conn.AddDigitalOrderField("vpc_Merchant", SADM.Settings.AppConfiguration.Values.vpc_Merchant); conn.AddDigitalOrderField("vpc_ReturnURL", "http://localhost:8080/api/"); conn.AddDigitalOrderField("vpc_MerchTxnRef", "PruebaRfId2529"); conn.AddDigitalOrderField("vpc_OrderInfo", "2529"); conn.AddDigitalOrderField("vpc_Amount", (card.Amount * 100).ToString()); conn.AddDigitalOrderField("vpc_Currency", SADM.Settings.AppConfiguration.Values.vpc_Currency); //conn.AddDigitalOrderField("vpc_CustomPaymentPlanPlanId", vpc_CustomPaymentPlanPlanId.Text); conn.AddDigitalOrderField("vpc_Locale", SADM.Settings.AppConfiguration.Values.vpc_Locale); // Perform the transaction string url = conn.Create3PartyQueryString(); url = "https://banamex.dialectpayments.com/vpcpay" + url; UrlWeb = url; }