Source: asp.net mvc – using windows authentication with active directory groups as roles – Stack Overflow
Month: October 2016
asp.net mvc – using windows authentication with active directory groups as roles – Stack Overflow
Connecting to the Mac – Xamarin
Xamarin.iOS for Visual Studio accomplishes an amazing feat: it lets you create, build, and debug iOS applications on a Windows computer using the Visual Studio IDE. This guide explains the features provided Xamarin.iOS for Visual Studio and how the connection to the Mac build host is made.
Source: Connecting to the Mac – Xamarin
POST Data Migration
Noticed that Transfer Table field Name Change Requires
Transfer Table:
Rename : LocCode –> Loc_Code
Adding Sub_Fund varchar(50)
Modifying
ALTER PROCEDURE [dbo].[addTransfer]
— Add the parameters for the stored procedure here
@ttp_code float,
@age_code float,
@minobj nvarchar(255),
@tc nvarchar(255),
@td nvarchar(255),
@reference nvarchar(255),
@processed datetime,
@trandate datetime,
@tra float,
@average float,
@comments nvarchar(255),
@lupd_user nvarchar(255),
@con nvarchar(255),
@supdist nvarchar(255),
@payreqnum nvarchar(255),
@payee nvarchar(255),
@loccode nvarchar(255),
@subfund varchar(50)
AS
BEGIN
— SET NOCOUNT ON added to prevent extra result sets from
— interfering with SELECT statements.
— Insert statements for procedure here
INSERT INTO [TRANSFERS]
([TRA_CODE],
[TTP_CODE],
[AGE_CODE],
[MINOBJ],
[TC],
[TD],
[REFERENCE],
[PROCESSED],
[TRANDATE],
[TRA],
[AVERAGE],
[COMMENTS],
[LUPD_USER],
[LUPD_DATE],
[LUPD_TIME]
,[CON]
,[SUPDIST]
,[PayReqNum]
,[Payee]
,[Loc_Code]
,[Sub_FUnd]
)
SELECT MAX([TRA_CODE])+1, @ttp_code, @age_code, @minobj, @tc, @td, @reference,@processed,@trandate,@tra,@average,
@comments, @lupd_user, GETDATE(), Convert(varchar, GETDATE(),108), @con,@supdist,@payreqnum,@payee,@loccode,@subfund
FROM [TRANSFERS]
END
Also Following Stored Procedure needs to be changed:
USE [FOXPRODEV]
GO
/****** Object: StoredProcedure [dbo].[editTransfers] Script Date: 10/20/2016 3:00:09 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
— =============================================
— Author: sovath
— Create date:
— Description: editransfers
— =============================================
ALTER PROCEDURE [dbo].[editTransfers]
— Add the parameters for the stored procedure here
@tra_code float,
@ttp_code float,
@age_code float,
@minobj nvarchar(255),
@tc nvarchar(255),
@td nvarchar(255),
@reference nvarchar(255),
@processed datetime,
@trandate datetime,
@tra float,
@average float,
@comments nvarchar(255),
@lupd_user nvarchar(255),
@supdist nvarchar(255),
@payreqnum nvarchar(255),
@payee nvarchar(255),
@loccode nvarchar(255),
@subfund varchar(50)
AS
BEGIN
— SET NOCOUNT ON added to prevent extra result sets from
— interfering with SELECT statements.
UPDATE [TRANSFERS] set
[TTP_CODE] = @ttp_code,
[AGE_CODE] = @age_code,
[MINOBJ] = @minobj,
[TC] = @tc,
[TD] = @td,
[REFERENCE] = @reference,
[PROCESSED] = @processed,
[TRANDATE] = @trandate,
[TRA] = @tra,
[AVERAGE] = @average,
[COMMENTS] = @comments,
[LUPD_USER] = @lupd_user,
[SUPDIST] = @supdist,
[PayReqNum]= @payreqnum,
[Payee]= @payee,
[Loc_Code]=@loccode,
[sub_fund] = @subfund
WHERE [TRA_CODE] = @tra_code
END
Stopwatch.Elapsed Property (System.Diagnostics)
trace – How to add (simple) tracing in C#? – Stack Overflow
IDENTITY (Property) (Transact-SQL)
How to resize a virtualbox VDI disk under windows | derekmolloy.ie
Describes how to resize a linux virtualbox vdi drive under windows host
Source: How to resize a virtualbox VDI disk under windows | derekmolloy.ie
String.IsNullOrEmpty Method (String) (System)
C# – Nullables
C# – Nullables – Learn C Sharp Programming in simple and easy steps starting from Environment setup, Basic Syntax, Data Types, Type Conversion, Variables, Constants, Operators, Decision Making, Loops, Methods, Arrays, Strings, Struct, Enums, File I/O, Classes, Encapsulation, Interfaces, Inheritance, Namespaces, Polymophism, Operator Overloading, Encapsulation, Reflection, Attributes, Properties, Indexes, Delegates, Events, Collections, Generics, Preprocessor Directives, Multithreading, Regular Expression, and Exception Handling.
Source: C# – Nullables