public static void Updatebrands(List <brand> brands) { using (var context = new WebsiteTTKEntities()) { foreach (brand item in brands) { var result = context.brands.SingleOrDefault(b => b.brand_id == item.brand_id); if (result != null) { result.brand_name = item.brand_name; result.brand_description = item.brand_description; result.images = item.images; result.create_date = item.create_date; context.SaveChanges(); } else { context.brands.Add(new brand { brand_name = item.brand_name, brand_description = item.brand_description, images = item.images, create_date = item.create_date, }); context.SaveChanges(); } } } }
public static void Updatecolours(List <colour> colours, bool isUpdateProductImages = false) { using (var context = new WebsiteTTKEntities()) { foreach (colour item in colours) { var result = context.colours.SingleOrDefault(b => b.colour_id == item.colour_id); if (result != null) { result.colour_name = item.colour_name; result.colour_description = item.colour_description; result.create_date = item.create_date; context.SaveChanges(); } else { context.colours.Add(new colour { colour_name = item.colour_name, colour_description = item.colour_description, create_date = item.create_date, }); context.SaveChanges(); } } } }
/// <summary> /// Update or add a new address /// </summary> /// <param name="addresses">List of address to be updated or added</param> public static void UpdateUserAddresses(List <AspNetUserAddress> addresses) { using (var context = new WebsiteTTKEntities()) { foreach (AspNetUserAddress item in addresses) { var result = context.AspNetUserAddresses.SingleOrDefault(b => b.Id == item.Id); if (result != null) { result.Firstname = item.Firstname; result.Lastname = item.Lastname; result.Company = item.Company; result.Street = item.Street; result.City = item.City; result.Zip = item.Zip; result.State = item.State; result.Country = item.Country; result.Birthday = item.Birthday; result.Gender = item.Gender; result.PhoneNumber = item.PhoneNumber; result.Email = item.Email; result.AddressType = item.AddressType; context.SaveChanges(); } else { context.AspNetUserAddresses.Add(new AspNetUserAddress { UserId = item.UserId, Firstname = item.Firstname, Lastname = item.Lastname, Company = item.Company, Street = item.Street, City = item.City, Zip = item.Zip, State = item.State, Country = item.Country, Birthday = item.Birthday, Gender = item.Gender, PhoneNumber = item.PhoneNumber, Email = item.Email, AddressType = item.AddressType }); context.SaveChanges(); } } } }
public static string UpdateNewOrderShippingCost(string userId, int delivery_id) { try { using (var context = new WebsiteTTKEntities()) { order order = context.orders.FirstOrDefault(x => x.customer_id == userId && x.order_status == (int)OrderStatus.Status.New); List <order_items> orderItems = context.order_items.Where(x => x.order_id == order.order_id).ToList(); if (order != null) { order.delivery_id = delivery_id; context.SaveChanges(); return(null); } else { return("Order doesn't exist!"); } } } catch (Exception ex) { LogHelper.Log("App_Code\\Helper\\OrderHelper.cs", LogHelper.ErrorType.Error, ex); return("Cannot update order's shipping cost!"); } }
/// <summary> /// Update customer address /// </summary> /// <param name="customer">Customer entity</param> /// <returns></returns> public static string UpdateCustomerAddress(Customer customer) { try { AspNetUser user = customer.AspNetUser; AspNetUserAddress address = customer.AspNetUserAddress; using (var context = new WebsiteTTKEntities()) { var existAddress = context.AspNetUserAddresses.FirstOrDefault(x => x.UserId == user.Id); existAddress.Firstname = address.Firstname; existAddress.Lastname = address.Lastname; existAddress.Company = address.Company; existAddress.Street = address.Street; existAddress.City = address.City; existAddress.Zip = address.Zip; existAddress.State = address.State; existAddress.PhoneNumber = address.PhoneNumber; existAddress.Email = address.Email; existAddress.Country = address.Country; context.SaveChanges(); return(null); } } catch (Exception ex) { return(ex.Message); } }
public static void AddCurrencyData() { List <string> list = new List <string>(); foreach (System.Globalization.CultureInfo ci in System.Globalization.CultureInfo.GetCultures(System.Globalization.CultureTypes.AllCultures)) { string specName = "(none)"; try { specName = System.Globalization.CultureInfo.CreateSpecificCulture(ci.Name).Name; } catch { } list.Add(ci.Name); } for (int i = 0; i < list.Count; i++) { if (list[i] != "" && list[i].Contains('-')) { try { var cl = new System.Globalization.CultureInfo(list[i]); using (var context = new WebsiteTTKEntities()) { context.currencies.Add(new currency { currency_name = cl.EnglishName, currency_code = cl.Name, currency_symbol = cl.NumberFormat.CurrencySymbol }); context.SaveChanges(); } } catch { } } } }
public static void Updateorders(List <order> orders) { using (var context = new WebsiteTTKEntities()) { foreach (order item in orders) { var result = context.orders.SingleOrDefault(b => b.order_id == item.order_id); if (result != null) { result.customer_id = item.customer_id; result.order_status = item.order_status; result.order_date = item.order_date; result.required_date = item.required_date; result.shipped_date = item.shipped_date; result.store_id = item.store_id; result.staff_id = item.staff_id; result.order_discount = item.order_discount; result.order_discount_is_fixed = item.order_discount_is_fixed; result.delivery_id = item.delivery_id; result.currency_id = item.currency_id; context.SaveChanges(); } else { context.orders.Add(new order { order_id = item.order_id, order_status = item.order_status, order_date = item.order_date, required_date = item.required_date, shipped_date = item.shipped_date, store_id = item.store_id, staff_id = item.staff_id, order_discount = item.order_discount, order_discount_is_fixed = item.order_discount_is_fixed, delivery_id = item.delivery_id, currency_id = item.currency_id, }); context.SaveChanges(); } } } }
public static void Updatestaffs(List <staff> staffs) { using (var context = new WebsiteTTKEntities()) { foreach (staff item in staffs) { var result = context.staffs.SingleOrDefault(b => b.staff_id == item.staff_id); if (result != null) { result.first_name = item.first_name; result.last_name = item.last_name; result.phone = item.phone; result.email = item.email; result.phone = item.phone; result.active = item.active; result.store_id = item.store_id; result.manager_id = item.manager_id; result.address = item.address; context.SaveChanges(); } else { context.staffs.Add(new staff { staff_id = item.staff_id, first_name = item.first_name, last_name = item.last_name, phone = item.phone, email = item.email, active = item.active, store_id = item.store_id, manager_id = item.manager_id, address = item.address, }); context.SaveChanges(); } } } }
public static void Updatestores(List <store> stores) { using (var context = new WebsiteTTKEntities()) { foreach (store item in stores) { var result = context.stores.SingleOrDefault(b => b.store_id == item.store_id); if (result != null) { result.store_name = item.store_name; result.store_description = item.store_description; result.store_images = item.store_images; result.phone = item.phone; result.email = item.email; result.street = item.street; result.city = item.city; result.zip_code = item.zip_code; context.SaveChanges(); } else { context.stores.Add(new store { store_id = item.store_id, store_name = item.store_name, store_description = item.store_description, store_images = item.store_images, phone = item.phone, email = item.email, street = item.street, city = item.city, zip_code = item.zip_code, }); context.SaveChanges(); } } } }
public static void DeleteStoreByIds(List <int> deletedIds) { using (var context = new WebsiteTTKEntities()) { foreach (var id in deletedIds) { var result = context.stores.SingleOrDefault(b => b.store_id == id); if (result != null) { context.stores.Attach(result); context.stores.Remove(result); context.SaveChanges(); } } } }
public static void DeleteCustomerByIds(List <string> deletedIds) { using (var context = new WebsiteTTKEntities()) { foreach (var id in deletedIds) { var result = context.AspNetUsers.SingleOrDefault(b => b.Id == id); if (result != null) { context.AspNetUsers.Attach(result); context.AspNetUsers.Remove(result); context.SaveChanges(); } } } }
public static void UpdateCategories(List <procategory> categories, bool isUpdateCategoryImages = false) { using (var context = new WebsiteTTKEntities()) { foreach (procategory item in categories) { var result = context.procategories.SingleOrDefault(b => b.category_id == item.category_id); if (result != null) { result.category_name = item.category_name; result.category_description = item.category_description; if (isUpdateCategoryImages) { result.category_images = item.category_images; } result.category_url = item.category_url; result.create_date = item.create_date; result.parent_id = item.parent_id; result.is_publish = item.is_publish; result.is_menu = item.is_menu; result.is_label = item.is_label; result.is_collection = item.is_collection; result.store_id = item.store_id; try { context.SaveChanges(); } catch (Exception ex) { LogHelper.Log("App_Code\\CategoryHelper.cs", LogHelper.ErrorType.Error, ex); } } else { context.procategories.Add(new procategory { category_name = item.category_name, category_description = item.category_description, category_images = item.category_images, category_url = item.category_url, create_date = item.create_date, parent_id = item.parent_id, is_publish = item.is_publish, is_menu = item.is_menu, is_label = item.is_label, is_collection = item.is_collection, store_id = item.store_id }); try { context.SaveChanges(); } catch (Exception ex) { LogHelper.Log("App_Code\\CategoryHelper.cs", LogHelper.ErrorType.Error, ex); } } } } }
public static void UpdateProducts(List <product> products, bool isUpdateProductImages = false) { using (var context = new WebsiteTTKEntities()) { foreach (product item in products) { var result = context.products.SingleOrDefault(b => b.product_id == item.product_id); if (result != null) { result.product_name = item.product_name; result.product_description = item.product_description; if (isUpdateProductImages) { result.product_images = item.product_images; } result.brand_id = item.brand_id; result.category_id = item.category_id; result.colour_id = item.colour_id; result.model_year = item.model_year; result.list_price = item.list_price; result.shipping_fee = item.shipping_fee; result.free_shipping_amount = item.free_shipping_amount; result.tax = item.tax; result.taxed_countries = item.taxed_countries; result.create_date = item.create_date; result.create_by = item.create_by; result.is_publish = item.is_publish; result.is_featured = item.is_featured; result.is_sale = item.is_sale; result.is_new = item.is_new; result.is_gift = item.is_gift; result.currency_id = item.currency_id; context.SaveChanges(); } else { context.products.Add(new product { product_name = item.product_name, product_description = item.product_description, product_images = item.product_images, brand_id = item.brand_id, category_id = item.category_id, colour_id = item.colour_id, model_year = item.model_year, list_price = item.list_price, shipping_fee = item.shipping_fee, free_shipping_amount = item.free_shipping_amount, tax = item.tax, taxed_countries = item.taxed_countries, create_date = item.create_date, create_by = item.create_by, is_publish = item.is_publish, is_featured = item.is_featured, is_sale = item.is_sale, is_new = item.is_new, is_gift = item.is_gift, currency_id = item.currency_id }); context.SaveChanges(); } } } }