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