示例#1
0
        public bool CreateClientBasicDetails(Client clientObj)
        {
            bool retFlag = default(bool);

            StringBuilder insertQuery = new StringBuilder("INSERT INTO [dbo].[Client] ([ClientFirstName],[ClientLastName],[BusinessName],[ClientPrimaryAddress],[PrimaryContactNumber],[AlternateContactNumber],[PrimaryMailId],[FacebookId],[CreatedDate],[IsActive])");

            insertQuery.Append("VALUES(@ClientFirstName,@ClientLastName,@BusinessName,@ClientPrimaryAddress,@PrimaryContactNumber,@AlternateContactNumber,@PrimaryMailId,@FacebookId,@CreatedDate,@IsActive)");
            insertQuery.Append(";SELECT CAST(scope_identity() AS int);");

            clientObj.ClientId = ClientDA.AddNewClient(clientObj, insertQuery.ToString());

            retFlag = (clientObj.ClientId > 0) ? true : false;

            return(retFlag);
        }