public IHttpActionResult PutInkeyUserQuestion(int id, InkeyUserQuestion inkeyUserQuestion)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != inkeyUserQuestion.InkeyUserQuestionsId)
{
return(BadRequest());
}
db.Entry(inkeyUserQuestion).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!InkeyUserQuestionExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task<ActionResult> GetMailingLists()
{
var mailChimpListCollection = await this.manager.Lists.GetAllAsync().ConfigureAwait(false);
foreach (MailChimp.Net.Models.List lst in mailChimpListCollection)
{
var newMailList = new BEMailingList
{
ListName = lst.Name,
ListId = lst.Id,
MemberCount = lst.Stats.MemberCount,
LastUpdated = DateTime.Now
};
BePreferencesEntities db = new BePreferencesEntities();
db.BEMailingLists.Add(newMailList);
db.SaveChanges();
}
MailingListsViewModel vwMod = new MailingListsViewModel();
vwMod.AllLists = mailChimpListCollection;
return View(vwMod);
}
private void AddMemberToDatabase(BEMemberList member, string newListId)
{
try
{
using(var db = new BePreferencesEntities())
{
BEMemberList newMember = new BEMemberList
{
Email = member.Email,
FirstName = member.FirstName,
LastName = member.LastName,
AccessToken = member.AccessToken,
Created = DateTime.Now,
ListId = newListId
};
db.BEMemberLists.Add(newMember);
db.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public ActionResult EditProduct(InkeyProduct inkProduct)
{
try
{
using (var db = new BePreferencesEntities())
{
db.Entry(inkProduct).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("ProductManager"));
}
catch (Exception)
{
throw;
}
}
private void ReInstateMemberToDatabase(BEMemberList member)
{
try
{
using (var db = new BePreferencesEntities())
{
member.Archived = false;
db.Entry(member).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
private void CheckStoresAndAddtoDatabaseUS(List <InkeyStoresU> storesToAdd)
{
try
{
using (var db = new BePreferencesEntities())
{
foreach (InkeyStoresU store in storesToAdd)
{
db.InkeyStoresUS.Add(store);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void CheckQuestionsandAddtoDatabase(List <InkeyAnswer> attendeesToAdd)
{
try
{
using (var db = new BePreferencesEntities())
{
foreach (InkeyAnswer question in attendeesToAdd)
{
db.InkeyAnswers.Add(question);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult EditQuestion(InkeyAnswer inkAnswer)
{
try
{
using (var db = new BePreferencesEntities())
{
inkAnswer.ProductName = db.InkeyProducts.FirstOrDefault(p => p.InkeyProductsId == inkAnswer.ProductId).ProductName;
db.Entry(inkAnswer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("InkeyAnswerForm"));
}
catch (Exception)
{
throw;
}
}
public ActionResult RemoveProduct(int prodId)
{
try
{
using (var db = new BePreferencesEntities())
{
InkeyProduct newProd = db.InkeyProducts.FirstOrDefault(p => p.InkeyProductsId == prodId);
db.InkeyProducts.Remove(newProd);
db.SaveChanges();
return(RedirectToAction("ProductManager"));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult AddNewProduct(ProductManagerViewModel newProdMod)
{
try
{
using (var db = new BePreferencesEntities())
{
InkeyProduct newProd = newProdMod.NewProduct;
db.InkeyProducts.Add(newProd);
db.SaveChanges();
return(RedirectToAction("ProductManager"));
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult InkeyAnswerForm(InkeyViewModel inkMod)
{
try
{
InkeyAnswer newAns = inkMod.answer;
using (var db = new BePreferencesEntities())
{
newAns.ProductName = db.InkeyProducts.FirstOrDefault(p => p.InkeyProductsId == inkMod.answer.ProductId).ProductName;
db.InkeyAnswers.Add(newAns);
db.SaveChanges();
return(View(new InkeyViewModel()));
}
}
catch (Exception ex)
{
throw ex;
}
}
private void RemoveMemberToDatabase(BEMemberList member, string newListId)
{
try
{
using (var db = new BePreferencesEntities())
{
member.ListId = newListId;
member.Archived = true;
db.Entry(member).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public async Task<ActionResult> GenerateMembers()
{
IMailChimpManager manager = new MailChimpManager(APIKEY);
List<BEMemberList> newMemberList = new List<BEMemberList>();
List<MailChimp.Net.Models.Member> allMembers = new List<MailChimp.Net.Models.Member>();
var mailChimpListCollection = await manager.Lists.GetAllAsync().ConfigureAwait(false);
foreach (MailChimp.Net.Models.List lst in mailChimpListCollection)
{
var lstMembers = await manager.Members.GetAllAsync(lst.Id).ConfigureAwait(false);
allMembers.AddRange(lstMembers);
}
foreach (MailChimp.Net.Models.Member member in allMembers)
{
using (var db = new BePreferencesEntities())
{
var newMember = new BEMemberList
{
FirstName = member.MergeFields.ContainsKey("FNAME") ? member.MergeFields["FNAME"].ToString() : "NA",
LastName = member.MergeFields.ContainsKey("LNAME") ? member.MergeFields["LNAME"].ToString() : "NA",
Email = member.EmailAddress,
AccessToken = Guid.NewGuid().ToString(),
Created = DateTime.Now,
ListId = member.ListId
};
db.BEMemberLists.Add(newMember);
db.SaveChanges();
}
}
return View(newMemberList);
}