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