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 async Task<ActionResult> UnsubscribeUser(string listId, string email)
{
try
{
IMailChimpManager manager = new MailChimpManager(APIKEY);
using (var db = new BePreferencesEntities())
{
BEMemberList member = db.BEMemberLists.FirstOrDefault(e => e.Email == email);
if (member != null)
{
await this.manager.Members.DeleteAsync(listId, member.Email);
}
RemoveMemberToDatabase(member, listId);
return RedirectToAction("Index", new { email = "*****@*****.**" });
}
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
// GET: Admin
public ActionResult Index()
{
List <UserSubscribedtoListViewModel> userModel = new List <UserSubscribedtoListViewModel>();
MailingListOptionsViewModel mailListOptions = new MailingListOptionsViewModel();
mailListOptions.CurrentlySubscribedListId = "NA";
BePreferencesEntities db = new BePreferencesEntities();
List <BEMailingList> list = db.BEMailingLists.ToList();
foreach (BEMailingList mlist in list)
{
UserSubscribedtoListViewModel beMaiList = new UserSubscribedtoListViewModel();
beMaiList.MailingList = mlist;
userModel.Add(beMaiList);
}
mailListOptions.MailingLists = userModel;
mailListOptions.MailingListMembers = db.BEMailingLists.ToList();
return(View(mailListOptions));
}
public ActionResult GetProductLinks(int id)
{
BePreferencesEntities db = new BePreferencesEntities();
string test = db.InkeyProducts.FirstOrDefault(i => i.InkeyProductsId == id).ProductImageLink + "," + db.InkeyProducts.FirstOrDefault(i => i.InkeyProductsId == id).ProductLink + "," + db.InkeyProducts.FirstOrDefault(i => i.InkeyProductsId == id).PhoneticName;
return(Content(db.InkeyProducts.FirstOrDefault(i => i.InkeyProductsId == id).ProductImageLink + "," + db.InkeyProducts.FirstOrDefault(i => i.InkeyProductsId == id).ProductLink + "," + db.InkeyProducts.FirstOrDefault(i => i.InkeyProductsId == id).PhoneticName));
}
public static List <SelectListItem> GetDropDownListForInkeyProducts()
{
BePreferencesEntities db = new BePreferencesEntities();
return(db.InkeyProducts.Select(r => new SelectListItem {
Text = r.ProductName, Value = r.InkeyProductsId.ToString()
}).ToList());
}
public ActionResult EditQuestion(int id)
{
BePreferencesEntities db = new BePreferencesEntities();
InkeyAnswer answerToEdit = db.InkeyAnswers.FirstOrDefault(i => i.InkeyAnswersId == id);
//answerToEdit.ProductName = db.InkeyProducts.FirstOrDefault(p => p.InkeyProductsId == (int)answerToEdit.ProductId).ProductName;
return(View(db.InkeyAnswers.FirstOrDefault(i => i.InkeyAnswersId == id)));
}
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 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;
}
}
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;
}
}
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 ActionResult Index(string x4p = "*****@*****.**")
{
if (x4p != "*****@*****.**")
{
string decrypted = EncryptionHelper.DecryptRijndael(x4p);
}
List<UserSubscribedtoListViewModel> userModel = new List<UserSubscribedtoListViewModel>();
MailingListOptionsViewModel mailListOptions = new MailingListOptionsViewModel();
mailListOptions.CurrentlySubscribedListId = "NA";
BePreferencesEntities db = new BePreferencesEntities();
List<BEMemberList> listsMemberof = db.BEMemberLists.Where(u => u.Email == x4p).ToList();
foreach (BEMailingList mlist in db.BEMailingLists.ToList())
{
UserSubscribedtoListViewModel beMaiList = new UserSubscribedtoListViewModel();
if (listsMemberof.FirstOrDefault(m => m.ListId == mlist.ListId && m.Archived == false) != null)
{
beMaiList.Subscribed = true;
mailListOptions.CurrentlySubscribedListId = mlist.ListId;
}
else
{
beMaiList.Subscribed = false;
}
beMaiList.MailingList = mlist;
userModel.Add(beMaiList);
}
mailListOptions.Email = x4p;
mailListOptions.MailingLists = userModel;
mailListOptions.MailingListMembers = db.BEMailingLists.ToList();
return View(mailListOptions);
}
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);
}
public async Task<ActionResult> SubscribeUser(string listId, string email)
{
try
{
if (listId == "NA")
return Content("error");
using (var db = new BePreferencesEntities())
{
if (db.BEMemberLists.FirstOrDefault(m => m.Email == email && m.ListId == listId && m.Archived == true) != null)
{
BEMemberList member = db.BEMemberLists.FirstOrDefault(e => e.Email == email && e.ListId == listId);
if (member != null)
{
// MailChimp.Net.Models.Member memberToSubscribe = await GetMember(currentlistId, email);
var newMember = new MailChimp.Net.Models.Member { EmailAddress = email, StatusIfNew = MailChimp.Net.Models.Status.Subscribed };
newMember.MergeFields.Add("FNAME", member.FirstName);
newMember.MergeFields.Add("LNAME", member.LastName);
newMember.MergeFields.Add("FULLNAME", member.FirstName + " " + member.LastName);
await this.manager.Members.AddOrUpdateAsync(listId, newMember);
ReInstateMemberToDatabase(member);
return RedirectToAction("Index", new { email = member.Email });
}
else
{
return RedirectToAction("Index", new { email = email });
}
}
else
{
BEMemberList member = db.BEMemberLists.FirstOrDefault(e => e.Email == email);
if (member != null)
{
// MailChimp.Net.Models.Member memberToSubscribe = await GetMember(currentlistId, email);
var newMember = new MailChimp.Net.Models.Member { EmailAddress = email, StatusIfNew = MailChimp.Net.Models.Status.Subscribed };
newMember.MergeFields.Add("FNAME", member.FirstName);
newMember.MergeFields.Add("LNAME", member.LastName);
newMember.MergeFields.Add("FULLNAME", member.FirstName + " " + member.LastName);
await this.manager.Members.AddOrUpdateAsync(listId, newMember);
AddMemberToDatabase(member, listId);
return RedirectToAction("Index", new { email = member.Email });
}
else
{
return RedirectToAction("Index", new { email = email });
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult EditProduct(int id)
{
BePreferencesEntities db = new BePreferencesEntities();
return(PartialView("Partials/_EditProduct", db.InkeyProducts.FirstOrDefault(s => s.InkeyProductsId == id)));
}
public ActionResult UserQuestions()
{
BePreferencesEntities db = new BePreferencesEntities();
return(View(db.InkeyUserQuestions.ToList()));
}
