Posts

Showing posts from 2022

anti forgery key

using System; using System.Web.Helpers; using System.Web.Mvc; namespace acushine.Utilities.Filters {     [AttributeUsage(AttributeTargets.Method | AttributeTargets.Class, AllowMultiple = false, Inherited = true)]     public sealed class ValidateHeaderAntiForgeryTokenAttribute : FilterAttribute, IAuthorizationFilter     {         public void OnAuthorization(AuthorizationContext filterContext)         {             if (filterContext == null)             {                 throw new ArgumentNullException("filterContext");             }             var httpContext = filterContext.HttpContext;             var cookie = httpContext.Request.Cookies[AntiForgeryConfig.CookieName];             AntiForgery.Validate...

signup and login

 #region signup()         public ActionResult signup()         {             return View();         }         [HttpPost]         public JsonResult CheckRoleSignUpCredential(string signvalue, string signtype)         {             var previous_url = Request.UrlReferrer.PathAndQuery;             try             {                 if (String.IsNullOrEmpty(signvalue))                     return Json(new { redirect = previous_url, Result = "blank", Message = "" });                 if (String.IsNullOrEmpty(signtype))                     return Json(new { redirect = previous_ur...

recaptcha

 reCaptcha v4.0.30319 using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace acushine.Utilities {     public class ReCaptchaClass     {         public static string Validate(string EncodedResponse)         {             var client = new System.Net.WebClient();             string SecretKey = "key";             var GoogleReply = client.DownloadString(string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", SecretKey, EncodedResponse));             var captchaResponse = Newtonsoft.Json.JsonConvert.DeserializeObject<ReCaptchaClass>(GoogleReply);             return captchaResponse.Success.ToLower();         }         [JsonProperty("succes...

codeClass

using System; using System.Linq; using System.Web; using System.Net.Mail; using System.Net; using System.Text.RegularExpressions; using acushine.Models; using System.IO; namespace acushine.Utilities {     public class _CodeClass     {         acushineEntities dbContext = new acushineEntities();         #region ENUM         public enum EnumProductStatus         {              PENDING,             REJECTED,             APPROVED         }         public enum EnumUserType         {             USER,             RETAILER,             SELLER,             ADMIN         }         public ...

DROP Tables and Procedures Using MS SQL Server

DROP Tables and Procedures Using MS SQL Server -- query to get all Tables DECLARE @sql NVARCHAR(max)='' SELECT @sql += ' DROP PROCEDURE  ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; ' FROM   INFORMATION_SCHEMA.PROCEDURES WHERE  TABLE_TYPE = 'BASE TABLE' SELECT @SQL  -- after executing the below query, All tables will dropped. EXEC Sp_executesql @sql -- query to get all procedures SELECT 'DROP PROCEDURE [' + SCHEMA_NAME(p.schema_id) + '].[' + p.NAME + '];' FROM sys.procedures p 

Microsoft SQL Server old and new versions

Major Version / Compatibility Level Version Label File Version 80 SQL Server 2000 8.00.xxxx 90 SQL Server 2005 9.00.xxxx 100 SQL Server 2008 10.00.xxxx 105 SQL Server 2008 R2 10.50.xxxx 110 SQL Server 2012 11.00.xxxx 120 SQL Server 2014 12.00.xxxx 130 SQL Server 2016 13.00.xxxx 140 SQL Server 2017 14.00.xxxx 150 SQL Server 2019 15.00.xxxx 160 SQL Server 2022 16.00.xxxx