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