public static bool UpdateShippingParams(int shippingMethodId, Dictionary <string, string> parameters) { foreach (var parameter in parameters) { SQLDataAccess.ExecuteNonQuery( @"if (SELECT COUNT(*) FROM [Order].[ShippingParam] WHERE [ShippingMethodID] = @ShippingMethodID AND [ParamName] = @ParamName) = 0 INSERT INTO [Order].[ShippingParam] ([ShippingMethodID], [ParamName], [ParamValue]) VALUES (@ShippingMethodID, @ParamName, @ParamValue) else UPDATE [Order].[ShippingParam] SET [ParamValue] = @ParamValue WHERE [ShippingMethodID] = @ShippingMethodID AND [ParamName] = @ParamName" , CommandType.Text, new SqlParameter("@ShippingMethodID", shippingMethodId), new SqlParameter("@ParamName", parameter.Key), new SqlParameter("@ParamValue", parameter.Value)); } return(true); }
public static void UpdateCustomOption(CustomOption copt) { SQLDataAccess.ExecuteNonQuery("[Catalog].[sp_UpdateCustomOption]", CommandType.StoredProcedure, new SqlParameter("@CustomOptionsId", copt.CustomOptionsId), new SqlParameter("@Title", copt.Title), new SqlParameter("@IsRequired", copt.IsRequired), new SqlParameter("@InputType", copt.InputType), new SqlParameter("@SortOrder", copt.SortOrder), new SqlParameter("@ProductID", copt.ProductId)); SQLDataAccess.ExecuteNonQuery("DELETE FROM [Catalog].[Options] WHERE [CustomOptionsId] = @CustomOptionsId", CommandType.Text, new SqlParameter("@CustomOptionsId", copt.CustomOptionsId)); foreach (var optionItem in copt.Options) { AddOption(optionItem, copt.CustomOptionsId); } }
public static void UpdateReview(Review review) { SQLDataAccess.ExecuteNonQuery("UPDATE [CMS].[Review] SET [ParentId] = @ParentId, [EntityId] = @EntityId, [Type] = @Type, [CustomerId] = @CustomerId, [Name] = @Name, [Email] = @Email, [Text] = @Text , [Checked] = @Checked, AddDate=@AddDate WHERE reviewId = @reviewId", CommandType.Text, new SqlParameter("@reviewId", review.ReviewId), new SqlParameter("@ParentId", review.ParentId), new SqlParameter("@EntityId", review.EntityId), new SqlParameter("@Type", review.Type), new SqlParameter("@CustomerId", review.CustomerId), new SqlParameter("@Name", review.Name), new SqlParameter("@Email", review.Email), new SqlParameter("@Checked", review.Checked), new SqlParameter("@Text", review.Text), new SqlParameter("@AddDate", review.AddDate) ); }
/// <summary> /// /// </summary> /// <param name="mItem"></param> /// <param name="menuType"> </param> public static void UpdateMenuItem(AdvMenuItem mItem, EMenuType menuType) { SQLDataAccess.ExecuteNonQuery( "[CMS].[sp_UpdateMenuItemByItemId]", CommandType.StoredProcedure, new SqlParameter("@MenuType", menuType.ToString()), new SqlParameter("@MenuItemID", mItem.MenuItemID), new SqlParameter("@MenuItemParentID", mItem.MenuItemParentID == 0 ? DBNull.Value : (object)mItem.MenuItemParentID), new SqlParameter("@MenuItemName", mItem.MenuItemName), new SqlParameter("@MenuItemIcon", string.IsNullOrEmpty(mItem.MenuItemIcon) ? DBNull.Value : (object)mItem.MenuItemIcon), new SqlParameter("@MenuItemUrlPath", mItem.MenuItemUrlPath), new SqlParameter("@MenuItemUrlType", mItem.MenuItemUrlType), new SqlParameter("@SortOrder", mItem.SortOrder), new SqlParameter("@ShowMode", mItem.ShowMode), new SqlParameter("@Enabled", mItem.Enabled), new SqlParameter("@Blank", mItem.Blank)); }
public static void UpdatePaymentMethod(PaymentMethod paymentMethod) { SQLDataAccess.ExecuteNonQuery( "UPDATE [Order].[PaymentMethod] SET [Name] = @Name,[Enabled] = @Enabled,[SortOrder] = @SortOrder,[Description] = @Description,[PaymentType] = @PaymentType, " + "Extracharge=@Extracharge, ExtrachargeType=@ExtrachargeType WHERE [PaymentMethodID] = @PaymentMethodID", CommandType.Text, new SqlParameter("@PaymentMethodID", paymentMethod.PaymentMethodId), new SqlParameter("@Name", paymentMethod.Name), new SqlParameter("@Enabled", paymentMethod.Enabled), new SqlParameter("@SortOrder", paymentMethod.SortOrder), new SqlParameter("@Description", paymentMethod.Description), new SqlParameter("@PaymentType", (int)paymentMethod.Type), new SqlParameter("@Extracharge", paymentMethod.Extracharge), new SqlParameter("@ExtrachargeType", (int)paymentMethod.ExtrachargeType)); UpdatePaymentParams(paymentMethod.PaymentMethodId, paymentMethod.Parameters); }
protected void Page_Load(object sender, EventArgs e) { if (SaasDataService.IsSaasEnabled && !SaasDataService.CurrentSaasData.HaveExcel) { mainDiv.Visible = false; notInTariff.Visible = true; } Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_ImportXLS_Title); if (!IsPostBack) { OutDiv.Visible = ImportElbuzCsvStatistic.IsRun; linkCancel.Visible = ImportElbuzCsvStatistic.IsRun; SQLDataAccess.ExecuteNonQuery("DELETE from [Catalog].[ImportLog]", CommandType.Text); } }
/// <summary> /// Add module to datebase and set Install /// </summary> /// <param name="module"></param> public static void InstallModuleToDb(Module module) { SQLDataAccess.ExecuteNonQuery( @"IF (SELECT COUNT([ModuleStringID]) FROM [dbo].[Modules] WHERE [ModuleStringID] = @ModuleStringID) = 0 BEGIN INSERT INTO [dbo].[Modules] ([ModuleStringID],[IsInstall],[DateAdded],[DateModified],[Version]) VALUES (@ModuleStringID,1,@DateAdded,@DateModified,@Version) END ELSE BEGIN UPDATE [dbo].[Modules] SET [IsInstall] = 1, [DateModified] = @DateModified, [Version] = @Version WHERE [ModuleStringID] = @ModuleStringID END", CommandType.Text, new SqlParameter("@ModuleStringID", module.StringId), new SqlParameter("@DateAdded", module.DateAdded), new SqlParameter("@DateModified", module.DateModified), new SqlParameter("@Version", module.Version.IsNullOrEmpty() ? DBNull.Value : (object)module.Version)); }
public static int UpdateContact(CustomerContact contact) { SQLDataAccess.ExecuteNonQuery("[Customers].[sp_UpdateCustomerContact]", CommandType.StoredProcedure, new SqlParameter("@ContactID", contact.CustomerContactID), new SqlParameter("@Name", contact.Name), new SqlParameter("@Country", contact.Country), new SqlParameter("@City", contact.City), new SqlParameter("@Zone", contact.RegionName), new SqlParameter("@Address", contact.Address), new SqlParameter("@Zip", contact.Zip), new SqlParameter("@CountryID", contact.CountryId), new SqlParameter("@RegionID", contact.RegionId.HasValue && contact.RegionId != -1 ? (object)contact.RegionId : DBNull.Value) ); return(0); }
public static void CreateClient(ClientOnlineInfo cInf) { SQLDataAccess.ExecuteNonQuery( IsExist(cInf.Address) ? "update [Customers].[ClientInfo] Set [sessionID]=@sessionID, [UserAgentBrowser]=@UserAgentBrowser, [UserAgentOS]=@UserAgentOS, [CountryByGeoIp]=@CountryByGeoIp, [LastAccessedPath]=@LastAccessedPath, [Started]=@Started, [Ended]=@Ended Where Address=@Address" : "INSERT INTO [Customers].[ClientInfo] ([sessionID], [Address], [UserAgentBrowser], [UserAgentOS], [CountryByGeoIp], [LastAccessedPath] ,[Started], [Ended]) VALUES (@sessionID, @Address, @UserAgentBrowser, @UserAgentOS, @CountryByGeoIp, @LastAccessedPath, @Started, @Ended)", CommandType.Text, new SqlParameter("@sessionID", cInf.SessionId), new SqlParameter("@Address", cInf.Address), new SqlParameter("@UserAgentBrowser", cInf.UserAgentBrowser), new SqlParameter("@UserAgentOS", cInf.UserAgentOS), new SqlParameter("@CountryByGeoIp", cInf.CountryByGeoIp), new SqlParameter("@LastAccessedPath", cInf.LastAccessedPath), new SqlParameter("@Started", cInf.Started), new SqlParameter("@Ended", cInf.Ended) ); }
public static void UpdateShoppingCartItem(ShoppingCartItem item) { if (item == null) { throw new ArgumentNullException("item"); } SQLDataAccess.ExecuteNonQuery( "UPDATE [Catalog].[ShoppingCart] SET [ShoppingCartType] = @ShoppingCartType, [CustomerId] = @CustomerId, [OfferId] = @OfferId, [AttributesXml] = @AttributesXml, [UpdatedOn] = GetDate(), [Amount] = @Amount WHERE [ShoppingCartItemId] = @ShoppingCartItemId", CommandType.Text, new SqlParameter("@ShoppingCartType", (int)item.ShoppingCartType), new SqlParameter("@ShoppingCartItemId", item.ShoppingCartItemId), new SqlParameter("@CustomerId", item.CustomerId), new SqlParameter("@OfferId", item.OfferId), new SqlParameter("@AttributesXml", item.AttributesXml ?? String.Empty), new SqlParameter("@Amount", item.Amount)); }
public static int UpdateCustomer(Customer customer) { // // Changed by Evgeni to devide Optovok and other users if (SettingsMailChimp.MailChimpActive)// && CustomerSubscribe(customer.Id) != customer.SubscribedForNews) { // Changed by Evgeni to devide Optovok and other users if (customer.SubscribedForNews) { if (customer.CustomerGroup.GroupName.ToLower() != "оптовик") { Mails.MailChimp.SubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpRegUsersList, customer.EMail); Mails.MailChimp.UnsubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpUnRegUsersList, customer.EMail); } else //"оптовик" { Mails.MailChimp.SubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpUnRegUsersList, customer.EMail); Mails.MailChimp.UnsubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpRegUsersList, customer.EMail); } Mails.MailChimp.SubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpAllUsersList, customer.EMail); } else { Mails.MailChimp.UnsubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpRegUsersList, customer.EMail); Mails.MailChimp.UnsubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpAllUsersList, customer.EMail); } } SQLDataAccess.ExecuteNonQuery("[Customers].[sp_UpdateCustomerInfo]", CommandType.StoredProcedure, new SqlParameter("@CustomerID", customer.Id), new SqlParameter("@FirstName", customer.FirstName), new SqlParameter("@LastName", customer.LastName), new SqlParameter("@Phone", customer.Phone), new SqlParameter("@Email", customer.EMail), new SqlParameter("@Subscribed4News", customer.SubscribedForNews), new SqlParameter("@CustomerGroupId", customer.CustomerGroupId == 0 ? (object)DBNull.Value : customer.CustomerGroupId), new SqlParameter("@CustomerRole", customer.CustomerRole) ); return(0); }
public static void UpdateProductPropertyValue(int productId, int oldPropertyValueId, int newPropertyValueId) { if (oldPropertyValueId == 0) { throw new ArgumentException(@"Value cannot be zero", "oldPropertyValueId"); } if (newPropertyValueId == 0) { throw new ArgumentException(@"Value cannot be zero", "newPropertyValueId"); } SQLDataAccess.ExecuteNonQuery("[Catalog].[sp_UpdateProductProperty]", CommandType.StoredProcedure, new SqlParameter("@ProductID", productId), new SqlParameter("@OldPropertyValueID", oldPropertyValueId), new SqlParameter("@NewPropertyValueID", newPropertyValueId) ); }
/// <summary> /// /// </summary> /// <param name="id"></param> public static void Unsubscribe(int id) { SQLDataAccess.ExecuteNonQuery( "UPDATE [Customers].[Subscription] SET [Subscribe] = 0, [UnsubscribeDate] = GETDATE() WHERE [Id] = @Id", CommandType.Text, new SqlParameter("@Id", id)); var subscription = GetSubscription(id); var modules = AttachedModules.GetModules <ISendMails>(); foreach (var moduleType in modules) { var moduleObject = (ISendMails)Activator.CreateInstance(moduleType, null); moduleObject.UnsubscribeEmail(subscription.Email); } }
/// <summary> /// /// </summary> /// <param name="moduleStringId"></param> /// <param name="active"></param> public static void SetActiveModule(string moduleStringId, bool active) { SQLDataAccess.ExecuteNonQuery( "Update [dbo].[Modules] SET [Active] = @Active WHERE [ModuleStringID] = @ModuleStringID", CommandType.Text, new SqlParameter("@ModuleStringID", moduleStringId), new SqlParameter("@Active", active)); AttachedModules.LoadModules(); var module = AttachedModules.GetModules().FirstOrDefault(x => x.Name.ToLower() == moduleStringId.ToLower()); if (module != null && typeof(IModuleChangeActive).IsAssignableFrom(module)) { var instance = (IModuleChangeActive)Activator.CreateInstance(module, null); instance.ModuleChangeActive(active); } }
public static void UpdateBrand(Brand brand) { SQLDataAccess.ExecuteNonQuery( "[Catalog].[sp_UpdateBrandById]", CommandType.StoredProcedure, new SqlParameter("@BrandID", brand.BrandId), new SqlParameter("@BrandName", brand.Name), new SqlParameter("@BrandDescription", brand.Description ?? (object)DBNull.Value), new SqlParameter("@BrandBriefDescription", brand.BriefDescription ?? (object)DBNull.Value), new SqlParameter("@Enabled", brand.Enabled), new SqlParameter("@SortOrder", brand.SortOrder), new SqlParameter("@CountryID", brand.CountryId == 0 ? (object)DBNull.Value : brand.CountryId), new SqlParameter("@UrlPath", brand.UrlPath), new SqlParameter("@BrandSiteUrl", brand.BrandSiteUrl.IsNotEmpty() ? brand.BrandSiteUrl : (object)DBNull.Value) ); MetaInfoService.SetMeta(brand.Meta); }
/// <summary> /// /// </summary> /// <param name="id"></param> public static void Subscribe(int id) { SQLDataAccess.ExecuteNonQuery( "UPDATE [Customers].[Subscription] SET [Subscribe] = 1, [SubscribeDate] = GETDATE(), [UnsubscribeDate] = NULL WHERE [Id] = @Id", CommandType.Text, new SqlParameter("@Id", id)); //todo: лишние запросы получения кастомера и подписки <Sckeef> var subscription = GetSubscription(id); var customer = CustomerService.GetCustomerByEmail(subscription.Email); var modules = AttachedModules.GetModules <ISendMails>(); foreach (var moduleType in modules) { var moduleObject = (ISendMails)Activator.CreateInstance(moduleType, null); moduleObject.SubscribeEmail(new Subscription { Email = subscription.Email, FirstName = customer.FirstName, LastName = customer.LastName, Phone = customer.Phone }); } }
public static float Vote(int productID, int myRating) { var customerID = CustomerSession.CurrentCustomer.Id; if (DoesUserVote(productID, customerID)) { return(0); } SQLDataAccess.ExecuteNonQuery("[Catalog].[sp_AddRatio]", CommandType.StoredProcedure, new SqlParameter() { ParameterName = "@ProductID", Value = productID }, new SqlParameter() { ParameterName = "@ProductRatio", Value = myRating }, new SqlParameter() { ParameterName = "@CustomerId", Value = customerID }); int newRating = SQLDataHelper.GetInt(SQLDataAccess.ExecuteScalar("[Catalog].[sp_GetAVGRatioByProductID]", CommandType.StoredProcedure, new SqlParameter() { ParameterName = "@ProductID", Value = productID })); SQLDataAccess.ExecuteNonQuery("[Catalog].[sp_UpdateProductRatio]", CommandType.StoredProcedure, new SqlParameter() { ParameterName = "@ProductID", Value = productID }, new SqlParameter() { ParameterName = "@Ratio", Value = newRating }); return(newRating); }
public static bool UpdateCategorySortOrder(string name, int sortOrder, int cateoryId) { SQLDataAccess.ExecuteNonQuery( "Update Catalog.Category set name=@name, SortOrder=@SortOrder where CategoryID = @CategoryID", CommandType.Text, new SqlParameter("@name", name), new SqlParameter("@SortOrder", sortOrder), new SqlParameter("@CategoryID", cateoryId)); CacheManager.RemoveByPattern("MenuCatalog"); var cacheName = CacheNames.GetBottomMenuCacheObjectName(); if (CacheManager.Contains(cacheName)) { CacheManager.Remove(cacheName); } return(true); }
public static bool UpdateShippingMethod(ShippingMethod item) { SQLDataAccess.ExecuteNonQuery( item.Type == ShippingType.None ? "UPDATE [Order].[ShippingMethod] SET [Name] = @Name,[Description] = @Description,[Enabled] = @Enabled,[SortOrder] = @SortOrder, DisplayCustomFields=@DisplayCustomFields, ShowInDetails=@ShowInDetails, ZeroPriceMessage=@ZeroPriceMessage WHERE ShippingMethodID=@ShippingMethodID" : "UPDATE [Order].[ShippingMethod] SET [ShippingType] = @ShippingType,[Name] = @Name,[Description] = @Description,[Enabled] = @Enabled,[SortOrder] = @SortOrder, DisplayCustomFields=@DisplayCustomFields, ShowInDetails=@ShowInDetails, ZeroPriceMessage=@ZeroPriceMessage WHERE ShippingMethodID=@ShippingMethodID", CommandType.Text, new SqlParameter("@ShippingType", (int)item.Type), new SqlParameter("@Name", item.Name), new SqlParameter("@Description", item.Description), new SqlParameter("@Enabled", item.Enabled), new SqlParameter("@SortOrder", item.SortOrder), new SqlParameter("@ShippingMethodID", item.ShippingMethodId), new SqlParameter("@DisplayCustomFields", item.DisplayCustomFields), new SqlParameter("@ShowInDetails", item.ShowInDetails), new SqlParameter("@ZeroPriceMessage", item.ZeroPriceMessage ?? "") ); return(true); }
public static int DeleteCustomer(Guid customerId) { //var cacheName = CacheNames.GetCustomerCacheObjectName(customerId); //CacheManager.Remove(cacheName); if (SettingsMailChimp.MailChimpActive) { Mails.MailChimp.UnsubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpRegUsersList, GetCustomerEmailById(customerId)); //Changed by Evgeni to unsubscribe from unregcutomers Mails.MailChimp.UnsubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpUnRegUsersList, GetCustomerEmailById(customerId)); Mails.MailChimp.UnsubscribeListMember(SettingsMailChimp.MailChimpId, SettingsMailChimp.MailChimpAllUsersList, GetCustomerEmailById(customerId)); } SQLDataAccess.ExecuteNonQuery("[Customers].[sp_DeleteCustomer]", CommandType.StoredProcedure, new SqlParameter("@CustomerID", customerId)); return(0); }
public static void UpdateProductByType(int productId, int sortOrder, TypeFlag type) { string sqlCmd; switch (type) { case TypeFlag.Bestseller: sqlCmd = "Update Catalog.Product set SortBestseller=@sortOrder where ProductId=@productId and Bestseller=1"; break; case TypeFlag.New: sqlCmd = "Update Catalog.Product set SortNew=@sortOrder where ProductId=@productId and New=1"; break; case TypeFlag.Discount: sqlCmd = "Update Catalog.Product set SortDiscount=@sortOrder where ProductId=@productId"; break; case TypeFlag.OnSale: sqlCmd = "Update Catalog.Product set SortOnSale=@sortOrder where ProductId=@productId and OnSale=1"; break; case TypeFlag.Recomended: sqlCmd = "Update Catalog.Product set SortRecomended=@recomendedOrder where ProductId=@productId and Recomended=1"; break; default: throw new NotImplementedException(); } SQLDataAccess.ExecuteNonQuery(sqlCmd, CommandType.Text, new SqlParameter { ParameterName = "@productId", Value = productId }, new SqlParameter { ParameterName = "@sortOrder", Value = sortOrder } ); }
private static void _PropertiesFromString(int productId, string properties, string columSeparator, string propertySeparator) { try { DeleteProductProperties(productId); if (string.IsNullOrEmpty(properties)) { return; } //type:value,type:value,... var items = properties.Split(new[] { columSeparator }, StringSplitOptions.RemoveEmptyEntries); var stepSort = 0; foreach (string s in items) { var temp = s.Trim().Split(new[] { propertySeparator }, StringSplitOptions.RemoveEmptyEntries); if (temp.Length != 2) { continue; } var tempType = temp[0].Trim(); var tempValue = temp[1].Trim(); if (!string.IsNullOrWhiteSpace(tempType) && !string.IsNullOrWhiteSpace(tempValue)) { // inside stored procedure not thread save/ do save mode by logic SQLDataAccess.ExecuteNonQuery("[Catalog].[sp_ParseProductProperty]", CommandType.StoredProcedure, new SqlParameter("@nameProperty", tempType), new SqlParameter("@propertyValue", tempValue), new SqlParameter("@productId", productId), new SqlParameter("@sort", stepSort)); stepSort += 10; } } } catch (Exception ex) { Debug.LogError(ex); } }
public static void UpdateNewsCategory(NewsCategory newsCategory) { SQLDataAccess.ExecuteNonQuery("Update [Settings].[NewsCategory] set [Name]=@name,[UrlPath] = @UrlPath , [SortOrder] = @SortOrder where NewsCategoryID = @NewsCategoryID", CommandType.Text, new SqlParameter("@NewsCategoryID", newsCategory.NewsCategoryID), new SqlParameter("@Name", newsCategory.Name), new SqlParameter("@UrlPath", newsCategory.UrlPath), new SqlParameter("@SortOrder", newsCategory.SortOrder)); if (newsCategory.Meta != null) { if (newsCategory.Meta.Title.IsNullOrEmpty() && newsCategory.Meta.MetaKeywords.IsNullOrEmpty() && newsCategory.Meta.MetaDescription.IsNullOrEmpty() && newsCategory.Meta.H1.IsNullOrEmpty()) { if (MetaInfoService.IsMetaExist(newsCategory.NewsCategoryID, MetaType.NewsCategory)) { MetaInfoService.DeleteMetaInfo(newsCategory.NewsCategoryID, MetaType.NewsCategory); } } else { MetaInfoService.SetMeta(newsCategory.Meta); } } }
public static void Update(string name, MetaInfo metaInfo) { var query = string.Empty; switch (metaInfo.Type) { case MetaType.Brand: query = "UPDATE Catalog.Brand SET BrandName=@name Where BrandID=@objId"; break; case MetaType.Category: query = "UPDATE [Catalog].[Category] SET [Name] = @name WHERE CategoryID = @objId"; break; case MetaType.News: query = "UPDATE [Settings].[News] SET [Title] = @name WHERE NewsID = @objId"; break; case MetaType.Product: query = "UPDATE [Catalog].[Product] SET [Name] = @name WHERE [ProductID] = @objId"; break; case MetaType.StaticPage: query = "UPDATE [CMS].[StaticPage] SET [PageName] = @name WHERE [StaticPageID] = @objId"; break; } SQLDataAccess.ExecuteNonQuery(query, CommandType.Text, new SqlParameter("@name", name), new SqlParameter("@objId", metaInfo.ObjId)); if (MetaType.Category == metaInfo.Type) { CategoryService.ClearCategoryCache(); } MetaInfoService.SetMeta(metaInfo); }
public static void LogApplicationRestart(bool checkPing, bool checkDbVersion) { if (checkPing) { if (!DataBaseService.PingDateBase()) { return; // Fail connection to DB } } if (checkDbVersion) { if (!DataBaseService.CheckDBVersion()) { return; // Wrong version of DB } } SQLDataAccess.ExecuteNonQuery("INSERT INTO [Internal].[AppRestartLog] ([RestartDate], [ServerName]) VALUES (@RestartDate, @ServerName);", CommandType.Text, new SqlParameter("@RestartDate", DateTime.Now), new SqlParameter("@ServerName", Dns.GetHostName())); SQLDataAccess.ExecuteNonQuery("DELETE FROM [Internal].[AppRestartLog] WHERE ID < (SELECT MAX(ID) - 300 FROM [Internal].[AppRestartLog]);", CommandType.Text); }
private static void UpdateMetaInfo(MetaInfo meta) { SQLDataAccess.ExecuteNonQuery("UPDATE [SEO].[MetaInfo] SET [Title] = @Title,[MetaKeywords] = @MetaKeywords,[MetaDescription] = @MetaDescription where ObjId=@ObjId and Type=@Type", CommandType.Text, new[] { new SqlParameter { ParameterName = "@Title", Value = meta.Title ?? SettingsSEO.DefaultMetaTitle }, new SqlParameter { ParameterName = "@MetaKeywords", Value = meta.MetaKeywords ?? SettingsSEO.DefaultMetaKeywords }, new SqlParameter { ParameterName = "@MetaDescription", Value = meta.MetaDescription ?? SettingsSEO.DefaultMetaDescription }, new SqlParameter { ParameterName = "@ObjId", Value = meta.ObjId }, new SqlParameter { ParameterName = "@Type", Value = meta.Type.ToString( ) } } ); }
public static void DeleteProductByType(int prodcutId, TypeFlag type) { string sqlCmd; switch (type) { case TypeFlag.Bestseller: sqlCmd = "Update Catalog.Product set SortBestseller=0, Bestseller=0 where ProductId=@productId"; break; case TypeFlag.New: sqlCmd = "Update Catalog.Product set SortNew=0, New=0 where ProductId=@productId"; break; case TypeFlag.Discount: sqlCmd = "Update Catalog.Product set SortDiscount=0, Discount =0 where ProductId=@productId"; break; case TypeFlag.OnSale: sqlCmd = "Update Catalog.Product set SortOnSale=0, OnSale=0 where ProductId=@productId"; break; case TypeFlag.Recomended: sqlCmd = "Update Catalog.Product set SortRecomended=0, Recomended=0 where ProductId=@productId"; break; default: throw new NotImplementedException(); } SQLDataAccess.ExecuteNonQuery(sqlCmd, CommandType.Text, new SqlParameter { ParameterName = "@productId", Value = prodcutId } ); }
protected void SaveAll_Click(object sender, EventArgs e) { for (int i = 0; i <= grid.Rows.Count - 1; i++) { grid.UpdateRow(grid.Rows[i].RowIndex, false); if (grid.UpdatedRow != null) { try { SQLDataAccess.ExecuteNonQuery("Update Catalog.Category set name=@name, SortOrder=@SortOrder where CategoryID = @CategoryID", CommandType.Text, new SqlParameter("@name", grid.UpdatedRow["Name"]), new SqlParameter("@SortOrder", grid.UpdatedRow["SortOrder"]), new SqlParameter("@CategoryID", grid.UpdatedRow["CategoryID"]) ); } catch (Exception ex) { Debug.LogError(ex); } } } divSave.Visible = true; }
public static void DeleteColor(int colorId) { SQLDataAccess.ExecuteNonQuery("DELETE FROM Catalog.Color WHERE ColorID = @ColorId", CommandType.Text, new SqlParameter("@ColorId", colorId)); }
public static void DeleteShoppingCartItem(int itemId) { SQLDataAccess.ExecuteNonQuery( "DELETE FROM Catalog.ShoppingCart WHERE ShoppingCartItemId = @ShoppingCartItemId", CommandType.Text, new SqlParameter("@ShoppingCartItemId", itemId)); }