public void MoveToWebFormat(EditCardHolderModel WebData, CardHolder DBData) { WebData.FirstName = GiftEncryption.Decrypt(DBData.EncryptedFirstName); WebData.LastName = DBData.LastName; WebData.Address1 = GiftEncryption.Decrypt(DBData.EncryptedAddress1); WebData.Address2 = GiftEncryption.Decrypt(DBData.EncryptedAddress2); WebData.City = GiftEncryption.Decrypt(DBData.EncryptedCity); WebData.State = DBData.State; WebData.PostalCode = GiftEncryption.Decrypt(DBData.EncryptedPostalCode); WebData.Country = DBData.Country; WebData.CellPhoneNumber = GiftEncryption.Decrypt(DBData.EncryptedPhone); WebData.Email = GiftEncryption.Decrypt(DBData.EncryptedEmail); }
String ICardRepository.FindNextCardToIssue(Guid MerchantGUID) { InitializeConnection(); Card DBCard = (from c in GiftEntity.Cards where c.MerchantGUID == MerchantGUID && c.Activated == "N" select c).FirstOrDefault(); if (DBCard != null) { return(GiftEncryption.Decrypt(DBCard.CardNumber)); } return(null); }
// List<String> ICardHolderRepository.CleanExistingPhoneList() // { // using (var GiftEntity = new GiftEntities()) // { // List<String> ToReturn = new List<String>(); // foreach (CardHolder ch in GiftEntity.CardHolders) // { // if (ch.EncryptedPhone != null) // { // String Phone = DecryptValue(ch.EncryptedPhone); // String Line = "<td>" + Phone + "</td><td>" + extractPhoneNumber(Phone) + "</td>"; // ch.EncryptedPhone = EncryptValue(extractPhoneNumber(Phone)); // ToReturn.Add(Line); // } // } // GiftEntity.SaveChanges(); // return ToReturn; // } List <String> ICardHolderRepository.GetPhoneList() { using (var GiftEntity = new GiftEntities()) { List <String> ToReturn = new List <String>(); foreach (CardHolder ch in GiftEntity.CardHolders) { if (ch.EncryptedPhone != null) { String Phone = GiftEncryption.Decrypt(ch.EncryptedPhone); String Line = "<td>" + Phone + "</td><td>" + extractPhoneNumber(Phone) + "</td>"; ToReturn.Add(Line); } } return(ToReturn); } }
String ICardHolderRepository.GetCardHolderName(String email) { if (email == null) { return(""); } String EncryptedEmail = GiftEncryption.Encrypt(email); using (var GiftEntity = new GiftEntities()) { CardHolder DBCardHolder = (from c in GiftEntity.CardHolders where c.EncryptedEmail == EncryptedEmail select c).FirstOrDefault(); if (DBCardHolder == null) { return(""); } return(GiftEncryption.Decrypt(DBCardHolder.EncryptedCardHolderName)); } }
// bool ICardHolderRepository.EncryptExistingFile() // { // InitializeConnection(); // var CardHolders = (from c in GiftEntity.CardHolders // select c); // foreach (CardHolder CH in CardHolders) // { // CH.EncryptedFirstName = EncryptValue(CH.FirstName); // CH.EncryptedLastName = EncryptValue(CH.LastName); // CH.EncryptedCardHolderName = EncryptValue(CH.CardHolderName); // CH.EncryptedAddress1 = EncryptValue(CH.Address1); // CH.EncryptedAddress2 = EncryptValue(CH.Address2); // CH.EncryptedPhone = EncryptValue(CH.Phone); // CH.EncryptedEmail = EncryptValue(CH.email); // } // GiftEntity.SaveChanges(); // return true; // } // // bool ICardHolderRepository.VerifyEncryptExistingFile() // { // InitializeConnection(); // var CardHolders = (from c in GiftEntity.CardHolders // select c); // foreach (CardHolder CH in CardHolders) // { // if (CH.FirstName != null) // if (DecryptValue(CH.EncryptedFirstName) != CH.FirstName) // throw new Exception("First name not matching for " + CH.CardHolderName); // if (CH.LastName != null) // if (DecryptValue(CH.EncryptedLastName) != CH.LastName) // throw new Exception("Last name not matching for " + CH.CardHolderName); // if (CH.CardHolderName != null) // if (DecryptValue(CH.EncryptedCardHolderName) != CH.CardHolderName) // throw new Exception("CardHolderName not matching for " + CH.CardHolderName); // if (CH.Address2 != null) // if (DecryptValue(CH.EncryptedAddress1) != CH.Address1) // throw new Exception("Address1 not matching for " + CH.CardHolderName); // if (CH.Address2 != null) // if (DecryptValue(CH.EncryptedAddress2) != CH.Address2) // throw new Exception("Address2 not matching for " + CH.CardHolderName); // if (CH.Phone != null) // if (DecryptValue(CH.EncryptedPhone) != CH.Phone) // throw new Exception("Phone not matching for " + CH.CardHolderName); // if (CH.email != null) // if (DecryptValue(CH.EncryptedEmail) != CH.email) // throw new Exception("Email not matching for " + CH.CardHolderName); // } // return true; // } String ICardHolderRepository.DecryptCardHolderValue(String Value) { return(GiftEncryption.Decrypt(Value)); }
// returns card number // would like this to return the encrypted card number, // but that would require all sorts of other changes public bool GetCardForTransaction(String MerchantID, String PhoneNumber, out String CardNumber) { CardNumber = ""; // first get the cardholder InitializeConnection(); String CleanPhoneNumber = extractPhoneNumber(PhoneNumber); String EncryptedPhone = GiftEncryption.Encrypt(CleanPhoneNumber); CardHolder DBCardHolder = (from c in GiftEntity.CardHolders where c.EncryptedPhone == EncryptedPhone select c).FirstOrDefault(); // now go down the list of cards to find one that is valid for this merchant Card tCard; if (DBCardHolder == null) { return(false); } if (DBCardHolder.Card1 != null) { tCard = (from c in GiftEntity.Cards where c.CardGUID == DBCardHolder.Card1 select c).FirstOrDefault(); if (tCard != null) { Merchant tMerch = (from m in GiftEntity.Merchants where m.MerchantGUID == tCard.MerchantGUID select m).FirstOrDefault(); if (tMerch != null) { if (tMerch.MerchantID == MerchantID.ToUpper()) { CardNumber = GiftEncryption.Decrypt(tCard.CardNumber); return(true); } } } } if (DBCardHolder.Card2 != null) { tCard = (from c in GiftEntity.Cards where c.CardGUID == DBCardHolder.Card2 select c).FirstOrDefault(); if (tCard != null) { Merchant tMerch = (from m in GiftEntity.Merchants where m.MerchantGUID == tCard.MerchantGUID select m).FirstOrDefault(); if (tMerch != null) { if (tMerch.MerchantID == MerchantID.ToUpper()) { CardNumber = GiftEncryption.Decrypt(tCard.CardNumber); return(true); } } } } if (DBCardHolder.Card3 != null) { tCard = (from c in GiftEntity.Cards where c.CardGUID == DBCardHolder.Card3 select c).FirstOrDefault(); if (tCard != null) { Merchant tMerch = (from m in GiftEntity.Merchants where m.MerchantGUID == tCard.MerchantGUID select m).FirstOrDefault(); if (tMerch != null) { if (tMerch.MerchantID == MerchantID.ToUpper()) { CardNumber = GiftEncryption.Decrypt(tCard.CardNumber); return(true); } } } } if (DBCardHolder.Card4 != null) { tCard = (from c in GiftEntity.Cards where c.CardGUID == DBCardHolder.Card4 select c).FirstOrDefault(); if (tCard != null) { Merchant tMerch = (from m in GiftEntity.Merchants where m.MerchantGUID == tCard.MerchantGUID select m).FirstOrDefault(); if (tMerch != null) { if (tMerch.MerchantID == MerchantID.ToUpper()) { CardNumber = GiftEncryption.Decrypt(tCard.CardNumber); return(true); } } } } if (DBCardHolder.Card5 != null) { tCard = (from c in GiftEntity.Cards where c.CardGUID == DBCardHolder.Card5 select c).FirstOrDefault(); if (tCard != null) { Merchant tMerch = (from m in GiftEntity.Merchants where m.MerchantGUID == tCard.MerchantGUID select m).FirstOrDefault(); if (tMerch != null) { if (tMerch.MerchantID == MerchantID.ToUpper()) { CardNumber = GiftEncryption.Decrypt(tCard.CardNumber); return(true); } } } } return(false); }