public void GetOfferForDevice_Test() { PersistantDevice persistantDevice = new PersistantDevice() { Clubcard = "222222222", EmailId = "*****@*****.**", GcmToken = "TR000001", Id = "1234555", Mobile = "9999999999", Name = "Test" }; PersistantOffer offer = new PersistantOffer() { Name = "test Offer", Description = "Test Offer Description", ImagePath = "Image test path", OfferCode = "Offer Code" }; List<PersistantOffer> lstPersistantOffer = new List<PersistantOffer>(); lstPersistantOffer.Add(offer); _persist.Setup(r => r.GetDeviceDetailsByDeviceId(It.IsAny<string>())).Returns(persistantDevice); _persist.Setup(r => r.GetOffers(It.IsAny<string>(), It.IsAny<string>())).Returns(lstPersistantOffer); IP2PBusinessLogic business = new P2PBusinessLogic(_persist.Object); var result = business.GetOffers("test device id","test store id",true); Assert.IsNotNull(result); }
public List<PersistantOffer> GetOffers(string clubcard, string storeId) { List<PersistantOffer> persistantOffers = new List<PersistantOffer>(); try { GetConnection(); // Get valid record from offer table string query = "select OfferCode,Name,OfferDescription,ImagePath from offer where storeid in (" + storeId + ") and startDate <='" + DateTime.Now.ToString("MM/dd/yyyy") + "' and EndDate >= '" + DateTime.Now.ToString("MM/dd/yyyy") + "'"; // if user has a clubcard number merge coupon records also if (clubcard != string.Empty) query += " union select CouponCode as 'OfferCode',Name,CouponDescription as 'OfferDescription',ImagePath from coupon where CouponAvailed = 0 and startDate <= '" + DateTime.Now.ToString("MM/dd/yyyy") + "' and EndDate >= '" + DateTime.Now.ToString("MM/dd/yyyy") + "';"; SqlCommand cmd = new SqlCommand(query, conn); cmd.CommandType = System.Data.CommandType.Text; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { PersistantOffer _PersistantOffer = new PersistantOffer() { OfferCode = reader["OfferCode"].ToString(), Name = reader["Name"].ToString(), Description = reader["OfferDescription"].ToString(), ImagePath = reader["ImagePath"].ToString() }; persistantOffers.Add(_PersistantOffer); } } } catch (Exception) { throw; } finally { conn.Close(); } return persistantOffers; }