public string Login([FromBody] Login details)
        {
            string    returnValue             = "";
            string    connString              = ConfigurationManager.ConnectionStrings["SQLConString"].ToString();
            IDBFamily family                  = new DBFamily();
            var       dbFamilyResult          = family.GetQueryBuilder(DbFamilyConstants.MSSQL);
            var       checkIfUsersExistsQuery = string.Format("select count(1) from NewUsers where UserName='******'", details.UserName);
            int       count = dbFamilyResult.ExecuteScalar(checkIfUsersExistsQuery, connString);

            if (count > 0)
            {
                var query  = string.Format("select count(1) from NewUsers where UserName='******' and Password='******'", details.UserName, details.Password);
                int result = dbFamilyResult.ExecuteScalar(query, connString);
                if (result > 0)
                {
                    returnValue = "Success";
                }
                else
                {
                    returnValue = "Invalid password";
                }
            }
            else
            {
                returnValue = "User doesnt exists";
            }
            return(returnValue);
        }
        public void Register([FromBody] Register details)
        {
            string    connString     = ConfigurationManager.ConnectionStrings["SQLConString"].ToString();
            IDBFamily family         = new DBFamily();
            var       dbFamilyResult = family.GetQueryBuilder(DbFamilyConstants.MSSQL);
            List <KeyValuePair <string, KeyValuePair <SqlDbType, object> > > inOutParams = new List <KeyValuePair <string, KeyValuePair <SqlDbType, object> > >();

            inOutParams.Add(new KeyValuePair <string, KeyValuePair <SqlDbType, object> >("UserName", new KeyValuePair <SqlDbType, object>(SqlDbType.NVarChar, details.FirstName + "." + details.LastName)));
            inOutParams.Add(new KeyValuePair <string, KeyValuePair <SqlDbType, object> >("Password", new KeyValuePair <SqlDbType, object>(SqlDbType.NVarChar, details.Password)));
            inOutParams.Add(new KeyValuePair <string, KeyValuePair <SqlDbType, object> >("EmailId", new KeyValuePair <SqlDbType, object>(SqlDbType.NVarChar, details.EmailId)));
            inOutParams.Add(new KeyValuePair <string, KeyValuePair <SqlDbType, object> >("FirstName", new KeyValuePair <SqlDbType, object>(SqlDbType.NVarChar, details.FirstName)));
            inOutParams.Add(new KeyValuePair <string, KeyValuePair <SqlDbType, object> >("LastName", new KeyValuePair <SqlDbType, object>(SqlDbType.NVarChar, details.LastName)));
            inOutParams.Add(new KeyValuePair <string, KeyValuePair <SqlDbType, object> >("IsActive", new KeyValuePair <SqlDbType, object>(SqlDbType.Bit, 1)));
            dbFamilyResult.ExecuteQuery("insert into NewUsers values(@UserName,@Password,@EmailId,@FirstName,@LastName,@IsActive)", connString, inOutParams);
        }
        public List <UserDetails> GetUserDetails()
        {
            string             conn     = ConfigurationManager.ConnectionStrings["SQLConString"].ConnectionString;
            List <UserDetails> result   = new List <UserDetails>();
            IDBFamily          dbFamily = new DBFamily();
            var dbFamilyResult          = dbFamily.GetQueryBuilder(DbFamilyConstants.MSSQL);
            var dataSet = dbFamilyResult.ExecuteCommand("select * from UserDetails", conn);

            if (dataSet != null && dataSet.Tables != null)
            {
                var dt = dataSet.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    result = dt.DataTableToList <UserDetails>();
                }
            }
            return(result);
        }