gp_DailyReport_Result IHistoryDAO.DailyReport(String MerchantID, String ClerkID, String WhereFrom, String MerchSeqNum, String TerminalID, DateTime LocalTime)
{
InitializeConnection();
gp_DailyReport_Result Res = GiftEntity.gp_DailyReport(MerchantID, ClerkID, "A", WhereFrom, MerchSeqNum, TerminalID, LocalTime).FirstOrDefault();
return(Res);
}
bool IPriceDAO.UpdatePrice(Price ToUpdate)
{
InitializeConnection();
GiftEntity.Prices.Attach(ToUpdate);
GiftEntity.SaveChanges(); //SaveOptions.AcceptAllChangesAfterSave
return(true);
}
void ICardHolderRepository.UpdateCardHolder(EditCardHolderModel WebData, String CardHolderName)
{
String EncryptedCardHolderName = GiftEncryption.Encrypt(CardHolderName);
InitializeConnection();
CardHolder DBCardHolder = (from c in GiftEntity.CardHolders
where c.EncryptedCardHolderName == EncryptedCardHolderName
select c).FirstOrDefault();
if (DBCardHolder != null)
{
DBCardHolder.EncryptedFirstName = GiftEncryption.Encrypt(WebData.FirstName);
DBCardHolder.LastName = WebData.LastName;
DBCardHolder.EncryptedLastName = GiftEncryption.Encrypt(WebData.LastName);
DBCardHolder.EncryptedAddress1 = GiftEncryption.Encrypt(WebData.Address1);
DBCardHolder.EncryptedAddress2 = GiftEncryption.Encrypt(WebData.Address2);
DBCardHolder.EncryptedCity = GiftEncryption.Encrypt(WebData.City);
DBCardHolder.State = WebData.State;
DBCardHolder.EncryptedPostalCode = GiftEncryption.Encrypt(WebData.PostalCode);
DBCardHolder.Country = WebData.Country;
String CleanPhoneNumber = extractPhoneNumber(WebData.CellPhoneNumber);
DBCardHolder.EncryptedPhone = GiftEncryption.Encrypt(CleanPhoneNumber);
DBCardHolder.EncryptedEmail = GiftEncryption.Encrypt(WebData.Email);
GiftEntity.SaveChanges();
}
}
bool ICardHolderRepository.CreateCardHolder(CreateCardHolderModel WebData)
{
CardHolder DBCardHolder = new CardHolder();
DBCardHolder.CardHolderGUID = Guid.NewGuid();
DBCardHolder.EncryptedFirstName = GiftEncryption.Encrypt(WebData.FirstName);
DBCardHolder.LastName = WebData.LastName;
DBCardHolder.EncryptedLastName = GiftEncryption.Encrypt(WebData.LastName);
DBCardHolder.EncryptedCardHolderName = GiftEncryption.Encrypt(WebData.UserName);
DBCardHolder.EncryptedEmail = GiftEncryption.Encrypt(WebData.email.ToLower());
DBCardHolder.EncryptedAddress1 = GiftEncryption.Encrypt(WebData.Address1);
DBCardHolder.EncryptedAddress2 = GiftEncryption.Encrypt(WebData.Address2);
DBCardHolder.EncryptedCity = GiftEncryption.Encrypt(WebData.City);
if (WebData.State != null)
{
DBCardHolder.State = WebData.State.ToUpper();
}
DBCardHolder.EncryptedPostalCode = GiftEncryption.Encrypt(WebData.PostalCode);
String CleanPhoneNumber = extractPhoneNumber(WebData.CellPhoneNumber);
DBCardHolder.EncryptedPhone = GiftEncryption.Encrypt(CleanPhoneNumber);
DBCardHolder.Card1 = WebData.Card1GUID;
DBCardHolder.Card2 = WebData.Card2GUID;
DBCardHolder.Card3 = WebData.Card3GUID;
DBCardHolder.Card4 = WebData.Card4GUID;
DBCardHolder.Card5 = WebData.Card5GUID;
GiftEntity.CardHolders.Add(DBCardHolder);
GiftEntity.SaveChanges();
WebData.ID = DBCardHolder.ID;
WebData.CardHolderGUID = (Guid)DBCardHolder.CardHolderGUID;
return(true);
}
String ICardRepository.ShipCards(String MerchantID, String ClerkID,
String TerminalID, DateTime LocalTime,
String CardToShip, Int32 CountToShip, String TransactionText)
{
int count;
InitializeConnection();
String CleanCardNumber = extractCardNumber(CardToShip);
if (CleanCardNumber.Length == 0)
{
return("BDCRD");
}
gp_ShipCard_Result Res = new gp_ShipCard_Result();
for (count = 0; count < CountToShip; count++)
{
String EncryptedCardNumber = GiftEncryption.Encrypt(CleanCardNumber);
Res = GiftEntity.gp_ShipCard(
MerchantID, ClerkID,
TerminalID, LocalTime,
EncryptedCardNumber, TransactionText).FirstOrDefault();
if (Res.ResponseCode != "A")
{
return(Res.ErrorCode);
}
CleanCardNumber = increment(CleanCardNumber);
}
return(Res.ErrorCode);
}
// PUT api/gift/5
public bool Put(int id, [FromBody] GiftEntity giftEntity)
{
if (id > 0)
{
return(_giftServices.UpdateGift(id, giftEntity));
}
return(false);
}
bool IMerchantDAO.CreateMerchant(Merchant ToAdd)
{
InitializeConnection();
ToAdd.MerchantID = ToAdd.MerchantID.ToUpper();
GiftEntity.Merchants.Add(ToAdd);
GiftEntity.SaveChanges();
return(true);
}
bool IPriceDAO.CreatePrice(Price NewPrice)
{
InitializeConnection();
using (GiftEntity)
{
GiftEntity.Prices.Add(NewPrice);
GiftEntity.SaveChanges();
}
return(true);
}
public IActionResult CreateGift([FromBody] GiftEntity giftEntity)
{
giftEntity.CreationDate = DateTime.Now;
_giftRepository.CreateGift(giftEntity);
if (!_giftRepository.Save())
{
return(StatusCode(500, "A problem happened while handling your request"));
}
return(NoContent());
}
void ICardRepository.DeactivateCard(String CardToDeactivate)
{
String CleanCardNumber = extractCardNumber(CardToDeactivate);
String EncryptedCard = GiftEncryption.Encrypt(CleanCardNumber);
Card DBCard = (from c in GiftEntity.Cards
where c.CardNumber == EncryptedCard
select c).FirstOrDefault();
DBCard.Activated = "N";
GiftEntity.SaveChanges();
}
void IPriceDAO.DeletePrice(int ID)
{
InitializeConnection();
var Price = GiftEntity.Prices.FirstOrDefault(d => d.ID == ID);
if (Price == null)
{
return;
}
GiftEntity.Prices.Remove(Price);
GiftEntity.SaveChanges();
}
bool IHistoryDAO.CloseDay(String MerchantID, String ClerkID, String WhereFrom, String MerchSeqNum, String TerminalID, DateTime LocalTime)
{
InitializeConnection();
gp_Close_Result Res = GiftEntity.gp_Close(MerchantID, ClerkID, WhereFrom, MerchSeqNum, TerminalID, LocalTime).FirstOrDefault();
if (Res.ResponseCode == "A")
{
return(true);
}
return(false);
}
public void SubmitForm(GiftEntity entity, string keyValue)
{
if (!string.IsNullOrEmpty(keyValue))
{
entity.Modify(keyValue);
service.Update(entity);
}
else
{
entity.Create();
service.Insert(entity);
}
}
gp_GiftActivateCard_Result ICardRepository.ActivateGiftCard(
String MerchantID, String Clerk,
String WebOrDial, String MerchantSequenceNumber,
String TerminalID, DateTime LocalTime,
String CardToActivate, Decimal Amount, String InvoiceNumber)
{
InitializeConnection();
String CleanCardNumber = extractCardNumber(CardToActivate);
String EncryptedCardNumber = GiftEncryption.Encrypt(CleanCardNumber);
gp_GiftActivateCard_Result Res = GiftEntity.gp_GiftActivateCard(MerchantID, Clerk, WebOrDial, MerchantSequenceNumber, TerminalID, LocalTime, EncryptedCardNumber, 0, Amount, InvoiceNumber).FirstOrDefault();
return(Res);
}
/// <summary>
/// removes the link to the cardholder
/// </summary>
/// <param name="CardToUnregister"></param>
void ICardRepository.UnregisterCard(Guid CardToUnregister)
{
InitializeConnection();
Card DBCard = (from c in GiftEntity.Cards
where c.CardGUID == CardToUnregister
select c).FirstOrDefault();
if (DBCard == null)
{
return;
}
DBCard.CardHolderGUID = null;
GiftEntity.SaveChanges();
}
/// <summary>
/// Creates a gift
/// </summary>
/// <param name="giftEntity"></param>
/// <returns></returns>
public int CreateGift(GiftEntity giftEntity)
{
//using (var scope = new TransactionScope()) // TODO: Handle transction scope.
//{
var gift = new Gift
{
GiftName = giftEntity.GiftName
};
_unitOfWork.GiftRepository.Insert(gift);
_unitOfWork.Save();
//scope.Complete();
return(gift.GiftId);
//}
}
/// <summary>
/// linkes the card to the cardholder
/// </summary>
/// <param name="CardHolderID"></param>
/// <param name="CardToRegister"></param>
void ICardRepository.RegisterCard(int CardHolderID, Guid?CardHolderGUID, String CardToRegister)
{
InitializeConnection();
String CleanCardNumber = extractCardNumber(CardToRegister);
String EncryptedCard = GiftEncryption.Encrypt(CleanCardNumber);
Card DBCard = (from c in GiftEntity.Cards
where c.CardNumber == EncryptedCard
select c).FirstOrDefault();
if (DBCard != null)
{
DBCard.CardHolderGUID = CardHolderGUID;
GiftEntity.SaveChanges();
}
}
CardHolder ICardHolderRepository.RegisterThisCard(String CardHolderName, Guid NewCard)
{
int cardholderid = 0;
InitializeConnection();
String EncryptedCardHolderName = GiftEncryption.Encrypt(CardHolderName);
CardHolder DBCardHolder = (from c in GiftEntity.CardHolders
where c.EncryptedCardHolderName == EncryptedCardHolderName
select c).FirstOrDefault();
if (DBCardHolder == null)
{
throw new Exception("Card holder not found");
}
cardholderid = DBCardHolder.ID;
if (DBCardHolder.Card1 == null)
{
DBCardHolder.Card1 = NewCard;
}
else
if (DBCardHolder.Card2 == null)
{
DBCardHolder.Card2 = NewCard;
}
else
if (DBCardHolder.Card3 == null)
{
DBCardHolder.Card3 = NewCard;
}
else
if (DBCardHolder.Card4 == null)
{
DBCardHolder.Card4 = NewCard;
}
else
if (DBCardHolder.Card5 == null)
{
DBCardHolder.Card5 = NewCard;
}
else
{
throw new Exception("Already five cards registered. Can not register more");
}
GiftEntity.SaveChanges();
return(DBCardHolder);
}
public String AddThisCard(String EncryptedCard, String CardNumberLast4,
String MerchantID, String ChainID, String GroupCode)
{
Card NewCard = GiftEntity.Cards.Create();
NewCard.CardGUID = Guid.NewGuid();
NewCard.Activated = "N";
NewCard.Shipped = "N";
NewCard.CardNumber = EncryptedCard;
NewCard.CardNumLast4 = CardNumberLast4;
NewCard.GiftBalance = 0.00M;
NewCard.MerchantGUID = null;
GiftEntity.Cards.Add(NewCard);
GiftEntity.SaveChanges();
return("APP ");
}
bool ICardHolderRepository.UpdateEmail(String CardHolderName, String email, String comment, bool isapproved)
{
InitializeConnection();
String EncryptedUserName = GiftEncryption.Encrypt(CardHolderName);
CardHolder DBCardHolder = (from c in GiftEntity.CardHolders
where c.EncryptedCardHolderName == EncryptedUserName
select c).FirstOrDefault();
if (DBCardHolder == null)
{
return(false);
}
DBCardHolder.EncryptedEmail = GiftEncryption.Encrypt(email);
GiftEntity.SaveChanges();
return(true);
}
gp_GiftBalanceInq_Result ICardRepository.GiftCardInquiry(
String MerchantID, String Clerk,
String WebOrDial, String MerchantSequenceNumber,
String TerminalID, DateTime LocalTime,
String CardNumber)
{
InitializeConnection();
String CleanCardNumber = extractCardNumber(CardNumber);
String EncryptedCardNumber = GiftEncryption.Encrypt(CleanCardNumber);
gp_GiftBalanceInq_Result Res = GiftEntity.gp_GiftBalanceInq(
MerchantID, Clerk, WebOrDial, MerchantSequenceNumber,
TerminalID, LocalTime,
EncryptedCardNumber).FirstOrDefault();
return(Res);
}
void ICardHolderRepository.UnregisterCard(String CardHolderName, Guid CardToUnregister)
{
InitializeConnection();
String EncryptedCardHolderName = GiftEncryption.Encrypt(CardHolderName);
CardHolder DBCardHolder = (from c in GiftEntity.CardHolders
where c.EncryptedCardHolderName == EncryptedCardHolderName
select c).FirstOrDefault();
if (DBCardHolder != null)
{
if (DBCardHolder.Card1 == CardToUnregister)
{
DBCardHolder.Card1 = DBCardHolder.Card2;
DBCardHolder.Card2 = DBCardHolder.Card3;
DBCardHolder.Card3 = DBCardHolder.Card4;
DBCardHolder.Card4 = DBCardHolder.Card5;
DBCardHolder.Card5 = null;
}
if (DBCardHolder.Card2 == CardToUnregister)
{
DBCardHolder.Card2 = DBCardHolder.Card3;
DBCardHolder.Card3 = DBCardHolder.Card4;
DBCardHolder.Card4 = DBCardHolder.Card5;
DBCardHolder.Card5 = null;
}
if (DBCardHolder.Card3 == CardToUnregister)
{
DBCardHolder.Card3 = DBCardHolder.Card4;
DBCardHolder.Card4 = DBCardHolder.Card5;
DBCardHolder.Card5 = null;
}
if (DBCardHolder.Card4 == CardToUnregister)
{
DBCardHolder.Card4 = DBCardHolder.Card5;
DBCardHolder.Card5 = null;
}
if (DBCardHolder.Card5 == CardToUnregister)
{
DBCardHolder.Card5 = null;
}
GiftEntity.SaveChanges();
}
}
String ICardRepository.ShipCards(String MerchantID, String ClerkID,
String TerminalID, DateTime LocalTime,
String CardToShip, String LastCardToShip, String TransactionText)
{
InitializeConnection();
String CleanCardNumber = extractCardNumber(CardToShip);
if (CleanCardNumber.Length == 0)
{
return("BDCRD");
}
String CleanLastCardNumber = extractCardNumber(LastCardToShip);
if (CleanLastCardNumber.Length == 0)
{
return("BDCRD");
}
int NumberToShip = StringDiff(CleanLastCardNumber, CleanCardNumber);
if (NumberToShip < 0)
{
return("BDCRD");
}
gp_ShipCard_Result Res = new gp_ShipCard_Result();
while (NumberToShip > 0)
{
String EncryptedCardNumber = GiftEncryption.Encrypt(CleanCardNumber);
Res = GiftEntity.gp_ShipCard(
MerchantID, ClerkID,
TerminalID, LocalTime,
EncryptedCardNumber, TransactionText).FirstOrDefault();
if (Res.ResponseCode != "A")
{
return(Res.ErrorCode);
}
CleanCardNumber = increment(CleanCardNumber);
NumberToShip--;
}
return(Res.ErrorCode);
}
/// <summary>
/// Updates a gift
/// </summary>
/// <param name="giftId"></param>
/// <param name="giftEntity"></param>
/// <returns></returns>
public bool UpdateGift(int giftId, GiftEntity giftEntity)
{
var success = false;
if (giftEntity != null)
{
//using (var scope = new TransactionScope())// TODO: Handle transction scope.
//{
var gift = _unitOfWork.GiftRepository.GetByID(giftId);
if (gift != null)
{
gift.GiftName = giftEntity.GiftName;
_unitOfWork.GiftRepository.Update(gift);
_unitOfWork.Save();
//scope.Complete();
success = true;
}
//}
}
return(success);
}
public ActionResult SubmitForm(GiftEntity investConfigEntity, string keyValue)
{
giftApp.SubmitForm(investConfigEntity, keyValue);
return(Success("操作成功。"));
}
// Yes, there was a stored procedure to do the detail report,
// but it returns two result sets and the second one can have
// a bunch of records in it.
DetailHistory IHistoryDAO.DetailReport(String MerchantID, String ClerkID, String WhereFrom, String MerchSeqNum, String TerminalID, DateTime LocalTime)
{
InitializeConnection();
// need to resolve any merchant sequence number issues
DetailHistory Results = new DetailHistory();
Results.DetailItems = new List <CardHistory>();
gp_DailyReport_Result Res = GiftEntity.gp_DailyReport(MerchantID, ClerkID, "E", WhereFrom, MerchSeqNum, TerminalID, LocalTime).FirstOrDefault();
if (Res.ResponseCode == "A")
{
Results.When = DateTime.Now;
Results.ResponseCode = Res.ResponseCode[0];
Results.ErrorCode = (string)Res.ErrorCode;
Results.Summary = new DailySalesInformation();
DailyReportToWeb(Res, Results.Summary, LocalTime);
// now get the details
Merchant Merch = GiftEntity.Merchants.FirstOrDefault(d => d.MerchantID == MerchantID);
var LastRun = (from h in GiftEntity.Histories
where h.WhichMerchantGUID == Merch.MerchantGUID &&
h.TransType == "CLOS"
orderby h.ID descending
select h.ID).FirstOrDefault();
//if (LastRun == null)
// LastRun = 0;
var DailyHistories = from h in GiftEntity.Histories
where h.WhichMerchantGUID == Merch.MerchantGUID &&
h.ID > LastRun &&
h.ErrorCode == "APP " &&
h.TransType != "DYRP" && // keep the daily report out of this
h.TransType != "SHIP" // keep the card shipments out of the report
orderby h.ID
//c.Card2 == WhichCard.ID
select new
{
ID = h.ID,
CardGUID = h.CardGUID,
TransType = h.TransType,
When = h.WhenHappened,
LocalTime = h.LocalTime,
Amount = h.Amount,
PointsGranted = 0,
MerchWhere = h.WhichMerchantGUID,
Clrk = h.Clerk,
Text = h.TransactionText,
CardGUID2 = h.CardGUID2,
CouponUsed = 0,
CouponIssued = 0,
PrizeAwardedGUID = Guid.NewGuid(),
InvoiceNumber = h.InvoiceNumber
};
foreach (var his in DailyHistories)
{
CardHistory nHistory = new CardHistory();
nHistory.ID = his.ID;
nHistory.CardNumber = (from c in GiftEntity.Cards
where c.CardGUID == his.CardGUID
select c.CardNumLast4).FirstOrDefault().ToString();
nHistory.Amount = his.Amount;
nHistory.Clerk = his.Clrk;
nHistory.MerchWhere = (from m in GiftEntity.Merchants
where m.MerchantGUID == his.MerchWhere
select m.MerchantName).FirstOrDefault();
nHistory.TransType = his.TransType;
nHistory.Transaction = ConvertTransactionType(his.TransType);
nHistory.When = his.When;
if (his.LocalTime.HasValue)
{
nHistory.LocalTime = his.LocalTime.Value;
}
nHistory.Text = his.Text;
nHistory.PointsGranted = his.PointsGranted;
if (his.CardGUID2 != null)
{
nHistory.Card2 = GiftEntity.Cards
.FirstOrDefault(c => c.CardGUID == his.CardGUID2).CardNumLast4;
}
nHistory.InvoiceNumber = his.InvoiceNumber;
Results.DetailItems.Add(nHistory);
}
}
else
{
Results.ResponseCode = Res.ResponseCode[0];
Results.ErrorCode = (string)Res.ErrorCode;
}
return(Results);
}
public void Delete(GiftEntity entity)
{
service.Delete(entity);
}
public void CreateGift(GiftEntity giftEntity)
{
_context.Gifts.Add(giftEntity);
}
// POST api/gift
public int Post([FromBody] GiftEntity giftEntity)
{
return(_giftServices.CreateGift(giftEntity));
}
