private void SaveInterests(Member Member, FormCollection fc) { try { string[] interestSelections = fc.GetValues("interests"); //remove interests List <MemberInterest> toRemove = db.MemberInterest.Where(m => m.MemberID == Member.ID || m.MemberID == null).ToList <MemberInterest>(); db.MemberInterest.RemoveRange(toRemove); //add interests for (int i = 0; i < interestSelections.Count(); i++) { MemberInterest mi = new MemberInterest(); mi.MemberID = (long)Member.ID; mi.InterestID = Convert.ToInt16(interestSelections[i]); db.MemberInterest.Add(mi); } db.SaveChanges(); } catch (Exception ex) { } }
public ActionResult DeleteConfirmed(int id) { MemberInterest memberInterest = db.MemberInterests.Find(id); db.MemberInterests.Remove(memberInterest); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: MemberInterests/Create public ActionResult Create() { ViewBag.MemberID = new SelectList(db.Members, "MemberID", "IdentityType"); ViewBag.ProductCategoryID = new SelectList(db.ProductCategories, "ProductCategoryID", "ProductCategoryCode"); MemberInterest model = new MemberInterest(); model = (MemberInterest)Helpers.TableTracker.TrackCreate(model, "USR"); return(View(model)); }
public ActionResult Edit([Bind(Include = "MemberInterestID,MemberID,ProductCategoryID,DateInserted,DateUpdated,USR")] MemberInterest memberInterest) { if (ModelState.IsValid) { db.Entry(memberInterest).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MemberID = new SelectList(db.Members, "MemberID", "IdentityType", memberInterest.MemberID); ViewBag.ProductCategoryID = new SelectList(db.ProductCategories, "ProductCategoryID", "ProductCategoryCode", memberInterest.ProductCategoryID); return(View(memberInterest)); }
// GET: MemberInterests/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MemberInterest memberInterest = db.MemberInterests.Find(id); if (memberInterest == null) { return(HttpNotFound()); } return(View(memberInterest)); }
// GET: MemberInterests/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MemberInterest model = db.MemberInterests.Find(id); model = (MemberInterest)Helpers.TableTracker.TrackEdit(model, "USR"); if (model == null) { return(HttpNotFound()); } ViewBag.MemberID = new SelectList(db.Members, "MemberID", "IdentityType", model.MemberID); ViewBag.ProductCategoryID = new SelectList(db.ProductCategories, "ProductCategoryID", "ProductCategoryCode", model.ProductCategoryID); return(View(model)); }
public Dictionary <string, string> MemberAccount(FormDataCollection formData) { Dictionary <string, string> result = new Dictionary <string, string>(); AccountService service = new AccountService(db, UserManager); var user = this.User.Identity; if (user == null) { result.Add("Error", "Unathorized"); return(result); } Member validateMember = service.findMember(user.Name); if (validateMember == null) { result.Add("Error", "Member not found"); return(result); } bool dataUpdate = false; if (formData != null) { string memberID = formData.Get("memberID"); if (memberID == null) { result.Add("Error", "MemberID required."); return(result); } int MemberID = Convert.ToInt32(memberID); if (MemberID != validateMember.MemberID) { result.Add("Error", "MemberID does not match authenticated user"); return(result); } // At this point, the authenticated user and memberID parameter have been successfully verified. // get member, Billing & postal (delivery) address and interests Member member = db.Members.Find(MemberID); Address billAddress = db.Addresses.Where(x => x.MemberID == member.MemberID && x.AddressType.ToLower().Equals("billing")).FirstOrDefault(); Address delAddress = db.Addresses.Where(x => x.MemberID == member.MemberID && x.AddressType.ToLower().Equals("postal")).FirstOrDefault(); MemberInterest memberInterest = member.MemberInterests.Where(x => x.MemberID == member.MemberID).FirstOrDefault(); if (formData["name"] != null || formData["surname"] != null || formData["email"] != null || formData["gender"] != null || formData["dateOfBirth"] != null || formData["mobile"] != null | formData["ethnicGroup"] != null || formData["maritalStatus"] != null || formData["children"] != null || formData["industry"] != null || formData["designation"] != null) { dataUpdate = true; member.DateUpdated = DateTime.Now; // Perform member details updates if (formData["name"] != null) { member.FirstName = formData.Get("name").Trim(); } if (formData["surname"] != null) { member.LastName = formData.Get("surname").Trim(); } if (formData["email"] != null) { member.EmailAddress = formData.Get("email").Trim(); } if (formData["gender"] != null) { member.Gender = formData.Get("gender").Trim(); } if (formData["dateOfBirth"] != null) { member.DateOfBirth = Convert.ToDateTime(formData.Get("dateOfBirth").Trim()); } if (formData["mobile"] != null) { member.TelephoneMobile = formData.Get("mobile").Trim(); } if (formData["ethnicGroup"] != null) { member.Ethnicity = formData.Get("ethnicGroup").Trim(); } if (formData["maritalStatus"] != null) { member.MaritalStatus = formData.Get("maritalStatus").Trim(); } if (formData["children"] != null) { member.Children = formData.Get("children").Trim(); } if (formData["industry"] != null) { member.Industry = formData.Get("industry").Trim(); } if (formData["designation"] != null) { member.Designation = formData.Get("designation").Trim(); } } bool addNewDelAddress = false; if (formData["countryDelivery"] != null || formData["stateDelivery"] != null || formData["cityDelivery"] != null || formData["postalDelivery"] != null || formData["addressLine1Delivery"] != null || formData["addressLine2Delivery"] != null) { dataUpdate = true; if (delAddress == null) { addNewDelAddress = true; delAddress = new Address(); delAddress.AddressType = "Postal"; delAddress.DateInserted = DateTime.Now; delAddress.MemberID = member.MemberID; delAddress.USR = "******"; } delAddress.DateUpdated = DateTime.Now; // perform delivery address information updates if (formData["countryDelivery"] != null) { delAddress.Country = formData.Get("countryDelivery").Trim(); } if (formData["stateDelivery"] != null) { delAddress.StateOrProvince = formData.Get("stateDelivery").Trim(); } if (formData["cityDelivery"] != null) { delAddress.CityName = formData.Get("cityDelivery").Trim(); } if (formData["postalDelivery"] != null) { delAddress.ZipOrPostalCode = formData.Get("postalDelivery").Trim(); } if (formData["addressLine1Delivery"] != null) { delAddress.AddressLine1 = formData.Get("addressLine1Delivery").Trim(); } if (formData["addressLine2Delivery"] != null) { delAddress.AddressLine2 = formData.Get("addressLine2Delivery").Trim(); } } bool addNewBillAddress = false; if (formData["countryBill"] != null || formData["stateBill"] != null || formData["cityBill"] != null || formData["postalBill"] != null || formData["addressLine1Bill"] != null || formData["addressLine2Bill"] != null) { dataUpdate = true; if (billAddress == null) { addNewBillAddress = true; billAddress = new Address(); billAddress.AddressType = "Billing"; billAddress.MemberID = member.MemberID; billAddress.USR = "******"; billAddress.DateInserted = DateTime.Now; } billAddress.DateUpdated = DateTime.Now; // perform billing address information updates if (formData["countryBill"] != null) { billAddress.Country = formData.Get("countryBill").Trim(); } if (formData["stateBill"] != null) { billAddress.StateOrProvince = formData.Get("stateBill").Trim(); } if (formData["cityBill"] != null) { billAddress.CityName = formData.Get("cityBill").Trim(); } if (formData["postalBill"] != null) { billAddress.ZipOrPostalCode = formData.Get("postalBill").Trim(); } if (formData["addressLine1Bill"] != null) { billAddress.AddressLine1 = formData.Get("addressLine1Bill").Trim(); } if (formData["addressLine2Bill"] != null) { billAddress.AddressLine2 = formData.Get("addressLine2Bill").Trim(); } } bool addNewMemberInterest = false; if (formData["interestAutomotive"] != null || formData["interestEntertainment"] != null || formData["interestFashion"] != null || formData["interestArt"] != null || formData["interestDecor"] != null || formData["interestExperiences"] != null || formData["interestAppliances"] != null || formData["interestBeauty"] != null || formData["interestTechnology"] != null || formData["interestToys"] != null || formData["interestDining"] != null || formData["interestTravel"] != null || formData["interestOther"] != null) { dataUpdate = true; if (memberInterest == null) { addNewMemberInterest = true; memberInterest = new MemberInterest(); memberInterest.MemberID = member.MemberID; memberInterest.DateInserted = DateTime.Now; memberInterest.USR = "******"; // I don't know what this productCategory table is supposed to represent here.... making it a 1 for now. memberInterest.ProductCategoryID = 1; } memberInterest.DateUpdated = DateTime.Now; // perform interests update if (formData["interestAutomotive"] != null) { memberInterest.MemberInterestAutomotive = Convert.ToBoolean(formData.Get("interestAutomotive").Trim()); } if (formData["interestEntertainment"] != null) { memberInterest.MemberInterestEntertainment = Convert.ToBoolean(formData.Get("interestEntertainment").Trim()); } if (formData["interestFashion"] != null) { memberInterest.MemberInterestFashionAccessories = Convert.ToBoolean(formData.Get("interestFashion").Trim()); } if (formData["interestArt"] != null) { memberInterest.MemberInterestArtCollectibles = Convert.ToBoolean(formData.Get("interestArt").Trim()); } if (formData["interestDecor"] != null) { memberInterest.MemberInterestDecorDesign = Convert.ToBoolean(formData.Get("interestDecor").Trim()); } if (formData["interestExperiences"] != null) { memberInterest.MemberInterestExperiences = Convert.ToBoolean(formData.Get("interestExperiences").Trim()); } if (formData["interestAppliances"] != null) { memberInterest.MemberInterestHomeAppliances = Convert.ToBoolean(formData.Get("interestAppliances").Trim()); } if (formData["interestBeauty"] != null) { memberInterest.MemberInterestHealthBeauty = Convert.ToBoolean(formData.Get("interestBeauty").Trim()); } if (formData["interestTechnology"] != null) { memberInterest.MemberInterestTechnology = Convert.ToBoolean(formData.Get("interestTechnology").Trim()); } if (formData["interestToys"] != null) { memberInterest.MemberInterestToys = Convert.ToBoolean(formData.Get("interestToys").Trim()); } if (formData["interestDining"] != null) { memberInterest.MemberInterestWiningDining = Convert.ToBoolean(formData.Get("interestDining").Trim()); } if (formData["interestTravel"] != null) { memberInterest.MemberInterestTravel = Convert.ToBoolean(formData.Get("interestTravel").Trim()); } if (formData["interestOther"] != null) { memberInterest.MemberInterestOther = formData.Get("interestOther").Trim(); } } if (!dataUpdate) { // No updates to process, just return account detail. Dictionary <string, string> accountDetails = new Dictionary <string, string>(); accountDetails.Add("name", member.FirstName.Trim()); accountDetails.Add("surname", member.LastName.Trim()); string email = (member.EmailAddress != null) ? member.EmailAddress.Trim() : ""; string gender = (member.Gender != null) ? member.Gender.Trim() : ""; string dob = (member.DateOfBirth != null) ? ((DateTime)member.DateOfBirth).ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : ""; string mobile = (member.TelephoneMobile != null) ? member.TelephoneMobile.Trim() : ""; string ethnicGroup = (member.Ethnicity != null) ? member.Ethnicity.Trim() : ""; string maritalStatus = (member.MaritalStatus != null) ? member.MaritalStatus.Trim() : ""; string children = (member.Children != null) ? member.Children.Trim() : ""; string industry = (member.Industry != null) ? member.Industry.Trim() : ""; string designation = (member.Designation != null) ? member.Designation.Trim() : ""; accountDetails.Add("email", email); accountDetails.Add("gender", gender); accountDetails.Add("dateOfBirth", dob); accountDetails.Add("mobile", mobile); accountDetails.Add("ethnicGroup", ethnicGroup); accountDetails.Add("maritalStatus", maritalStatus); accountDetails.Add("children", children); accountDetails.Add("industry", industry); accountDetails.Add("designation", designation); if (billAddress != null) { string countryBill = (billAddress.Country != null) ? billAddress.Country.Trim() : ""; string stateBill = (billAddress.StateOrProvince != null) ? billAddress.StateOrProvince.Trim() : ""; string cityBill = (billAddress.CityName != null) ? billAddress.CityName.Trim() : ""; string postalBill = (billAddress.ZipOrPostalCode != null) ? billAddress.ZipOrPostalCode.Trim() : ""; string addressLine1Bill = (billAddress.AddressLine1 != null) ? billAddress.AddressLine1.Trim() : ""; string addressLine2Bill = (billAddress.AddressLine2 != null) ? billAddress.AddressLine2.Trim() : ""; accountDetails.Add("countryBill", countryBill); accountDetails.Add("stateBill", stateBill); accountDetails.Add("cityBill", cityBill); accountDetails.Add("postalBill", postalBill); accountDetails.Add("addressLine1Bill", addressLine1Bill); accountDetails.Add("addressLine2Bill", addressLine2Bill); } if (delAddress != null) { string countryDelivery = (delAddress.Country != null) ? delAddress.Country.Trim() : ""; string stateDelivery = (delAddress.StateOrProvince != null) ? delAddress.StateOrProvince.Trim() : ""; string cityDelivery = (delAddress.CityName != null) ? delAddress.CityName.Trim() : ""; string postalDelivery = (delAddress.ZipOrPostalCode != null) ? delAddress.ZipOrPostalCode.Trim() : ""; string addressLine1Delivery = (delAddress.AddressLine1 != null) ? delAddress.AddressLine1.Trim() : ""; string addressLine2Delivery = (delAddress.AddressLine2 != null) ? delAddress.AddressLine2.Trim() : ""; accountDetails.Add("countryDelivery", countryDelivery); accountDetails.Add("stateDelivery", stateDelivery); accountDetails.Add("cityDelivery", cityDelivery); accountDetails.Add("postalDelivery", postalDelivery); accountDetails.Add("addressLine1Delivery", addressLine1Delivery); accountDetails.Add("addressLine2Delivery", addressLine2Delivery); } if (memberInterest != null) { string interestOther = (memberInterest.MemberInterestOther != null) ? memberInterest.MemberInterestOther.Trim() : ""; accountDetails.Add("interestAutomotive", memberInterest.MemberInterestAutomotive.ToString()); accountDetails.Add("interestEntertainment", memberInterest.MemberInterestEntertainment.ToString()); accountDetails.Add("interestFashion", memberInterest.MemberInterestFashionAccessories.ToString()); accountDetails.Add("interestArt", memberInterest.MemberInterestArtCollectibles.ToString()); accountDetails.Add("interestDecor", memberInterest.MemberInterestDecorDesign.ToString()); accountDetails.Add("interestExperiences", memberInterest.MemberInterestExperiences.ToString()); accountDetails.Add("interestAppliances", memberInterest.MemberInterestHomeAppliances.ToString()); accountDetails.Add("interestBeauty", memberInterest.MemberInterestHealthBeauty.ToString()); accountDetails.Add("interestTechnology", memberInterest.MemberInterestTechnology.ToString()); accountDetails.Add("interestToys", memberInterest.MemberInterestToys.ToString()); accountDetails.Add("interestDining", memberInterest.MemberInterestWiningDining.ToString()); accountDetails.Add("interestTravel", memberInterest.MemberInterestTravel.ToString()); accountDetails.Add("interestOther", interestOther); } return(accountDetails); } else { try { if (addNewBillAddress) { db.Addresses.Add(billAddress); } if (addNewDelAddress) { db.Addresses.Add(delAddress); } if (addNewMemberInterest) { db.MemberInterests.Add(memberInterest); } db.SaveChanges(); result.Add("Success", "Successfully saved changes"); return(result); } catch (System.Data.Entity.Validation.DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); result.Add("Property: " + ve.PropertyName, " Error: " + ve.ErrorMessage); } } result.Add("Error", "During Save"); return(result); } } } else { result.Add("Input Error", "No Valid Data"); } return(result); }
private void UpdateInterest(MemberInterest interest, IDataGateway dataGateway) { dataGateway.Connection.Execute(@"update memberinterest set vkgroupid = @VkGroupId, vkmemberid = @VkMemberId, title = @Title, type = @Type where id = @Id", interest); }
private void InsertInterest(MemberInterest interest, IDataGateway dataGateway) { interest.Id = dataGateway.Connection.Query <int>(@"insert into memberinterest(vkgroupid, vkmemberid, title, type) values (@VkGroupId, @VkMemberId, @Title, @Type) RETURNING id", interest).First(); }