public string GetConsumer(string email) { var consumer = service.Where(o => o.Email.Equals(email)).SingleOrDefault(); if (consumer != null) { var con = consumerService.Where(o => o.Email.Equals(email)).SingleOrDefault(); string userToken = System.Guid.NewGuid().ToString(); Consumer selectedConsumer = consumerService.Get(con.Id); selectedConsumer.Token = userToken; consumerService.Save(); var list = service.Where(o => o.Email.Equals(email)).AsEnumerable(); var query = from seletedConsumer in list select new { seletedConsumer.Address, seletedConsumer.Age, BirthDate = DateConverter.GetJsonDate(seletedConsumer.BirthDate), DateRegistered = DateConverter.GetJsonDate(seletedConsumer.DateRegistered), seletedConsumer.Email, seletedConsumer.Gender, seletedConsumer.Name, seletedConsumer.Phone, seletedConsumer.Picture, seletedConsumer.Token, seletedConsumer.DeviceId, seletedConsumer.City, seletedConsumer.Country }; var oSerializer = new JavaScriptSerializer(); string sJson = oSerializer.Serialize(query); sJson = @"{""Data"":" + sJson + @",""success"":true}"; return(sJson); } return(null); }
public string GetPromotionsByRetailerIdAndPCategory(int id, int pCat) { var list = service.Where(o => o.Products.All(m => m.Userid == id && m.ProductCategoryId == pCat && m.IsDeleted == false)); var query = from pro in list select new { pro.Id, pro.Description, End = DateConverter.GetJsonDate(pro.End), pro.Price, Start = DateConverter.GetJsonDate(pro.Start), pro.Products.First().Picture, pro.Products.First().ProductCategoryId, pro.Products.First().LikesCounter, productId = pro.Products.First().Id }; var oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string sJson = oSerializer.Serialize(query); sJson = @"{""Data"":" + sJson + @",""success"":true}"; return(sJson); }
public string GetPromotionsByRetailerId(int id) { var cats = categoryService.Where(o => o.UserId == id && o.IsDeleted == false); List <int> catids = new List <int>(); foreach (var c in cats) { catids.Add(c.Id); } var list = service.Where(o => o.Products.All(m => m.Userid == id && m.IsDeleted == false && catids.Contains(m.ProductCategoryId))); // list = service.Where(p => p.Products.All(x => catids.Contains(x.ProductCategoryId))); var query = from pro in list select new { pro.Id, pro.Description, End = DateConverter.GetJsonDate(pro.End), pro.Price, Start = DateConverter.GetJsonDate(pro.Start), pro.Products.First().Picture, pro.Products.First().Name, pro.Products.First().ProductCategoryId, pro.Products.First().LikesCounter, productId = pro.Products.First().Id, pro.DiscountPercentage }; var oSerializer = new System.Web.Script.Serialization.JavaScriptSerializer(); string sJson = oSerializer.Serialize(query); sJson = @"{""Data"":" + sJson + @",""success"":true}"; return(sJson); }
public string RegisterConsumer(string name, string birthDate, int age, string gender, string email, long phone, string address, string deviceId, string country, string city) { var consumerDupEmail = consumerService.Where(o => o.Email.Equals(email)).AsEnumerable(); if (consumerDupEmail.Any()) { string sJson3 = "Account already exists. You may want to login instead."; sJson3 = @"{""Data"":" + sJson3 + @",""success"":false}"; return(sJson3); } if (name.Length > 0 && age > 0 && phone > 0 && address.Length > 0 && email.Length > 0) { DateTime dtBdate = Convert.ToDateTime(birthDate); var cons = service.Create(new Consumer { Name = name, Age = age, BirthDate = dtBdate, Gender = gender, Email = email, Phone = phone, Address = address, DateRegistered = DateTime.Now, DeviceId = deviceId, City = city, Country = country }); service.Save(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Db"].ConnectionString)) using (var command = new SqlCommand("sp_send_dbmail", conn) { CommandType = CommandType.StoredProcedure }) { conn.Open(); command.Parameters.Add(new SqlParameter("@profile_name", "DBMail Profile")); command.Parameters.Add(new SqlParameter("@recipients", email)); command.Parameters.Add(new SqlParameter("@subject", "Registration for Application ...")); command.Parameters.Add(new SqlParameter("@from_address", ConfigurationManager.AppSettings["EmailHost"])); command.Parameters.Add(new SqlParameter("@Body", "Welcome to testAppname")); command.ExecuteNonQuery(); conn.Close(); } var consumer = consumerService.Where(o => o.Email.Equals(email)).AsEnumerable(); var query = from seletedConsumer in consumer select new { seletedConsumer.Address, seletedConsumer.Age, BirthDate = DateConverter.GetJsonDate(seletedConsumer.BirthDate), DateRegistered = DateConverter.GetJsonDate(seletedConsumer.DateRegistered), seletedConsumer.Email, seletedConsumer.Gender, seletedConsumer.Name, seletedConsumer.Phone, seletedConsumer.Picture, seletedConsumer.Token, seletedConsumer.DeviceId, seletedConsumer.Country, seletedConsumer.City }; var oSerializer = new JavaScriptSerializer(); string sJson = oSerializer.Serialize(query); sJson = @"{""Data"":" + sJson + @",""success"":true}"; return(sJson); } else { string sJson2 = "Some required fields are empty."; sJson2 = @"{""Data"":" + sJson2 + @",""success"":false}"; return(sJson2); } string sJson1 = ""; sJson1 = @"{""Data"":" + sJson1 + @",""success"":false}"; return(sJson1); }