public static Boolean createAccount(string email, string first, string last, string password, string gender, DateTime birthday) { try { SIEBUEntities db = new SIEBUEntities(); if (db.Users.Where(u => u.email == email).Count() == 0) { //populate user object with general information User n_customer = new User(); n_customer.email = email; n_customer.firstName = first; n_customer.lastName = last; n_customer.dob = birthday; n_customer.joindate = DateTime.Now; n_customer.gender = (gender == "female") ? true : false; // encryption/salt creation byte[] salt = new byte[48]; new RNGCryptoServiceProvider().GetBytes(salt); n_customer.salt = salt; n_customer.password = encrypt(email, password, salt); db.Users.Add(n_customer); db.SaveChanges(); return true; } return false; } catch (Exception e) { Console.WriteLine("The Error is " + e.ToString()); return false; } }
public Boolean LikeProduct(int p_id) { SIEBUEntities db = new SIEBUEntities(); Product_Like p_like = db.Product_Like.FirstOrDefault(pl => pl.product_id == p_id && pl.user_id == WebSecurity.CurrentUserId); if (p_like != null) { db.Product_Like.Remove(p_like); db.SaveChanges(); return false; } p_like = new Product_Like(); p_like.user_id = WebSecurity.CurrentUserId; p_like.product_id = p_id; db.Product_Like.Add(p_like); db.SaveChanges(); return true; }
public static void createPurchaseHistory(int customerID, decimal amountPaid, int transaction_id, Boolean isPaypal) { SIEBUEntities db = new SIEBUEntities(); //CREATE THE USER CREDIT HISTORY AND PURCHASE HISTORY User_Purchase_History purchaseHistory = new User_Purchase_History(); purchaseHistory.user_id = customerID; purchaseHistory.value = amountPaid; purchaseHistory.date = DateTime.Now; if (isPaypal) { purchaseHistory.paypal_transaction_id = transaction_id; } else { purchaseHistory.transaction_id = transaction_id; } db.User_Purchase_History.Add(purchaseHistory); db.SaveChanges(); }
public static void createCreditHistory(Dictionary<int, int> subtransactionIds, Boolean isPaypal) { SIEBUEntities db = new SIEBUEntities(); foreach (var pair in subtransactionIds) { int subtransactions = pair.Value; User_Credit_History creditHistory = new User_Credit_History(); //get the store's user id. creditHistory.date = DateTime.Now; creditHistory.value = (decimal)db.Transaction_Subtransaction.Where(sub => sub.st_id == subtransactions).FirstOrDefault().total; creditHistory.user_id = pair.Key; if (isPaypal) { creditHistory.paypal_subtransaction_id = subtransactions; } else { creditHistory.subtransaction_id = subtransactions; } db.User_Credit_History.Add(creditHistory); } db.SaveChanges(); }
public ActionResult DeleteBlog(string blog_id) { try { SIEBUEntities db = new SIEBUEntities(); int id = int.Parse(blog_id); db.Store_NewsItem.FirstOrDefault(ni => ni.sn_id == id).is_deleted = true; db.SaveChanges(); return Json(true, JsonRequestBehavior.AllowGet); } catch (Exception e) { return Json(false, JsonRequestBehavior.AllowGet); } }
public ActionResult UpdateStore(StoreModel update) { //StoreModel update = JsonConvert.DeserializeObject<StoreModel>(obj); SIEBUEntities db = new SIEBUEntities(); Store target_store = db.Stores.FirstOrDefault(s => s.s_id == update.id); //if no store is found, create one bool add_new = false; if (target_store == null) { add_new = true; target_store = new Store(); target_store.creator_id = WebSecurity.CurrentUserId; target_store.created_on = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); target_store.credit = 0; } //check for conflicting namespace if (ValidationController.checkNamespaceAvailability(update.store_namespace) != true) return Json(new { error = "The namespace is unavailable for use." }, JsonRequestBehavior.AllowGet); target_store.name = update.name; target_store.name_space = update.store_namespace; target_store.description = update.description; target_store.category_id = update.category; target_store.status = update.status; //create store before connections required if (add_new) { db.Stores.Add(target_store); db.SaveChanges(); } if (target_store.logo == null || !(update.logo + "").Contains(target_store.logo)) //(!(target_store.logo == update.logo || update.logo.Contains(target_store.logo))) target_store.logo = update.logo != null ? ImageController.UploadFile(update.logo, "logo" + target_store.s_id) : null; if (target_store.banner_img == null || !(update.banner + "").Contains(target_store.banner_img)) target_store.banner_img = update.banner != null ? ImageController.UploadFile(update.banner, "banner" + target_store.s_id) : null; if (target_store.background_img == null || !(update.background + "").Contains(target_store.background_img)) //) CHANGED FOR PARTIAL URLS target_store.background_img = update.background != null ? ImageController.UploadFile(update.background, "background" + target_store.s_id) : null; //update social media foreach (SocialMediaModel sm in update.social_media) { Store_Contact ssm = db.Store_Contact.FirstOrDefault(q => q.store == update.id && q.Contact.caption == sm.type); bool add_new_sm = false; if (ssm == null) { add_new = true; ssm = new Store_Contact(); } ssm.value = sm.url; if (add_new_sm) db.Store_Contact.Add(ssm); } db.SaveChanges(); return Json(target_store.name_space, JsonRequestBehavior.AllowGet); }
public ActionResult UpdateProduct(ProductModel update) { SIEBUEntities db = new SIEBUEntities(); Product target_product = db.Products.FirstOrDefault(p => p.p_id == update.id); Product_History history = new Product_History(); //if no product is found, create one bool add_new = false; if (target_product == null) { add_new = true; target_product = new Product(); target_product.dateadded = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); } target_product.lastmodified = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); history.datemodified = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); bool change_made = false; if (target_product.name != update.name || target_product.sku != update.sku) { change_made = true; history.name = target_product.name; history.sku = target_product.sku; target_product.name = update.name; target_product.sku = update.sku; } if (!((target_product.cost + target_product.shipping_cost).Equals(update.cost + update.shipping_cost))) { change_made = true; history.cost = target_product.cost; history.shipping_cost = target_product.shipping_cost; target_product.cost = Convert.ToDecimal(update.cost, CultureInfo.GetCultureInfo("en")); target_product.shipping_cost = Convert.ToDecimal(update.shipping_cost, CultureInfo.GetCultureInfo("en")); } if (target_product.avail_inventory != update.avail_inventory) { change_made = true; history.avail_inventory = target_product.avail_inventory; target_product.avail_inventory = update.avail_inventory; } target_product.short_description = update.short_description; target_product.description = update.description; if (target_product.status != update.status) { change_made = true; history.status = target_product.status; target_product.status = update.status; } if (target_product.is_featured != update.is_featured) { change_made = true; history.is_featured = target_product.is_featured; target_product.is_featured = update.is_featured; if (update.is_featured) { target_product.featured_since = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); } else { target_product.featured_since = null; } } if (add_new) { target_product.store_id = update.store_id; db.Products.Add(target_product); db.SaveChanges(); //changes must be saved so that product_id exists for image/tag/history foreign key relationships } foreach (ProductImageModel pim in update.images) { Product_Image target_image = db.Product_Image.FirstOrDefault(p => p.pi_id == pim.id); //only save up to 8 images per product if (db.Product_Image.Count(p => p.product_id == target_product.p_id) <= 8) { bool add_new_img = false; if (target_image == null) { add_new_img = true; target_image = new Product_Image(); } target_image.product_id = target_product.p_id; target_image.sort = pim.order; //check to make sure update does not match existing content if ((target_image.url == null || !(pim.url + "").Contains(target_image.url)) && pim.url != null) { //if different from original, determine whether value is blank (for purpose of removing images) if (pim.url != null) target_image.url = ImageController.UploadFile(pim.url, target_image.product_id + "" + target_image.pi_id + "" + target_product.lastmodified.Value.ToString("ffffff")); else target_image.url = null; } if (add_new_img) db.Product_Image.Add(target_image); } if (pim.delete) db.Product_Image.Remove(target_image); } foreach (ProductTagModel ptm in update.tags) { //create tag if non-existent Tag ref_tag = db.Tags.FirstOrDefault(t => t.caption == ptm.caption.Trim().ToLower()); if (ref_tag == null) { ref_tag = new Tag(); ref_tag.caption = ptm.caption.Trim().ToLower(); db.Tags.Add(ref_tag); db.SaveChanges(); } //tolower to compare captions Product_Tag target_tag = db.Product_Tag.FirstOrDefault(t => t.product_id == update.id && t.Tag.t_id == ref_tag.t_id); bool add_new_tag = false; if (target_tag == null) { add_new_tag = true; target_tag = new Product_Tag(); } target_tag.product_id = target_product.p_id; target_tag.tag_id = ref_tag.t_id; if (add_new_tag) db.Product_Tag.Add(target_tag); if (ptm.delete) db.Product_Tag.Remove(target_tag); } if (change_made) db.Product_History.Add(history); history.product_id = target_product.p_id; db.SaveChanges(); return Json(target_product.p_id, JsonRequestBehavior.AllowGet); }
public ActionResult UpdateBlog(BlogEntryModel update) { SIEBUEntities db = new SIEBUEntities(); Store_NewsItem target_entry = db.Store_NewsItem.FirstOrDefault(ni => ni.sn_id == update.id); //if no id is given, create new blog entry bool add_new = false; if (target_entry == null) { add_new = true; target_entry = new Store_NewsItem(); target_entry.store_id = update.store_id; target_entry.author_id = WebSecurity.CurrentUserId; target_entry.date_added = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); } target_entry.title = update.title; target_entry.last_modified = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); target_entry.description = update.description; target_entry.text = update.body_text; target_entry.is_featured = update.is_featured; if (update.is_featured) { target_entry.featured_since = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time")); } else { target_entry.featured_since = null; } target_entry.is_draft = update.is_draft; if (add_new) { db.Store_NewsItem.Add(target_entry); db.SaveChanges(); } //if the update is not equal to the target image if (target_entry.img == null || !(update.img + "").Contains(target_entry.img)) //target_entry.img != update.img) target_entry.img = update.img != null ? ImageController.UploadFile(update.img, update.store_id + "" + target_entry.sn_id) : null; //no unique file name required + "" + target_entry.last_modified.Value.ToString("ffffff") db.SaveChanges(); return Json(target_entry.sn_id, JsonRequestBehavior.AllowGet); }
public ActionResult DeleteProducts(string[] id_list) { try { SIEBUEntities db = new SIEBUEntities(); for (int i = 0; i < id_list.Length; i++) { int id = int.Parse(id_list[i]); db.Products.FirstOrDefault(p => p.p_id == id).is_deleted = true; } db.SaveChanges(); return Json(true, JsonRequestBehavior.AllowGet); } catch (Exception e) { return Json(false, JsonRequestBehavior.AllowGet); } }
public static String editProfile(String email, String firstName, String lastName, String gender, DateTime Birthday, String about, String profileImage) { SIEBUEntities context = new SIEBUEntities(); if (context.Users.Where(u => u.email == email).Count() != 0) { try { User user = context.Users.First(c => c.email == email); // Must check if user is in the database user.firstName = firstName; user.lastName = lastName; user.gender = (gender == "female") ? true : false; user.dob = Birthday; user.about = about; if (user.profileimg_url == null || !(profileImage + "").Contains(user.profileimg_url)) { user.profileimg_url = profileImage == null ? null : ImageController.UploadFile(profileImage, "profile" + WebSecurity.CurrentUserId); } context.SaveChanges(); return ""; } catch { return "Changes to your account could not be made at this time"; // Changes could not be made/ } } //Could not find email return "Could not find account with associated Email"; }
//public static UserModel getProfile(String email) //{ // SIEBUEntities context = new SIEBUEntities(); // if (context.Users.Where(u => u.email == email).Count() != 0) // { // User user = context.Users.First(c => c.email == email); // Must check if user is in the database // UserModel model = new UserModel(); // model.id = user.id; // model.email = email; // model.first_name = user.firstName; // model.last_name = user.lastName; // model.dob = user.dob; // model.gender = Convert.ToInt32(user.gender).ToString(); // model.about = user.about; // model.profile_image = user.profileimg_url; // model.location = user.location; // model.contact_email = (user.User_Contact.Count(c => c.Contact.caption == "Email Address") > 0 ? user.User_Contact.Where(c => c.Contact.caption == "Email Address").FirstOrDefault().value : ""); // model.website = (user.User_Contact.Count(c => c.Contact.caption == "Website") > 0 ? user.User_Contact.Where(c => c.Contact.caption == "Website").FirstOrDefault().value : ""); // model.social_media = SocialMediaModel.getSocialMedia(user, context); // return model; // } // return null; //} public static String editProfile(String user_email, FormCollection form) { SIEBUEntities db = new SIEBUEntities(); User target_user = db.Users.Where(u => u.email == user_email).FirstOrDefault(); if (target_user == null) { try { target_user.firstName = form["manage_firstname"]; target_user.lastName = form["manage_lastname"]; target_user.gender = (form["gender"] == "female" ? true : false); target_user.dob = new DateTime(int.Parse(form["bYear"]), int.Parse(form["bMonth"]), int.Parse(form["bDay"])); target_user.location = form["manage_location"]; target_user.about = form["about"]; if (target_user.profileimg_url == null || !(form["image-input"] + "").Contains(target_user.profileimg_url)) { target_user.profileimg_url = form["image-input"] == null ? null : ImageController.UploadFile(form["image-input"], "profile" + WebSecurity.CurrentUserId); } User_Contact contact_email = target_user.User_Contact.Where(c => c.Contact.caption == "Email Address").FirstOrDefault(); if (contact_email == null) { contact_email = new User_Contact(); contact_email.u_id = target_user.id; contact_email.social_media = db.Contacts.Where(c => c.caption == "Email Address").FirstOrDefault().sm_id; db.User_Contact.Add(contact_email); db.SaveChanges(); } contact_email.value = form["manage_contactemail"]; User_Contact website = target_user.User_Contact.Where(c => c.Contact.caption == "Website").FirstOrDefault(); if (website == null) { website = new User_Contact(); website.u_id = target_user.id; website.social_media = db.Contacts.Where(c => c.caption == "Website").FirstOrDefault().sm_id; db.User_Contact.Add(contact_email); db.SaveChanges(); } website.value = form["manage_website"]; foreach (Contact socialmedia in db.Contacts.Where(c => c.is_socialmedia == true)) { User_Contact sm = target_user.User_Contact.Where(c => c.social_media == socialmedia.sm_id).FirstOrDefault(); if (sm == null) { sm = new User_Contact(); sm.u_id = target_user.id; sm.social_media = socialmedia.sm_id; db.User_Contact.Add(sm); db.SaveChanges(); } sm.value = form["manage-" + socialmedia.caption]; } db.SaveChanges(); } catch (ArgumentOutOfRangeException) { return "Date of Birth not valid"; } catch { return "Changes to your account could not be made at this time"; // Changes could not be made/ } } //Could not find email return "Could not find account with associated Email"; }
/// <summary> /// Store cart in the database after session has ended /// </summary> /// <param name="userId">User's id</param> /// <param name="cartInSession">the cart in the session</param> /// <returns>true if the cart has been saved and false if otherwise</returns> public Boolean storeCartInDB(int userId) { //TODO: TESTING FOR ALL CASES SIEBUEntities db = new SIEBUEntities(); List<Shopping_Cart> cartInDB = db.Shopping_Cart.Where(cart => cart.userID == userId).ToList(); //Compare database with the session to remove items that have been removed in the session cart Boolean contains = false; for (int i = 0; i < cartInDB.Count; i++) { //compare every item associated to a store in the shopping cart. foreach (CartItem item in this.cartItems) { contains = cartInDB[i].productID == item.productId && cartInDB[i].userID == userId; if (contains) break; //found the item in both database and session cart. } /* for (int y = 0; y < cartInSession.Items.Count && !contains; y++) { contains = cartInDB[i].productID == cartInSession.Items[y].productId && cartInDB[i].storeID == cartInSession.Items[y].storeId && cartInDB[i].userID == userId; } */ if (!contains) { db.Shopping_Cart.Remove(cartInDB[i]); //remove items in the database that are not in the cart. Debug.WriteLine("cart item: " + cartInDB[i].id + "removed"); } contains = false; } db.SaveChanges(); /*Compare session with the database to add items that are in the session but not in the db or modify that quantity for the item that are in both*/ cartInDB = db.Shopping_Cart.Where(cart => cart.userID == userId).ToList(); //Retrieve the new list contains = false; foreach (CartItem cItem in this.cartItems) { int index = -1; for (int y = 0; !contains && y < cartInDB.Count; y++) { contains = cartInDB[y].productID == cItem.productId && cartInDB[y].storeID == cItem.storeId && cartInDB[y].userID == userId; if (contains) { index = y; } } if (!contains) //if it's a new record then add it { Shopping_Cart item = new Shopping_Cart(); item.userID = userId; item.dateAdded = DateTime.Now; item.productID = cItem.productId; item.quantity = cItem.quantity; item.storeID = cItem.storeId; db.Shopping_Cart.Add(item); } else //Existing record. Modify quantity { Shopping_Cart item = cartInDB[index]; item.quantity = cItem.quantity; } contains = false; } db.SaveChanges(); return true; }
/// <summary> /// Update the user's recently viewed product in the cookie and database /// </summary> /// <param name="s_id">shop id</param> /// <param name="p_id">product id</param> /// <param name="max">max amount of product views</param> public static HttpCookie updateViewCookieHistory(int userId, HttpCookie cookie, int s_id, int p_id = 0, int max = 10) { HttpCookie returnCookie = new HttpCookie(cookie.Name); returnCookie.Value = ""; SIEBUEntities db = new SIEBUEntities(); Store store = db.Stores.FirstOrDefault(s => s.s_id == s_id); Product product = db.Products.FirstOrDefault(p => p.p_id == p_id); User_SearchHistory record = db.User_SearchHistory.FirstOrDefault(search => search.user_id == userId && search.product_id == product.p_id); if (record != null) //modify existing record in the database or add it { record.dateaccessed = DateTime.Now; } else //add new record in the database { record = new User_SearchHistory(); record.product_id = product.p_id; record.store_id = store.s_id; record.user_id = userId; record.dateaccessed = DateTime.Now; db.User_SearchHistory.Add(record); } db.SaveChanges(); //Set the cookie history //var cookie = Request.Cookies["item_hist"]; String itemHist = ""; HttpCookie productCookie = null; if (cookie == null) //cookie doesn't exist { productCookie = recentStoreViewedCookie(userId); itemHist = productCookie.Value; //Response.Cookies.Add(productCookie); } else //get the value { itemHist = cookie.Value; } if (itemHist != "") { String[] cookieRecords = itemHist.Split('|'); Boolean contains = false; int index = -1; try { for (int i = 0; i < cookieRecords.Length; i++) // Check and find the index of the item if it is in the cookie { String[] cookieRecord = cookieRecords[i].Split('&'); int storeId = int.Parse(cookieRecord[0].ToString()); int productId = int.Parse(cookieRecord[2].ToString()); if (storeId == store.s_id && product.p_id == productId) { contains = true; index = i; break; } } if (!contains) // new record add it in the cookie { String cookieValue = ""; if (cookieRecords.Length >= max) { for (int i = 0; i < cookieRecords.Length - 1; i++) //Take the first items in the record { cookieValue = cookieValue + "|" + cookieRecords[i]; } //add element 0 before cookieValue; returnCookie.Value = getItemCookieValue(store.s_id, store.name_space, product.p_id, product.name, (product.Product_Image.Count > 0 ? product.Product_Image.First().url : "/content/no-image"), store.name, (store.logo != null) ? store.logo : "/content/no-image") + cookieValue; } else { returnCookie.Value = getItemCookieValue(store.s_id, store.name_space, product.p_id, product.name, (product.Product_Image.Count > 0 ? product.Product_Image.First().url : "/content/no-image"), store.name, (store.logo != null) ? store.logo : "/content/no-image") + "|" + cookieValue; } } else //Modify existing record in the cookie { String cookieValue = ""; if (index != 0) //first element is not the product { if (index == cookieRecords.Length - 1) //the record is the last element in the cookie. { cookieValue = cookieRecords[cookieRecords.Length - 1]; for (int i = 0; i != cookieRecords.Length - 1; i++) { cookieValue = cookieValue + "|" + cookieRecords[i]; } returnCookie.Value = cookieValue; } else //record in the middle { String before = cookieRecords[0]; // for sure not the first element since we checked earlier for (int i = 1; i < index; i++) { before = before + "|" + cookieRecords[i]; } String after = cookieRecords[index + 1]; for (int i = index + 2; i < cookieRecords.Length; i++) { after = after + "|" + cookieRecords[i]; } returnCookie.Value = cookieRecords[index] + "|" + before + "|" + after; } } else //first element is the first product. Just return the same thing { returnCookie.Value = itemHist; //just return the same cookie. } } } catch (Exception e) { //Debug.WriteLine("Exception has occured with modifying the recently viewed store cookie: " + e.ToString()); //Response.Cookies.Add(NavigationModel.recentProductsViewedCookie(WebSecurity.CurrentUserId)); returnCookie.Value = itemHist; } } else // First record on the list { returnCookie.Value = NavigationModel.getItemCookieValue(store.s_id, store.name_space, product.p_id, product.name, (product.Product_Image.Count > 0 ? product.Product_Image.First().url : "/content/no-image"), store.name, (store.logo != null) ? store.logo : "/content/no-image"); } return returnCookie; }
/// <summary> /// Update the recent stores viewed in the cookie and add in the database /// </summary> /// <param name="userId">user's id</param> /// <param name="store">store viewed</param> /// <param name="max">max items in a cookie</param> /// <returns></returns> public static HttpCookie updateStoreViewHistory(int userId, HttpCookie cookie, Store store, int max = 10) { HttpCookie returnCookie = new HttpCookie(cookie.Name); returnCookie.Value = ""; //add the new store in the database SIEBUEntities db = new SIEBUEntities(); User_SearchHistory record = db.User_SearchHistory.FirstOrDefault(search => search.store_id == store.s_id && search.product_id == null); if (record != null) //modify existing record in the database or add it { record.dateaccessed = DateTime.Now; } else //add new record in the database { record = new User_SearchHistory(); record.store_id = store.s_id; record.user_id = userId; record.dateaccessed = DateTime.Now; db.User_SearchHistory.Add(record); } db.SaveChanges(); String storeHist = ""; HttpCookie storeCookie = null; if (cookie == null) //cookie doesn't exist { storeCookie = recentStoreViewedCookie(userId); storeHist = storeCookie.Value; } else //get the value { storeHist = cookie.Value; } if (storeHist != "") { String[] cookieRecords = storeHist.Split('|'); Boolean contains = false; int index = -1; try { for (int i = 0; i < cookieRecords.Length; i++) // Check and find the index of the item if it is in the cookie { String[] cookieRecord = cookieRecords[i].Split('&'); int storeId = int.Parse(cookieRecord[0].ToString()); if (storeId == store.s_id) { contains = true; index = i; break; } } String cookieValue = ""; if (!contains) //new record { if (cookieRecords.Length >= max) { for (int i = 0; i < cookieRecords.Length - 1; i++) //Take the first items in the record minus the last element { cookieValue = cookieValue + "|" + cookieRecords[i]; } //add element 0 before cookieValue; returnCookie.Value = getStoreCookieValue(store.s_id, store.name, store.name_space, (store.logo != null) ? store.logo : "/content/no-image") + cookieValue; } else { returnCookie.Value = getStoreCookieValue(store.s_id, store.name, store.name_space, (store.logo != null) ? store.logo : "/content/no-image") + "|" + storeHist; } } else //modify existing cookie { if (index != 0) // if index == 0 then it's just the first element and we don't need to do anything { if (index == cookieRecords.Length - 1) //the record is the last element in the cookie. { cookieValue = cookieRecords[cookieRecords.Length - 1]; for (int i = 0; i != cookieRecords.Length - 1; i++) { cookieValue = cookieValue + "|" + cookieRecords[i]; } returnCookie.Value = cookieValue; } else //record is in the middle of the cookie { String before = cookieRecords[0]; for (int i = 1; i < index; i++) { before = before + "|" + cookieRecords[i]; } String after = cookieRecords[index + 1]; for (int i = index + 2; i < cookieRecords.Length; i++) { after = after + "|" + cookieRecords[i]; } returnCookie.Value = cookieRecords[index] + "|" + before + "|" + after; } } else { returnCookie.Value = storeHist; //just return the same cookie. } } } catch (Exception e) { //Debug.WriteLine("Exception has occured with modifying the recently viewed store cookie: " + e.ToString()); returnCookie.Value = storeHist; //Response.Cookies.Add(recentStoreViewedCookie(WebSecurity.CurrentUserId)); } } else //first shop viewed. { returnCookie.Value = getStoreCookieValue(store.s_id, store.name, store.name_space, store.logo); } return returnCookie; }
public static String editProfile(String email, String firstName, String lastName, String gender, DateTime Birthday, String about) { SIEBUEntities context = new SIEBUEntities(); if (context.Users.Where(u => u.email == email).Count() != 0) { try { User user = context.Users.First(c => c.email == email); // Must check if user is in the database user.firstName = firstName; user.lastName = lastName; user.gender = (gender == "female") ? true : false; user.dob = Birthday; user.about = about; context.SaveChanges(); return ""; } catch { return "Changes to your account could not be made at this time"; // Changes could not be made/ } } //Could not find email return "Could not find account with associated Email"; }