Dominic Burford - Professional Profile

CREATE VIEW [dbo].[v_CardDefinitions] AS
	SELECT 
		CardDefinitions.*,
		Cards.ID AS CardID,
		Cards.ParentID,
		Cards.[Index],
		Cards.UserID,
		Cards.CardDefinitionID,
		Users.Email AS UserEmail,
		Modules.Name AS ModuleName
	FROM 
		CardDefinitions
	LEFT JOIN
		Cards ON CardDefinitions.ID = Cards.CardDefinitionID
	JOIN
		Modules ON CardDefinitions.ModuleID = Modules.ID
	LEFT JOIN
		Users ON Cards.UserID = Users.ID
	WHERE 
		CardDefinitions.Active = 1

CREATE PROCEDURE [dbo].[Cards_GetById] 
	@cardId INT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    SELECT 
		DISTINCT ID, Name, [Permissions] 
	FROM 
		v_CardDefinitions 
	WHERE 
		ID = @cardId
END

CREATE FUNCTION [dbo].[Split]
(
	@List nvarchar(2000),
	@SplitOn nvarchar(5)
)  
RETURNS @RtnValue table 
(
		
	Id int identity(1,1),
	Value nvarchar(100)
) 
AS  
BEGIN 
	While (Charindex(@SplitOn,@List)>0)
	Begin

		Insert Into @RtnValue (value)
		Select 
			Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1)))

		Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List))
	End

	Insert Into @RtnValue (Value)
	Select Value = ltrim(rtrim(@List))
	
	Return
END

@List = '1, 2, 3, 4, 5'

@SplitOn = ','

CREATE PROCEDURE [dbo].[Documents_UpdateOwner] 
	@owner INT,
	@documentids NVARCHAR(1000)
AS
BEGIN
	UPDATE 
		Documents 
	SET 
		UploadedBy = @owner  
	WHERE 
		ID IN (SELECT CONVERT(INT, Value) FROM Split(@documentids, ',')) 
END

@echo off
cls

ECHO Setting version number to %1

cd <projectFolder>
dotnet restore
dotnet publish <project>.csproj --configuration Release /p:Version=%1

Quote:

the number of people who think social media is a net positive for society is down to 40 percent.

private async Task<string> GetValueFromTextbox(string controlId)
{
    return await WebView.EvaluateJavaScriptAsync($"document.getElementById('{controlId}').value;");
}
private async Task<string> GetValueFromCheckbox(string controlId)
{
    return await WebView.EvaluateJavaScriptAsync($"document.getElementById('{controlId}').checked;");
}
private async Task<string> GetValueFromRadioButton(string controlname)
{
    return await WebView.EvaluateJavaScriptAsync($"document.querySelector(\'input[name=\"{controlname}\"]:checked\').value;");
}
private async Task<string> GetValueFromDropdownn(string controlId)
{
    return await WebView.EvaluateJavaScriptAsync($"document.getElementById(\'{controlId}\').options[document.getElementById(\'{controlId}\').selectedIndex].value;");
}

public class BaseFormModel : NotifyPropertyChangedBase
{
}

public interface IFormData<T>
{
    T CreateDefaultModel();
}

public class MessageUsModel : BaseFormModel, IFormData<MessageUsModel>
{
    private string _messageToSend;

    [DisplayOptions(Header = MessageUsModelConstants.MessageHeader)]
    [NonEmptyValidator(MessageUsModelConstants.MessageError)]
    public string MessageToSend
    {
        get => _messageToSend;
        set
        {
            if (_messageToSend == value) return;
            _messageToSend = value;
            OnPropertyChanged();
        }
    }

    public MessageUsModel CreateDefaultModel()
    {
        return new MessageUsModel
        {
            _messageToSend = ""
        };
    }
}

public abstract class ViewModelBase<T> : NotifyPropertyChangedBase where T : new()
{
    /// <summary>
    /// This is the View-Model's reference to the Model. Use this whenever the view-model needs to reference the model.
    /// </summary>
    public T FormModel = new T();

    /// <summary>
    /// Implement this method in the derived class to define what actions to take when the user
    /// submits data from one of the data-entry forms 
    /// </summary>
    /// <returns></returns>
    public abstract Task PostCompleteTask();
}

public class MessageUsViewModel : ViewModelBase<MessageUsModel>
{
    public MessageUsModel MessageUsModel;
        
    public MessageUsViewModel()
    {
        this.MessageUsModel = this.FormModel.CreateDefaultModel();
    }

    public override async Task PostCompleteTask()
    {
        //implement your code here to submit the form data
    }
}

this.MessageUsModel = this.FormModel.CreateDefaultModel();

[XamlCompilation(XamlCompilationOptions.Compile)]
public partial class MessageUsView : ContentPage
{
    public MessageUsViewModel Muvm;

    public MessageUsView()
    {
        InitializeComponent();

        //initiate the view-model and bind it to the form
        this.Muvm = new MessageUsViewModel();
        this.BindingContext = this.Muvm;
    }

    private async void DataFormValidationCompleted(object sender, FormValidationCompletedEventArgs e)
    {
        dataForm.FormValidationCompleted -= this.DataFormValidationCompleted;

        if (e.IsValid)
        {
            await this.Muvm.PostCompleteTask();
        }
    }

    private void CommitButtonClicked(object sender, EventArgs e)
    {
        dataForm.FormValidationCompleted += this.DataFormValidationCompleted;
        dataForm.CommitAll();
    }
}

<input:RadDataForm x:Name="dataForm" CommitMode="Immediate"  />
<input:RadButton x:Name="CommitButton" Text="Save" Clicked="CommitButtonClicked" IsEnabled="True"/>

this.Muvm = new MessageUsViewModel();
this.BindingContext = this.Muvm;

WebPublishMethod=Package;
PackageFileName=$(Build.ArtifactStagingDirectory)\package.zip;
DesktopBuildPackageLocation=$(Build.ArtifactStagingDirectory)\package.zip;
PackageAsSingleFile=true;
PackageLocation=$(Build.ArtifactStagingDirectory)\package.zip;
DeployOnBuild=true;
DeployTarget=Package

$(Build.ArtifactStagingDirectory)

<div>
  rest of the Razor page goes here
</div>
<script>
    $(document).ready(function () {
        var queryparams = window.location.search;
        //using URLSearchParams to extract the querystring parameter
        if (queryparams && typeof (queryparams) === "string" && queryparams.length > 0) {
            var urlParams = new URLSearchParams(window.location.search);
            var documentid = urlParams.get('documentid');
            //call the JS function that will make the AJAX request and fetch the data
            loadDocumentManagerForDocument(documentid ); //see below for definition!
        }
    });
</script>

function loadDocumentManagerForDocument(documentid) {
    if (documentid) {

        //AJAX call to Razor page handler to fetch the document details

        $.ajax({
            type: "GET",
            url: `/DocumentManager/DocumentManager?handler=document&documentid=${documentid}`,
            contentType: "application/json",
            dataType: "json",
            success: function (response) {
                //populate the form elements with the returned data
            },
            failure: function (response) {
                //handle the error
            }
        });
    }
}

public async Task<JsonResult> OnGetDocument(int documentid)
{
    JsonResult result = null;
    var response = await new DocumentManagerPageModelService().GetDocumentById(documentid);
    result = new JsonResult(document);
    return result;
}

[HttpPost]
[EnableCors(origins: "*", headers: "*", methods: "*")]
public async Task<HttpResponseMessage> WebPostData(string formname, [FromBody] JToken postdata)
{
    //log the request
    base.LogMessage(string.Format(CultureInfo.InvariantCulture, "{0}.{1}", GetType().Name, "WebPostDataToServiceBus"));
    base.LogMessage($"Formname={formname}");

    //authenticate the request
    if (!base.IsRequestAuthenticated())
    {
        base.LogMessage("Request failed authentication");
        throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.Forbidden));
    }
    //add the request to the service bus for processing
    return await this.AddWebTaskToServiceBus(formname, postdata);
}

"Path\To\MSBuild\MSBuild.exe" /p:configuration="release";platform="any cpu";WebPublishMethod=Package;PackageFileName="\MyFolder\package.zip";DesktopBuildPackageLocation="\MyFolder\package.zip";PackageAsSingleFile=true;PackageLocation="\MyFolder\package.zip";DeployOnBuild=true;DeployTarget=Package